Sunday, June 8, 2008

Configure Recovery Catalog for Target Database

There are three steps for recovery catalog configuration.
1. Configure the database that will content the recovery catalog,
2. Create owner for recovery catalog
3. Create recovery catalog

SQL> conn sys@dev as sysdba
Enter password:

SQL> create tablespace CATDB
2 datafile 'c:\oracle\catdb01.dbf' size 10m;

Tablespace created.

NOTE: Here I am create separate tablespace for recovery catalog on target database.

SQL>conn sys@dev as sysdba
SQL> create user CATDB
2 identified by CATDB
3 default tablespace CATDB;

NOTE: Owner for recovery catalog

SQL> grant connect,resource to catdb;
Grant succeeded.
SQL> grant recovery_catalog_owner to CATDB;
Grant succeeded.
NOTE: Grant the RECOVERY_CATALOG_OWNER role to the schema owner.
This role provides the user with all privileges required to maintain and query the recovery catalog.
Recovery Manager: Release - ProductionCopyright (c) 1995, 2004, Oracle. All rights reserved.
RMAN> connect catalog catdb/catdb@dev
connected to recovery catalog database
recovery catalog is not installed

RMAN> create catalog tablespace CATDB;
recovery catalog created
NOTE: now recovery catalog is created.
SQL> conn catdb/catdb@dev
SQL> select table_name from user_tables where rownum =1;

NOTE: after recovery catalog creation we can check all recovery catalog views is created in recovery catalog owner.

Now just register target database to recovery catalog and store RMAN repository in recovery catalog.
C:\>rman target sys@dev catalog catdb/catdb@dev

Recovery Manager: Release - ProductionCopyright (c) 1995, 2004, Oracle. All rights reserved.
target database
connected to target database: DEV (DBID=3718891706)
connected to recovery catalog database

RMAN> register database;

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

NOTE: “target sys@dev” is use for target database which we want to register to recovery catalog through recovery catalog owner “catdb/catdb@dev”.

How to take Recovery Catalog Backup

1. If recovery catalog created as separate tablespace on target database
Then just export recovery catalog tablespace and store in backup drive.
2. If recovery catalog created as separate database.
Then we can use any backup method which we use for target database for instance we can use user managed backup or we can also use RMAN method.

How can I remove a URL on my website from the Google Index?

To remove a specific URL (for example, the page of your own website from Google’s index, there are two ...