5.2 Import RMAN catalog export into rmanunan schema

imp userid=rmanunan/rman4CRM@rman file=rman_Sun.dmp fromuser=rmanager touser=rmanunan

6.0 Connect to RMAN catalog and check backup

rman catalog rmanunan/rman4CRM@rman target sys/change_on_install@CRM log=C:\Oracle\job\rman_logs\%date:~10,4%_%date:~4,2%_%date:~7,2%_log.txt

6.1 Check available backup with this command

list backup

7.0 Recover Duplicated Database
——————————-

7.1 startup nomount the database using SQLPLUS

SQL> startup nomount pfile=C:\oracle\admin92\CRM\pfile\initCRM.ora

7.2 restore the controlfile(s) (RMAN)

connect to RMAN

run{
allocate channel c1 type disk;
restore controlfile to ‘J:\Oradata\CRM\control04.ctl’;
}

Use OS command, copy J:\Oradata\CRM\control04.ctl to control01.ctl, control02.ctl, control03.ctl

copy J:\Oradata\CRM\control04.ctl J:\Oradata\CRM\control01.ctl
copy J:\Oradata\CRM\control04.ctl J:\Oradata\CRM\control02.ctl
copy J:\Oradata\CRM\control04.ctl J:\Oradata\CRM\control03.ctl

7.2 Mount the database

RMAN> alter database mount;

7.3 rename and restore the datafiles, and perform database recovery

RMAN can be used to change the location of the datafiles from the location on us01ap17 to the new location on test_us01ap17.

Use windows explorer, copy temporary tablespace datafiles to H:\ORADATA\CRM directory. Then run this command

run {
allocate channel c1 type disk;
restore database;
recover database;
}

7.4 restore archive log files (optional)

RMAN> restore archivelog all;

7.5 Recover using SQLPLUS

sqlplus /nolog
SQL>connect sys/change_on_install@CRM as sysdba
SQL>recover automatic database using backup controlfile until cancel;
cancel;
SQL>alter database open resetlogs;
SQL> connect CRM/DBA@CRM;
Connected.

Technorati : Oracle RMAN Backup Restore Recover Different server host

Popularity: 20%

Bookmark This

Hide Sites

Pages: 1 2 3 4 5