Friday, October 12, 2012

Recovery catalog creation

---How to create recovery catalog----
I am going to create recovery catalog in demo database.

1)connect to demo database where you want to create the recovery catalog schema.

$sqlplus sys as sysdba
SQL> select name from v$database;


2)create one schema and grant requried permission to the schema.

SQL> select username from dba_users where username='RMAN';

no rows selected

SQL> create user rman identified by rman;

User created.

SQL> grant connect,resource,recovery_catalog_owner to rman;

Grant succeeded.

3)Now connect to the catalog schema and create the catalog.

[oracle@localhost datapump]$ rman target / catalog=rman/rman@demo

Recovery Manager: Release - Production on Fri Oct 12 00:08:34 2012

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

connected to target database: ASTI (DBID=1162410665)
connected to recovery catalog database

RMAN> create catalog;

recovery catalog created

4) Register the asti database to the catalog.

RMAN> register database;

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

No comments:

Post a Comment