2.1 Export RMAN catalog schema

exp rmanager/rmanager@rman file=P:\Rman\exp\rman_CRM_exp_%date:~0,3%.dmp

this will create an export dump file, e.g., rman_Thu.dmp

2.2 List Datafile Locations on us01ap17
————————————-

If you still have access to us01ap17, meaning it is still running (thank God it is!), you should find out each datafile’s number and location.

SQL> select file#, name from v$datafile;

FILE# NAME
———- ————————————–
1 H:\ORADATA\CRM\SYSTEM01.DBF
2 H:\ORADATA\CRM\UNDOTBS01.DBF
3 H:\ORADATA\CRM\CRM_DATA01.DBF
4 H:\ORADATA\CRM\CRM_DATA02.DBF
5 H:\ORADATA\CRM\CRM_DRSYS01.DBF
6 H:\ORADATA\CRM\CRM_INDX01.DBF
7 H:\ORADATA\CRM\CRM_INDX02.DBF
8 H:\ORADATA\CRM\CRM_TOOLS01.DBF
9 H:\ORADATA\CRM\CRM_USERS01.DBF
10 H:\ORADATA\CRM\CRM_XDB01.DBF
11 H:\ORADATA\I3FP\VERITAS_I3_ORCL.DBF
12 H:\ORADATA\CRM\CRM_DATA03.DBF

The log file names should also be recorded.

SQL> select group#, member from v$logfile;

GROUP# MEMBER
——- ——————————————
1 J:\ORADATA\CRM\REDO01.LOG
2 J:\ORADATA\CRM\REDO02.LOG
3 J:\ORADATA\CRM\REDO03.LOG
4 J:\ORADATA\CRM\CRM_SRL0.F
5 J:\ORADATA\CRM\CRM_SRL1.F

3.0 Make the Backups Available to test_us01ap17
———————————————–

3.1 Disk Backups

During restore, RMAN will expect the backup sets to be located in the same directory as written to during the backup. For disk backups, the DBA can accomplish this in many ways:

- create the same directory structure on us01ap17 and test_us01ap17
- copy RMAN backup files to test_us01ap17
Use Windows explorer to copy RMAN backup files from H:\rman_backup on us01ap17 to test_us01ap17

Also copy RMAN catalog export file to test_us01ap19

Popularity: 20%

Bookmark This

Hide Sites

Pages: 1 2 3 4 5