-
recover database until time
All:
I am trying to get the recover database until time option to work.
I took the following steps
1) created a table and added 25 rows to it and at 10:30AM
2) I shutdown the database
3) I backed up the data file associated with the tablespace.
4) I startuped database
5) 10:35AM I dropped the table.
6) shutdown database
7) I restored datafile from back
8) startup mount database
9) recover database until time '2009-02-25:10:30:00';
I get the following erorr: ORA-00283: recovery session canceled due to errors
ORA-19907: recovery time or SCN does not belong to recovered incarnation
Is there a table I need to query first to find the correct time I can recover
too? Or is there something wrong with my test case. If so, can somebody
please correct
Thanks in advance to all who answer this post
-
I'm not sure you got the concept of point-in-time recovery... it relies on having hot backups followed by archivelog backups. It seams to me you are attempting point-in-time recovery with a cold backup.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
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
-
The hot backup part perhaps?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
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
|