RE: Tablespace recovery - Point in time (TSPITR)

From: A. Bardeen <abardeen1_at_yahoo.com>
Date: Wed, 20 Jun 2001 03:11:24 -0700
Message-ID: <F001.0032FB31.20010620024534@fatcity.com>

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 <NIRMALK_at_qtel.com.qa> wrote:
    > Any Help Please.... !!!!
    >
    > > -----Original Message-----
    > > From: Nirmal Kumar Muthu Kumaran
    > [SMTP:NIRMALK_at_qtel.com.qa]
    > > 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: abardeen1_at_yahoo.com

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: ListGuru_at_fatcity.com (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).

Received on Wed Jun 20 2001 - 05:11:24 CDT