Main Library Archivelog and Standbylog
Just test 4 days of data, the project is not officially launched
/data/dddb/dbsoftware/app/oracle/product/11.2.0/dbhome_1/dbs/archivelog
/data/dddb/dbsoftware/app/oracle/standbylog
Standby Archivedlog and Standbylog
Main Library SPFile
Main Library "Listener.ora"
Main Library Tnsnames.ora
Standby Library SPFile
Standby Library Tnsnames.ora
/data/dddb/dbsoftware/app/oracle/product/11.2.0/dbhome_1/network/admin
Standby Library "Listener.ora"
Main Library Spfile,listener.ora,tnsnames.ora
LISTENER = (description_list = ( DESCRIPTION = ( address = (PROTOCOL = IPC) (KEY = EXTPROC1521)) (address = (PROTOCOL = TCP) (HOST = priydb.cc) (PORT = 1521)))) Sid_list_listener = (sid_list = ( Sid_desc = (global_dbname = dg1.priydb.cc) (oracle_home =/data/ Dddb/dbsoftware/app/oracle/product/11.2.0/dbhome_1) (sid_name = DG) ) Adr_base_listener =/data/ Dddb/dbsoftware/app/oracle
Listener.ora
DG1 = (DESCRIPTION = ( ADDRESS = (PROTOCOL = TCP) (HOST = priydb.cc) (PORT = 1521)) (Connect_data = (SERVER = Dedicated) (service_name = dg1.priydb.cc) ) ) dg2 = (DESCRIPTION = ( ADDRESS = (PROTOCOL = TCP) (HOST = stadby.cc) (PORT = 1521)) (Connect_data = (SERVER = dedicated) (service_name = dg2.stadby.cc) ) c14/>) for_db = (DESCRIPTION = ( ADDRESS = (PROTOCOL = TCP) (HOST = 10.252.32.183) (PORT = 1521))
"Tnsnames.ora"
Dg.__db_cache_size=423624704dg.__java_pool_size=4194304dg.__large_pool_size=4194304dg.__oracle_base= '/data/ Dddb/dbsoftware/app/oracle ' #ORACLE_BASE set from environmentdg.__pga_aggregate_target=432013312dg.__sga_target= 641728512dg.__shared_io_pool_size=0dg.__shared_pool_size=197132288dg.__streams_pool_size=0*.audit_file_dest= '/ Data/dddb/dbsoftware/app/oracle/admin/dg/adump ' *.audit_trail= ' db ' *.compatible= ' 11.2.0.0.0 ' *.control_files= '/ Data/dddb/dbdata/oradata/dg/control01.ctl ', '/data/dddb/dbsoftware/app/oracle/flash_recovery_area/dg/ Control02.ctl ' *.db_block_size=8192*.db_domain= ' priydb.cc ' *.db_name= ' dg ' *.db_recovery_file_dest= '/data/dddb/ Dbsoftware/app/oracle/flash_recovery_area ' *.db_recovery_file_dest_size=4070572032*.db_unique_name= ' dg1 ' *. diagnostic_dest= '/data/dddb/dbsoftware/app/oracle ' *.dispatchers= ' (protocol=tcp) (service=dgxdb) ' *.fal_client= ' DG1 ' *.fal_server= ' dg2 ' *.local_listener= ' for_db ' *.log_archive_config= ' dg_config= (dg1,dg2) ' *.log_archive_dest_1= ' Location=/data/dddb/dbsoftware/App/oracle/product/11.2.0/dbhome_1/dbs/archivelog valid_for= (all_logfiles,primary_role) DB_UNIQUE_NAME=DG1 ' *.log _archive_dest_2= ' service=dg2 lgwr sync valid_for= (online_logfile,primary_role) db_unique_name=dg2 ' *.log_archive_ Dest_3= ' Location=/data/dddb/dbsoftware/app/oracle/standbylog valid_for= (standby_logfile,standby_role) db_unique_ Name=dg1 ' *.memory_target=1073741824*.open_cursors=300*.processes=150*.remote_login_passwordfile= ' EXCLUSIVE ' *. Standby_file_management= ' AUTO ' *.undo_tablespace= ' UNDOTBS1 '
/initdg.ora "
Dataguard Archived_log and Standby_log of the Earth Courtyard Project