Hi, I am migrating from Oracle 8i to 9i on a new server. The new instance is being set up to enable archiving. Archiving was not set up in the 8i instance.
The server will be backed up nightly, but the database will only be backed up on a biweekly basis. If we encounter a failure, I intend to use the archive logs to recover. Do I also need to apply the redo logs somehow in order to restore right up to the point of failure? If so, can I change the path to where the redo logs are written? I would like to put them on a separate drive just as I am putting the archive logs on a separate drive. Is this possible? Thanks very much for your assistance.
You will need to apply the archived redo logs in the order they were created. If you do need to restore, do not restore the control files unless you absolutely have to. The control files will know which online redo logs were created and their location. The control files become the guide to how to recover the transactions since the last backup.
You can put your online redo logs in another location. When I move my online redo logs, I find it useful to do the following:
- Query V$LOG to find an inactive group (SELECT group#,status FROM v$log).
- Drop an inactive group (ALTER DATABASE DROP LOGFILE GROUP x).
- Re-create the group in the new location (ALTER DATABASE ADD LOGFILE GROUP x ('/dir1/log1a.dbf','/dir2/log1b.dbf' size xxxM)).
- Continue with other inactive groups.
- Eventually, you'll want a group to become inactive, so switch the logfiles (ALTER SYSTEM SWITH LOGFILE).
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.