Problems with Oracle DG archive setup Verification

Problems with Oracle DG archive setup Verification

1. -- Master database
2. SQL> col statusForA10
3. SQL> col destinationForA20
4. SQL> col errorForA20
5. SQL>SELECTSTATUS, DESTINATION, ERRORFROMV $ ARCHIVE_DEST;
7. STATUS DESTINATION ERROR
8. --------------------------------------------------
9. VALID/home/oracle/flash_r
10. Ecovery_area/ORCL/ar
11. Chivelog
13. ERROR orcl_st ORA-12514:
14. TNS: listener does
15. NotCurrently know
16. OfService
17. RequestedIn
18. ConnectDescriptor
21. STATUS DESTINATION ERROR
22. --------------------------------------------------
23. INACTIVE
24. INACTIVE
25. INACTIVE
26. INACTIVE
27. INACTIVE
28. INACTIVE
29. INACTIVE
30. INACTIVE
32. 10RowsSelected.
34. -- Slave Database
35. SQL> col statusForA10
36. SQL> col destinationForA20
37. SQL> col errorForA20
38. SQL>SELECTSTATUS, DESTINATION, ERRORFROMV $ ARCHIVE_DEST;
40. STATUS DESTINATION ERROR
41. --------------------------------------------------
42. VALID/home/oracle/flash_r
43. Ecovery_area/ORCL/ar
44. Chivelog
46. ERROR orcl_pd ORA-12514:
47. TNS: listener does
48. NotCurrently know
49. OfService
50. RequestedIn
51. ConnectDescriptor
54. STATUS DESTINATION ERROR
55. --------------------------------------------------
56. INACTIVE
57. INACTIVE
58. INACTIVE
59. INACTIVE
60. INACTIVE
61. INACTIVE
62. INACTIVE
63. INACTIVE
64. VALID/home/oracle/flash_r
65. Ecovery_area/ORCL/ar
66. Chivelog
68. STATUS DESTINATION ERROR
69. --------------------------------------------------
72. 11RowsSelected.

Modify the listening files of the master and slave databases, and add SID_DESCEntry:

1. SID_LIST_LISTENER =
2. (SID_LIST =
3. (SID_DESC =
4. (SID_NAME = PLSExtProc)
5. (ORACLE_HOME =/home/oracle/product/10.2.0/db_1)
6. (PROGRAM = extproc)
7. )
8. <Span style = "background-color: rgb (0,153, 0);"> (SID_DESC =
9. (GLOBAL_DBNAME = orcl)
10. (ORACLE_HOME =/home/oracle/product/10.2.0/db_1)
11. (SID_NAME = orcl)
12. )
13. </Span>
14. )
16. LISTENER =
17. (DESCRIPTION_LIST =
18. (DESCRIPTION =
19. (ADDRESS = (PROTOCOL = TCP) (HOST = target) (PORT = 1521 ))
20. )
21. )

Also query V $ ARCHIVE_DEST or v $ archive_dest_status:
SQL> select status, destination, error from v $ archive_dest;
SQL> select error from v $ archive_dest_status;
The following error occurs:
ORA-16009: remote archive log destination must be a STANDBY database
Modify the log_archive_dest_2 parameter of the master and slave databases and add the valid_for = (online_logfiles, primary_role) option.

1. SQL>AlterSystemSetLog_archive_dest_2 ='Service = orcl_pd valid_for = (online_logfiles, primary_role) DB_UNIQUE_NAME = orcl_pd'
2. Scope = both;
3. SQL>AlterSystemSetLog_archive_dest_2 ='Service = orcl_st valid_for = (online_logfiles, primary_role) DB_UNIQUE_NAME = orcl_st'
4. Scope = both;

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12