Purpose of Catalog Database
A base recovery catalog is a database schema that contains RMAN metadata for a set of target databases. A virtual private catalog is a set of synonyms and views that enable user access to a subset of a base recovery catalog.
Catalog Database can be two types
- Base recovery catalog
- Virtual private catalog.
For more details
https://docs.oracle.com/html/E10643_07/rcmsynta013.htm
Create the tablespace for catalog user
SQL> create tablespace rman_cat datafile ‘D:\oracle\product\10.2.0\oradata\cat_01\rman_cat02.DBF’ SIZE 100M; Tablespace created. SQL> create user anuradha identified by anuradha default tablespace rman_cat temporary tablespace temp_1; User created. SQL> grant connect,resource,recovery_catalog_owner to anuradha; Grant succeeded.
Now connect to RMAN with Catalog user
RMAN> connect catalog anuradha/anuradha@cat connected to recovery catalog database RMAN> create catalog tablespace rman_cat recovery catalog created
Take a backup with Catalog database.
C:\>rman target sys/sys@dba_01 catalog Anuradha/anuradha@cat01 Recovery Manager: Release 10.2.0.1.0 – Production on Mon Jul 12 16:08:21 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: ORCL (DBID=847839442) connected to recovery catalog database RMAN> run { allocate channel c1 type disk; allocate channel c2 type disk; backup database; } RMAN> report schema;
If any physical structure changes in target database then this command required for resynchronization.
RMAN> resync catalog; starting full resync of recovery catalog full resync complete RMAN> reset database; database incarnation already registered
This command required only when incomplete recovery occurred in the target database. Remove the one or more datafiles and try to restart the database
SQL> shutdown immediate; Database closed. Database dismounted. Delete some Datafile SQL> startup; ORACLE instance started. Total System Global Area 167772160 bytes Fixed Size 1247876 bytes Variable Size 75498876 bytes Database Buffers 83886080 bytes Redo Buffers 7139328 bytes Database mounted. ORA-01157: cannot identify/lock data file 1 – see DBWR trace file ORA-01110: data file 1: ‘D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\SYSTEM01.DBF’
Restore the deleted file with catalog
C:\>rman target sys/sys@dba_01 catalog anuradha/anuradha@cat01 RMAN> run { allocate channel c1 type disk; allocate channel c2 type disk; restore database; recover database; } SQL> alter database open; Database altered.
Today’s thought
“Act confident, even when you’re not.” Larry Ellison
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Telegram Channel: https://t.me/helporacle
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp