Solved

RMAN-06024: no backup or copy of the controlfile found to restore

Posted on 2007-11-17
6
3,527 Views
Last Modified: 2013-12-19
Hi,

My production database was on Oracle 9.2.0.1 On Sun Solaris 5.8.

Cataog is on Oracle 10.1.0.5.0 On Sun Solaris 5.9.

I've lost my production database .

I've the catalog database intact.

Now i've a new host running Solaris 5.9 Having database 9.2.0.1

I connect to target from the new host and run rman ...

RMAN> run {
2> allocate channel c1 type disk;
3> restore controlfile ;
4> }


I get the following error message ....

released channel: ORA_DISK_1
allocated channel: c1
channel c1: sid=12 devtype=DISK

Starting restore at 16-NOV-07

released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/16/2007 20:15:46
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the controlfile found to restore

..

My rman backup files are on NFS mounted file system. Before running this commnad i had executed  crosscheck backup and it had marked file status as EXPIRED to all files, eventhough tthe files on the NFS file system are present and accesible in OS from the new host.

What am i missing in the sequence to restore my prev Prodn database on the new host.

Cheers

0
Comment
Question by:gpp_28
[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
6 Comments
 
LVL 11

Accepted Solution

by:
Akenathon earned 63 total points
ID: 20304185
RMAN is not finding your controlfile where it expects it to be. Either put it in the same directory it was when RMAN copied it, tell RMAN the new location, or if you never backed up your controlfile recreate it by using STARTUP NOMOUNT and CREATE CONTROLFILE in the target DB -you'll have to perform an incomplete recovery after that.
0
 
LVL 5

Assisted Solution

by:sora
sora earned 62 total points
ID: 20310180
1. you are trying to restore your database from a NEW host while the backup was taken from the old host using path/directories as visible on the old host.
2. presume your old server still exists although you lost the DB. Then connect to rman catalog from old host/server and do a restore database.
3. then copy the restored files and archivelogs to the new server . if you are copying to the same directory structure then straightaway try recover database. else you have to use the SWITCH command on the new server to tell the new DB on the new server the new path names - and then do a recover database
0
 

Author Comment

by:gpp_28
ID: 20317617
I could able to solve this issue, i think rman doesnt recognise nfs mounts, so i copied to the local disk and able to reciover the control file and datafiles.

but now i dont have the archives for the database.

so can any one tell me how to recover the database without redo logs and archives if i have all the datafiles and control files.

when i open the database with resetlogs, it gives the following error
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1:
'/orahome/app/oracle/product/9.2.0/oradata/kspl/system01.dbf'
please help




0
 
LVL 11

Expert Comment

by:Akenathon
ID: 20511866
Forget it: you cannot sync the files with themselves without rolling forward (i.e. using the redo logs). See, your backup has been taken online -that means each of your files has its first blocks copied at one moment, and its last blocks copied at a later moment... so the file is NOT consistent.

Get an older online backup for which you do have redo, or else get an offline backup (i.e. with the DB closed). Oracle will never let you open an inconsistent DB... UNLESS you set in your init.ora

_allow_resetlogs_corruption=TRUE

But that's undocumented, unsupported, nasty, etc... so don't say you got it from me ;-)

Seriously, use that only as a last resort and then reconstruct the data the best you can (parts of it from the tables, other parts from the indexes!). Hope it helps.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

756 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