Saturday, August 7, 2021

Parameter for Oracle Data Guard

1. LOG_ARCHIVE_CONFIG - highly recommended by oracle, The DG_CONFIG is set on each database to set Data Guard Configuration. 

2. LOG_ARCHIVE_MAX_PROCESS - optional by Oracle, specify the number ( from 1- 30 ) of archiver (ARCn) process you want oracle software to invoke initially.
The default value is 4.

3.DB_CREATE_FILE_DEST - It specifies the default location of the Oracle Managed datafile.4
DB_CREATE_FILE_DEST= dictory / disk group. 
4.FAL_CLIENT - this parameter is no longer required.

5. FAL_SERVER - it specifies more oracle Net Services name, it can retrieve the missing archive file.
ORACLE_NET _SERVICE_NAME


 looking forward to your suggestions.. please feel free to write to me. Your help would definitely help to improve our blog. Chetan Yadav

how many Database are using ASM

How to know how many databases are using ASM 


we can use 

V$asm_client 




Looking forward to your suggestions.. please feel free to write to me.. Your help would definitely help to improve our blog. Chetan Yadav