Home » RDBMS Server » Backup & Recovery » RMAN-06023: no backup or copy of datafile 4 found to restore (Suse-10 sp2)
RMAN-06023: no backup or copy of datafile 4 found to restore [message #482202] Wed, 10 November 2010 05:35 Go to next message
SystemEng
Messages: 12
Registered: November 2010
Junior Member
Hi,

I have been trying to restore backups from the live database to another fresh database but to no avail. I have spent days on that.

I have been able to recover the control files.
But when i do
RMAN> restore database validate;

i get
Starting restore at 10-NOV-10
using channel ORA_DISK_1
using channel ORA_DISK_2

data file 5 will be created automatically during restore operation
data file 6 will be created automatically during restore operation
data file 7 will be created automatically during restore operation
data file 8 will be created automatically during restore operation
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/10/2010 15:24:19
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

--------------------------------------------------------

But everything seems to be fine when i do
RMAN> list recoverable backup;


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

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
475 Full 7.48M DISK 00:00:00 09-NOV-10
BP Key: 488 Status: AVAILABLE Compressed: NO Tag: TAG20101109T123025
Piece Name: /oradata/APPPLU/flash_recovery_area/c-3493678350-20101109-01
Control File Included: Ckp SCN: 17283476 Ckp time: 09-NOV-10
SPFILE Included: Modification time: 26-OCT-10

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
480 1.31M DISK 00:00:01 09-NOV-10
BP Key: 495 Status: AVAILABLE Compressed: YES Tag: TAG20101109T210219
Piece Name: /oradata/APPPLU/flash_recovery_area/APPPLU_20101109_2100_INCR_0_f0lsjm6r_1_1

List of Archived Logs in backup set 480
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 1022 17426174 09-NOV-10 17426788 09-NOV-10

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
481 Full 7.48M DISK 00:00:00 09-NOV-10
BP Key: 489 Status: AVAILABLE Compressed: NO Tag: TAG20101109T210221
Piece Name: /oradata/APPPLU/flash_recovery_area/c-3493678350-20101109-02
Control File Included: Ckp SCN: 17426795 Ckp time: 09-NOV-10
SPFILE Included: Modification time: 26-OCT-10

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
482 20.88M DISK 00:00:04 10-NOV-10
BP Key: 491 Status: AVAILABLE Compressed: YES Tag: TAG20101110T053006
Piece Name: /oradata/APPPLU/flash_recovery_area/APPPLU_20101110_0530_INCR_1_f3lskjuv_1_1

List of Archived Logs in backup set 482
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 1026 17483525 10-NOV-10 17512837 10-NOV-10
1 1027 17512837 10-NOV-10 17521856 10-NOV-10
1 1028 17521856 10-NOV-10 17521867 10-NOV-10

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
483 41.76M DISK 00:00:07 10-NOV-10
BP Key: 493 Status: AVAILABLE Compressed: YES Tag: TAG20101110T053006
Piece Name: /oradata/APPPLU/flash_recovery_area/APPPLU_20101110_0530_INCR_1_f2lskjuv_1_1

List of Archived Logs in backup set 483
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 1023 17426788 09-NOV-10 17443906 09-NOV-10
1 1024 17443906 09-NOV-10 17456991 09-NOV-10
1 1025 17456991 09-NOV-10 17483525 10-NOV-10

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
486 81.00K DISK 00:00:01 10-NOV-10
BP Key: 492 Status: AVAILABLE Compressed: YES Tag: TAG20101110T053023
Piece Name: /oradata/APPPLU/flash_recovery_area/APPPLU_20101110_0530_INCR_1_f6lskjvf_1_1

List of Archived Logs in backup set 486
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 1029 17521867 10-NOV-10 17521935 10-NOV-10

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
487 Full 7.48M DISK 00:00:00 10-NOV-10
BP Key: 490 Status: AVAILABLE Compressed: NO Tag: TAG20101110T053025
Piece Name: /oradata/APPPLU/flash_recovery_area/c-3493678350-20101110-00
Control File Included: Ckp SCN: 17521963 Ckp time: 10-NOV-10
SPFILE Included: Modification time: 26-OCT-10
------------------------------------------------------------

RMAN> CROSSCHECK BACKUP
2> ;

using channel ORA_DISK_1
using channel ORA_DISK_2
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/oradata/APPPLU/flash_recovery_area/c-3493678350-20101109-01 recid=488 stamp=734680702
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/oradata/APPPLU/flash_recovery_area/APPPLU_20101109_2100_INCR_0_f0lsjm6r_1_1 recid=495 stamp=734680702
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/oradata/APPPLU/flash_recovery_area/c-3493678350-20101109-02 recid=489 stamp=734680702
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/oradata/APPPLU/flash_recovery_area/APPPLU_20101110_0530_INCR_1_f3lskjuv_1_1 recid=491 stamp=734680702
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/oradata/APPPLU/flash_recovery_area/APPPLU_20101110_0530_INCR_1_f2lskjuv_1_1 recid=493 stamp=734680702
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/oradata/APPPLU/flash_recovery_area/APPPLU_20101110_0530_INCR_1_f4lskjv8_1_1 recid=496 stamp=734680702
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/oradata/APPPLU/flash_recovery_area/APPPLU_20101110_0530_INCR_1_f5lskjv8_1_1 recid=494 stamp=734680702
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/oradata/APPPLU/flash_recovery_area/APPPLU_20101110_0530_INCR_1_f6lskjvf_1_1 recid=492 stamp=734680702
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/oradata/APPPLU/flash_recovery_area/c-3493678350-20101110-00 recid=490 stamp=734680702
Crosschecked 9 objects

FOLLOWED by some expired ones.

--------------------------------------------------------------
RMAN> list incarnation of database;


List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 APPPLU 3493678350 PARENT 1 16-NOV-06
2 2 APPPLU 3493678350 CURRENT 456954 23-SEP-10

RMAN>
----------------------------------------------------------------

Can anyone please tell me where what im doing wrong?

Re: RMAN-06023: no backup or copy of datafile 4 found to restore [message #482232 is a reply to message #482202] Wed, 10 November 2010 08:40 Go to previous messageGo to next message
Michel Cadot
Messages: 67769
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You didn't back up the 4 mentionned files (at least in this incarnation).

Regards
Michel
Re: RMAN-06023: no backup or copy of datafile 4 found to restore [message #482244 is a reply to message #482202] Wed, 10 November 2010 09:51 Go to previous messageGo to next message
SystemEng
Messages: 12
Registered: November 2010
Junior Member
Well its an incremental backup, and it does backup the whole database also, as u can see when i did the list backup , it does show a full backup with 0.
APPPLU_20101109_2100_INCR_0_f0lsjm6r_1_1

So something else must be wrong.

Re: RMAN-06023: no backup or copy of datafile 4 found to restore [message #482281 is a reply to message #482244] Wed, 10 November 2010 21:09 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Unless I'm missing something, the only thing I can make out in your list recoverable backup command are backups for controlfiles/spfile and archivelogs ?

Where are the backups of your datafiles ?
Re: RMAN-06023: no backup or copy of datafile 4 found to restore [message #482291 is a reply to message #482281] Wed, 10 November 2010 22:17 Go to previous messageGo to next message
SystemEng
Messages: 12
Registered: November 2010
Junior Member
Well, Since im new to rman..

RMAN> LIST BACKUPSET OF DATAFILE 1;


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

Backup Set Copy #2 of backup set 485
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:05 10-NOV-10 YES APPPLU_20101110_0530_INCR_1

List of Backup Pieces for backup set 485 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
494 1 AVAILABLE /oradata/APPPLU/flash_recovery_area/APPPLU_20101110_0530_INCR_1_f5lskjv8_1_1

RMAN>

So from the above, does it mean it shud be able to recover the datafile 1.

???
Im desperate :)Smile

Re: RMAN-06023: no backup or copy of datafile 4 found to restore [message #482350 is a reply to message #482291] Thu, 11 November 2010 02:46 Go to previous messageGo to next message
SystemEng
Messages: 12
Registered: November 2010
Junior Member
I think i really missed some backups. Cos i blindly copied all the backups this time and it got restored.

But is there a way to know which files i should have copied for the restore to be done. Cos i copied even expired backups.

Re: RMAN-06023: no backup or copy of datafile 4 found to restore [message #482353 is a reply to message #482350] Thu, 11 November 2010 02:52 Go to previous messageGo to next message
Michel Cadot
Messages: 67769
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Those that are not obsolete.

Regards
Michel
Re: RMAN-06023: no backup or copy of datafile 4 found to restore [message #482358 is a reply to message #482353] Thu, 11 November 2010 03:00 Go to previous messageGo to next message
SystemEng
Messages: 12
Registered: November 2010
Junior Member
Ok thx.

The backup script does cater for deleting the obsolete ones.

So my backup folder always contain valid ones.

Thx for your help.

I will find out more abt the backup and recovery strategies

Regards
Re: RMAN-06023: no backup or copy of datafile 4 found to restore [message #482360 is a reply to message #482358] Thu, 11 November 2010 03:03 Go to previous message
Michel Cadot
Messages: 67769
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
See your other topic (http://www.orafaq.com/forum/t/163238/102589/).

Regards
Michel

[Updated on: Thu, 11 November 2010 03:03]

Report message to a moderator

Previous Topic: ORA-01195
Next Topic: Job_Action details
Goto Forum:
  


Current Time: Sun Mar 07 21:45:04 CST 2021