Home » RDBMS Server » Backup & Recovery » recover by the scn (10.2.0.1)
recover by the scn [message #556707] Wed, 06 June 2012 04:28 Go to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Dear all,
I want to do the imcomplete recover by the scn, and i want to know how to get the scn in my database?

run{
  set until scn 1000000;
  restore database;
  recover database;
}
Re: recover by the scn [message #556711 is a reply to message #556707] Wed, 06 June 2012 04:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
select current_scn from v$database;

Regards
Michel
Re: recover by the scn [message #556748 is a reply to message #556711] Wed, 06 June 2012 07:16 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks,
Michel,if i have drop a table in after a scn,i want to recover database to the scn,how can i get the scn?
Re: recover by the scn [message #556752 is a reply to message #556748] Wed, 06 June 2012 07:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use Log Miner to find the scn but if you know the time you can use timestamp_to_scn function.

Regards
Michel
Re: recover by the scn [message #556759 is a reply to message #556752] Wed, 06 June 2012 07:46 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks,
Michel,can you tell me how to use the Log Miner?
Re: recover by the scn [message #556762 is a reply to message #556759] Wed, 06 June 2012 07:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It's all in the documentation.

Regads
Michel
Re: recover by the scn [message #556768 is a reply to message #556762] Wed, 06 June 2012 08:41 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks,
I will read the doc.
Re: recover by the scn [message #556770 is a reply to message #556768] Wed, 06 June 2012 08:44 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I will read the doc.
past behavior indicates otherwise.
Previous Topic: delete backupset issue
Next Topic: recover database until cancel
Goto Forum:
  


Current Time: Fri Mar 29 05:59:34 CDT 2024