Hi Friends
Running 11.2.0.3.0 I recently lost a recovery, lost a database and for my luck, some dumps were available.
But the situation fired a yellow light, a warning that my scripts might be useless.
Here is how I make rman backups every FRIDAY
run {
allocate channel d1 type disk;
backup as compressed backupset
incremental level 0
format 'c:\BACKUP\RMAN\rman_%s%t.bkp'
database;
copy current controlfile to 'C:\BACKUP\RMAN\CONTROL_FILES\ctl_%s%t.ctl';
sql 'alter system archive log current';
backup
format 'C:\BACKUP\RMAN\BACKUP_ARC\arc_%t%s'
archivelog all
delete input;
release channel d1;
}
Here is how I make rman backups every day instead of friday
run {
allocate channel d1 type disk;
backup as compressed backupset
incremental level 2
format 'C:\BACKUP\RMAN\rman_%s%t.bkp'
database;
copy current controlfile to 'C:\BACKUP\RMAN\CONTROL_FILES\ctl_%s%t.ctl';
release channel d1;
}
But last week we had a power outage that prevented the DB to be opened and we stuck forever in error ORA-10567: Redo is inconsistent with data block (file# 37) an then after some workarounds we faced ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
All we had was a full level 0 backup and the database was looking for a log that were created before the level 0 backup and also sometimes logs generated during the backup level0, but a crosscheck that retains only 01 day of recovery windows deleted them automaticly
My question is:
If I run this backup level 0 script with the DB opened and with mediu activity, some users and jobs running, am I missing something?
Do I MST use "plus archivelog" with all scripts so that rman also backs up the logs during the backup operation.
After I have lost the forst DB in many many years I have to question my procedures.
How to write a perfect and complete rman level0 scripts that can recovery the DB after any failures without maintaining too much old archived redo logs?
Tks a lot guys