System Administrator’s Guide U42252-J-Z915-1-76
Recovery Performing a recovery
This command gives you the names and the save set IDs of all the files
saved in <ora_pool> in the period specified.
5. Remove the save set IDs of the following files from this output:
–recover_info_last
–bootstrap
–.../nsr/index/<client>/db
6. Recover the remaining save sets again:
# recover -a -f -S<ssid1> -S<ssid2> ...
7. For the recovery of an online backup only:
In an online backup the control file is not saved with its correct pathname.
So, if you need a copy of the saved control file you will have to copy the
control file to the correct position.
The file name of the saved file is:
/nsr/oracle/${ORACLE_SID}/tmp/cntrl${ORACLE_SID].dbf.back). The name of
the control file in the database can be copied with the SQL command
select name from v$controlfile. In order to copy this file, use the UNIX
command cp for databases in the file system and the UNIX command dd bs=
8k if=... of=...for databases on raw devices.
You must then use the usingbackup controlfile option with the ORACLE
command recover database ....
8. Reapply the redolog files since the last full backup to the ORACLE archiving
directory, if they have already been saved with NetWorker.
9. Start the ORACLE database using the startup mount command in the mount
state.
10.Recover the database by calling either the recover databa se, recover database
until time or recover database until cancel command (see ORACLE documen-
tation).
11.Open the database using
alter database open NORESETLOGS;
or
alter database open RESETLOGS;
12.If you set save groups to disabled in step 3., then you can now set them back
to enabled.