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';
Monday, January 9, 2012
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment