Recovery Catalog Database Using RMAN - Karan Rajpoot

                                    Recovery Catalog Database Using RMAN 


By default, RMAN connects to the target database in NOCATALOG mode, meaning that it uses the control files in the target database as the sole repository of RMAN metadata. Perhaps the most important decision you make when using RMAN is whether to create a recovery catalog as the RMAN repository for normal production operations. A recovery catalog is a schema created in a separate database that contains metadata obtained from the target control file.

With the use of the recovery catalog database, you can put all the backup or pieces information of the multiple databases in a single location.

==> Benefits of Using the Recovery Catalog as the RMAN Repository

When you use a recovery catalog, RMAN can perform a wider variety of automated backup and recovery functions than when you use the control file in the target database as the sole repository of metadata.

==>The following features are available only with a catalog

1) You can store metadata about multiple target databases in a single catalog.

2) You can store metadata about multiple incarnations of a single target database in the catalog. Hence, you can restore backups from any incarnation.

3) Resynchronizing the recovery catalog at intervals less than the CONTROL_FILE_RECORD_KEEP_TIME setting, you can keep historical metadata.

4) You can report the target database schema at a noncurrent time.

5) You can store RMAN scripts in the recovery catalog.

==> Steps to create a Recovery Catalog Database 


Step 1) First to create a tablespace for the recovery catalog database to put the information.

Recovery_Catalog Tablespace Creation


Step 2) Next step is to create a recovery catalog user and assign tablespace which we have created in the first step.

Recovery Catalog User

Step 3) Grant the recovery_catalog_owner permission to the user.

Grant permission to the User

Step 4) Connect to the RMAN to create the catalog database.

create catalog database

Step 5) Now Register the databases which will use this database as a recovery catalog.

register database

Step 6) Configure the RMAN persistent parameters.

backup policy

Disk Policy

Step 7) Take the backup plus archivelog from below command.

Command: - backup database plus archivelog.

Step 8) You can also check how many databases are registered under the catalog database by using below command.

Note: - First you need to login to the catalog user.

connection to recovery catalog user

View: - rc_database

Command: - select name,DBID,DB_KEY from rc_database;

Example: -


Thank you!!

Comments

Post a Comment

Popular posts from this blog

How to do "Multiplexing of Control Files" through spfile ( server parameter file) in Oracle 11g

Image
Step 1)  To perform "Multiplexing of Control Files" through spfile ( server parameter file)" first we need to create spfile from pfile. Example to create spfile from pfile: -                                       Step 2) Copy the control files in physical location from 'cp' command. Note: - At present, I have 2 control files,  I will add one more Control files in the same location. Example: -  Now you can see from above output control04.ctl file has been physically added successfully under /u01/app/oracle/oradata/prod/control04.ctl location. Step 3)  Now you need to set the same through alter command. a)  first shut down the database                                          b)  Startup (Start the database through spfile) ...
Read more

How to Add, Resize, Drop and Rename of a datafile in Tablespace

Image
                                       How to Add, Resize, Drop and Rename a datafile in Tablespace In order to create a data file first, need to create a tablespace, To know how to create a tablespace  Click here To demonstrate, I will use USERS tablespace to Add,  Resize, Drop and Rename a data file. First, we can check how many data files are present under USERS tablespace through below command. Command: - select name from v$datafile; We can see from above output only a single data file is present under USERS tablespace. Addition of Datafile: - Command to add a datafile: - alter tablespace users add datafile '/u01/app/oracle/oradata/prod/users02.dbf' size 50m; The new data file has been added to my USERS tablespace. Resize of a Datafile: - Command to resize the datafile: - alter database datafile '/u01/app/oracle/oradata/prod/users02...
Read more

Oracle "Redo log Groups addition/deletion" | Karan Rajpoot

Image
                    Oracle "Redo log Groups addition/deletion" Step 1) To add redo log group first we will check the log groups, members details, location, and size. Example: - From the above output, we can see we have 3 groups and inside every group, we have 1 member each of size 50 MB and the location is /u01/app/oracle/oradata/karan/ Step 2) Now we will add one group and check the status of that group. Example: - Now again we can check the details of log groups and member. Now the 4th group and a member of 50 MB has been added successfully. Step 3) Now I will add one more member to the 4th log group. Example: - We can see from the above output that in group 4, now 2 members are there. Steps to drop the latest added group and member Note: - We cannot drop CURRENT members as shown in the above output, So I will add a new member in group 3 and then I will drop th...
Read more