Home » RDBMS Server » Backup & Recovery » SCN Numbers
SCN Numbers [message #165970] Mon, 03 April 2006 15:24 Go to next message
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.
Re: SCN Numbers [message #165971 is a reply to message #165970] Mon, 03 April 2006 15:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmrecov.htm#1008597
Re: SCN Numbers [message #166066 is a reply to message #165970] Tue, 04 April 2006 06:00 Go to previous messageGo to next message
ksaad
Messages: 1
Registered: April 2006
Location: India
Junior Member
select file#,checkpoint_change# from v$datafile;
Re: SCN Numbers [message #167940 is a reply to message #165970] Tue, 18 April 2006 01:18 Go to previous messageGo to next message
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
Re: SCN Numbers [message #168054 is a reply to message #167940] Tue, 18 April 2006 09:57 Go to previous message
it_me24
Messages: 167
Registered: March 2006
Location: delhi
Senior Member
Thank you so much all of U for Ur frequent Response.
Previous Topic: backup
Next Topic: hot backup
Goto Forum:
  


Current Time: Thu Mar 28 07:20:45 CDT 2024