restore archivelog both threads at the same time
mirmadJun 26 2009 — edited Jun 27 2009Y'ello All,
While trying to recover an offline datafile on a two node RAC, it keeps asking for threads from both nodes with is normal.
My questions are:
a) Is there a script that will tell me the list of archive logs needed to recover that particular datafile?
b) I only know how to restore archive logs for one thread, see below
run
{
allocate channel p1 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
restore archivelog from sequence 147422 until sequence 147427 thread 1;
release channel p1;
}
But want to restore both threads at the same time, not running twice the rman command for thread 1 and then thread 2.
will the below work?
run
{
allocate channel p1 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
restore archivelog from sequence 147422 until sequence 147427 thread 1;
restore archivelog from sequence 251561 to 251573 thread 2;
release channel p1;
}
Kindly help and advice.
DID