Home » RDBMS Server » Backup & Recovery » RMAN-03002: failure of restore command at 10/08/2014 14:24:25 (10gR2, SuSE Linux)
RMAN-03002: failure of restore command at 10/08/2014 14:24:25 [message #625438] Wed, 08 October 2014 05:10 Go to next message
daulat01
Messages: 62
Registered: May 2011
Location: Delhi
Member
While doing restore database I got below errors:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/08/2014 14:24:25
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 5 found to 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

Note: A) Backup is available at the destination (NOT Using FRA)
B) Spfile and Controlfile restored successfully and database is mounted.

Steps I have used.

Copy pfile in dbs folder
oracle@myhost dbs $ sqlplus / as sysdba
SQL> startup nomount;
SQL> Exit
oracle@myhost dbs$ rman target /
RMAN> set dbid =2564181429;
RMAN> restore spfile from '/dbbackup/oracle_backup/lamdb/mtesting/lamdb_0bpkhlbb_1_1';
RMAN> shutdown immediate;
SQL> startup nomount;
rman target /
RMAN> set dbid =2564181429;
RMAN> restore controlfile from '/dbbackup/oracle_backup/lamdb/mtesting/snapcf_lamdb.f';

RMAN> sql "alter database mount";

RMAN > list backup summary;
RMAN > list backup TAG='TAG20090630T154910';
RMAN > crosscheck backup TAG='TAG20090630T154910'
RMAN> restore database from TAG='TAG20090630T154910'


Please help on this.

[Updated on: Wed, 08 October 2014 05:17]

Report message to a moderator

