Oracle rman restore problems.

I backup one of my test db that sid as ORCL via
run
{
     backup database;
}

command result of this script created two files one of this file

O1_MF_NCSNF_TAG20101109T141743_6FLH1C6C_.BKP  is control file
 '/export/home/oraclebackup/O1_MF_NNNDF_TAG20101109T141743_6FLGZ86C_.BKP' s data file

I copied two of this files new installed Solarin 10 x86 and Oracle 10 computer.

When I try to restore blow script and commands

---------------------------------------------
bash-3.00$ rman target / nocatalog;
 
Recovery Manager: Release 10.2.0.2.0 - Production on Tue Nov 9 16:07:36 2010
 
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
 
connected to target database (not started)
 
RMAN> startup nomount;
 
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/10.2.0/db_1/dbs/initORCL.ora'
 
starting Oracle instance without parameter file for retrival of spfile
Oracle instance started
 
Total System Global Area     159383552 bytes
 
Fixed Size                     1279048 bytes
Variable Size                 58723256 bytes
Database Buffers              92274688 bytes
Redo Buffers                   7106560 bytes
 
RMAN> SET DBID 1262397168;
 
executing command: SET DBID
 
RMAN> RUN
{
  ALLOCATE CHANNEL ch00 TYPE DISK connect 'sys/ora123';
  RESTORE CONTROLFILE TO '/tmp/control01.ctl' FROM '/export/home/oraclebackup/O1_MF_NCSNF_TAG20101109T141743_6FLH1C6C_.BKP';
  RESTORE CONTROLFILE FROM '/tmp/control01.ctl'; # restores to all CONTROL_FILES locations
  ALTER DATABASE MOUNT;
  RESTORE DATABASE FROM '/export/home/oraclebackup/O1_MF_NNNDF_TAG20101109T141743_6FLGZ86C_.BKP';
  RECOVER DATABASE;
}2> 3> 4> 5> 6> 7> 8> 9>
 
allocated channel: ch00
channel ch00: sid=37 devtype=DISK
 
Starting restore at 09-NOV-10
 
channel ch00: restoring control file
channel ch00: restore complete, elapsed time: 00:00:02
Finished restore at 09-NOV-10
 
Starting restore at 09-NOV-10
 
channel ch00: copied control file copy
output filename=/u01/app/oracle/product/10.2.0/db_1/dbs/cntrlORCL.dbf
Finished restore at 09-NOV-10
 
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 11/09/2010 16:08:19
ORA-01103: database name 'ORCL' in control file is not 'DUMMY'
 
RMAN>

I get "ORA-01103: database name 'ORCL' in control file is not 'DUMMY'" but I installed new this db and never execute dbca. this is an empty db.

Thanks for help.
scientiaAsked:
Who is Participating?
 
scientiaConnect With a Mentor Author Commented:
Hi all,

I found solution of mine problem. I have not got an pfile because of "backup database" rman command did not get to backup copy of init.ora file so when you try to restore from full backup to fresh intalled oracle before that you must create an init<sid>.ora by using init.ora file. On this file database_name field that you sould change suitible value. Before that dont forget to export <sid name> to change environmet variable than you can restore.
0
 
anumosesCommented:
http://it.toolbox.com/wiki/index.php/ORA-01078_and_LRM-00109

This link might be of help. Take a look
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
schwertnerCommented:
When you backup the database you have to backup ALSO the control file, the password file and archive logs.
Database backup without control file and password file is practically useful.
0
 
schwertnerCommented:
Also spfile<SID>.ora ora and to have an uptodate copy of int.ora created from spfile.ora.
0
 
Praveen Kumar ChandrashekatrDatabase Analysist Senior Commented:
yes as schwertner said you have to backup all control file, password file, spfile, then only you can restore.

before you recover the database startup the database using pfile/spfile

for detail info go through the link..

http://www.dba-oracle.com/concepts/rman_recovery_database_spfile.htm
0
 
scientiaAuthor Commented:
I select mine solution because it works for our case.
0
All Courses

From novice to tech pro — start learning today.