Master Database: vsgpdb
Standby Database: dgdb
1. confirm that the master database is in archive Mode
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination/gp/arch
Oldest online log sequence 1307
Next log sequence to archive 1312
Current log sequence 1312
2. Set the primary database to force logging mode. Use the following statements:
SQL> select force_logging from v $ database;
FOR
---
YES
SQL> alter database force logging;
3. Configure the initialization parameters of the Primary database
Modify the client initialization parameter file and add the following content:
*. DB_UNIQUE_NAME = vsgpdb
*. LOG_ARCHIVE_CONFIG = 'dg _ CONFIG = (vsgpdb, dgdb )'
*. LOG_ARCHIVE_DEST_2 = 'service = dgdb lgwr sync affrem VALID_FOR = (ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME = dgdb'
*. LOG_ARCHIVE_DEST_STATE_2 = DEFER
SQL> alter system set LOG_ARCHIVE_CONFIG = 'dg _ CONFIG = (vsgpdb, dgdb )';
SQL> alter system set LOG_ARCHIVE_DEST_2 = 'service = dgdb LGWR SYNC affsert
VALID_FOR = (ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME = dgdb ';
SQL> alter system set LOG_ARCHIVE_DEST_STATE_2 = DEFER;
# -------- Configure the parameters of the standby role for role conversion
*. FAL_SERVER = DGDB
*. FAL_CLIENT = VSGPDB
*. DB_FILE_NAME_CONVERT = '/opt/ora10g/oradata/vsgpdb','/opt/dgdb/oradata/dgdb'
*. LOG_FILE_NAME_CONVERT = '/opt/ora10g/oradata/vsgpdb','/opt/dgdb/oradata/dgdb'
*. STANDBY_FILE_MANAGEMENT = AUTO
SQL> alter system set FAL_SERVER = DGDB;
System altered.
SQL> alter system set FAL_CLIENT = VSGPDB;
System altered.
SQL> alter system set DB_FILE_NAME_CONVERT = '/opt/ora10g/oradata/vsgpdb', '/opt/dgdb/oradata/dgdb ';
Alter system set DB_FILE_NAME_CONVERT = '/opt/ora10g/oradata/vsgpdb','/opt/dgdb/oradata/dgdb'
*
ERROR at line 1:
ORA-02096: specified initialization parameter is not modifiable with this
Option
SQL> alter system set DB_FILE_NAME_CONVERT = '/opt/ora10g/oradata/vsgpdb', '/opt/dgdb/oradata/dgdb','/gp/oradata ', '/opt/dgdb/oradata/dgdb' scope = spfile;
System altered.
SQL>
SQL> alter system set LOG_FILE_NAME_CONVERT = '/opt/ora10g/oradata/vsgpdb', '/opt/dgdb/oradata/dgdb' scope = spfile;
SQL> alter system set STANDBY_FILE_MANAGEMENT = AUTO;
Restart after modification
4. Create a control file-primary database operation
SQL> alter database create standby controlfile as '/opt/ora10g/oradata/vsgpdb/dgdb03.ctl ';
SQL> create pfile from spfile;
File created.
Shutdown immediate -- Be sure to turn off the master database and then transfer data files
5. transfer files to the standby Database
Initialize parameter files + control files + data files
SLAVE: 192.168.165.26 is the slave database IP address.
Scp/opt/ora10g/product/10.2.0/db_1/dbs/initvsgpdb. ora dgdb@192.168.165.26:/opt/dgdb/product/10.2.0/db_1/dbs/initdgdb. ora
Scp/opt/ora10g/oradata/vsgpdb/dgdb03.ctl dgdb@192.168.165.26:/opt/dgdb/oradata/dgdb/dgdb01.ctl
Scp/opt/ora10g/oradata/vsgpdb/dgdb03.ctl dgdb@192.168.165.26:/opt/dgdb/oradata/dgdb/dgdb02.ctl
Scp/opt/ora10g/oradata/vsgpdb/dgdb03.ctl dgdb@192.168.165.26:/opt/dgdb/oradata/dgdb/dgdb03.ctl
Scp/opt/ora10g/oradata/vsgpdb/redo02.log dgdb@192.168.165.26:/opt/dgdb/oradata/dgdb/
Scp/opt/ora10g/oradata/vsgpdb/system01.dbf dgdb@192.168.165.26:/opt/dgdb/oradata/dgdb/
Scp/gp/oradata/undo0201.dbf dgdb@192.168.165.26:/opt/dgdb/oradata/dgdb/
Scp/opt/ora10g/oradata/vsgpdb/redo01.log dgdb@192.168.165.26:/opt/dgdb/oradata/dgdb/
Scp/opt/ora10g/oradata/vsgpdb/redo03.log dgdb@192.168.165.26:/opt/dgdb/oradata/dgdb/
Scp/opt/ora10g/oradata/vsgpdb/sysaux01.dbf dgdb@192.168.165.26:/opt/dgdb/oradata/dgdb/
Scp/opt/ora10g/oradata/vsgpdb/temp01.dbf dgdb@192.168.165.26:/opt/dgdb/oradata/dgdb/
Scp/gp/oradata/temp01.dbf dgdb@192.168.165.26:/opt/dgdb/oradata/dgdb/
Scp/gp/oradata/users01.dbf dgdb@192.168.165.26:/opt/dgdb/oradata/dgdb/
6. Modify the backup database initialization parameter file
[Dgdb @ rac1 dbs] $ cat initdgdb. ora
Dgdb. _ db_cache_size = 557842432
Dgdb. _ java_pool_size = 25165824
Dgdb. _ large_pool_size = 4194304
Dgdb. _ shared_pool_size = 255852544
Dgdb. _ streams_pool_size = 130023424
*. Aq_tm_processes = 0
*. Audit_file_dest = '/opt/dgdb/admin/dgdb/adump'
*. Audit_trail = 'db'
*. Background_dump_dest = '/opt/dgdb/admin/dgdb/bdump'
*. Compatible = '10. 2.0.3.0'
*. Control_files = '/opt/dgdb/oradata/dgdb/dg01.ctl', '/opt/dgdb/oradata/dgdb/dg02.ctl', '/opt/dgdb/oradata/dgdb/dg03.ctl'
*. Core_dump_dest = '/opt/dgdb/admin/dgdb/cdump'
*. Cursor_sharing = 'exist'
*. Db_block_size = 8192
*. Db_domain =''
*. Db_file_multiblock_read_count = 32
*. Db_file_name_convert = '/opt/ora10g/oradata/vsgpdb', '/opt/dgdb/oradata/dgdb','/opt/dgdb/oradata/dgdb ', '/opt/ora10g/oradata/vsgpdb'
*. Db_keep_cache_size = 33554432
*. Db_name = 'vsgpdb'
*. Db_recovery_file_dest = '/opt/dgdb/flash_recovery_area'
*. Db_recovery_file_dest_size = 10737418240
*. Dispatchers = '(PROTOCOL = TCP) (SERVICE = dgdbXDB )'
*. Fal_client = 'dgdb'
*. Fal_server = 'vsgpdb'
*. Global_names = TRUE
*. Job_queue_processes = 10
*. Log_archive_config = 'dg _ CONFIG = (vsgpdb, dgdb )'
*. Log_archive_dest_1 = 'location =/gp/arch'
*. Log_archive_dest_2 = 'service = vsgpdb lgwr sync affrem VALID_FOR = (ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME = vsgpdb'
*. Log_archive_dest_state_2 = ENABLE
*. Log_archive_format = 'arch % t _ % s _ % r. arc'
*. Log_buffer = 61081600
*. Log_file_name_convert = '/opt/ora10g/oradata/vsgpdb', '/opt/dgdb/oradata/dgdb','/opt/dgdb/oradata/dgdb ', '/opt/ora10g/oradata/vsgpdb'
*. Nls_date_format = 'yyyy-MM-DD HH24: MI: ss'
*. Open_cursors = 300
*. Open_links = 4
*. Parallel_max_servers = 20
*. Pga_aggregate_target = 170917888
*. Processses = 150
*. Recyclebin = 'off'
*. Remote_login_passwordfile = 'clusive'
*. Sga_max_size = 1073741824
*. Sga_target = 1073741824
*. Standby_file_management = 'auto'
*. Star_transformation_enabled = 'true'
*. Streams_pool_size = 26214400
*. Trace_enabled = FALSE
*. Undo_management = 'auto'
*. Undo_retention = 3600
*. Undo_tablespace = 'undotbs1'
*. User_dump_dest = '/opt/dgdb/admin/dgdb/udump'
*. Utl_file_dir = '*'
[Dgdb @ rac1 dbs] $
[Dgdb @ rac1 dbs] $ sqlplus/as sysdba
SQL * Plus: Release 10.2.0.4.0-Production on Wed Aug 21 08:55:38 2013
Copyright (c) 1982,200 7, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> create spfile from pfile = '/opt/dgdb/product/10.2.0/db_1/dbs/initdgdb. ora ';
Startup mount
References:
Important configuration parameters of Oracle Data Guard
Configure Oracle 11g Data Guard based on the same host
Explore Oracle 11g elastic uard
Oracle Data Guard (RAC + DG) archive deletion policies and scripts
Role conversion for Oracle Data Guard
FAL gap in Oracle Data Guard logs
Oracle 11g Data Guard Error 16143 Heartbeat failed to connect to standby
For more details, please continue to read the highlights on the next page: