Explain the steps required to enable the RMAN backup for a target database?
Submitted by: Administrator1. $ rman target /
2. Configure the persistent parameter of RMAN eg :
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 15 DAYS;
old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 15 DAYS;
new RMAN configuration parameters are successfully store
3. Script to take backup
RMAN> run {
BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
DELETE NOPROMPT OBSOLETE;
CROSSCHECK BACKUP;
}
Submitted by: Administrator
2. Configure the persistent parameter of RMAN eg :
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 15 DAYS;
old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 15 DAYS;
new RMAN configuration parameters are successfully store
3. Script to take backup
RMAN> run {
BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
DELETE NOPROMPT OBSOLETE;
CROSSCHECK BACKUP;
}
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. |
