Oracle Database Discussions

Hello,

We are using 9.2.0.7 Oracle Database. And we have created a physical standby database.
The standby data base has been created and all ther configuration has been done as per the DataGuard admin manual. Archived redo logs are transmitted from primary to standby database. But archive logs are not been applied to the standby database. I have checked there are no archive log Gap detected on standby database



SQL> select * from v$archive_gap;

no rows selected



SQL> select process, status from v$managed_standby;

PROCESS STATUS
--------- ------------
ARCH CONNECTED
ARCH CONNECTED
RFS RECEIVING
MRP0 WAIT_FOR_LOG


But when when I query V$ARCHIVED_LOG for applies archive logs on standby database it shows none of the received log has been applied;


SQL> SELECT THREAD#, SEQUENCE#, APPLIED FROM V$ARCHIVED_LOG;

THREAD# SEQUENCE# APP
---------- ---------- ---
1 1409 NO
1 1391 NO
1 1392 NO
1 1393 NO
1 1394 NO
1 1395 NO
1 1396 NO
1 1397 NO
1 1398 NO
1 1399 NO
1 1400 NO

THREAD# SEQUENCE# APP
---------- ---------- ---
1 1401 NO
1 1402 NO
1 1403 NO
1 1404 NO
1 1405 NO
1 1406 NO
1 1407 NO
1 1408 NO
1 1410 NO
1 1411 NO
1 1412 NO

THREAD# SEQUENCE# APP
---------- ---------- ---
1 1413 NO
1 1414 NO
1 1415 NO
1 1416 NO
1 1417 NO
1 1418 NO
1 1419 NO
1 1420 NO
1 1422 NO
1 1421 NO
1 1423 NO

THREAD# SEQUENCE# APP
---------- ---------- ---
1 1424 NO
1 1425 NO
1 1426 NO
1 1427 NO
1 1428 NO
1 1429 NO
1 1430 NO
1 1431 NO
1 1432 NO
1 1433 NO
1 1434 NO

THREAD# SEQUENCE# APP
---------- ---------- ---
1 1435 NO
1 1436 NO
1 1437 NO
1 1438 NO
1 1439 NO
1 1440 NO
1 1441 NO
1 1442 NO
1 1443 NO
1 1444 NO
1 1445 NO

55 rows selected.


On standby database the messages from v$dataguard_status are:


SQL> select message from v$dataguard_status;

MESSAGE
--------------------------------------------------------------------------------
ARC0: Archival started
ARC1: Archival started
Attempt to start background Managed Standby Recovery process
Media Recovery Waiting for thread 8153 seq# 1



SQL> select message from v$dataguard_status;

MESSAGE
--------------------------------------------------------------------------------
ARC0: Archival started
ARC1: Archival started
ARCH: Evaluating archive log 1 thread 1 sequence 1442
ARCH: Beginning to archive log 1 thread 1 sequence 1442
ARC0: Evaluating archive log 1 thread 1 sequence 1442
ARC0: Unable to archive log 1 thread 1 sequence 1442
Log actively being archived by another process
Creating archive destination LOG_ARCHIVE_DEST_2: 'STDBY_12'
Creating archive destination LOG_ARCHIVE_DEST_1: '/oracle/SBX/oraarch/SBXarch1_1
442.dbf'


MESSAGE
--------------------------------------------------------------------------------
ARCH: Completed archiving log 1 thread 1 sequence 1442
ARCH: Evaluating archive log 3 thread 1 sequence 1443
ARCH: Beginning to archive log 3 thread 1 sequence 1443
Creating archive destination LOG_ARCHIVE_DEST_2: 'STDBY_12'
ARC0: Evaluating archive log 3 thread 1 sequence 1443
ARC0: Unable to archive log 3 thread 1 sequence 1443
Log actively being archived by another process
Creating archive destination LOG_ARCHIVE_DEST_1: '/oracle/SBX/oraarch/SBXarch1_1
443.dbf'

ARCH: Completed archiving log 3 thread 1 sequence 1443

MESSAGE
--------------------------------------------------------------------------------
ARCH: Evaluating archive log 4 thread 1 sequence 1444
ARCH: Beginning to archive log 4 thread 1 sequence 1444
ARC0: Evaluating archive log 4 thread 1 sequence 1444
ARC0: Unable to archive log 4 thread 1 sequence 1444
Log actively being archived by another process
Creating archive destination LOG_ARCHIVE_DEST_2: 'STDBY_12'
Creating archive destination LOG_ARCHIVE_DEST_1: '/oracle/SBX/oraarch/SBXarch1_1
444.dbf'

ARCH: Completed archiving log 4 thread 1 sequence 1444
ARCH: Evaluating archive log 2 thread 1 sequence 1445

MESSAGE
--------------------------------------------------------------------------------
ARCH: Beginning to archive log 2 thread 1 sequence 1445
Creating archive destination LOG_ARCHIVE_DEST_2: 'STDBY_12'
ARC0: Evaluating archive log 2 thread 1 sequence 1445
ARC0: Unable to archive log 2 thread 1 sequence 1445
Log actively being archived by another process
Creating archive destination LOG_ARCHIVE_DEST_1: '/oracle/SBX/oraarch/SBXarch1_1
445.dbf'

ARCH: Completed archiving log 2 thread 1 sequence 1445
ARCH: Evaluating archive log 1 thread 1 sequence 1446
ARCH: Beginning to archive log 1 thread 1 sequence 1446

MESSAGE
--------------------------------------------------------------------------------
ARC0: Evaluating archive log 1 thread 1 sequence 1446
Creating archive destination LOG_ARCHIVE_DEST_2: 'STDBY_12'
ARC0: Unable to archive log 1 thread 1 sequence 1446
Log actively being archived by another process
Creating archive destination LOG_ARCHIVE_DEST_1: '/oracle/SBX/oraarch/SBXarch1_1
446.dbf'

ARCH: Completed archiving log 1 thread 1 sequence 1446

42 rows selected.



Please help me to resolve the issue.


Thanks in Advance,

Manoj Dhiman