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

restore the controlfile, your DB has to be in the mount state first

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

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.