Re: RMAN-03002: failure of restore command at 10/08/2014 14:24:25 [message #625442 is a reply to message #625438] Wed, 08 October 2014 05:15 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Please show us what you have done to get to this stage. Copy your entire session and paste it here.
Re: RMAN-03002: failure of restore command at 10/08/2014 14:24:25 [message #625446 is a reply to message #625442] Wed, 08 October 2014 05:21 Go to previous messageGo to next message
daulat01
Messages: 62
Registered: May 2011
Location: Delhi
Member
I am using following steps

I have our database no ASM.

I created the ASM instance first and then using these steps.

Copy pfile in dbs folder
oracle@myhost dbs $ sqlplus / as sysdba
SQL> startup nomount;
SQL> Exit
oracle@myhost dbs$ rman target /
RMAN> set dbid =2564181429;
RMAN> restore spfile from '/dbbackup/oracle_backup/lamdb/mtesting/lamdb_0bpkhlbb_1_1';
RMAN> shutdown immediate;
SQL> startup nomount;
rman target /
RMAN> set dbid =2564181429;
RMAN> restore controlfile from '/dbbackup/oracle_backup/lamdb/mtesting/snapcf_lamdb.f';

RMAN> sql "alter database mount";

RMAN > list backup summary;
RMAN > list backup TAG='TAG20090630T154910';
RMAN > crosscheck backup TAG='TAG20090630T154910'
RMAN> restore database from TAG='TAG20090630T154910'


[Updated on: Wed, 08 October 2014 05:34]

Report message to a moderator

Re: RMAN-03002: failure of restore command at 10/08/2014 14:24:25 [message #625452 is a reply to message #625446] Wed, 08 October 2014 05:40 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Where is the output of the commands below?

RMAN > list backup summary;
RMAN > list backup TAG='TAG20090630T154910'; 
RMAN > crosscheck backup TAG='TAG20090630T154910' 
Re: RMAN-03002: failure of restore command at 10/08/2014 14:24:25 [message #625454 is a reply to message #625452] Wed, 08 October 2014 05:47 Go to previous messageGo to next message
daulat01
Messages: 62
Registered: May 2011
Location: Delhi
Member
RMAN> list backup summary;


List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
6 B F A DISK 08-OCT-14 1 1 YES TAG20141008T110659
7 B F A DISK 08-OCT-14 1 1 YES TAG20141008T110703
8 B F A DISK 08-OCT-14 1 1 YES TAG20141008T110704

RMAN> list backup TAG='TAG20141008T110659'
2> ;


List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6 Full 1.03M DISK 00:00:03 08-OCT-14
BP Key: 6 Status: AVAILABLE Compressed: YES Tag: TAG20141008T110659
Piece Name: /dbbackup/oracle_backup/lamdb/mtesting/lamdb_06pkhlaj_1_1
Control File Included: Ckp SCN: 567173 Ckp time: 08-OCT-14

RMAN> list backup TAG'TAG20141008T110704';


List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8 Full 15.05M DISK 00:00:11 08-OCT-14
BP Key: 8 Status: AVAILABLE Compressed: YES Tag: TAG20141008T110704
Piece Name: /dbbackup/oracle_backup/lamdb/mtesting/lamdb_09pkhlao_1_1
List of Datafiles in backup set 8
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 567173 08-OCT-14 +DGLAM/lamdb/datafile/undotbs1.276.860412561
3 Full 567173 08-OCT-14 +DGLAM/lamdb/datafile/sysaux.268.860336945
5 Full 567173 08-OCT-14 +DGLAM/lamdb/datafile/testing.279.860408597

RMAN> list backup TAG='TAG20141008T110703';


List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7 Full 80.00K DISK 00:00:00 08-OCT-14
BP Key: 7 Status: AVAILABLE Compressed: YES Tag: TAG20141008T110703
Piece Name: /dbbackup/oracle_backup/lamdb/mtesting/lamdb_07pkhlan_1_1
SPFILE Included: Modification time: 08-OCT-14


RMAN> crosscheck backup TAG='TAG20141008T110704';

using channel ORA_DISK_1
using channel ORA_DISK_2
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/dbbackup/oracle_backup/lamdb/mtesting/lamdb_09pkhlao_1_1 recid=8 stamp=860411224
Crosschecked 1 objects


_____________________________________________
Please find my log file for RMAN export. I have seen system and users tablespace is not available while doing list backup TAG'TAG20141008T110704' but these are in below export script.



oracle@metadb-lam:/dbbackup/oracle_backup/lamdb/mtesting> cat lamdb_backup.log

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Oct 8 11:06:57 2014

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

connected to target database: LAMDB (DBID=2564181429, not open)

RMAN> 2> 3> 4> 5> 6>
Starting backup at 08-OCT-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=153 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=152 devtype=DISK
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 08-OCT-14
channel ORA_DISK_1: finished piece 1 at 08-OCT-14
piece handle=/dbbackup/oracle_backup/lamdb/mtesting/lamdb_06pkhlaj_1_1 tag=TAG20141008T110659 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
Finished backup at 08-OCT-14

Starting backup at 08-OCT-14
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 08-OCT-14
channel ORA_DISK_1: finished piece 1 at 08-OCT-14
piece handle=/dbbackup/oracle_backup/lamdb/mtesting/lamdb_07pkhlan_1_1 tag=TAG20141008T110703 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 08-OCT-14

Starting backup at 08-OCT-14
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=+DGLAM/lamdb/datafile/system.269.860336945
input datafile fno=00004 name=+DGLAM/lamdb/datafile/users.273.860336949
channel ORA_DISK_1: starting piece 1 at 08-OCT-14
channel ORA_DISK_2: starting compressed full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00003 name=+DGLAM/lamdb/datafile/sysaux.268.860336945
input datafile fno=00005 name=+DGLAM/lamdb/datafile/testing.279.860408597
input datafile fno=00002 name=+DGLAM/lamdb/datafile/undotbs1.272.860336947
channel ORA_DISK_2: starting piece 1 at 08-OCT-14
channel ORA_DISK_2: finished piece 1 at 08-OCT-14
piece handle=/dbbackup/oracle_backup/lamdb/mtesting/lamdb_09pkhlao_1_1 tag=TAG20141008T110704 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_2: starting compressed full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_2: starting piece 1 at 08-OCT-14
channel ORA_DISK_2: finished piece 1 at 08-OCT-14
piece handle=/dbbackup/oracle_backup/lamdb/mtesting/lamdb_0apkhlb8_1_1 tag=TAG20141008T110704 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_2: starting compressed full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
including current SPFILE in backupset
channel ORA_DISK_2: starting piece 1 at 08-OCT-14
channel ORA_DISK_2: finished piece 1 at 08-OCT-14
piece handle=/dbbackup/oracle_backup/lamdb/mtesting/lamdb_0bpkhlbb_1_1 tag=TAG20141008T110704 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: finished piece 1 at 08-OCT-14
piece handle=/dbbackup/oracle_backup/lamdb/mtesting/lamdb_08pkhlao_1_1 tag=TAG20141008T110704 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
Finished backup at 08-OCT-14

RMAN>

Recovery Manager complete.
oracle@metadb-lam:/dbbackup/oracle_backup/lamdb/mtesting>
Re: RMAN-03002: failure of restore command at 10/08/2014 14:24:25 [message #625457 is a reply to message #625454] Wed, 08 October 2014 06:20 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
This makes no sense! What backups do you have? Tag TAG20090630T154910 would be from five years ago.
Re: RMAN-03002: failure of restore command at 10/08/2014 14:24:25 [message #625460 is a reply to message #625457] Wed, 08 October 2014 06:33 Go to previous messageGo to next message
daulat01
Messages: 62
Registered: May 2011
Location: Delhi
Member
I have taken RMAN cold backup today.forget this TAG- TAG20090630T154910 (This is for example only)


Actual TAGs are as below.

Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
6 B F A DISK 08-OCT-14 1 1 YES TAG20141008T110659
7 B F A DISK 08-OCT-14 1 1 YES TAG20141008T110703
8 B F A DISK 08-OCT-14 1 1 YES TAG20141008T110704

RMAN> list backup TAG='TAG20141008T110659'
2> ;


List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6 Full 1.03M DISK 00:00:03 08-OCT-14
BP Key: 6 Status: AVAILABLE Compressed: YES Tag: TAG20141008T110659
Piece Name: /dbbackup/oracle_backup/lamdb/mtesting/lamdb_06pkhlaj_1_1
Control File Included: Ckp SCN: 567173 Ckp time: 08-OCT-14

RMAN> list backup TAG'TAG20141008T110704';


List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8 Full 15.05M DISK 00:00:11 08-OCT-14
BP Key: 8 Status: AVAILABLE Compressed: YES Tag: TAG20141008T110704
Piece Name: /dbbackup/oracle_backup/lamdb/mtesting/lamdb_09pkhlao_1_1
List of Datafiles in backup set 8
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 567173 08-OCT-14 +DGLAM/lamdb/datafile/undotbs1.276.860412561
3 Full 567173 08-OCT-14 +DGLAM/lamdb/datafile/sysaux.268.860336945
5 Full 567173 08-OCT-14 +DGLAM/lamdb/datafile/testing.279.860408597

RMAN> list backup TAG='TAG20141008T110703';


List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7 Full 80.00K DISK 00:00:00 08-OCT-14
BP Key: 7 Status: AVAILABLE Compressed: YES Tag: TAG20141008T110703
Piece Name: /dbbackup/oracle_backup/lamdb/mtesting/lamdb_07pkhlan_1_1
SPFILE Included: Modification time: 08-OCT-14


RMAN> crosscheck backup TAG='TAG20141008T110704';

using channel ORA_DISK_1
using channel ORA_DISK_2
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/dbbackup/oracle_backup/lamdb/mtesting/lamdb_09pkhlao_1_1 recid=8 stamp=860411224
Crosschecked 1 objects

Re: RMAN-03002: failure of restore command at 10/08/2014 14:24:25 [message #625467 is a reply to message #625460] Wed, 08 October 2014 07:28 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
In future, please always tell the truth. It saves a lot of time.
However, it looks as though you do not have a complete backup: you are missing backups of various datafiles. So you can't restore.
Previous Topic: Comments in RMAN Log file
Next Topic: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
Goto Forum:
  


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