| Incomplete recovery until change [message #284694] |
Fri, 30 November 2007 10:28  |
it_me24
Messages: 167
Registered: March 2006
Location: delhi
|
Senior Member |
|
|
Hello Experts,
I am little bit confused about incomplete recovery.
While doing incomplete recovery until change we use SCN numbers if i am not wrong.
so while quering the dynamic V$Log_history view, i got the following output.
Seq# First_Change Next_Change Date
1111 126568 356131 30-Nov-07
2222 299755 564545 30-Nov-07
3333 456871 655555 30-Nov-07
Can anyone please explain to me,
1. what is First change n next change.
2. how can one know which SCN to pick from the above SCN numbers and use in the recovery.
3. in the above output does seq# means log sequence number.
Thanks for your expert views.
|
|
|
|
|
|
| Re: Incomplete recovery until change [message #284718 is a reply to message #284694] |
Fri, 30 November 2007 12:16  |
it_me24
Messages: 167
Registered: March 2006
Location: delhi
|
Senior Member |
|
|
Thankx for your response.
I have gone through the links.
However my scenario is like i want to do the incomplete recovery.
recover database untill change _______
in the blank place i need to enter the SCN, so on which basis i can decide which SCN should be entered keeping in mind the below output fron v$Log_history view.
Seq# First_Change Next_Change Date
1111 126568 356131 30-Nov-07
2222 299755 564545 30-Nov-07
3333 456871 655555 30-Nov-07
Appreciate your comments.
|
|
|
|
| Re: Incomplete recovery until change [message #284720 is a reply to message #284694] |
Fri, 30 November 2007 12:22 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
>Appreciate your comments.
I do NOT believe that you got the following values from an actual
SELECT * FROM V$LOGHISTORY
1111 126568 356131 30-Nov-07
2222 299755 564545 30-Nov-07
3333 456871 655555 30-Nov-07
In my opinion, your fabricated values do not conform to reality.
Please post using CUT & PASTE complete SQL*Plus session showing actual query & results (using <code tags>).
What version of Oracle to FOUR decimal places?
[Updated on: Fri, 30 November 2007 12:23] by Moderator Report message to a moderator |
|
|
|
| Re: Incomplete recovery until change [message #284722 is a reply to message #284694] |
Fri, 30 November 2007 12:31 |
it_me24
Messages: 167
Registered: March 2006
Location: delhi
|
Senior Member |
|
|
yes you are right...
these are the dummy values.
I just wanted to know how can i get to know on which basis i can decide the value for SCN to be entered in the recovery command.
recover database untill change _______
Thanks for your time.
|
|
|
|
|
|
| Re: Incomplete recovery until change [message #284729 is a reply to message #284694] |
Fri, 30 November 2007 13:04 |
it_me24
Messages: 167
Registered: March 2006
Location: delhi
|
Senior Member |
|
|
> I think on time, doesn't it?
Appreciate your comments Michel.
While using the recovery command recover database untill change SCN
which query will provide me the SCN and the time associated with each SCN, so that i will be able to decide uptil what SCN should i recover my database.
Thanks once again.
|
|
|
|
|
|
| Re: Incomplete recovery until change [message #284734 is a reply to message #284694] |
Fri, 30 November 2007 14:04 |
it_me24
Messages: 167
Registered: March 2006
Location: delhi
|
Senior Member |
|
|
Thanks Michel,
Refering to the links provided by you.
Does that mean i have to use the command SELECT SCN_TO_TIMESTAMP for each SCN and then based on that decide uptil what time recovery has to be done.
thanks for the clarification.
|
|
|
|
|
|
| Re: Incomplete recovery until change [message #284739 is a reply to message #284694] |
Fri, 30 November 2007 14:41 |
it_me24
Messages: 167
Registered: March 2006
Location: delhi
|
Senior Member |
|
|
Thanks ancedent,
May be i am not able to convay what i needed.
I would request you if you could look onto my scenario below.
My question was like we can do incomplete recovery three ways.
1. Until time.
2. Until Cancel.
3. Until Change.
question was about until change, i am familiar with rest of two recovery option.
while using the recovery command (Recover database until change SCN),
So we need to type some SCN to recover the DB prior to the failure.
Now the question arises on what basis can we decide which SCN value to be entered in the recovery command,
If time, then where can i find all the SCN numbers with time associated to each SCN so that i can recover the databse upto that perticular SCN perior to failure.
Note: I want to use incomplete recovery Until Change. only.
Let us suppose V$Log_History displays something like.
1111 126568 356131 30-Nov-07
2222 299755 564545 30-Nov-07
3333 456871 655555 30-Nov-07
Thanks so much for your valuable time.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
