Home » RDBMS Server » Backup & Recovery » Incomplete recovery shows RMAN-20207
Incomplete recovery shows RMAN-20207 [message #538118] Wed, 04 January 2012 02:57 Go to next message
ashishs
Messages: 40
Registered: May 2011
Member

Sir,when i performed incomplete recovery i try to set until time but it shows RMAN-20207:until time or recovery window shoubld be before resetlogs. what is the solution of this problem..


[Split from Incarnation difference by LF]

[Updated on: Wed, 04 January 2012 03:18] by Moderator

Report message to a moderator

Re: Incarnation differenece [message #538121 is a reply to message #538118] Wed, 04 January 2012 03:07 Go to previous messageGo to next message
Michel Cadot
Messages: 65385
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ashishs wrote on Wed, 04 January 2012 09:57
Sir,when i performed incomplete recovery i try to set until time but it shows RMAN-20207:until time or recovery window shoubld be before resetlogs. what is the solution of this problem..


New question, new topic, do NOT mix up the questions.

Regards
Michel

Re: Incarnation differenece [message #538124 is a reply to message #538118] Wed, 04 January 2012 03:14 Go to previous messageGo to next message
John Watson
Messages: 7261
Registered: January 2010
Location: Global Village
Senior Member
Ashish, I've looked through your previous messages trying to work out what you are doing. It looks as though you are trying to teach yourself backup and recovdery rechniques. If so, your first step must be to read the manual, http://docs.oracle.com/cd/E11882_01/backup.112/e10642/toc.htm
Then a sensible way to proceed is to perform a backup, and then simulate various problems, such as losing a datafile; or a controlfile copy; and so on. Then try to restore and recover. The Data Recovery Advisor (chapter 15) can be a useful tool: it will generate scripts for you, but don't just run them, look at them and understand them. You can often improve on them.
Why don't you try it on your database now, and see what it recommends?
Re: Incarnation differenece [message #538127 is a reply to message #538124] Wed, 04 January 2012 03:41 Go to previous message
Michel Cadot
Messages: 65385
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
...Then when you have a question like that COPY AND PASTE what you did and got.
It is very to tell what is wrong with just an error message.

Regards
Michel
Previous Topic: Incarnation difference
Next Topic: how to clone database
Goto Forum:
  


Current Time: Tue Feb 20 20:27:33 CST 2018

Total time taken to generate the page: 0.05284 seconds