Oracle Database 19c Dataguard Kurulumu Rman Dublicate

Primary

Standby

Database Version

19.3.0

19.3.0

Database Name

orcl

orcl

Database Uniqname

orcl

orcldg

Ip

192.168.56.19

192.168.56.20

Lıstener Port

1521

1521

Os

Oel 7.9

Oel 7.9

alter system set log_archive_dest_1=’LOCATION=/u01/app/oracle/arch’ scope=both; ALTER SYSTEM SET log_archive_format=’%t_%r_%s.arc’ SCOPE=spfile;

shutdown immediate;

startup mount;

alter database archivelog;

alter database force logging;

alter system set log_archive_config= ‘dg_config=(orcl,orcldg)’

alter system set log_archive_dest_2=’SERVICE=orcldg LGWR ASYNC VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE) DB_UNIQUE_NAME=orcldg’;

alter system set log_archive_max_processes=30;

alter system set remote_login_passwordfile=exclusive scope=spfile;

alter system set fal_server=orcldg;

alter system set standby_file_management=auto;

alter database add standby logfile (‘/u01/app/oracle/oradata/ORCL/standby_redo01.log’) size 50m;

alter database add standby logfile (‘/u01/app/oracle/oradata/ORCL/standby_redo01.log’) size 50m;

alter database add standby logfile (‘/u01/app/oracle/oradata/ORCL/standby_redo02.log’) size 50m;

alter database add standby logfile (‘/u01/app/oracle/oradata/ORCL/standby_redo03.log’) size 50m;

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = db19c.localdomain)(PORT = 1521))

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = orcl)

(ORACLE_HOME = /u01/app/oracle/product/19c/db_1)

(SID_NAME = orcl)

)

)

ADR_BASE_LISTENER = /u01/app/oracle

LISTENER_ORCL =

(ADDRESS = (PROTOCOL = TCP)(HOST = db19c.localdomain)(PORT = 1521))

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = db19c.localdomain)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

ORCLDG =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = dg19c.localdomain)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = orcl)

(GLOBAL_NAME = orcl)

)

)

scp orapworcl oracle@dg19c:/u01/app/oracle/product/19c/db_1/dbs

scp tnsnames.ora oracle@dg19c:/u01/app/oracle/product/19c/db_1/network/admin

mkdir -p /u01/app/oracle/oradata/ORCL

mkdir -p $ORACLE_BASE/admin/orcl/adump

[oracle@dg19c ORCL]$ more /u01/app/oracle/product/19c/db_1/network/admin/listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/19c/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = dg19c.localdomain)(PORT = 1521))

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = orcl)

(ORACLE_HOME = /u01/app/oracle/product/19c/db_1)

(SID_NAME = orcl)

)

)

ADR_BASE_LISTENER = /u01/app/oracle

*.db_name=’orcl’

memory_target=1G

processes = 150

audit_file_dest=’/u01/app/oracle/admin/orcl/adump’

audit_trail =’db’

db_block_size=8192

db_domain=”

db_recovery_file_dest=’/u01/app/oracle/arch’

db_recovery_file_dest_size=2G

diagnostic_dest='<ORACLE_BASE>’

dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)’

open_cursors=300

remote_login_passwordfile=’EXCLUSIVE’

undo_tablespace=’UNDOTBS1′

# You may want to ensure that control files are created on separate physical

# devices

control_files = (ora_control1, ora_control2)

compatible =’11.2.0′

rman TARGET sys/welcome1@orcl AUXILIARY sys/welcome1@orcldg

run{

allocate channel prmy1 type disk;

allocate channel prmy2 type disk;

allocate channel prmy3 type disk;

allocate channel prmy4 type disk;

allocate auxiliary channel stby type disk;

duplicate target database for standby nofilenamecheck from active database

spfile

parameter_value_convert ‘ORCLDG’,’ORCL’

set db_unique_name=’orcldg’

set fal_client=’orcldg’

set fal_server=’orcl’

set standby_file_management=’MANUAL’

set log_archive_config=’dg_config=(orcl,orcldg)’

set log_archive_max_processes=’5′

set log_archive_config=’dg_config=(ORCL,ORCLDG)’

set log_archive_dest_2=’service=ORCL ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=ORCL’;}

alter database recover managed standby database disconnect from session;