| Unable to find out the SCN to perform the incompete recovery (merged) [message #382421] |
Thu, 22 January 2009 04:23  |
kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI
|
Senior Member |
|
|
Dear sir,
we are just testing the incompelte recovery in our loacl machine.we are generating backup thro RMAN..and successfully tested incomplete recovery using RECOVER DATABASE UNTIL TIME <...>
Now we need to test the same using SCN no....
for e.g. RECOVER DATABASE UNTIL SCN 1000;
pls adv where to find out this SCN(1000)...
in which view, we can see,
for e.g. when we check the oracle docs, it says,
SQL> SELECT MIN(maxnc) FROM
(SELECT MAX(a.NEXT_CHANGE#) maxnc
FROM V$ARCHIVED_LOG a, V$THREAD t
WHERE a.THREAD# = t.THREAD#
AND a.ARCHIVED='YES'
AND t.ENABLED='DISABLED'
GROUP BY a.THREAD#);
they ask us to check the max(next_change#) from v$archived_log view....if this above is the correct one, please confirm when this next_change# value will get increase...?
when we do the log switch ?
our test scenario is, in one table, we would like to insert 3 rows, then commit....then we would like to note SCN...
then again need to insert 3 rows...note the SCN....
while doing the recovery , we would like to put the SCN no genrated for first 3 rows....so that we should get only 3 rows...
pls cfm....
thank you,
kesavan.
|
|
|
|
|
|
|
|
|
|
| Re: Unable to find out the SCN to perform the incompete recovery [message #382438 is a reply to message #382427] |
Thu, 22 January 2009 05:32  |
kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI
|
Senior Member |
|
|
Dear sir,
Iam reposting the same. kindly do the needful.
we are just testing the incompelte recovery in our loacl machine.we are generating backup thro RMAN..and successfully tested incomplete recovery using RECOVER DATABASE UNTIL TIME <...>
Now we need to test the same using SCN no....
for e.g. RECOVER DATABASE UNTIL SCN 1000;
pls adv where to find out this SCN(1000)...
in which view, we can see,
for e.g. when we check the oracle docs, it says,
SQL> SELECT MIN(maxnc) FROM
(SELECT MAX(a.NEXT_CHANGE#) maxnc
FROM V$ARCHIVED_LOG a, V$THREAD t
WHERE a.THREAD# = t.THREAD#
AND a.ARCHIVED='YES'
AND t.ENABLED='DISABLED'
GROUP BY a.THREAD#);
they ask us to check the max(next_change#) from v$archived_log view....if this above is the correct one, please confirm when this next_change# value will get increase...?
when we do the log switch ?
our test scenario is, in one table, we would like to insert 3 rows, then commit....then we would like to note SCN...
then again need to insert 3 rows...note the SCN....
while doing the recovery , we would like to put the SCN no genrated for first 3 rows....so that we should get only 3 rows...
pls cfm....
thank you,
kesavan.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
