OraFAQ Forum: Backup & Recovery » recover by the scn

Home » RDBMS Server » Backup & Recovery » recover by the scn (10.2.0.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

recover by the scn [message #556707]

Wed, 06 June 2012 04:28

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;
}

Report message to a moderator

Re: recover by the scn [message #556711 is a reply to message #556707]

Wed, 06 June 2012 04:43

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

select current_scn from v$database;

Regards
Michel

Report message to a moderator

Re: recover by the scn [message #556748 is a reply to message #556711]

Wed, 06 June 2012 07:16

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?

Report message to a moderator

Re: recover by the scn [message #556752 is a reply to message #556748]

Wed, 06 June 2012 07:20

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: recover by the scn [message #556759 is a reply to message #556752]

Wed, 06 June 2012 07:46

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks,
Michel,can you tell me how to use the Log Miner?

Report message to a moderator

Re: recover by the scn [message #556762 is a reply to message #556759]

Wed, 06 June 2012 07:54

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It's all in the documentation.

Regads
Michel

Report message to a moderator

Re: recover by the scn [message #556768 is a reply to message #556762]

Wed, 06 June 2012 08:41

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks,
I will read the doc.

Report message to a moderator

Re: recover by the scn [message #556770 is a reply to message #556768]

Wed, 06 June 2012 08:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I will read the doc.
past behavior indicates otherwise.

Report message to a moderator

Previous Topic:	delete backupset issue
Next Topic:	recover database until cancel

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 17 23:25:14 CST 2025