Help:"backup database plus archivelog not backed up;" no good?
Date: Fri, 7 Mar 2008 19:42:21 -0800 (PST)
I have a 4 nodes RAC on redhat linux(10.2.0.3) the relevant configuration is like this: RMAN>CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 2; RMAN>CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '+TST', '/backup/bk_ %d_%T_%U_%p' MAXPIECESIZE 2 G;
I use the command
backup database plus archivelog not backed up;
the backup went successfully, even "restore database validate" did not give any error.
How ever, when i move the whole backupset to another host, and do the restore, restore successfully.
But recover database gives me the error
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get
ORA-01152: file 3 was not restored from a sufficiently old backup ORA-01110: data file 3: '+TST/trng/datafile/sysaux.10463.648771607'
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
RMAN-03002: failure of recover command at 03/07/2008 22:21:05 RMAN-06053: unable to perform media recovery because of missing log RMAN-06025: no backup of log thread 4 seq 22 lowscn 6432367 found torestore
RMAN-06025: no backup of log thread 4 seq 21 lowscn 6258555 found to restore
RMAN-06025: no backup of log thread 3 seq 20 lowscn 6432380 found to restore
It seems to me that "backup database plus archivelog not backed up" did not backup enough archivelogs, thread 4 seg 22 was archive 8 hours later after the database backup. Which means if my database crashed after I took the full database backup, and I lost online redo logs, I will lost my database, as thread 4 seq 22 was still in online redo yet when the backup finished.
What is the correct way of backing up my database to avoid this problem?
Thanks Received on Fri Mar 07 2008 - 21:42:21 CST