-
Hi,
How do I find the system change number and what it was , say, 2 hrs ago?
Thanks for your input
Vj
-
You can look in your alert.log and see when your redo logs changed. That will give you your SCN.
Otherwise, you could look at v$log_history for the start and end change number of each redo log.
I hope you're in archive log mode...
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|