| RMAN : ORA-27041: unable to open file while file exists at location [message #437432] |
Mon, 04 January 2010 07:06  |
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  |
 |
Mahesh Rajendran
Messages: 10708
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
