Skip to main content

Posts

Showing posts with the label Implementing Dataguard

Step By Step Dataguard Implementation (oracle 10g)

Step By Step Dataguard Implementation (oracle 10g) Your Pfile in primary should have entries like the following entries: ** init File for primary PRIM.__db_cache_size=4194304000 PRIM.__java_pool_size=16777216 PRIM.__large_pool_size=16777216 PRIM.__shared_pool_size=872415232 PRIM.__streams_pool_size=0 *.audit_file_dest='AUDIT_FILE_LOCATION/PRIM/adump' *.background_dump_dest='AUDIT_FILE_LOCATION/PRIM/bdump' *.compatible='10.2.0.1.0' *.control_files='DATAFILE_LOCATION/PRIM/control01.ctl','DATAFILE_LOCATION/PRIM/control02.ctl','DATAFILE_LOCATION/PRIM/control03.ctl' *.core_dump_dest='AUDIT_FILE_LOCATION/PRIM/cdump' *.db_block_size=8192 *.db_domain='' *.db_file_multiblock_read_count=16 *.db_name='PRIM' db_unique_name='PRIM' LOG_ARCHIVE_CONFIG='DG_CONFIG=(PRIM,STAN)' *.db_recovery_file_dest_size=536870912000 *.db_recovery_file_dest='RECOVERY_DESTINA...