周五下午客户突然反馈有套ODA X9-2的orcl实例报归档满了，目前没运维，需要帮忙处理一下问题，登录环境后发现db_recovery_file_dest_size配置了300G，当前使用率100%了
救急情况 先把db_recovery_file_dest_size 扩展到400G，切换日志后业务恢复正常
手动做rman的归档( backup archivelog delete all input tag arch_bak format '/nasbackup/orcl/ORCL_%d_%T_%s_%p' ;)，
过了1小时后回来发现归档备份数据量已超过600G了，还在继续备份中，感觉有点奇怪，立刻查看配置
SYS@orcl2> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 768
Next log sequence to archive 769
Current log sequence 769
SYS@orcl2> show parameter log_archive_dest_state
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_1 string ENABLE
log_archive_dest_state_10 string ALTERNATE
SYS@orcl2> show parameter log_archive_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1 string LOCATION=USE_DB_RECOVERY_FILE_
DEST VALID_FOR=(ALL_LOGFILES,A
LL_ROLES) MAX_FAILURE=1 REOPEN
=5 DB_UNIQUE_NAME=orcl ALT
ERNATE=log_archive_dest_10
log_archive_dest_10 string LOCATION=+DATA/orcl/arc10
VALID_FOR=(ALL_LOGFILES,ALL_RO
LES) DB_UNIQUE_NAME=orcl A
LTERNATE=log_archive_dest_1
SYS@orcl2> show parameter log_archive
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_config string
log_archive_dest string
log_archive_dest_1 string LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) MAX_FAILURE=1 REOPEN=5 DB_UNIQUE_NAME=orcl ALTERNATE=log_archive_dest_10
log_archive_dest_10 string LOCATION=+DATA/orcl/arc10 VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl ALTERNATE=log_archive_dest_1
##附录参数文件配置
[oracle@oda0 ~]$ more /tmp/orcl.pfile
orcl2.__data_transfer_cache_size=0
orcl2.__data_transfer_cache_size=0
orcl2.__db_cache_size=1694498816
orcl2.__db_cache_size=1627389952
orcl2.__inmemory_ext_roarea=0
orcl2.__inmemory_ext_roarea=0
orcl2.__inmemory_ext_rwarea=0
orcl2.__inmemory_ext_rwarea=0
orcl2.__java_pool_size=0
orcl2.__java_pool_size=0
orcl2.__large_pool_size=16777216
orcl2.__large_pool_size=16777216
orcl2.__oracle_base='/u01/app/odaorabase/oracle'#ORACLE_BASE set from environment
orcl2.__oracle_base='/u01/app/odaorabase/oracle'#ORACLE_BASE set from environment
orcl2.__pga_aggregate_target=2147483648
orcl2.__pga_aggregate_target=2147483648
orcl2.__sga_target=4294967296
orcl2.__sga_target=4294967296
orcl2.__shared_io_pool_size=134217728
orcl2.__shared_io_pool_size=134217728
orcl2.__shared_pool_size=2365587456
orcl2.__shared_pool_size=2449473536
orcl2.__streams_pool_size=0
orcl2.__streams_pool_size=16777216
orcl2.__unified_pga_pool_size=0
orcl2.__unified_pga_pool_size=0
*._datafile_write_errors_crash_instance=false
*._db_writer_coalesce_area_size=16777216
*._disable_interface_checking=TRUE
*._file_size_increase_increment=2143289344
*._fix_control='18960760:on'
*._gc_policy_time=20
*._gc_undo_affinity=TRUE
*.audit_file_dest='/u01/app/odaorabase/oracle/admin/orcl/adump'
*.audit_sys_operations=TRUE
*.audit_trail='db'
*.cluster_database=true
*.compatible='19.0.0.0'
*.control_files='+RECO/PORTRAIT/CONTROLFILE/current.357.1169067287'
*.cpu_count=2
*.cursor_sharing='EXACT'
*.db_block_checking='FULL'
*.db_block_checksum='FULL'
*.db_block_size=8192
*.db_create_file_dest='+DATA(FG$FILEGROUP_TEMPLATE_MIRROR)'
*.db_create_online_log_dest_1='+RECO(FG$FILEGROUP_TEMPLATE_MIRROR)'
*.db_domain=''
*.db_files=1024
*.db_lost_write_protect='TYPICAL'
*.db_name='orcl'
*.db_recovery_file_dest='+RECO(FG$FILEGROUP_TEMPLATE_MIRROR)'
*.db_recovery_file_dest_size=343597383680
*.db_unique_name='orcl'
*.diagnostic_dest='/u01/app/odaorabase/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.encrypt_new_tablespaces='DDL'
*.fast_start_mttr_target=300
*.filesystemio_options='setall'
*.global_names=TRUE
family:dw_helper.instance_mode='read-only'
orcl2.instance_number=1
orcl2.instance_number=2
*.listener_networks='((NAME=net1)(LOCAL_LISTENER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.11.35)(PORT=1521)))))','((NAME=net1)(LOCAL_LISTENER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.11.36)(PORT=1521)))))','((NAME=net1)(REMOTE_LISTENER=x9odanode-scan.cuc.edu.cn:1521))'
*.local_listener='-oracle-none-'
*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) MAX_FAILURE=1 REOPEN=5 DB_UNIQUE_NAME=orcl ALTERNATE=log_archive_dest_10'
*.log_archive_dest_10='LOCATION=+DATA/orcl/arc10 VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl ALTERNATE=log_archive_dest_1'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_10='ALTERNATE'
*.log_archive_format='%t_%s_%r.dbf'
*.log_buffer=33554432
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=1000
*.os_authent_prefix='ops$'
*.parallel_execution_message_size=16384
*.parallel_max_servers=80
*.parallel_min_servers=8
*.parallel_threads_per_cpu=2
*.pga_aggregate_limit=21474836480
*.pga_aggregate_target=2048m
*.processes=1000
*.remote_listener=''
*.remote_login_passwordfile='exclusive'
*.session_cached_cursors=100
*.sga_target=4096m
*.sql92_security=TRUE
orcl2.thread=2
orcl2.thread=1
*.undo_retention=900
orcl2.undo_tablespace='UNDOTBS1'
orcl2.undo_tablespace='UNDOTBS2'
*.use_large_pages='only'
