Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Oracle rman restore problems.

Posted on 2010-11-09
7
Medium Priority
?
2,495 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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:Praveen Kumar Chandrashekatr
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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

Many businesses neglect disaster recovery and treat it as an after-thought. I can tell you first hand that data will be lost, hard drives die, servers will be hacked, and careless (or malicious) employees can ruin your data.
Want to know how to use Exchange Server Eseutil command? Go through this article as it gives you the know-how.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
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…

650 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