| Why RMAN did not obtain the backupset? [message #461580] |
Sat, 19 June 2010 03:01  |
trantuananh24hg
Messages: 744
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 #461618 is a reply to message #461590] |
Sat, 19 June 2010 23:04  |
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
ebrian wrote on Sat, 19 June 2010 18:38Does 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 |
 |
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
