Database Backup and Recovery (MOSC)

MOSC Banner

point in time table restore

edited Nov 1, 2010 7:16AM in Database Backup and Recovery (MOSC) 13 commentsAnswered
Hello.

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';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center