2. Start the point-in-time restore:
• On Windows: ORACLE_HOME\bin\rman target sys/manager@PROD
catalog rman/rman@CATAL
cmdfile=Data_Protector_home\tmp\restore_PIT
• On UNIX: ORACLE_HOME/bin/rman target sys/manager@PROD
catalog rman/rman@CATAL
cmdfile=/var/opt/omni/tmp/restore_PIT
Example of tablespace restore and recovery
If a table is missing or corrupted, you need to perform a restore and recovery of the
entire tablespace. To restore a tablespace, you may take only a part of the database
offline, so that the database does not have to be in the mount mode. You can use
either a recovery catalog database or control files to perform a tablespace restore
and recovery. Follow the steps below:
1. Log in to the Oracle RMAN:
• On Windows: ORACLE_HOME\bin\rman target sys/manager@PROD
catalog rman/rman@CATAL
• On UNIX: ORACLE_HOME/bin/rman target sys/manager@PROD
catalog rman/rman@CATAL
Zero downtime backup integration guide 129
To Next Page
Loading...
