Oracle Database Discussions

HI ,

Oracle 11gr2 on windows 7 ,I have both Primary and standby Database on same system (For learning).

When i check status both on primary and secondary using below query it give applied log is "NO".

SQL> select sequence#, applied from v$archived_log;

SEQUENCE# APPLIED
---------- ---------
516 NO
517 NO
523 NO
524 NO
525 NO
531 NO
532 NO
533 NO
541 NO
544 NO

When i checked error on Primary DB .it give me following erro.
SQL> SELECT DEST_ID "ID", STATUS "DB_status", DESTINATION "Archive_dest", ERROR "Error" FROM V$ARCHIVE_DEST WHERE DEST_ID <=5;
---------- ---------
Archive_dest Error
------------------------------------------------------------------------------------------------------------------------------------------------------
1 D:\app\kamdarvg\flash_recovery_area\test\ARCHIVELOG ORA-19504: failed to create file ""

2 STAND ORA-00270: error creating archive log

I checked space on system ...it has enough free space on drive .

On Primary DB (archive log destination)

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination D:\app\kamdarvg\flash_recovery_area\test\ARCHIVELOG
Oldest online log sequence 564
Next log sequence to archive 566
Current log sequence 566

On Standby DB (archive log list)

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination D:\app\kamdarvg\flash_recovery_area\test\ARCHIVELOG
Oldest online log sequence 564
Next log sequence to archive 566
Current log sequence 566

Please guide is it because of same archive log destination shared by standby and Primary ?

If so how to change archive log destination on standby DB ?

Thanks .

Edited by: 977220 on Apr 18, 2013 8:49 PM