179 lines
5.2 KiB
Plaintext
179 lines
5.2 KiB
Plaintext
select force_logging from v$database;
|
|
|
|
set lines 256 pages 999
|
|
|
|
col MEMBER for a60
|
|
select * from v$logfile;
|
|
|
|
-- create standby redologs
|
|
select 'ALTER DATABASE ADD STANDBY LOGFILE THREAD '||thread#||' size '||bytes||';' from v$log;
|
|
select distinct 'ALTER DATABASE ADD STANDBY LOGFILE THREAD '||thread#||' size '||bytes||';' from v$log;
|
|
|
|
-- clear / drop standby redologs
|
|
select 'ALTER DATABASE CLEAR LOGFILE GROUP '||GROUP#||';' from v$standby_log;
|
|
select 'ALTER DATABASE DROP STANDBY LOGFILE GROUP '||GROUP#||';' from v$standby_log;
|
|
|
|
|
|
|
|
|
|
*.audit_file_dest='/app/oracle/base/admin/ANDODRP/adump'
|
|
*.audit_trail='OS'
|
|
*.compatible='19.0.0.0'
|
|
*.control_files='/data/ANDODRP/control01.ctl'
|
|
*.db_block_size=8192
|
|
*.db_create_file_dest='/data'
|
|
*.db_create_online_log_dest_1='/data'
|
|
*.db_name='ANDO'
|
|
*.db_recovery_file_dest_size=10G
|
|
*.db_recovery_file_dest='/reco'
|
|
*.db_unique_name='ANDODRP'
|
|
*.diagnostic_dest='/app/oracle/base/admin/ANDODRP'
|
|
*.enable_goldengate_replication=TRUE
|
|
*.enable_pluggable_database=FALSE
|
|
*.instance_name='ANDODRP'
|
|
*.log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST'
|
|
*.log_archive_format='%t_%s_%r.arc'
|
|
*.open_cursors=300
|
|
*.pga_aggregate_target=512M
|
|
*.processes=350
|
|
*.remote_login_passwordfile='exclusive'
|
|
*.sga_max_size=3G
|
|
*.sga_target=3G
|
|
*.undo_tablespace='TS_UNDO'
|
|
|
|
|
|
|
|
create spfile='/app/oracle/base/admin/ANDODRP/spfile/spfileANDODRP.ora' from pfile='/mnt/yavin4/tmp/_oracle_/tmp/ANDO.txt';
|
|
|
|
|
|
/mnt/yavin4/tmp/_oracle_/tmp/bakura/listener.ora
|
|
|
|
STATIC =
|
|
(DESCRIPTION_LIST =
|
|
(DESCRIPTION =
|
|
(ADDRESS = (PROTOCOL = TCP)(HOST = bakura)(PORT = 1600))
|
|
)
|
|
)
|
|
|
|
SID_LIST_STATIC =
|
|
(SID_LIST =
|
|
(SID_DESC =
|
|
(GLOBAL_DBNAME = ANDODRP_STATIC)
|
|
(SID_NAME = ANDODRP)
|
|
(ORACLE_HOME = /app/oracle/product/19)
|
|
)
|
|
)
|
|
|
|
|
|
|
|
|
|
|
|
export TNS_ADMIN=/mnt/yavin4/tmp/_oracle_/tmp/bakura
|
|
lsnrctl start STATIC
|
|
lsnrctl status STATIC
|
|
|
|
|
|
|
|
|
|
/mnt/yavin4/tmp/_oracle_/tmp/togoria/listener.ora
|
|
|
|
STATIC =
|
|
(DESCRIPTION_LIST =
|
|
(DESCRIPTION =
|
|
(ADDRESS = (PROTOCOL = TCP)(HOST = togoria)(PORT = 1600))
|
|
)
|
|
)
|
|
|
|
SID_LIST_STATIC =
|
|
(SID_LIST =
|
|
(SID_DESC =
|
|
(GLOBAL_DBNAME = ANDOPRD_STATIC)
|
|
(SID_NAME = ANDOPRD)
|
|
(ORACLE_HOME = /app/oracle/product/19)
|
|
)
|
|
)
|
|
|
|
|
|
|
|
|
|
|
|
export TNS_ADMIN=/mnt/yavin4/tmp/_oracle_/tmp/togoria
|
|
lsnrctl start STATIC
|
|
lsnrctl status STATIC
|
|
|
|
|
|
connect sys/"Secret00!"@//togoria:1600/ANDOPRD_STATIC as sysdba
|
|
connect sys/"Secret00!"@//bakura:1600/ANDODRP_STATIC as sysdba
|
|
|
|
|
|
rman target=sys/"Secret00!"@//togoria:1600/ANDOPRD_STATIC auxiliary=sys/"Secret00!"@//bakura:1600/ANDODRP_STATIC
|
|
run {
|
|
allocate channel pri1 device type DISK;
|
|
allocate channel pri2 device type DISK;
|
|
allocate channel pri3 device type DISK;
|
|
allocate channel pri4 device type DISK;
|
|
allocate auxiliary channel aux1 device type DISK;
|
|
allocate auxiliary channel aux2 device type DISK;
|
|
allocate auxiliary channel aux3 device type DISK;
|
|
allocate auxiliary channel aux4 device type DISK;
|
|
duplicate target database
|
|
for standby
|
|
dorecover
|
|
from active database
|
|
nofilenamecheck
|
|
using compressed backupset section size 1G;
|
|
}
|
|
|
|
|
|
alter system set dg_broker_config_file1='/app/oracle/base/admin/ANDOPRD/divers/dr1ANDOPRD.dat' scope=both sid='*';
|
|
alter system set dg_broker_config_file2='/app/oracle/base/admin/ANDOPRD/divers/dr2ANDOPRD.dat' scope=both sid='*';
|
|
alter system set dg_broker_start=TRUE scope=both sid='*';
|
|
|
|
alter system set dg_broker_config_file1='/app/oracle/base/admin/ANDODRP/divers/dr1ANDODRP.dat' scope=both sid='*';
|
|
alter system set dg_broker_config_file2='/app/oracle/base/admin/ANDODRP/divers/dr2ANDODRP.dat' scope=both sid='*';
|
|
alter system set dg_broker_start=TRUE scope=both sid='*';
|
|
|
|
|
|
dgmgrl
|
|
connect sys/"Secret00!"@//togoria:1600/ANDOPRD_STATIC
|
|
|
|
create configuration ANDO as
|
|
primary database is ANDOPRD
|
|
connect identifier is "//togoria:1600/ANDOPRD_STATIC";
|
|
|
|
add database ANDODRP
|
|
as connect identifier is "//bakura:1600/ANDODRP_STATIC"
|
|
maintained as physical;
|
|
|
|
enable configuration;
|
|
show configuration;
|
|
|
|
edit database 'andoprd' set property ArchiveLagTarget=0;
|
|
edit database 'andoprd' set property LogArchiveMaxProcesses=2;
|
|
edit database 'andoprd' set property LogArchiveMinSucceedDest=1;
|
|
edit database 'andoprd' set property StandbyFileManagement='AUTO';
|
|
|
|
edit database 'andodrp' set property ArchiveLagTarget=0;
|
|
edit database 'andodrp' set property LogArchiveMaxProcesses=2;
|
|
edit database 'andodrp' set property LogArchiveMinSucceedDest=1;
|
|
edit database 'andodrp' set property StandbyFileManagement='AUTO';
|
|
|
|
edit database 'andoprd' set property 'StaticConnectIdentifier'='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=togoria)(PORT=1600))(CONNECT_DATA=(SERVICE_NAME=ANDOPRD_STATIC)(SERVER=DEDICATED)))';
|
|
edit database 'andodrp' set property 'StaticConnectIdentifier'='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bakura)(PORT=1600))(CONNECT_DATA=(SERVICE_NAME=ANDODRP_STATIC)(SERVER=DEDICATED)))';
|
|
|
|
validate database 'andoprd'
|
|
validate database 'andodrp'
|
|
|
|
switchover to 'andodrp'
|
|
switchover to 'andoprd'
|
|
switchover to 'andodrp'
|
|
|
|
convert database 'andodrp' to snapshot standby;
|
|
convert database 'andodrp' to physical standby;
|
|
|
|
|
|
|
|
|
|
|
|
|