This manual describes the steps that are necessary to restore a RMAN backup to another server. The RMAN backup that is stored on disk.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
oracle> rman target / RMAN> startup nomount force; RMAN> restore spfile from '/u02/oradata/rman/c-1579753020-20140227-00'; Starting restore at 28-FEB-14 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=63 device type=DISKchannel ORA_DISK_1: restoring spfile from AUTOBACKUP /u02/oradata/rman/c-1579753020-20140227-00 channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete Finished restore at 28-FEB-14 RMAN> exit; oracle> sqlplus / as sysdba <span style="background-color: #cce4f5;">SQL> create pfile from spfile;</span> |
Now there is a pfile which can be configured with the right location of the database files, next create a spfile en start the database.
1 2 |
SQL> create spfile from pfile; SQL> shutdown abort |
Restore the control files and start the database in mount fase.
1 2 3 4 |
oracle> rman target / RMAN> startup nomount; RMAN> restore controlfile from '/u02/oradata/rman/c-1579753020-20140227-01'; RMAN> alter database mount; |
Give the location of the RMAN backup files.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
RMAN> catalog start with '/u02/oradata/rman'; List of Files Unknown to the Database ===================================== File Name: /u02/oradata/rman/c-1579753020-20140227-01 File Name: /u02/oradata/rman/c-1579753020-20140226-01 File Name: /u02/oradata/rman/a7p1jal8_1_1 File Name: /u02/oradata/rman/a9p1ls66_1_1 File Name: /u02/oradata/rman/abp1lv8h_1_1 File Name: /u02/oradata/rman/a5p1j7q8_1_1 File Name: /u02/oradata/rman/pdbfusion_full_rman.log File Name: /u02/oradata/rman/c-1579753020-20140227-00 Do you really want to catalog the above files (enter YES or NO)? YES RMAN> restore database; RMAN> recover database; |
Please let me know if this installation manual ‘Clone RMAN new database SID’ was usefull to you. If there are errors or you have suggestions regarding this manual, please let me know.
No rights can be derived from this Installation manual
Regards,
Maarten