OraFAQ Forum: Backup & Recovery » rman restore error

Home » RDBMS Server » Backup & Recovery » rman restore error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

rman restore error [message #247132]

Sun, 24 June 2007 10:54

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

Report message to a moderator

Re: rman restore error [message #247135 is a reply to message #247132]

Sun, 24 June 2007 11:18

Michel Cadot
Messages: 68651
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

Report message to a moderator

Re: rman restore error [message #247162 is a reply to message #247135]

Sun, 24 June 2007 19:02

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.

Report message to a moderator

Previous Topic:	RMAN: DUPLICATE DATABASE to same disk group?
Next Topic:	Incremental Backup of updated and new records/tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 12:02:11 CDT 2024