| Archive Destination Status |
|---|
| The following select will attempt to gather as much information as possible from the standby. Standby redo logs are not supported with Logical Standby until Version 10.1. The ARCHIVED_SEQUENCE# from a logical standby is the sequence# created by the apply, not the sequence# sent from the primary. |
| DEST_ID | DATABASE_MODE | RECOVERY_MODE | PROTECTION_MODE | STANDBY_LOGFILE_COUNT | STANDBY_LOGFILE_ACTIVE | ARCHIVED_SEQ# |
|---|---|---|---|---|---|---|
| 1 | OPEN | IDLE | MAXIMUM PERFORMANCE | 0 | 0 | 638 |
| 2 | MOUNTED-STANDBY | IDLE | MAXIMUM PERFORMANCE | 4 | 1 | 638 |
| Non Default init Parameters |
|---|
| Non-default init parameters. For a RAC DB Thread# = * means the value is the same for all threads (SID=*) Threads with different values are shown with their individual thread# and values. |
| THREAD# | NAME | VALUE |
|---|---|---|
| * | processes | 150 |
| * | memory_target | 817889280 |
| * | control_files | /u01/app/ora11/oradata/ORA11G/controlfile/o1_mf_907t9hd6_.ctl |
| * | db_block_size | 8192 |
| * | compatible | 11.2.0.0.0 |
| * | log_archive_dest_1 | LOCATION=/u01/app/ora11/flash_recovery_area valid_for=(all_logfiles,all_roles) db_unique_name=ora11g |
| * | log_archive_dest_2 | SERVICE=orcl lgwr async valid_for=(online_logfile,primary_role) db_unique_name=orcl |
| * | fal_client | ora11g |
| * | fal_server | orcl |
| * | log_archive_config | DG_CONFIG=(ora11g,orcl) |
| * | db_create_file_dest | /u01/app/ora11/oradata |
| * | db_recovery_file_dest | /u01/app/ora11/flash_recovery_area |
| * | db_recovery_file_dest_size | 4070572032 |
| * | standby_file_management | AUTO |
| * | undo_tablespace | UNDOTBS1 |
| * | remote_login_passwordfile | EXCLUSIVE |
| * | db_domain | |
| * | dispatchers | (PROTOCOL=TCP) (SERVICE=ora11gXDB) |
| * | audit_file_dest | /u01/app/ora11/admin/ora11g/adump |
| * | audit_trail | DB |
| * | db_name | ora11g |
| * | open_cursors | 300 |
| * | dg_broker_start | TRUE |
| * | diagnostic_dest | /u01/app/ora11 |