Home » RDBMS Server » Backup & Recovery » TSPITR
TSPITR [message #502206] Tue, 05 April 2011 04:06 Go to next message
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 #502210 is a reply to message #502206] Tue, 05 April 2011 04:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not clear what you did and have now.
Copy and paste all actions you did.

Regards
Michel
Re: TSPITR [message #502212 is a reply to message #502210] Tue, 05 April 2011 04:48 Go to previous messageGo to next message
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 #502214 is a reply to message #502212] Tue, 05 April 2011 05:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
...and brought the tablespace online.

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.

Quote:
Now can I again do TSPITR to recover tablespace to 04-Apr 05:00 pm.

Drop the tablespace and recover it again.

Regards
Michel
Re: TSPITR [message #502223 is a reply to message #502214] Tue, 05 April 2011 06:03 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
What is the concept of TSPITR then....
Re: TSPITR [message #502224 is a reply to message #502223] Tue, 05 April 2011 06:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You did it ands you don't know the concept?!!

Database Backup and Recovery Advanced User's Guide
Chapter 8 RMAN Tablespace Point-in-Time Recovery (TSPITR)

Regards
Michel

Re: TSPITR [message #502225 is a reply to message #502224] Tue, 05 April 2011 06:44 Go to previous messageGo to next message
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 #502228 is a reply to message #502225] Tue, 05 April 2011 07:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can do that ONLY if you do it OUTSIDE the source database not inside it.
As you refuse to post what you actually did, I can just assume you did it in the source db.

Regards
Michel
Re: TSPITR [message #502234 is a reply to message #502228] Tue, 05 April 2011 07:23 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
I told you taht I did a tspitr..
Re: TSPITR [message #502235 is a reply to message #502234] Tue, 05 April 2011 07:24 Go to previous messageGo to next message
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 #502238 is a reply to message #502235] Tue, 05 April 2011 07:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do it in the same way.

Regards
Michel
Re: TSPITR [message #502241 is a reply to message #502235] Tue, 05 April 2011 07:46 Go to previous messageGo to next message
John Watson
Messages: 8922
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 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 68625
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
Previous Topic: error while restoring database using rman
Next Topic: ORACLE dump file to txt file
Goto Forum:
  


Current Time: Thu Mar 28 18:07:54 CDT 2024