Database Backup and Recovery (MOSC)

MOSC Banner

incomplete point-in-time recovery

edited Jul 30, 2009 3:00AM in Database Backup and Recovery (MOSC) 6 commentsAnswered ✓
Hello.

I am trying to restore a lost partition of one table. To do that I am doing an incomplete point in time cross-node recovery. I have restored the system, sysaux, undo as well as the tablespace where my table is residing as of the time before the partition was dropped. I have also restored the archived logfiles and the controlfile for an appropriate time.  Now I am trying to recover the datafiles as follows:

sql 'alter session set nls_date_format="mm-dd-yyyy hh24:mi"';
set until time '07-21-2009 20:00';
allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type 'SBT_TAPE';

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