System Administrator’s Guide U42252-J-Z915-1-76
NSR-ORA and NetApp Recovery
If you want NSR-ORA to copy the files (selection “1”) it will search for the
directory with the most free space and will ask you whether the existing
archivelog files should be copied to this filesystem. Additionally you may also
specify a different directory. Later on, if there are redolog files required for the
database recovery, NSR-ORA searches this directory for these redolog files
before it tries to perform a backup from the NetWorker tape media.
However if overwriting of the archivelog files is selected (as shown in the
example above, selection “2”), the dialog shown above appears.
If you do not select the snap restore function, (because for example another
database is located on the same volume, NSR-ORA checks the relevant direc-
tories, if it is possible to copy the files using the ndmp_copy command or not. If
there are any files not related to the database to be restored to one of the
relevant directories, NSR-ORA asks, if you really want ndmp_copy to be used.
This is because this command also restores these other files. If the answer is
“no”, NSR-ORA performs the default copy command.
6.6.2 Crash Recovery (nsrora_rec)When a database file is corrupted NSR-ORA first tries to recover it using the last
(most recent) snapshot (see “Example 1: Recovery based on the last
snapshot”). However the recovery can also be based on a snapshot dating from
an earlier point in time (see “Example 2: Recovery based on a specified
snapshot”).
Performing a recover based on a snapshot NSR-ORA restores the files on the
database computer using the standard copy command or, if possible, it restores
them on the NetApp filer using the ndmp_copy command. In the second case the
corrupted files must be the only ones stored in the relevant directory, because
the ndmp_copy command copies complete directories only but not single files.
Example 1: Recovery based on the last snapshot
Should I try to use a copy from the LAST SNAPSHOT or
do you want to select a specific snapshot?
1) last SNAPSHOT
2) select SNAPSHOT
(default 1:) > 1
INFO: doing ndmpcopy for /netapp_oracle/sapda ta4/proti_1