This discussion is archived
6 Replies Latest reply: Nov 16, 2012 4:42 AM by 974641 RSS

Foreign database file

user522961 Newbie
Currently Being Moderated
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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points