RMAN

What is Table Point In Time Recovery (PITR) in Oracle?using RMAN? In the past, when a table was deleted or had to come back after a certain period of time for any reason, it did a lot of unnecessary work. With Oracle Database 12C, we had the chance to bring the table back to our […]

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 […]

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 […]