point in time table restore
I am working on restoring a a table via a crossnode restore(oracle v10.2.0.3) and I am looking for a critique of my approach.
So far I have restored the controlfile
run {
sql 'alter session set nls_date_format="mm-dd-yyyy hh24:mi"';
set until time '09-27-2010 08:00';
allocate channel t1 type 'SBT_TAPE';
restore controlfile to '/oradata/oraredo01/db/control1.ctl';
replicate controlfile from '/oradata/oraredo01/db/control1.ctl';
release channel t1 ;
}
and currently I am restoring some of the datafiles
run {
sql 'alter session set nls_date_format="mm-dd-yyyy hh24:mi"';
set until time '09-27-2010 08:00';