|
TOP
|
|
dataguard主库检测脚本(三)
| 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 |
|