DanBrother的部落格

# Perform Backup:

. oraenv
[test1]

RMAN> backup device type disk format '/backup/test1_fullbk/%U' database;
RMAN> backup device type disk format '/backup/test1_fullbk/%U' archivelog all;

SQL> create pfile='/backup/test1_fullbk/inittest1.ora' from spfile;
SQL> alter database backup controlfile to '/backup/test1_fullbk/control.ctl';
 

# Perform Recovery:

echo "test1:/oracle/orabase/product/11.2.0.3/dbhome_1:N" >> /etc/oratab

. oraenv
[test1]

mkdir -p /oracle/orabase/admin/test1/adump
mkdir -p /oracle/orabase/admin/test1/dpdump
mkdir -p /oracle/orabase/admin/test1/pfile
mkdir -p /oracle/orabase/admin/test1/scripts
chmod -R 750 /oracle/orabase/admin/test1

sqlplus /  as sysdba

SQL> startup nomount pfile='/backup/test1_fullbk/inittest1.ora'

$ rman target / nocatalog

RMAN> restore controlfile from '/backup/test1_fullbk/control.ctl';
RMAN> alter database mount;
RMAN> restore database;
RMAN> recover database;
RMAN> alter database open resetlogs;
RMAN> exit