Oracle Database migration to a remote Data Protector cell--Best practices
36
Appendix D: How to import the Recovery Catalog in the
new cell
In this example, we export the Recovery Catalog on ita017 and import it into hpu015.
We assume no Recovery Catalog backup was taken previously with Data Protector, or this backup is
not available.
On the source system (ita017), export the recovery catalog owned by the user RMAN and copy it to
the target system:
oracle@ita017[RCVCAT]:/home/oracle$ exp rman/xxx@rcvcat file=rcvcat.dmp owner=rman
Export: Release 10.2.0.3.0 - Production on Wed Mar 19 11:34:38 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
Production
With the Partitioning, OLAP and Data Mining options
…
oracle@ita017[RCVCAT]:/home/oracle$ scp rcvcat.dmp oracle@hpu015:/home/oracle/
On the target system (hpu015), create the user RMAN and grant it the needed privileges:
NOTE:
If there is a already a Recovery Catalog, then create a new recovery
catalog owner; in our case there is already an RMAN user; we create
another user called RMANI for the new recovery catalog
oracle@hpu015[RCVCAT]:/home/oracle$ sq
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Mar 19 11:36:10 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
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 username,default_tablespace from dba_users;
USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
MGMT_VIEW SYSTEM
SYS SYSTEM
SYSTEM SYSTEM
DBSNMP SYSAUX
SYSMAN SYSAUX
RMAN RCVCAT
OUTLN SYSTEM
WMSYS SYSAUX
ORDSYS SYSAUX
EXFSYS SYSAUX
XDB SYSAUX
USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
DMSYS SYSAUX
OLAPSYS SYSAUX
SI_INFORMTN_SCHEMA SYSAUX
ORDPLUGINS SYSAUX
MDSYS SYSAUX