Home » RDBMS Server » Backup & Recovery » RMAN : ORA-27041: unable to open file while file exists at location (Oracle 9.2.0.6.0 on HP-UX)
RMAN : ORA-27041: unable to open file while file exists at location [message #437432] Mon, 04 January 2010 07:06 Go to next message
chetanaZ
Messages: 132
Registered: October 2009
Location: UK
Senior Member
Hi,

I am trying to refresh a RAC node from of Test database from live backup

During restore I am getting an error as follows :

RMAN> run{
2>  set until time "to_date('2010-01-01:11:00:00','YYYY-MM-DD:HH24:MI:SS')";
3> restore datafile 7;
4> }

executing command: SET until clause

Starting restore at 04-JAN-10

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=21 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=22 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=23 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=24 devtype=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: sid=25 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00007 to /u06/oradata/appdb0/myapp_index_02.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/04/2010 12:33:08
ORA-19504: failed to create file "/u06/oradata/appdb0/myapp_index_02.dbf"
ORA-27041: unable to open file
HPUX-ia64 Error: 6: No such device or address
Additional information: 1
RMAN>


However the file exists as can be seen below
Also nobody has changed any file permissions as well
oracle@server1:/opt/oracle/admin/appdb0/bdump $ls -ltr /u06/oradata/appdb0/myapp_index_02.dbf
lrwxrwxrwx   1 oracle     dba             30 Feb 21  2006 /u06/oradata/appdb0/myapp_index_02.dbf -> /dev/vg06_db0_data/rlv_032G_06

oracle@server1:/opt/oracle/admin/appdb0/bdump $ls -ltr /dev/vg06_db0_data/rlv_032G_06
crw-r-----   1 oracle     dba         64 0x06000e Feb 21  2006 /dev/vg06_db0_data/rlv_032G_06


I tried the following
alter database backup controlfile to trace;


and checked datafiles path in the traced file but it is same as above

Please suggest

Thanks and Regards,
Chetana
Re: RMAN : ORA-27041: unable to open file while file exists at location [message #437437 is a reply to message #437432] Mon, 04 January 2010 07:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> I am trying to refresh a RAC node from of Test database from live backup
Not sure what you mean by "live backup".
Active database duplication is not available in 9x.
Which means, you have to rely on backupsets created by RMAN and do a TSPITR.


If i understand you correctly,
You are refreshing a RAC database from a single instance database.
>>ORA-19504: failed to create file "/u06/oradata/appdb0/myapp_index_02.dbf"
This does not appear to be shared storage for RAC.

>>However the file exists as can be seen below
Exists in source filesystem?
Are trying to restore from same server or between servers?

[Updated on: Mon, 04 January 2010 07:19]

Report message to a moderator

Re: RMAN : ORA-27041: unable to open file while file exists at location [message #437441 is a reply to message #437432] Mon, 04 January 2010 07:24 Go to previous message
chetanaZ
Messages: 132
Registered: October 2009
Location: UK
Senior Member
Thanks Mahesh,

live backup is stored on shared storage area from which test database picks it for restore etc

Now test database is RAC database on server 1
we refresh it as follows
live db name is db01
with 4 nodes db01..db04

test database has 2 nodes tb01,tb01 on server 2

first we refresh a dummy database instance db01 on server 2 (thus server is diff but 1 instance name is same uptill now)
this instance is restored and recovered using rman , with live database backup kept in shared staorage area
now from db01 on server 2, we create tb01, tb02 by just changing folder names and open resetlogs

now server 1 and server 2 are using raw device

oracle@server1:/opt/oracle/admin/appdb0/bdump $ls -ltr /u06/oradata/appdb0/myapp_index_02.dbf
lrwxrwxrwx   1 oracle     dba             30 Feb 21  2006 /u06/oradata/appdb0/myapp_index_02.dbf -> /dev/vg06_db0_data/rlv_032G_06

oracle@server1:/opt/oracle/admin/appdb0/bdump $ls -ltr /dev/vg06_db0_data/rlv_032G_06
crw-r-----   1 oracle     dba         64 0x06000e Feb 21  2006 /dev/vg06_db0_data/rlv_032G_06



Thanks and Regards,
Chetana
Previous Topic: logminer
Next Topic: RMAN archive log backup
Goto Forum:
  


Current Time: Wed Dec 07 08:40:49 CST 2016

Total time taken to generate the page: 0.07093 seconds