Home » RDBMS Server » Backup & Recovery » Why RMAN did not obtain the backupset? (Windows Platform, Oracle 10.2.0.1)
Why RMAN did not obtain the backupset? [message #461580] Sat, 19 June 2010 03:01 Go to next message
trantuananh24hg
Messages: 606
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Dear all!

I've restored the DB to new host. I've got 1 backupset (Level 0, cumulative), 3 Level 1. Then, when I restore DB, the error occurred:

RMAN> list backup of database;


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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3552    Incr 1  40.04M     DISK        00:00:23     18-JUN-10
        BP Key: 3562   Status: AVAILABLE  Compressed: YES  Tag: PAYALL_LEVEL_1
        Piece Name: C:\PAYALL_BACKUP\LEVEL1_PAYALL_3563_721973002.BKP
  List of Datafiles in backup set 3552
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    1  Incr 32662806105 18-JUN-10 C:\ORACLE\PRODUCT\10.2.0\ORADATA\PAYALL\SYS
TEM01.DBF
  2    1  Incr 32662806105 18-JUN-10 C:\ORACLE\PRODUCT\10.2.0\ORADATA\PAYALL\UND
OTBS01.DBF
  3    1  Incr 32662806105 18-JUN-10 C:\ORACLE\PRODUCT\10.2.0\ORADATA\PAYALL\SYS
AUX01.DBF
  4    1  Incr 32662806105 18-JUN-10 C:\ORACLE\PRODUCT\10.2.0\ORADATA\PAYALL\USE
RS01.DBF
  5    1  Incr 32662806105 18-JUN-10 C:\ORACLE\PRODUCT\10.2.0\ORADATA\PAYALL\USE
RS02.DBF
  6    1  Incr 32662806105 18-JUN-10 D:\PAYALL_DATAFILES\PREPAID01.DBF
  7    1  Incr 32662806105 18-JUN-10 D:\PAYALL_DATAFILES\PREPAID02.DBF

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3557    Incr 0  4.37G      DISK        00:25:52     19-JUN-10
        BP Key: 3566   Status: AVAILABLE  Compressed: YES  Tag: PAYALL_LEVEL_0
        Piece Name: C:\PAYALL_BACKUP\LEVEL_0_PAYALL_3568_722053342_1.BKP
  List of Datafiles in backup set 3557
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 32663137616 19-JUN-10 C:\ORACLE\PRODUCT\10.2.0\ORADATA\PAYALL\SYS
TEM01.DBF
  2    0  Incr 32663137616 19-JUN-10 C:\ORACLE\PRODUCT\10.2.0\ORADATA\PAYALL\UND
OTBS01.DBF
  3    0  Incr 32663137616 19-JUN-10 C:\ORACLE\PRODUCT\10.2.0\ORADATA\PAYALL\SYS
AUX01.DBF
  4    0  Incr 32663137616 19-JUN-10 C:\ORACLE\PRODUCT\10.2.0\ORADATA\PAYALL\USE
RS01.DBF
  5    0  Incr 32663137616 19-JUN-10 C:\ORACLE\PRODUCT\10.2.0\ORADATA\PAYALL\USE
RS02.DBF
  6    0  Incr 32663137616 19-JUN-10 D:\PAYALL_DATAFILES\PREPAID01.DBF
  7    0  Incr 32663137616 19-JUN-10 D:\PAYALL_DATAFILES\PREPAID02.DBF

RMAN> restore database;

Starting restore at 19-JUN-10
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to C:\ORACLE\PRODUCT\10.2.0\ORADATA\PAYALL\SYSTEM01.DBF

restoring datafile 00002 to C:\ORACLE\PRODUCT\10.2.0\ORADATA\PAYALL\UNDOTBS01.DB
F
restoring datafile 00003 to C:\ORACLE\PRODUCT\10.2.0\ORADATA\PAYALL\SYSAUX01.DBF

restoring datafile 00004 to C:\ORACLE\PRODUCT\10.2.0\ORADATA\PAYALL\USERS01.DBF
restoring datafile 00005 to C:\ORACLE\PRODUCT\10.2.0\ORADATA\PAYALL\USERS02.DBF
restoring datafile 00006 to D:\PAYALL_DATAFILES\PREPAID01.DBF
restoring datafile 00007 to D:\PAYALL_DATAFILES\PREPAID02.DBF
channel ORA_DISK_1: reading from backup piece C:\PAYALL_BACKUP\LEVEL_0_PAYALL_35
68_722053342_1.BKP
ORA-19870: error reading backup piece C:\PAYALL_BACKUP\LEVEL_0_PAYALL_3568_72205
3342_1.BKP
ORA-19504: failed to create file "D:\PAYALL_DATAFILES\PREPAID01.DBF"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
failover to previous backup

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/19/2010 14:48:21
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>


Well, the datafile PREPAID created at 13/05/2010.

sys@PAYALL> select name, to_char(creation_time,'dd/mm/yyyy hh24:mi:ss') created
  2  from v$datafile
  3  where name like '%PRE%';

NAME                                CREATED
----------------------------------- -------------------------
D:\PAYALL_DATAFILES\PREPAID01.DBF   13/03/2010 11:54:03
D:\PAYALL_DATAFILES\PREPAID02.DBF   15/06/2010 16:19:19


And the newest backup full was 19/05/2010.
May you clarify me more?

Thank you!
Re: Why RMAN did not obtain the backupset? [message #461590 is a reply to message #461580] Sat, 19 June 2010 06:38 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Does the file C:\PAYALL_BACKUP\LEVEL_0_PAYALL_3568_722053342_1.BKP exist?

Try to run a RMAN> CROSSCHECK BACKUP ?
Re: Why RMAN did not obtain the backupset? [message #461618 is a reply to message #461590] Sat, 19 June 2010 23:04 Go to previous messageGo to next message
trantuananh24hg
Messages: 606
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
ebrian wrote on Sat, 19 June 2010 18:38
Does the file C:\PAYALL_BACKUP\LEVEL_0_PAYALL_3568_722053342_1.BKP exist?

Try to run a RMAN> CROSSCHECK BACKUP ?


Yes, all of the backup was in my folder. I tried to restore to new host. The scenario was:

1- Restore new controlfile
2- Restore/recreate spfile from pfile
3- Catalog all of backup (1 level 0, 3 level 1 was copied to my folder)
4- Crosscheck backup/archivelog and delete expired because of the old information saved in controlfile.
5- Set newname, change redolog
6- Restore/Recover

But, when RMAN executed progressing restore, the error occurred above.

[Updated on: Sat, 19 June 2010 23:05]

Report message to a moderator

Re: Why RMAN did not obtain the backupset? [message #461652 is a reply to message #461618] Sun, 20 June 2010 08:20 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Well there definitely seems to be some backups missing and confusion on dates. All your report above shows is an useless LEVEL 1 backup from 18-JUN-10 and a LEVEL 1 from 19-JUN-10. I do not see the 3 LEVEL 1's you are talking about. In addition, you say PREPAID datafile was created 13/05/2010, yet your output shows create dates of 13/03/2010 & 15/06/2010 ??

I assume the datafile directory (D:\PAYALL_DATAFILES) and the backup directory (C:\PAYALL_BACKUP) are actually on the new server with the appropriate permissions set?

Have you checked Restore and Recovery of the Database on a New Host for full details on the process?
Previous Topic: Cleaning of Old Archive Logs
Next Topic: Data Recovery
Goto Forum:
  


Current Time: Wed Sep 03 00:20:51 CDT 2014

Total time taken to generate the page: 0.24834 seconds