Home » RDBMS Server » Backup & Recovery » problem restoring database (oracle server , 10.2.0 , unbreakable linux)
problem restoring database [message #412100] Tue, 07 July 2009 15:32 Go to next message
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
Re: problem restoring database [message #412101 is a reply to message #412100] Tue, 07 July 2009 15:38 Go to previous messageGo to next message
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]$

Re: problem restoring database [message #412118 is a reply to message #412100] Tue, 07 July 2009 18:30 Go to previous messageGo to next message
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.
Re: problem restoring database [message #412327 is a reply to message #412100] Wed, 08 July 2009 12:41 Go to previous message
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
Previous Topic: Flashback confusion...
Next Topic: Various Backup Methods
Goto Forum:
  


Current Time: Thu Mar 28 11:33:08 CDT 2024