Re: Tablespace recovery - Point in time (TSPITR)
You can do a tspitr if you are using rman. You can make a clone database, import the tablespace in question with the until time option. T hen export the clone database tablespace and import it into the live database. I hope this helps. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, June 19, 2001 4:25 PM > Any Help Please > > > -Original Message- > > From: Nirmal Kumar Muthu Kumaran [SMTP:[EMAIL PROTECTED]] > > Sent: Monday, June 18, 2001 5:51 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Tablespace recovery - Point in time (TSPITR) > > > > Dear guru's > > > > Can any one please help me , how to do the tablespace point in time > > recovery. > > > > I reviewed the backup and recovery books, but still am not clear. > > > > I don't know how to make the 'Clone Database'. > > > > Hope that i can do TSPITR with three way by using the following > > > > a) cloning a database > > b) transportable tablespace > > c) rman. > > > > Please enlighten me for the above. > > > > Thanks in advance. > > > > Regards, > > Nirmal > > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Tablespace recovery - Point in time (TSPITR)
Nirmal, I've not done a tablespace PITR via RMAN, so I can't help you there. I've done it manually many times and find the following doc has described the steps needed very well: Note: 96197.1 "Recovering a Dropped Table from a Full Database Backup" Essentially a tablespace PITR is accomplished by: * restoring all or a subset of the db files. * performing PITR * exporting the required objects * importing them into the current version of the db (i.e. not the clone on which PITR was done). HTH, -- Anita --- Nirmal Kumar Muthu Kumaran <[EMAIL PROTECTED]> wrote: > Any Help Please > > > -Original Message- > > From: Nirmal Kumar Muthu Kumaran > [SMTP:[EMAIL PROTECTED]] > > Sent: Monday, June 18, 2001 5:51 PM > > To: Multiple recipients of list ORACLE-L > > Subject:Tablespace recovery - Point in time > (TSPITR) > > > > Dear guru's > > > > Can any one please help me , how to do the > tablespace point in time > > recovery. > > > > I reviewed the backup and recovery books, but > still am not clear. > > > > I don't know how to make the 'Clone Database'. > > > > Hope that i can do TSPITR with three way by using > the following > > > > a) cloning a database > > b) transportable tablespace > > c) rman. > > > > Please enlighten me for the above. > > > > Thanks in advance. > > > > Regards, > > Nirmal > > > > > __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Tablespace recovery - Point in time (TSPITR)
Title: RE: Tablespace recovery - Point in time (TSPITR) Any Help Please -Original Message- From: Nirmal Kumar Muthu Kumaran [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 18, 2001 5:51 PM To: Multiple recipients of list ORACLE-L Subject: Tablespace recovery - Point in time (TSPITR) Dear guru's Can any one please help me , how to do the tablespace point in time recovery. I reviewed the backup and recovery books, but still am not clear. I don't know how to make the 'Clone Database'. Hope that i can do TSPITR with three way by using the following a) cloning a database b) transportable tablespace c) rman. Please enlighten me for the above. Thanks in advance. Regards, Nirmal
Tablespace recovery - Point in time (TSPITR)
Title: Tablespace recovery - Point in time (TSPITR) Dear guru's Can any one please help me , how to do the tablespace point in time recovery. I reviewed the backup and recovery books, but still am not clear. I don't know how to make the 'Clone Database'. Hope that i can do TSPITR with three way by using the following a) cloning a database b) transportable tablespace c) rman. Please enlighten me for the above. Thanks in advance. Regards, Nirmal