If you try to take the backup of a controlfile and it returns ORA-00236, it means that you are trying to take backup of a controlfile that is already a backup. The scenario is that you are performing recovery of a database, and during this process, you restored the backup of controlfile. Before recovery is completed and database is opened, the status of controlfile remains “backup”, and trying to backup the controlfile would return ORA-00236.
RMAN> backup format '/backup/testdb/control_4jun.bak' current controlfile;
Starting backup at 04-JUN-18 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=4201 device type=DISK channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/04/2018 13:01:12 ORA-00236: snapshot operation disallowed: mounted control file is a backup |
SQL > select controlfile_type from v$database;
CONTROL ------------- BACKUP
1 row selected. |
No comments:
Post a Comment