Home » RDBMS Server » Backup & Recovery » rman restore error
icon6.gif  rman restore error [message #247132] Sun, 24 June 2007 10:54 Go to next message
sudhirgattu
Messages: 1
Registered: June 2007
Location: Nashville
Junior Member

I am trying to refresh prod database to test server.... when trying to restore I get file create error.... as below......

I even tried rman duplicate database... but same error.....

RMAN> restore database;

Starting restore at 24-JUN-07
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 00024 to /oradata/DSI/indexes10.dbf
restoring datafile 00068 to /oradata02/DSI/users32.dbf
channel ORA_DISK_1: reading from backup piece /backup/DSI/1giks1v5_1_1
ORA-19870: error reading backup piece /backup/DSI/1giks1v5_1_1
ORA-19504: failed to create file "/oradata02/DSI/users32.dbf"
ORA-27040: file create error, unable to create file
HP-UX Error: 2: No such file or directory
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00034 to /oradata/DSI/indexes15.dbf
restoring datafile 00070 to /oradata02/DSI/users33.dbf
channel ORA_DISK_1: reading from backup piece /backup/DSI/1hiks1v5_1_1
ORA-19870: error reading backup piece /backup/DSI/1hiks1v5_1_1
ORA-19504: failed to create file "/oradata02/DSI/users33.dbf"
ORA-27040: file create error, unable to create file
HP-UX Error: 2: No such file or directory
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00004 to /oradata/DSI/indexes01.dbf
restoring datafile 00071 to /oradata02/DSI/indexes33.dbf
channel ORA_DISK_1: reading from backup piece /backup/DSI/1fiks1v5_1_1
Re: rman restore error [message #247135 is a reply to message #247132] Sun, 24 June 2007 11:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ora-27040: file create error, unable to create file
 *Cause:  create system call returned an error, unable to create file
 *Action: verify filename, and permissions

Regards
Michel
Re: rman restore error [message #247162 is a reply to message #247135] Sun, 24 June 2007 19:02 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
BEFORE RESTORING
ist try to catalog backup piece and then try.
or you can check validat command before restoring.
Previous Topic: RMAN: DUPLICATE DATABASE to same disk group?
Next Topic: Incremental Backup of updated and new records/tables
Goto Forum:
  


Current Time: Mon Dec 05 08:30:42 CST 2016

Total time taken to generate the page: 0.14443 seconds