Dataguard Archived_log and Standby_log of the Earth Courtyard Project

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