Oracle RMAN Question:
Download Job Interview Questions and Answers PDF
Tell me Is it possible to take Catalog Database Backup using RMAN?
Answer:
Yes, 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.
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.
Download RMAN Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How to setup the RMAN tape backups? | How to clone the database using RMAN software? Give brief steps? When do you use crosscheck command? |