| RMAN-03002: failure of restore command at 10/08/2014 14:24:25 [message #625438] |
Wed, 08 October 2014 05:10  |
 |
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 #625446 is a reply to message #625442] |
Wed, 08 October 2014 05:21  |
|
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 #625454 is a reply to message #625452] |
Wed, 08 October 2014 05:47 |
|
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>
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
