Home » RDBMS Server » Backup & Recovery » point in time recovery in oracle 10g. (Oracle
point in time recovery in oracle 10g. [message #415691] Tue, 28 July 2009 13:35 Go to next message
Messages: 1
Registered: July 2009
Junior Member

Hi everybody..
iam doing point in time recovery using cold backup.
my db is in archive log mode.
for this i have created a user and done some transactns and set time on and then dropped the table and commited.
later i shut down my db and taken a fresh backup.so i need to restore my db to the point before dropping.so due to that reason i restored my db to last cold backup taken.then i opened my db and gave alter database recover automatic using backup controlfile until that time.
its showing some threads are missing and unable to reover t.

can anyone explain me y this error is coming.

thankyou in advance !!!
Re: point in time recovery in oracle 10g. [message #415745 is a reply to message #415691] Wed, 29 July 2009 01:49 Go to previous message
Michel Cadot
Messages: 67846
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Copy and paste what you did and got.

Before, please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.


[Updated on: Wed, 29 July 2009 01:49]

Report message to a moderator

Previous Topic: RMAN compare to TS in HOT backup mode
Next Topic: Tablespace recovery
Goto Forum:

Current Time: Tue May 11 06:40:49 CDT 2021