asked on

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

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

ASKER CERTIFIED SOLUTION

Akenathon

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

sora

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

gpp_28

ASKER

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

Akenathon

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.