Home » RDBMS Server » Backup & Recovery » DBPITR (10.2.0.1, Windows 2003)
DBPITR [message #407563] Wed, 10 June 2009 09:31 Go to next message
sant_new
Messages: 165
Registered: June 2008
Senior Member
Hi all,

We have to troubleshoot our application program on our client's database, so after we run the programs we would like to restore the database back to the time prior to the run. They dont have RMAN configured. I researched that DBPITR does imcomplete recovery sometimes. Could you please give me any suggestions on how we can restore the database to the prior time without having to restore the full database?

Thanks a lot!
Re: DBPITR [message #407564 is a reply to message #407563] Wed, 10 June 2009 09:33 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
> Could you please give me any suggestions on how we can restore the database to the prior time without having to restore the full database?
Can not / will not happen
Re: DBPITR [message #407569 is a reply to message #407563] Wed, 10 June 2009 09:53 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> Could you please give me any suggestions on how we can restore the database to the prior time without having to restore the full database?
Very ambiguous requirement which makes no sense.
Restore traditionally means wiping the existing the database.
If you can rephrase the question, may be we can understand what you are looking into.
May be you can restore to another node (without or without RMAN) and do the testing there.
If this is just a small schema, you can export and import it elsewhere and test it there.
Re: DBPITR [message #407575 is a reply to message #407563] Wed, 10 June 2009 10:04 Go to previous message
sant_new
Messages: 165
Registered: June 2008
Senior Member
Thanks for your replies.

I used flashback database and restored the database to the scn prior to the program was run

Thanks
Previous Topic: Rolling forward the archivelog and online redo logs to the restored database
Next Topic: ORA-01092 Oracle instance terminated, disconnection forced (merged)
Goto Forum:
  


Current Time: Tue Dec 06 15:56:11 CST 2016

Total time taken to generate the page: 0.10188 seconds