Oracle Database Discussions

My Production configuration are as below:
DB Version : 11.2.0.1
OS: Windows 2008
File Storage : ASM
Primary : 2 Node RAC
Standby : Single Node

In my standby node,

When i query for recovery_file view, it shows
5 datafiles are not found which are in ASM storage.

STBYNODE> select * from v$recover_file;
FILE# ONLINE ONLINE_ ERROR CHANGE# TIME
---------- ------- ------- --------------- ---------- ---------
1 ONLINE ONLINE FILE NOT FOUND 0
2 ONLINE ONLINE FILE NOT FOUND 0
3 ONLINE ONLINE FILE NOT FOUND 0
4 ONLINE ONLINE FILE NOT FOUND 0
5 ONLINE ONLINE FILE NOT FOUND 0
.............................................................
.............................................................
.............................................................


Due to archive gap ,

I have applied incremental backup , then replaced old standby controlfile with latest one.

When i query v$datafile, it is showing fine from the control file.

STBYNODE> SELECT NAME FROM V$DATAFILE;
NAME
--------------------------------------------------
+DATA/hstandby/datafile/system.261.746467221
+DATA/hstandby/datafile/sysaux.263.746467227
+DATA/hstandby/datafile/undotbs1.264.746467231
+DATA/hstandby/datafile/undotbs2.269.746467241
+DATA/hstandby/datafile/users.270.746467245
.............................................................
.............................................................

My Alert log files says as follows
alter database recover managed standby database disconnect
Mon Jun 20 14:23:37 2011
MRP0 started with pid=34, OS id=4976
Serial Media Recovery started
Managed Standby Recovery not using Real Time Apply
Mon Jun 20 14:23:49 2011
Errors in file d:\oracle\diag\diag\rdbms\hstandby\hstandby\trace\hstandby_dbw0_5712.trc:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '+DATA/hstandby/datafile/system.261.746467221'
ORA-17503: ksfdopn:2 Failed to open file +DATA/hstandby/datafile/system.261.746467221
ORA-15012: ASM file '+DATA/hstandby/datafile/system.261.746467221' does not exist
Errors in file d:\oracle\diag\diag\rdbms\hstandby\hstandby\trace\hstandby_dbw0_5712.trc:
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: '+DATA/hstandby/datafile/sysaux.263.746467227'
ORA-17503: ksfdopn:2 Failed to open file +DATA/hstandby/datafile/sysaux.263.746467227
ORA-15012: ASM file '+DATA/hstandby/datafile/sysaux.263.746467227' does not exist
Errors in file d:\oracle\diag\diag\rdbms\hstandby\hstandby\trace\hstandby_dbw0_5712.trc:
ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
ORA-01110: data file 3: '+DATA/hstandby/datafile/undotbs1.264.746467231'
ORA-17503: ksfdopn:2 Failed to open file +DATA/hstandby/datafile/undotbs1.264.746467231
ORA-15012: ASM file '+DATA/hstandby/datafile/undotbs1.264.746467231' does not exist
Errors in file d:\oracle\diag\diag\rdbms\hstandby\hstandby\trace\hstandby_dbw0_5712.trc:
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: '+DATA/hstandby/datafile/undotbs2.269.746467241'
ORA-17503: ksfdopn:2 Failed to open file +DATA/hstandby/datafile/undotbs2.269.746467241
ORA-15012: ASM file '+DATA/hstandby/datafile/undotbs2.269.746467241' does not exist
Errors in file d:\oracle\diag\diag\rdbms\hstandby\hstandby\trace\hstandby_dbw0_5712.trc:
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '+DATA/hstandby/datafile/users.270.746467245'
ORA-17503: ksfdopn:2 Failed to open file +DATA/hstandby/datafile/users.270.746467245
ORA-15012: ASM file '+DATA/hstandby/datafile/users.270.746467245' does not exist
Mon Jun 20 14:23:50 2011
Archived Log entry 129 added for thread 2 sequence 1800 ID 0x5a37080f dest 1:
Mon Jun 20 14:23:50 2011
MRP0: Background Media Recovery terminated with error 1110
Errors in file d:\oracle\diag\diag\rdbms\hstandby\hstandby\trace\hstandby_mrp0_4976.trc:
ORA-01110: data file 1: '+DATA/hstandby/datafile/system.261.746467221'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '+DATA/hstandby/datafile/system.261.746467221'
Errors in file d:\oracle\diag\diag\rdbms\hstandby\hstandby\trace\hstandby_mrp0_4976.trc:
ORA-01110: data file 1: '+DATA/hstandby/datafile/system.261.746467221'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '+DATA/hstandby/datafile/system.261.746467221'
Mon Jun 20 14:23:51 2011
Completed: alter database recover managed standby database disconnect
Mon Jun 20 14:37:42 2011
db_recovery_file_dest_size of 61440 MB is 0.04% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.

When query with ASMCMD , i face the following issue

C:\Users\dbadmin>asmcmd
Connected to an idle instance.
ASMCMD> ls -l
ASMCMD-08102: no connection to ASM; command requires ASM to run
ASMCMD>

I have defined the environment in GRID path as follows with administrator logins
SET ORACLE_HOME=d:\oracle\product\11.2.0\grid
SET PATH=%ORACLE_HOME%\bin;%PATH%
SET ORACLE_SID=+asm

any idea how to recover the datafiles ?


Best Regards
Suresh