Solved

Oracle rman restore problems.

Posted on 2010-11-09
7
2,249 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 48

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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 48

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

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.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

837 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