|
-
These are the instructions I found on-line, granted they are old but what step am I missing.
Incomplete Recovery Using Time-Based
Scenario: The current time is 12 pm on 9-Mar-01 and someone dropped the
EMP table around 11:45 am. The table must be recovered.
If the database is open, shut it down using either the "normal" or "immediate" options: SVRMGR> shutdown normal;
Mount the database:
SVRMGR> startup mount pfile=Oracle\admin\mike\pfile\init.ora;
Restore all datafiles(*.dbf) from the most recent backup. (Do not restore
the Control file, Redo Logs, or Parameter files.)
UNIX> !cp /disk1/backup/*.dbf /disk1/data/
NT > !copy c:\backup\*.dbf c:\data\
Recover the database: SVRMGR> recover database until time '2001-03-09:11:44:00';
To synchronize datafiles with control files and redo logs, open database using
"resetlogs" options:
SVRMGR> alter database open resetlogs;
Any data entered after the recovery time (11:44 am) will need to be reentered.
Perform a closed whole backup
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|