Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get the last SCN number from catalog database

user11977214Jun 16 2010 — edited Jun 17 2010
Hi All,

I have a catalog database where my PROD database is registered. Evereyday at 12AM rman takes the hot backup of PROD.

Now I want to create a auxillary database using the last RMAN backup, for this I want to restore using the SCN from the catalog views.

Please help me to get the SCN number from the RC_ views.

Regards,
Bikram
This post has been answered by asifkabirdba on Jun 16 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 15 2010
Added on Jun 16 2010
7 comments
4,023 views