Oracle Database migration to a remote Data Protector cell--Best practices

2. the Recovery Catalog (if available); connect to the recovery catalog database with the RMAN

user:

oracle@ita022[DB10g]:/home/oracle$ sqlplus rman/xxx@rcvcat

SQL*Plus: Release 10.2.0.3.0 - Production on Wed May 21 14:28:20 2008

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

SQL> select * from rc_database ;

DB_KEY DBINC_KEY DBID NAME RESETLOGS_CHANGE# RESETLOGS

---------- ---------- ---------- -------- ----------------- ---------

1 2 2216826430 RAC 547422 25-JUL-07

41601 41602 38758237 DB10G 3181685 17-MAR-08

Data Protector Settings

Data Protector-managed Control File backup

If enabled (default), Data Protector performs a Control File backup at the end of every Oracle backup

session. This is a file system backup and no RMAN is used for it.

Figure 6. DP Managed Control File Backup

root@ita022:/.root# omnidb -session 2008/05/26-5

Object Name Object Type Object Status CopyID

===============================================================================

ita022:DB10g_online_FL<DB10g_196:655741754:1>.dbf Oracle8 Completed

ita022:DB10g_online_FL<DB10g_195:655741753:1>.dbf Oracle8 Completed

ita022:DB10g_online_FL<DB10g_194:655741753:1>.dbf Oracle8 Completed

ita022:c-38758237-20080526-00 Oracle8 Completed 148 (O)

ita022:DB10g_online_FL<DB10g_198:655741857:1>.dbf Oracle8 Completed

ita022:DB10g_online_FL<DB10g_199:655741857:1>.dbf Oracle8 Completed

ita022:DB10g_online_FL<DB10g_200:655741857:1>.dbf Oracle8 Completed

ita022:DB10g_online_FL<DB10g_201:655741857:1>.dbf Oracle8 Completed

ita022:DB10g_online_FL<DB10g_202:655742056:1>.dbf Oracle8 Completed

ita022:DB10g_online_FL<DB10g_203:655742078:1>.dbf Oracle8 Completed

ita022:c-38758237-20080526-01 Oracle8 Completed 141 (O)

ita022:DB10g DP Managed Control File Oracle8 Completed 91 (O)

ita022:Oracle Recovery Backup Catalog Oracle8 Completed 95 (O)

The restore of the DP-managed Control File can be done through the Data Protector GUI. See the Data

Protector Integration guide for Oracle for more information.