HP A.06.11 User Manual
Page 143
3.
Start SQL*Plus and type:
connect Recovery_Catalog_Login;
select * from rc_database;
exit
If this fails, start the configuration using Data Protector, or see the Oracle
documentation for information on how to register an Oracle target database in
the recovery catalog database.
•
Verify backup and restore directly to disk using an RMAN channel type disk:
If you use the recovery catalog:
1.
Export or set the ORACLE_HOME variable as described in
2.
Start RMAN from the bin directory in the ORACLE_HOME directory:
rman target Target_Database_Login catalog
Recovery_Catalog_Login cmd_file=rman_script
If you do not use the recovery catalog:
1.
Export or set the ORACLE_HOME variable as described in
2.
Start RMAN from the bin directory in the ORACLE_HOME directory:
rman target Target_Database_Login nocatalog
cmd_file=rman_script
An example of the RMAN backup script is presented below:
run {
allocate channel 'dev0' type disk;
backup tablespace tablespace_name format
'ORACLE_HOME/tmp/datafile_name';
}
After a successful backup, try to restore the backed up tablespace by running the
following restore script:
run {
allocate channel 'dev0' type disk;
sql 'alter tablespace tablespace_name offline immediate';
restore tablespace tablespace_name;
recover tablespace tablespace_name;
sql 'alter tablespace tablespace_name online';release channel 'dev0';
}
If this fails, see the Oracle documentation for details on how to execute a backup
and restore directly to disk using RMAN.
Integration guide for Oracle and SAP
143