6 Replies Latest reply: Nov 16, 2012 6:42 AM by 974641 RSS

    Foreign database file

    user522961
      Hi,
      on 10g R2 ,I try to use the RMAN backup files from another data base for my database :
      target database Password:
      connected to target database: ORCL2 (DBID=728416591)
      connected to recovery catalog database
      
      RMAN> catalog start with 'E:\oracle\backup\orcl2';
      
      searching for all files that match the pattern E:\oracle\backup\orcl2
      
      List of Files Unknown to the Database
      =====================================
      File Name: E:\ORACLE\BACKUP\orcl2\AL_ORCL2_20110404_3_1
      File Name: E:\ORACLE\BACKUP\orcl2\CTL_ORCL2_20110404_4_1
      File Name: E:\ORACLE\BACKUP\orcl2\DF_ORCL2_20110404_1_1
      File Name: E:\ORACLE\BACKUP\orcl2\DF_ORCL2_20110404_2_1
      
      Do you really want to catalog the above files (enter YES or NO)? YES
      cataloging files...
      no files cataloged
      
      List of Files Which Where Not Cataloged
      =======================================
      File Name: E:\ORACLE\BACKUP\orcl2\AL_ORCL2_20110404_3_1
        RMAN-07518: Reason: Foreign database file DBID: 703792865  Database Name: ORCL2
      File Name: E:\ORACLE\BACKUP\orcl2\CTL_ORCL2_20110404_4_1
        RMAN-07518: Reason: Foreign database file DBID: 703792865  Database Name: ORCL2
      File Name: E:\ORACLE\BACKUP\orcl2\DF_ORCL2_20110404_1_1
        RMAN-07518: Reason: Foreign database file DBID: 703792865  Database Name: ORCL2
      File Name: E:\ORACLE\BACKUP\orcl2\DF_ORCL2_20110404_2_1
        RMAN-07518: Reason: Foreign database file DBID: 703792865  Database Name: ORCL2
      Is there any solution for this error ? Can we define DBID for our database ?
      Thank you.
        • 1. Re: Foreign database file
          Helios-GunesEROL
          Hi;

          RMAN-07518: Reason: Foreign database file DBID: string Database Name: string
          Cause: This is an informational message only.
          Action: No action is required.

          Regard
          Helios
          • 2. Re: Foreign database file
            565226
            You cannot use backup of one database for the recovery of another database and also cannot catalog the backups of another database. Because there is a difference in DBID in both database. You can instead use transportable tablesapce feature to have the data of particular tablespace from one database to another.
            • 3. Re: Foreign database file
              Chinar
              on 10g R2 ,I try to use the RMAN backup files from another data base for my database :
              Your work is wrong.Firstly why you want using another database backups for other database?,second this will not work even these have same DBID.So choose correct ways and steps perform your backup and recovery operations.
              • 4. Re: Foreign database file
                Helios-GunesEROL
                Hi user;
                on 10g R2 ,I try to use the RMAN backup files from another data base for my database :
                You mean you are trying to use RMAN backup and create new db wiht that backup or you mean try to use one database backup to recover one other db.

                For option 1 its possible, for option 2 its not

                Regard
                Helios
                • 5. Re: Foreign database file
                  user522961
                  Hi all,
                  I was trying to find a way to use the RMAN backups to create a new DB supposing that the original target has completely deleted. I have always appreciated HOT Backups since they are useable to create a database in any circumstance (by creating control file).
                  Up to you then RMAN Backup files are unusable if target database is deleted.

                  Helios, how can I use them to create a new DB ? (Option 1)
                  Thanks .
                  • 6. Re: Foreign database file
                    974641
                    Hello Chinar,

                    Unfortunately, what you have said is entirely wrong. The restoration of a database to a second server is something that alot of people/organisations do. The reason is because of disaster recovery.

                    If I use DUPLICATE DATABASE to restore to a test server, I end up with a different DBID for each restoration which is not always desireable (for example if the server is a part of a Data Guard configuration). Of course, I could use Data Pump but that is a lot of unecessary work and it takes a good while longer when dealing with databases in the Terabyte range.

                    The correct answer to the question is the following:

                    From the RMAN prompt:

                    SET DBID= 12345678;
                    RESTORE SPFILE TO '<path>' from '<path>';
                    RESTORE CONTROLFILE FROM AUTOBACKUP;
                    RESTORE DATABASE;
                    RECOVER DATABASE;

                    There is of course a good deal more to add to the list but that is the basis for the restoration.

                    Regards,

                    Kev