Solved

Oracle rman restore problems.

Posted on 2010-11-09
7
2,171 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
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to recover a database from a user managed backup
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

708 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

15 Experts available now in Live!

Get 1:1 Help Now