OraFAQ Forum: Backup & Recovery » problem restoring database

Home » RDBMS Server » Backup & Recovery » problem restoring database (oracle server , 10.2.0 , unbreakable linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

problem restoring database [message #412100]

Tue, 07 July 2009 15:32

samiraly
Messages: 57
Registered: June 2009

Member

i have database running on archive log mode a full database backup taken for this database , then i lost all datafiles and controlfiles , recovery cataloge was on the same database ,
this is why RMAN do not know about the backup taken
then i tried to restore database i got the following error

[oracle@localhost ~]$ rman target sys/oracle

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jul 8 03:29:29 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: ORCL (DBID=1216981084, not open)

RMAN> restore database;

Starting restore at 08-JUL-09
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/08/2009 03:29:40
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

RMAN>

please help if there is a way to tell the RMAN about the backup taken ;

thank you for support

Report message to a moderator

Re: problem restoring database [message #412101 is a reply to message #412100]

Tue, 07 July 2009 15:38

samiraly
Messages: 57
Registered: June 2009

Member

here is the pase of the backup set taken

[oracle@localhost 2009_07_08]$ uname -a
Linux localhost.localdomain 2.6.9-42.0.0.0.1.ELsmp #1 SMP Sun Oct 15 14:02:40 PDT 2006 i686 i686 i386 GNU/Linux
[oracle@localhost 2009_07_08]$ pwd
/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/ORCL/backupset/2009_07_08
[oracle@localhost 2009_07_08]$ ls -ltr
total 733952
-rw-r-----  1 oracle oinstall 743677952 Jul  8 00:02 o1_mf_nnndf_TAG20090708T000108_557fwo97_.bkp-rw-r-----  1 oracle oinstall   7143424 Jul  8 00:02 o1_mf_ncsnf_TAG20090708T000108_557fz2vc_.bkp[oracle@localhost 2009_07_08]$

Report message to a moderator

Re: problem restoring database [message #412118 is a reply to message #412100]

Tue, 07 July 2009 18:30

ebrian
Messages: 2794
Registered: April 2006

Senior Member

If you lost the controlfiles, then how did you mount the database?

You can tell RMAN about the backups by using the CATALOG command.

Report message to a moderator

Re: problem restoring database [message #412327 is a reply to message #412100]

Wed, 08 July 2009 12:41

samiraly
Messages: 57
Registered: June 2009

Member

Hi Ebrian

i used an old backup of the control file this copy taken prior the full database backup i used it to mount database but still Rman dont know about the backup taken

i restored the control file from the backup using restore control file from command
and then i restored recovered database successfully

Issue Resolved

Thank you very much Ebrian you are such a geart helpful person .

Thanks for every thing

Report message to a moderator

Previous Topic:	Flashback confusion...
Next Topic:	Various Backup Methods

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 23:10:30 CST 2024