Home » RDBMS Server » Server Administration » Unable to find out the SCN to perform the incompete recovery (merged)
Unable to find out the SCN to perform the incompete recovery (merged) [message #382421] Thu, 22 January 2009 04:23 Go to next message
kesavansundaram
Messages: 181
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 #382422 is a reply to message #382421] Thu, 22 January 2009 04:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You know there is code tags, you (ab)use it in all your post as header and footer.
Now (correctly) use it with your query.
This has been asked to you several times.
Do it now.

Regards
Michel
Unable to find out the SCN to perform the incompete recovery [message #382424 is a reply to message #382421] Thu, 22 January 2009 04:31 Go to previous messageGo to next message
kesavansundaram
Messages: 181
Registered: October 2007
Location: MUMBAI
Senior Member


Dear sir,

sorry for the incon(.)

Iam regularly posting correctly, but my internet screen was taking much time, hence i tried to refresh and post it again...but it is registered....

pls acccept our apologies..and provide the solution for subejct issue.

thank you
kesavan.

[Updated on: Thu, 22 January 2009 04:40]

Report message to a moderator

Re: Unable to find out the SCN to perform the incompete recovery [message #382427 is a reply to message #382424] Thu, 22 January 2009 04:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please repost the query formatted.
And don't start a new topic for this.

Regards
Michel
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 Go to previous messageGo to next message
kesavansundaram
Messages: 181
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.
Re: Unable to find out the SCN to perform the incompete recovery [message #382444 is a reply to message #382438] Thu, 22 January 2009 06:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I give up.
Do you think the query is formatted?

Regards
Michel

[Updated on: Thu, 22 January 2009 06:03]

Report message to a moderator

Re: Unable to find out the SCN to perform the incompete recovery [message #382482 is a reply to message #382438] Thu, 22 January 2009 10:26 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
And what is with those empty CODE tags like header and footer in all your posts?
Previous Topic: ORA-00922: missing or invalid option
Next Topic: Data File size in UNDO Tablespace 380 GB
Goto Forum:
  


Current Time: Sun Dec 04 18:35:29 CST 2016

Total time taken to generate the page: 0.15992 seconds