OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » SCN Numbers

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

SCN Numbers [message #165970]

Mon, 03 April 2006 15:24

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

I want to do incomplete recovery,
and i want to use command :
RECOVER DATABASE UNTIL SCN [SCN number]

but i am confused where can i get the SCN numbers so that i can decide uptill what SCN i should recover.
I want to recover only thru SCN Number.

plz help.

Report message to a moderator

Re: SCN Numbers [message #165971 is a reply to message #165970]

Mon, 03 April 2006 15:59

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmrecov.htm#1008597

Report message to a moderator

Re: SCN Numbers [message #166066 is a reply to message #165970]

Tue, 04 April 2006 06:00

ksaad
Messages: 1
Registered: April 2006
Location: India

Junior Member

select file#,checkpoint_change# from v$datafile;

Report message to a moderator

Re: SCN Numbers [message #167940 is a reply to message #165970]

Tue, 18 April 2006 01:18

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Hi,

In Oracle 9i onwards to know the current scn

select  dbms_flashback.get_system_CHANGE_NUMBER from dual;

Rgds
SALIH KM Cool

Report message to a moderator

Re: SCN Numbers [message #168054 is a reply to message #167940]

Tue, 18 April 2006 09:57

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

Thank you so much all of U for Ur frequent Response.

Report message to a moderator

Previous Topic:	backup
Next Topic:	hot backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 03 04:28:35 CDT 2025