Rman backup.

[penzk001]

I have a bit of a problem. We have a production server and we make backups using rman. The database is in archivelog mode. This morning we made the backups (full /control / redo logs). During the day, the client inputed some data. A RAID disk failed and we need to restore the database to log 30012). The recovery catalog has in it register till 30001. How can I restore the database till SCN 30012?

Is there a way to backup the log immediately as it is archived to avoid such situations ?

Thanks

 

[stefanhei]

I don't know of a way to backup the archivelogs immediately after they are written - and i don't think there is one.
But to avoid that situation in the future you could multiplex your archives to different disks. That's what the multipe log_archive_dest's in your init.ora are for.
If you didn't multiplex and actually lost your archivelogs due to that failure i fear you lost data.

Stefan

 

[penzk001]

Actually I had the redo on another disk...however I do not know how can I restore them...

This is the rman script I am using


run {
execute script alloc_all_disks;
set archivelog destination to 'D:\oracle\oradata\CUSTEST2\archive';
restore controlfile;
alter database mount;
restore database;
recover database;
alter database open resetlogs;
}

In location 'D:\oracle\oradata\backup\archive' there are the logs 30002 to 30012.

the rman error is:
RMAN-08054: starting media recovery

RMAN-03022: compiling command: recover(4)
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: d1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover(4)
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 30004 scn 683026 found to restore
RMAN-06025: no backup of log thread 1 seq 30003 scn 682974 found to restore

RMAN>

 

[stefanhei]

If the files definitively are in that directory you can manually catalog them.
When connected to catalog and target with rman issue:
catalog archivelog 'D:\oracle\oradata\CUSTEST2\archive\NameOfFile.Ext';
for each file from 30002 to 30012
If the files are not there you can look at your alert.log and do a point in time recovery until time for 30003 (which should be the earlier).

Stefan

 

[penzk001]

Thanks for your help Stefan, I managed to restore the database till redo log 30012. The problem was that I was not cataloging the log.


Thanks and Regards
Kenneth