TSPITR [message #502206] |
Tue, 05 April 2011 04:06 |
sekar52
Messages: 141 Registered: May 2010 Location: Mumbai
|
Senior Member |
|
|
Hi,
Imagine this situation
Current time :05 Apr 2011
I have to perform the TSPITR of a tablespace to recover it to a time 03-apr-2011 5 pm.Now I have done that.
Now I find that I need to actually recover it ti 04-apr-2011.Can I again recover the tablespace to 04-Apr after recovering it to 03-Apr by mistake.
I am not usng recovery catalog;
|
|
|
|
Re: TSPITR [message #502212 is a reply to message #502210] |
Tue, 05 April 2011 04:48 |
sekar52
Messages: 141 Registered: May 2010 Location: Mumbai
|
Senior Member |
|
|
Actually I had to recover a tablespace to 04-Apr 5:00 pm but by mistake I recovered it to 03-Apr 05:00 pm and brought the tablespace online.
Now can I again do TSPITR to recover tablespace to 04-Apr 05:00 pm.
I did this mistake today at 10:00 am
|
|
|
|
|
|
Re: TSPITR [message #502225 is a reply to message #502224] |
Tue, 05 April 2011 06:44 |
sekar52
Messages: 141 Registered: May 2010 Location: Mumbai
|
Senior Member |
|
|
I knew it But you where saying
Quote:How is this possible? Oracle does not allow to put a tablespace (actually its data files) online if the current SCN does not match the one of rest of the database. I have to assume that you recover the whole database and open it at this time but I may be wrong.
So please, copy and paste what did and got.
Actually we can do that..So why I was asking
[Updated on: Tue, 05 April 2011 07:08] by Moderator Report message to a moderator
|
|
|
|
|
Re: TSPITR [message #502235 is a reply to message #502234] |
Tue, 05 April 2011 07:24 |
sekar52
Messages: 141 Registered: May 2010 Location: Mumbai
|
Senior Member |
|
|
This is what I did
Actually I had to recover a tablespace to 04-Apr 5:00 pm but by mistake I recovered it to 03-Apr 05:00 pm and brought the tablespace online.
Now can I again do TSPITR to recover tablespace to 04-Apr 05:00 pm.
I did this mistake today at 10:00 am
|
|
|
|
Re: TSPITR [message #502241 is a reply to message #502235] |
Tue, 05 April 2011 07:46 |
John Watson
Messages: 8951 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
You didn't say what release you are on, or how you did it - but certainly in the current release, RMAN is very clever and I should think you can just do it again. Try it - it sounds as though you have nothing to lose.
|
|
|
Re: TSPITR [message #502340 is a reply to message #502241] |
Wed, 06 April 2011 00:37 |
sekar52
Messages: 141 Registered: May 2010 Location: Mumbai
|
Senior Member |
|
|
I am using 10g R2
Oracle doc says
Assume that you run TSPITR on a tablespace, and then bring the tablespace online
at time t. Backups of the tablespace created before time t are no longer usable for
recovery with a current control file. You cannot run TSPITR again on this
tablespace to recover it to any time less than or equal to time t, nor can you use the
current control file to recover the database to any time less than or equal to t.
Therefore, you must back up the recovered tablespace as soon as TSPITR is
complete.
Is it the time on which we bring the tablespace online after TSPITR or is it the old time to which we restore the tablespace to.
|
|
|
Re: TSPITR [message #502347 is a reply to message #502340] |
Wed, 06 April 2011 01:15 |
|
Michel Cadot
Messages: 68693 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
It does not matter, drop the tablespace and restart the process from the beginning using a backup of the control file in the auxiliary db (or just the one you used in the previous restore), it will work. The problem is just with the current control file.
Regards
Michel
|
|
|