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

Thread: ORA-01103 while using RMAN to restore

Hybrid View

  1. #1
    Join Date
    Aug 2005
    Posts
    2

    ORA-01103 while using RMAN to restore

    Hi All,

    I need some help in recreating new database instance.
    Here are the steps I have done so far:
    1. Created a database with name 'LASTDB' using DBCA
    2. Connected to RMAN.
    3. RMAN>SET DBID=******; (of the source database)
    4. Connect to target. RMAN>connect target SYS/*****;
    5. Executed controlfile restore on RMAN.
    RMAN>Run{
    Allocate channel D1 Type DISK;
    Set controlfile autobackup format for device type DISK to
    ‘\\\Backup\Prod\%F’;
    Restore controlfile from autobackup;
    }
    6. RMAN> ALTER DATABASE MOUNT;
    Now got an error saying ORA-01103: database name ‘PRODDB' in control file is not ‘LASTDB’

    I tried using NID to change the database name but it's throwing an error that database is not mounted.

    I have browsed a lot and found that I need to recreate a control file of the production database using ALTER DATABASE BACKUP CONTROLFILE TO TRACE and should edit the trace file. But it also says to shutdown the source database which is production database and I cannot try that.

    Also I have tried adding a line to init.ora like lock_space_name = LASTDB. Also tried replacing everything from LASTDB to PRODDB but that didn't work either.

    I have been trying to find a solution to this. Please bear with me as I'm a beginner and please let me know how I can fix the error.

    I am running oracle 10.1.0.2.0 enterprise edition on windows 2000.

    Thanks for your patience,
    KG

  2. #2
    Join Date
    Jan 2005
    Posts
    221
    restore the controlfile, your DB has to be in the mount state first

  3. #3
    Join Date
    Aug 2005
    Posts
    2
    Hi hannah00,

    I cannot get DB into a mount state because of the error ORA-01103. Is there something I am missing here. Please bear with my ignorance.

    Thanks,
    KG

  4. #4
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    I assume you created a shell database "LASTDB" and restoring from the "PROD" database to "LASTDB" by setting the DBID of "PROD" - Just like what we do in an Export / Import command.

    If you wants to create a new database ( cloning) from an exisitng Db, please read about "rman duplicate" command.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

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