Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Location
    Nevada
    Posts
    14

    Smile Unanswered: Restoring the database from an old backup

    OS: Linux Advanced Server 3.0
    DB Version: 9.2.0.4
    Backup Utility: RMAN

    We have a set up for the backups through which we do a nightly backup ..and while performing the backup in RMAN we use

    delete noprompt backup completed before 'sysdate';

    and all the backups are stored to the disk and then to the tape using veritas.

    if i want to restore the database from 2 day old backupset stored in the tape.. How do i do it? is there a way that i can make RMAN recognize the backup that is now transferred from the tape to the disk( to the location where backup took place)

    Please let me know how to accomplish this task?

    - Raj

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    there is a way.

    way #1: put the backup set into the default backup location: $ORACLE_HOME/dbs

    way #2: put the backup set on any path you want, then configure rman to look at that location.
    ie:
    allocate channel c1 device type disk format = /path/to/backupset/%U;
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Sep 2003
    Location
    Nevada
    Posts
    14

    backup couldn't be found

    I placed the backups at the respective places from where i had moved to the tape and executed this command allocating the channels...
    -------------
    RUN
    {
    ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT '/u05/backup/wdb/full/%d_%T_%U';
    ALLOCATE CHANNEL disk2 DEVICE TYPE DISK FORMAT '/u05/backup/wdb/arch/arc_%d_%T_%U';
    RESTORE CONTROLFILE;
    }
    --------------
    when i executed this command using allocate channel , i got the error as follows:

    -----------
    RMAN-03002: failure of restore command at 01/24/2005 14:55:15
    RMAN-06026: some targets not found - aborting restore
    RMAN-06024: no backup or copy of the controlfile found to restore
    -------------


    any suggestions?

    - Raj

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    yes, make sure your backup controlfile is in the proper location and
    that RMAN knows where it is.
    - 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
  •