DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: perform TSPITR

  1. #1
    Join Date
    Mar 2001
    Posts
    109
    Can we perform the Tablespace Point-in-Time Recovery from Oracle Enterprise Manager? Or we have to RMAN command line utility from the OS prompt?

    Thanks.
    zm

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Best is to use the RMAN command line. That way you know for sure that if any errors were to occour.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Mar 2001
    Posts
    109
    If I use RMAN command line to perform TSPITR, I need to prepare the Auxiliary Instance first. I am not quite understand what this Auxiliary Instance means. Do I actually need to create the Auxiliary database?

    I also need to create a password file for the Auxiliary Instance. If I have multiple databases, how can I create the password file for a particular database?

    Thanks.
    zm

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Check this link for more picturesque detail.

    http://technet.oracle.com/doc/oracle...spi.htm#443309


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Mar 2001
    Posts
    109
    That is the document I red. But I got confused. The following is what the document requires for preparing the Auxiliary Instance for TSPITR:

    "Satisfy the following requirements before performing RMAN TSPITR:

    * Create an Oracle Password File for the Auxiliary Instance

    * Create a Parameter File for the Auxiliary Instance

    * Start the Auxiliary Instance

    * Ensure Net8 Connectivity to the Auxiliary Instance

    * Start the Recovery Manager Command Line Interface "

    I don't know if I need to create the Auxiliary database first.
    Also I don't know how to use ORAPWD to create password file for Auxilary as there are more than one databases existing.
    zm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width