RMAN

ORA-19573: cannot obtain exclusive enqueue for datafile 1 RM

Received below error while doing the dataguard restoration on standby database. RMAN-03002: failure of restore command at 06/30/2019 13:23:19 ORA-19870: error while restoring backup piece /data/rman/CDB/CDB1_D_20190607_0au 3g8ip_s10_p1 ORA-19573: cannot obtain exclusive enqueue for datafile 1 Follow the below steps to solve this error message. Shutdown the database. RMAN> shutdown immediate;database closeddatabase dismountedOracle instance shut down …

ORA-19573: cannot obtain exclusive enqueue for datafile 1 RM Read More »

RMAN oracle database 12c backup script

Change RMAN backup location configure channel device type disk format ‘/data/backup/%U’ maxpiecesize 2 G; SPFILE backups The SPFILE can be automatically backed up with the control file during database backups by configuring the CONTROLFILE AUTOBACKUP parameters To backup up the SPFILE explicitly use: RMAN> BACKUP SPFILE; Controlfile backups The current controlfile can be automatically backed …

RMAN oracle database 12c backup script Read More »