Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    41

    Question Unanswered: Using RMAN, how do you restore from an old backup file?

    HI,

    I use Oracle 9i on Solaris.

    I'm currently doing incremental level 0 hot backups every night using RMAN in NOCATALOG mode. The controlfile is backed up with the database. I back it up to a file (e.g. "level0_20041225.dmp"). After I back it up, it's backed up to tape using Veritas. Before doing a backup, I delete the old one first.

    I need to restore a copy of the database backup that was taken a month ago. This file is on tape. How do I go about it using RMAN? The documentation is not too clear as it talks more about Restoring the control file and the latest copy of the database.

    How do you restore an old copy of the database from a database file?

    Pls advise

    Thanks

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    you need to extract it from tape.
    Hopefully you use a catalog. If not ...

    once you can access it, the simplest way is to throw it into the $ORACLE_HOME/dbs
    directory. then, set the sid and use rman to recover the database.

    be sure to create a link from the $ORACLE_HOME/dbs/initsid.ora
    to the rman backup controlfile .
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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