I was working on a recovery guide for a RAC cluster I built so I thought I would share the recovery of the DATA diskgroup. The set-up is a 2 node RAC cluster running 11.2.0.3 standard edition ASM with 2 disk groups DATA and FLASH. The OCR and voting disk are in the DATA diskgroup […]
Oracle 11.2.0.3 RAC DB backup failing with the following error: Error Mon Oct 07 01:03:28 2013 Errors in file /u01/app/oracle/diag/rdbms/testdb/TESTDB1/trace/TESTDB1_ora_25286.trc: ORA-00245: control file backup failed; target is likely on a local file system Cause This is down to the snapshot controlfile being on a local disk and it needs to be on a shared disk […]
Show all of the RMAN parameters for the database RMAN> show all; Configure the disk channel to the format /backup/ora_df%t_s%s_s%p’ RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ‘/backup/ora_df%t_s%s_s%p’; Configure the disk channel to the format +FLASHDG RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ‘+FLASHDG’; Backup the database using the standard RMAN parameters RMAN> backup database; […]
The RMAN restore validate command can be very useful to test the integrity of your backups on tape or disk; it is sometimes not feasible to test a restore so we can at least run the restore validate as a test. We can check for database, controlfile, spfile or archivelogs. Restore database test RMAN> restore database […]
Running an RMAN backup or backup validate will check for logical and physical corruption on the data blocks, with 11g we get more output back from the run listing if there are any blocks marked corrupt. Output from checking a test database for corruptions, in the test run we have no issues RMAN> backup check […]
For the Love of Data 