Home » RDBMS Server » Backup & Recovery » obtaining last SCN generated for crashed database ?
obtaining last SCN generated for crashed database ? [message #402219] Fri, 08 May 2009 02:20 Go to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
If I would want to recover the database via SCN number how this can be done ?


rman> set until scn <number> ;
rman> recover database;

Hw the last scn generated can be obtained, since the databae would be in crashed state ?

Report message to a moderator

Re: obtaining last SCN generated for crashed database ? [message #402250 is a reply to message #402219] Fri, 08 May 2009 03:30 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
From RMAN list backup and other reporting tools.
You can also use TIME instead of SCN.

Report message to a moderator

Previous Topic: RMAN hotbackup
Next Topic: Toggle Read-Only Schema
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jul 12 01:08:08 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.