|
-
First he is running 7.3.2... Don't use RMAN with that oracle release.
After taking the hot backup how are you relocating/restoring the files?
Simplest approach is to simply do an ftp copy of everything while the DB is down. However if that is not an option then the following should work just fine.
1. Alter system switch logfile (noting the log number that is archived)
2a. Put each tablespace in backup mode (1 at a time).
(alter tablespace <> begin backup)
2b. ftp the datafiles in the tablespace to your backup server.
2c. End the backup for the tablespace.
2d. Repeat steps 2a - dc for all tablespaces.
3a. switch log files..
3b. Copy the control file to the backup server
4. copy the Init files to the backup server
5. copy the redo log files to the backup server
6. copy the archive log files to the backup server ( see step 1... )
7. Perform recover: recover database
8. It will prompt you for the archive log files.
9. There should be no need to perform an open with reset logs.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|