Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Wednesday, July 21, 2010

Create RMAN recovery catalog

labrman01(RCAT) /ora_backup/datafile
>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jul 21 10:31:55 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create user RCAT10G identified by rcat10g default tablespace RCAT;

User created.


SQL> grant connect,resource,recovery_catalog_owner to rcat10g;

Grant succeeded.

SQL>exit

labrman01(RCAT) /ora_backup/datafile
>rman

Recovery Manager: Release 10.2.0.4.0 - Production on Wed Jul 21 10:36:20 2010

Copyright (c) 1982, 2007, Oracle. All rights reserved.


RMAN> connect catalog rcat10g/rcat10g@RCAT

connected to recovery catalog database

RMAN> create catalog

recovery catalog created

RMAN> exit


Recovery Manager complete.
labrman01(RCAT) /ora_backup/datafile
>rman

Recovery Manager: Release 10.2.0.4.0 - Production on Wed Jul 21 10:38:33 2010

Copyright (c) 1982, 2007, Oracle. All rights reserved.

RMAN> connect target sys/syspwd@HYPP

connected to target database: HYPP (DBID=2563884143)

RMAN> connect catalog rcat10g/rcat10g@RCAT

connected to recovery catalog database

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

RMAN>exit

No comments: