11gR2 RAC recovery test

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

ORA-00245: control file backup failed; target is likely on a local file system

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

Useful RMAN Commands

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

RMAN Restore Validate

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