Oracle Standby Database Changes standby_archive_dest path

1, export Pfile file;

sql> create pfile= '/oratmp/pfile.ora ' from SPFile;

File created.

2, modify the Pfile file, comment out #*.standby_archive_dest= '/archivelog/standby/slog ' this line

p560a:/#vi/oratmp/pfile.ora

"/oratmp/pfile.ora" lines, 1944 characters

port1.__db_cache_size=58955137024

port2.__db_cache_size=7230980096

standby.__db_cache_size=14042529792

port1.__java_pool_size=117440512

port2.__java_pool_size=117440512

standby.__java_pool_size=16777216

port2.__large_pool_size=16777216

port1.__large_pool_size=16777216

standby.__large_pool_size=16777216

port1.__shared_pool_size=9579790336

port2.__shared_pool_size=5469372416

standby.__shared_pool_size=2013265920

Port2.__streams_pool_size=0

Port1.__streams_pool_size=0

Standby.__streams_pool_size=0

*._kgl_large_heap_warning_threshold=8388608

*.audit_file_dest= '/home/oracle/admin/port/adump '

*.background_dump_dest= '/home/oracle/admin/port/bdump '

*.cluster_database=false

*.compatible= ' 10.2.0.1.0 '

*.control_files= '/dev/rcontrol01 ', '/dev/rcontrol02 ', '/dev/rcontrol03 '

*.core_dump_dest= '/home/oracle/admin/port/cdump '

*.db_block_size=8192

*.db_domain= "

*.db_file_multiblock_read_count=16

*.db_files=1000

*.db_name= ' Port '

*.db_recovery_file_dest= "

*.db_recovery_file_dest_size=10737418240

*.db_unique_name= ' STANDBY '

*.dispatchers= ' (protocol=tcp) (SERVICE=PORTXDB) '

*.event= ' 10298 Trace name context Forever,level 32 '

*.fal_client= ' STANDBY '

*.fal_server= ' Port '

*.instance_number=1

*.job_queue_processes=10

*.local_listener= "

*.lock_sga=true

*.log_archive_config= ' dg_config= (port,standby) '

*.log_archive_dest_1= ' Location=/backup/archivelog valid_for= (all_logfiles,all_roles) DB_UNIQUE_NAME=standby '

*.log_archive_dest_state_1= ' ENABLE '

*.log_archive_format= '%t_%s_%r.arc '

*.log_archive_max_processes=4

*.nls_language= ' AMERICAN '

*.open_cursors=1000

*.pga_aggregate_target=2g

*.processes=1500

*.remote_login_passwordfile= ' EXCLUSIVE '

*.resource_limit=true

*.sessions=1655

*.sga_max_size=15g

*.sga_target=15g

#*.standby_archive_dest= '/archivelog/standby/slog '

*.standby_file_management= ' AUTO '

"/oratmp/pfile.ora" lines, 1945 characters

3. Start with modified Pfile

sql> shutdown immediate;

Ora-01109:database not open

Database dismounted.

ORACLE instance shut down.

sql> startup Nomount pfile= '/oratmp/pfile.ora ';

ORACLE instance started.

Total System Global area 1.6106E+10 bytes

Fixed Size 2112192 bytes

Variable Size 2046821696 bytes

Database buffers 1.4043E+10 bytes

Redo buffers 14663680 bytes

4. Rebuilding SPFile

Sql> create SPFile from Pfile;

File created.

5. Mount Database

Sql> ALTER DATABASE mount standby database;

Database altered.

sql> ALTER DATABASE recover managed standby database disconnect from session;

Database altered.

Sql>

6, observation log found that the archive directory has been changed

Before change:

Tue June 16 13:54:07 2015

RFS[24297]: Archived Log: '/archivelog/standby/slog/1_106003_862729481.arc '

After the change:

Tue June 16 14:33:13 2015

RFS[2]: Archived Log: '/backup/archivelog/2_59627_862729481.arc '

This article is from the "Wheat Dock" blog, please make sure to keep this source http://yunlongzheng.blog.51cto.com/788996/1662312

Oracle Standby Database Changes standby_archive_dest path