Solved

Oracle rman restore problems.

Posted on 2010-11-09
7
2,222 Views
Last Modified: 2013-12-18
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.
0
Comment
Question by:scientia
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 6

Expert Comment

by:anumoses
ID: 34093927
http://it.toolbox.com/wiki/index.php/ORA-01078_and_LRM-00109

This link might be of help. Take a look
0
 
LVL 6

Expert Comment

by:anumoses
ID: 34093955
0
 
LVL 47

Expert Comment

by:schwertner
ID: 34095479
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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 47

Expert Comment

by:schwertner
ID: 34095497
Also spfile<SID>.ora ora and to have an uptodate copy of int.ora created from spfile.ora.
0
 
LVL 12

Expert Comment

by:praveencpk
ID: 34095787
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
 

Accepted Solution

by:
scientia earned 0 total points
ID: 34099632
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
 

Author Closing Comment

by:scientia
ID: 34130334
I select mine solution because it works for our case.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Finally comes the third version of VMware Virtual SAN, whose name is 6.1, and comes loaded with new features many of which really are excellent and even surprising.
In this article we have discussed the manual scenarios to recover data from Windows 10 through some backup and recovery tools which are offered by it.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now