JTS and RTC Online Backup Scenario with Oracle
I am operating from the information provided in the Online Backup Wiki.
I have a need to provide a failover for RTC with a given time parameter on 60 minutes. We will be using RTC 5.0.2 so we can utilize the online backups of Oracle and the FullIndex files.
Is it possible to detect when a user is performing and admin function that would update the config files the need to be copied for the backup? I noticed that the floating user log file gives some hint as to what operation the user is performing. Maybe that could be queried before and after to see if an 'Admin Function' had been performed?
Valid online backup procedure?
1. Backup Application Config files.
2. Backup Server Config Files 3. Backup RTC and JTS Index Files
4. Backup CCM Full Index Files
5. Online Backup of Oracle database.
If all goes right then I have created a 'Hot Backup' of my production instance? I could copy these backup files to my hot instance. Restore the Oracle Backup to the hot instance. Shutdown the production instance and fire up the hot instance.
I understand that I would loose data in the interval from when the last online back up was taken.
I am trying to avoid the issue where the I would have to do a full text index restore after the database is restored. Which could take hours depending on the size of my database and I am constrained to the 60 minute window.
Holes in this procedure? Did I miss anything?
|
Accepted answer
Ralph Schoon (63.3k●3●36●46)
| answered Apr 13 '15, 4:43 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER edited Apr 13 '15, 4:47 a.m.
Robert,
what you describe is a cold standby scenario, where the standby server is either down or inactive. Instead of trying to use the online backup to create a second server, I would consider the following scenario:
If the main server fails
You would only loose data if the DB gets corrupted, in which case you would need to fall back to a valid backup and loose data anyway. I think the DB is most unlikely to fail, especially if you use available HA solutions. I don't think there is anything built in that allows to detect that the server configuration files are changed by a user. However, I think these files are usually pretty stable after the first setup and config is done. You could probably run a job that checks the modification time of these files and copies them over if that changes - indicating a change. Robert Carter selected this answer as the correct answer
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.
Comments
This message is repeated several times in the Wiki
So your last concern may not be completely addressed.