TERRAN
-------------------PRI/STB
TERRAN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.120)(PORT = 1522))
)
(CONNECT_DATA =
(SID = TERRAN)
)
)
TERRANSTB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.140)(PORT = 1522))
)
(CONNECT_DATA =
(SID = TERRAN)
)
)
--PRI---------------------------------------
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.120)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = TERRAN_DGMGRL)
(ORACLE_HOME = /data/oracle/19)
(SID_NAME = TERRAN)
(ENVS="TNS_ADMIN=/data/oracle/19/network/admin")
)
)
ADR_BASE_LISTENER = /data/oracle/19
-------PRI--------------------------------
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.140)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = TERRANSTB_DGMGRL)
(ORACLE_HOME = /data/oracle/19)
(SID_NAME = TERRAN)
(ENVS="TNS_ADMIN=/data/oracle/19/network/admin")
)
)
ADR_BASE_LISTENER = /u01/app/oracle
----PRI--------------------------------------
alter system set log_archive_config='dg_config=(TERRAN,TERRANSTB)' scope = spfile;
alter system set log_archive_dest_1='location=/data/oracledata/TERRAN/arch valid_for=(all_logfiles,primary_role)' scope = spfile;
alter system set log_archive_dest_2='service=TERRANSTB lgwr async noaffirm valid_for=(all_logfiles,primary_role) db_unique_name=TERRANSTB' scope = spfile;
alter system set log_archive_dest_state_1=enable scope = spfile;
alter system set log_archive_dest_state_2=enable scope = spfile;
alter system set remote_login_passwordfile=exclusive scope=spfile scope = spfile;
alter system set standby_file_management=auto scope = spfile;
alter system set log_archive_max_processes=10 scope = spfile;
alter system set db_unique_name=TERRAN scope=spfile scope = spfile;
alter system set fal_client=TERRAN scope = spfile;
alter system set fal_server=TERRANSTB scope = spfile;
alter system set local_listener='' scope=both;
alter system set log_file_name_convert='dummy','dummy' scope=spfile;
ALTER SYSTEM SET LOG_ARCHIVE_FORMAT='%t_%s_%r.arc' SCOPE=SPFILE;
ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 10 ('/data/oracledata/TERRAN/redo01stb.log') SIZE 209715200;
ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 11 ('/data/oracledata/TERRAN/redo02stb.log') SIZE 209715200;
ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 12 ('/data/oracledata/TERRAN/redo03stb.log') SIZE 209715200;
ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 13 ('/data/oracledata/TERRAN/redo04stb.log') SIZE 209715200;
----STB--------------------------------------
mkdir -p /data/oracledata/TERRAN
mkdir -p /data/oracledata/TERRAN/arch
mkdir -p /data/oracledata/TERRAN/flash
mkdir -p /data/oracle/admin/TERRAN/adump
mkdir -p /data/oracle/admin/TERRAN/bdump
mkdir -p /data/oracle/admin/TERRAN/dpdump
mkdir -p /data/oracle/admin/TERRAN/pfile
orapwd file=/data/oracle/12/dbs/orapwTERRAN password=xxxxx. entries=10
echo "*.db_name='TERRAN'" > /home/oracle/init_stby.ora
STARTUP NOMOUNT PFILE='/home/oracle/init_stby.ora';
----PRI RMAN-----------------------------------------
rman TARGET sys/xxxxx.@TERRAN AUXILIARY sys/xxxxxx.@TERRANSTB
DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE DORECOVER SPFILE SET db_unique_name='TERRANSTB' COMMENT 'Is standby' NOFILENAMECHECK;
----STB-----------------------------------------
sqlplus / as sysdba
shu abort
startup
alter system set fal_client=TERRANSTB;
alter system set fal_server=TERRAN;
---poprawiany redo logi bez tego arch sie nie applajuja
c2_32005.trc:
ORA-00313: open failed for members of log group 13 of thread 1
ORA-00312: online log 13 thread 1: '/data/oracledata/TERRAN/redo04stb.log'
ORA-27037: unable to obtain file status
---poprawiany redo logi bez tego arch sie nie applajuja
select * from v$logfile;
alter system set standby_file_management=manual;
alter database clear logfile group 1;
alter database clear logfile group 2;
alter database clear logfile group 3;
alter database drop standby logfile group 10;
alter database drop standby logfile group 11;
alter database drop standby logfile group 12;
alter database drop standby logfile group 13;
ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 10 ('/data/oracledata/TERRAN/redo01stb.log') SIZE 209715200;
ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 11 ('/data/oracledata/TERRAN/redo02stb.log') SIZE 209715200;
ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 12 ('/data/oracledata/TERRAN/redo03stb.log') SIZE 209715200;
ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 13 ('/data/oracledata/TERRAN/redo04stb.log') SIZE 209715200;
alter system set standby_file_management=auto;
To enable the real-time apply feature on physical standby database , issue the following sql statement, (Active Data guard option is licensed)
alter database recover managed standby database disconnect from session;
Disable
alter database recover managed standby database cancel;
alter database recover managed standby database disconnect;
---
zeby archy na STB nie ladowal
alter system set LOG_ARCHIVE_DEST_1='LOCATION=/data/oracledata/TERRAN/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=TERRANSTB' scope = spfile;
----PRI-----------------------------------------
ALTER SYSTEM SET dg_broker_start=true;
-------------TIPS------------------------------
create user psp3 identified by xxxxxx;
select * from dba_users;
alter system switch logfile;
select max(sequence#) from v$thread;
select message from v$DATAGUARD_STATUS;
select name, open_mode, database_role, INSTANCE_NAME from v$database,v$instance;
SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE;
SELECT * FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
Switching a physical standby database to read only and vice versa
From standby to read only
alter database recover managed standby database cancel;
alter database open read only;
From read only to standby
alter database recover managed standby database disconnect from session;