Oracle sql query to find sequence number of archive logs to be applied for recovery during restoring online database:
$ Select SEQUENCE#,to_char(FIRST_TIME,'YYYY-MM-DD:HH24:MI:SS') FIRST_TIME from v$archived_log where to_char(FIRST_TIME,'YYYY-MM-DD HH24:mi:ss') between '2011-01-10 01:26:54' and '2011-01-11 21:00:00';
Subscribe to:
Post Comments (Atom)
1 comment:
Thanks for sharing great information in your blog. Got to learn new things from your Blog . It was very nice blog to learn about Selenium.
selenium Training in Chennai
Post a Comment