Tell me Is it possible to take Catalog Database Backup using RMAN?
Submitted by: AdministratorYes, you can perform backup of catalog database using RMAN with below steps:
1. Start the RMAN with NOCATALOG option.
2. Run the recovery catalog database in ARCHIVELOG mode.
3. set the retention policy to a REDUNDANCY value greater than 1.
4. Backup the database onto two separate media(disk and tape), You can use BACKUP COPIES 2.
5. Donot use another recovery catalog as the repository for these backups.
6. configure the controlfile autoback feature to ON.
Submitted by: Administrator
1. Start the RMAN with NOCATALOG option.
2. Run the recovery catalog database in ARCHIVELOG mode.
3. set the retention policy to a REDUNDANCY value greater than 1.
4. Backup the database onto two separate media(disk and tape), You can use BACKUP COPIES 2.
5. Donot use another recovery catalog as the repository for these backups.
6. configure the controlfile autoback feature to ON.
Submitted by: Administrator
Read Online Oracle RMAN Job Interview Questions And Answers
Top Oracle RMAN Questions
| ☺ | What are RTO, MTBF, and MTTR? |
| ☺ | How to enable the encryption for RMAN backups? |
| ☺ | How RMAN improves backup time? |
| ☺ | Explain what is Channel? How to enable the parallel backups with RMAN? |
| ☺ | How to setup the physical stand by database with RMAN? |
Top DB Oracle Categories
| ☺ | Oracle PL-SQL Interview Questions. |
| ☺ | Oracle DBA Interview Questions. |
| ☺ | Oracle D2K Interview Questions. |
| ☺ | OCI Interview Questions. |
| ☺ | Oracle RMAN Interview Questions. |
