This content has been marked as final. Show 3 replies
Have not tested, but I cannot see where anything negative or anything would happen to impact you.
1)The default is in "dbf" and to change the parameter we need to shutdown the database. We don't want our production to be shutdown, and so what happens if i don't change the parameter and leave it as "dbf".
Beside the letters nothing. Its just the extension you give to the file name.
2)What is the difference between .arc and .dbf for log_archive_format?
You can. I like to keep things the same if possible myself.
3)Can we have primary in .dbf and standby in .arc, and we are planning to have our backups on standby so are standby backups can be used at primary with different log_archive_format if needed?if no why?
No it is not.
I don't have it set on any of mine.
Complete INIT from my test system
PRIMARY.__db_cache_size=318767104 PRIMARY.__java_pool_size=4194304 PRIMARY.__large_pool_size=4194304 PRIMARY.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment PRIMARY.__pga_aggregate_target=281018368 PRIMARY.__sga_target=834666496 PRIMARY.__shared_io_pool_size=0 PRIMARY.__shared_pool_size=490733568 PRIMARY.__streams_pool_size=4194304 *.audit_file_dest='/u01/app/oracle/admin/PRIMARY/adump' *.audit_trail='db' *.compatible='220.127.116.11.0' *.control_files='/u01/app/oracle/oradata/PRIMARY/control01.ctl','/u01/app/oracle/oradata/PRIMARY/control02.ctl' *.db_block_size=8192 *.db_flashback_retention_target=2880 *.db_name='PRIMARY' *.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area' *.db_recovery_file_dest_size=23622320128 *.DB_UNIQUE_NAME='PRIMARY' *.diagnostic_dest='/u01/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=PRIMARYXDB)' *.FAL_SERVER='STANDBY' *.local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=REGISTER)))' *.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PRIMARY' *.log_archive_dest_2='SERVICE=STANDBY LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STANDBY' *.LOG_ARCHIVE_DEST_STATE_1='ENABLE' *.log_archive_dest_state_2='ENABLE' *.LOG_ARCHIVE_MAX_PROCESSES=30 *.open_cursors=300 *.pga_aggregate_target=277872640 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sec_case_sensitive_logon=FALSE *.sga_target=833617920 *.STANDBY_FILE_MANAGEMENT='AUTO' *.undo_tablespace='UNDOTBS1'
Edited by: mseberg on Oct 24, 2012 4:03 PM