Oracle 12cR2 | Oracle Data Guard Physical Standby | Active Database Duplication | Data Guard Setup! - High Level Steps Explored!
Oracle Data Guard Physical Standby Configuration on Oracle 12.2.0.1:
==================================================
Hi DBA Connections,
Today I have tested in my lab, Oracle 12.2.0.1 CDB+PDB database Physical Standby (Data Guard Setup).
In this video, I have demonstrated Oracle 12.2.0.1 database Physical Standby Configuration and creation.
There are various steps in which you can configure physical standby database. We need to make several changes to the primary database before we can even setup the standby database.
My Lab Configuration overview:
------------------------------
Primary details:
----------------
SID: SRCDB1
DB_UNIQUE_NAME: SRCDB1
ORACLE_HOME: /u01/app/oracle/product/12.2.0.1/db_2
Host Name: srlabprmy.localdomain(192.168.58.201)
Port: 1521
Standby details:
----------------
SID: SRCDB1
DB_UNIQUE_NAME: SRCDB1SBY
ORACLE_HOME: /u01/app/oracle/product/12.2.0.1/db_2
Host Name: srlabsby.localdomain(192.168.58.202)
Port: 1521
Assumption:
-----------
we assume that primary server has a database (SID=SRCDB1) up and running. The standby database has Oracle 12cR2 installation done in the same oracle home location as primary.
Primary database changes:
-------------------------
Primary must run in archive log mode. Check the archive log mode
SQL> archive log list or select log_mode from v$database;
If it is not running in archive log mode, then enable it
SQL> shutdown immediate
SQL> startup mount
SQL> alter database archivelog;
SQL> alter database open;
SQL> archive log list;
Note: In our case my database is running archive log mode already been enabled.
Enable force logging on primary:
--------------------------------
In oracle, users can restrict redo generation for SQL by using NOLOGGING clause. This NOLOGGING transaction will be a problem for physical standby. Hence, we force logging so even user uses NOLOGGING clause, every SQL will be logged on to redo.
SQL> alter database force logging;
SQL> select name, force_logging from v$database;
Standby file management:
------------------------
We need to make sure whenever we add/drop datafile in primary database, those files are also added / dropped on standby
SQL> alter system set standby_file_management = 'AUTO';
Create standby log files:
-------------------------
You must create standby log files on primary. These files are used by a standby database to store redo it receives from primary database.
Our primary may become standby later and we would need them, so better to create it. First check the current log groups:
SQL> select GROUP#, THREAD#, bytes/1024/1024, MEMBERS, STATUS from v$log;
SQL> select member from v$logfile;
Add the standby logfiles, make sure group number should be from a different series like in this case we choose to start with 11 and above. This helps in easy differentiation.
Make sure to keep the thread# and logfile size exactly same. Oracle also recommends to always create n+1 standby log files. Where n is the total number of logfiles
— Create:
ALTER DATABASE ADD STANDBY LOGFILE '/u02/oradata/SRCDB1/redosby01.log' size 209715200;
ALTER DATABASE ADD STANDBY LOGFILE '/u02/oradata/SRCDB1/redosby02.log' size 209715200;
ALTER DATABASE ADD STANDBY LOGFILE '/u02/oradata/SRCDB1/redosby03.log' size 209715200;
ALTER DATABASE ADD STANDBY LOGFILE '/u02/oradata/SRCDB1/redosby04.log' size 209715200;
Check the standby log files via below query:
--------------------------------------------
SELECT GROUP#,THREAD#,SEQUENCE#,ARCHIVED,STATUS FROM V$STANDBY_LOG;
SELECT group#, type, member FROM v$logfile WHERE type = 'STANDBY' order by group#;
column DBID format a20
SELECT group#, dbid, thread#, sequence#, status FROM v$standby_log;
Enable flashback on primary:
----------------------------
Flashback database is highly recommended because in case of failover, you need not re-create primary database from scratch.
SQL> alter system set db_recovery_file_dest_size=15g;
SQL> alter database flashback on;
SQL> select flashback_on from v$database;
If flashback parameters are not set properly, use below commands
SQL> show parameter recovery;
SQL> alter system set db_recovery_file_dest='/u02/fra';
SQL> alter system set db_recovery_file_dest_size=15g;
SQL> alter database flashback on;
Check DB Unique name parameter on primary:
Make sure your primary database has DB_UNIQUE_NAME parameter set for consistency. If it’s not set properly, use ALTER SYSTEM SET command
SQL> show parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- -------------
db_name string SRCDB1
SQL> show parameter db_unique_name
NAME TYPE VALUE
------------------------------------ ----------- -------------
db_unique_name string SRCDB1
Create password file for standby:
---------------------------------
This is needed for cloning purpose. Even if there is one password file in $ORACLE_HOME/dbs location, create a new one with standby SID
$ orapwd file=$ORACLE_HOME/dbs/orapwSRCDB1 password=ora$123 entries=10 force=y
$ scp orapwSRCDB1 oracle@srlabsby:$ORACLE_HOME/dbs/orapwSRCDB1SBY or orapwd file=$ORACLE_HOME/dbs/orapwSRCDB1SBY password=ora$123 entries=10 force=y
Configure network:
------------------
Use below tns entries and put them under ORACLE user $ORACLE_HOME/network/admin/tnsnames.ora. Change host as per your environment and execute on both primary and standby.
Notice the use of the SID, rather than the SERVICE_NAME in the entries. This is important as the broker will need to connect to the databases when they are down, so the services will not be present.
vi $ORACLE_HOME/network/admin/tnsnames.ora
#Primary
SRCDB1PRMY =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.58.201)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SRCDB1)
)
)
SRDBPLUG =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.58.201)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SRCDB1)
)
)
SRCDB1SBY =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.58.202)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SRCDB1SBY)
(UR=A)
)
)
LISTENER_SRCDB1 =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.58.201)(PORT = 1521))
Configure listener on primary database. Since the broker will need to connect to the database when it’s down, we can’t rely on auto-registration with the listener, hence the explicit entry for the database.
[oracle@srlabprmy admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/12.2.0.1/db_2/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER_SRCDB1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.58.201)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = SRCDB1)
(ORACLE_HOME = /u01/app/oracle/product/12.2.0.1/db_2)
(SID_NAME = SRCDB1)
)
)
ADR_BASE_LISTENER = /u01/app/oracle
Configure listener on standby. Since the broker will need to connect to the database when it’s down, we can’t rely on auto-registration with the listener, hence the explicit entry for the database.
vi $ORACLE_HOME/network/admin/listener.ora
LISTENER_SRCDB1SBY =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.58.202)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = SRCDB1)
(ORACLE_HOME = /u01/app/oracle/product/12.2.0.1/db_2)
(SID_NAME = SRCDB1)
)
)
ADR_BASE_LISTENER = /u01/app/oracle
Once the listener.ora changes are in place, restart the listener on both servers
Configure redo transport:
-------------------------
Note: if you plan to use Oracle Data Guard broker, then you can skip this section “configure redo transport” and jump to “Build Standby” section.
Configure redo transport from primary to standby:
-------------------------------------------------
The below statement says that if the current database is in primary role, then transport logs to standby. We need to change service and db_unique_name for same parameter on standby server
On Primary Server
=================
SQL> alter system set log_archive_dest_2 = 'service=SRCDB1SBY async valid_for=(online_logfiles,primary_role) db_unique_name=SRCDB1SBY';
Setup FAL (Fetch Archive Log) server:
-------------------------------------
This parameters tell the primary as to where it will get archives from (FAL Server=SRCDB1SBY)
On Primary Server
=================
SQL> alter system set fal_server = 'SRCDB1SBY';
Setup Data Guard configuration on primary:
------------------------------------------
This parameter will let primary database know which databases are in data guard configuration.
On Primary Server
=================
SQL> alter system set log_archive_config = 'dg_config=(SRCDB1,SRCDB1SBY)';
Build standby:
--------------
On standby server, create parameter file with below contents
On standby server
=================
[oracle@srlabsby dbs]$ vi initSRCDB1.ora
*.db_name='SRCDB1'
Create pfile on primary, open it and create the necessary directories on the standby server
On Primary Server
=================
SQL> create pfile='/home/oracle/scripts/initSRCDB1.ora from spfile;
$ cd $ORACLE_HOME/dbs
$ cat initSRCDB1.ora
On Standby Server
=================
on standby, create directories as you find in the initSRCDB1.ora file
mkdir -p /u01/app/oracle/admin/SRCDB1/adump
mkdir -p /u02/oradata/SRCDB1
mkdir -p /u02/fra/SRCDB1
Start the auxiliary instance on the standby server by starting it using the temporary “init.ora” file
On Standby Server
=================
$ export ORACLE_SID=SRCDB1
$ sqlplus / as sysdba
SQL> STARTUP NOMOUNT PFILE='/u01/app/oracle/product/12.2.0.1/db_2/dbs/initSRCDB1SBY.ora';
SQL> exit;
--you must exit from sqlplus, else cloning will fail
Duplicate primary database via RMAN: In this step, we will use RMAN to duplicate primary database for our standby database.
On primary, connect to RMAN, specifying a full connect string for both the TARGET and AUXILIARY instances. Do not attempt to use OS authentication or the database cloning will fail
On primary server
=================
$ rman
RMAN> connect target sys/ora$1234@SRCDB1PRMY;
RMAN> connect auxiliary sys/ora$1234@SRCDB1;
RMAN> DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE DORECOVER SPFILE SET db_unique_name='SRCDB1SBY' COMMENT 'Is standby' NOFILENAMECHECK;
Once cloning is done, you should see below at RMAN prompt.
Set Standby Parameters:
-----------------------
We need to make some changes to standby parameters that will enable log shipping to the current primary (SRCDB1) when a switchover happens
On Standby Server
=================
SQL> create pfile from spfile;
$ cd $ORACLE_HOME/dbs
$ vi initSRCDB1.ora
--change
*.fal_server='SRCDB1SBY'
--to
*.fal_server='SRCDB1'
--change
*.log_archive_dest_2='service=SRCDB1SBY async valid_for=(online_logfiles,primary_role) db_unique_name=SRCDB1SBY'
--to
*.log_archive_dest_2='service=SRCDB1 async valid_for=(online_logfiles,primary_role) db_unique_name=SRCDB1'
Now re-create spfile for standby using the pfile you just modified
On Standby Server
=================
SQL> create spfile from pfile;
SQL> shut immediate;
SQL> startup mount;
SQL> show parameter spfile;
Enable flashback on standby: As we know the importance of flashback in data guard, we must enable it on standby as well
On Standby Server
=================
SQL> alter database flashback on;
Verify standby configuration
Once MRP is started, we must verify if our setup is working fine
On standby:
===========
--start MRP command
SQL> alter database recover managed standby database disconnect;
SELECT NAME, DATABASE_ROLE, OPEN_MODE FROM V$DATABASE;
–Run the following command to stop the recovery process (MRP)
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
–Run the following command to start the recovery process (MRP) which will include the current log-file
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
–To see the status run the following SQL statement.
SELECT PROCESS, CLIENT_PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;
On both primary & standby:
==========================
set lines 999;
select * from v$dataguard_status order by timestamp;
select dest_id, status, destination, error from v$archive_dest where dest_id<=2;
IF you see any ORA error like ORA-16058, do this on primary:
============================================================
SQL> alter system set log_archive_dest_state_2='DEFER';
SQL> alter system set log_archive_dest_state_2='ENABLE';
SQL> select dest_id, status, destination, error from v$archive_dest where dest_id<=2;
On primary:
===========
select sequence#, first_time, next_time, applied, archived from v$archived_log where name = 'SRCDB1SBY' order by first_time;
select STATUS, GAP_STATUS from V$ARCHIVE_DEST_STATUS where DEST_ID = 2;
archive log list;
On standby:
===========
select process, status, sequence# from v$managed_standby;
select sequence#, applied, first_time, next_time, name filename from v$archived_log order by sequence#;
Configure Archive deletion policy: We must set this policy in order to prevent accidental deletion of archive logs on primary database
On Primary:
===========
rman target /
configure archivelog deletion policy to applied on all standby;
-- On Primary and Standby
SQL> alter system set redo_transport_user='C##DBIDG';
System altered.
Activity Log:
Primary Database:
----------------------
SQL> alter user sys identified by ora$1234;
User altered.
[oracle@srlabprmy db_2]$ cd dbs
[oracle@srlabprmy dbs]$ ls -lrt
total 18308
-rw-r--r--. 1 oracle oinstall 3079 May 15 2015 init.ora
-rw-r-----. 1 oracle oinstall 24 Jul 19 03:08 lkSRCDB1
-rw-rw----. 1 oracle oinstall 1544 Jul 26 03:20 hc_SRCDB1.dat
-rw-r-----. 1 oracle oinstall 18726912 Jul 26 04:10 snapcf_SRCDB1.f
-rw-r-----. 1 oracle oinstall 3584 Jul 26 06:04 spfileSRCDB1.ora
-rw-r-----. 1 oracle oinstall 4096 Jul 26 06:25 orapwSRCDB1
[oracle@srlabprmy dbs]$
[oracle@srlabprmy dbs]$ mv orapwSRCDB1 orapwSRCDB1_bkp
[oracle@srlabprmy dbs]$
[oracle@srlabprmy dbs]$ orapwd file=$ORACLE_HOME/dbs/orapwSRCDB1 entries=10 force=y
Enter password for SYS:
[oracle@srlabprmy dbs]$
[oracle@srlabprmy dbs]$ ls -lrt
total 18316
-rw-r--r--. 1 oracle oinstall 3079 May 15 2015 init.ora
-rw-r-----. 1 oracle oinstall 24 Jul 19 03:08 lkSRCDB1
-rw-rw----. 1 oracle oinstall 1544 Jul 26 03:20 hc_SRCDB1.dat
-rw-r-----. 1 oracle oinstall 18726912 Jul 26 04:10 snapcf_SRCDB1.f
-rw-r-----. 1 oracle oinstall 3584 Jul 26 06:04 spfileSRCDB1.ora
-rw-r-----. 1 oracle oinstall 4096 Jul 26 06:25 orapwSRCDB1_bkp
-rw-r-----. 1 oracle oinstall 6144 Jul 26 06:33 orapwSRCDB1
[oracle@srlabprmy dbs]$
[oracle@srlabprmy dbs]$ rman
Recovery Manager: Release 12.2.0.1.0 - Production on Sun Jul 26 06:33:38 2020
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target sys/ora$1234@SRCDB1PRMY;
connected to target database: SRCDB1 (DBID=797033739)
RMAN> connect auxiliary sys/ora$1234@SRCDB1;
connected to auxiliary database: SRCDB1 (not mounted)
RMAN> DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE DORECOVER SPFILE SET db_unique_name='SRCDB1SBY' COMMENT 'Is standby' NOFILENAMECHECK;
Starting Duplicate Db at 26-JUL-20
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=179 device type=DISK
current log archived
contents of Memory Script:
{
backup as copy reuse
targetfile '/u01/app/oracle/product/12.2.0.1/db_2/dbs/orapwSRCDB1' auxiliary format
'/u01/app/oracle/product/12.2.0.1/db_2/dbs/orapwSRCDB1' ;
restore clone from service 'SRCDB1PRMY' spfile to
'/u01/app/oracle/product/12.2.0.1/db_2/dbs/spfileSRCDB1.ora';
sql clone "alter system set spfile= ''/u01/app/oracle/product/12.2.0.1/db_2/dbs/spfileSRCDB1.ora''";
}
executing Memory Script
Starting backup at 26-JUL-20
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=252 device type=DISK
Finished backup at 26-JUL-20
Starting restore at 26-JUL-20
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service SRCDB1PRMY
channel ORA_AUX_DISK_1: restoring SPFILE
output file name=/u01/app/oracle/product/12.2.0.1/db_2/dbs/spfileSRCDB1.ora
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
Finished restore at 26-JUL-20
sql statement: alter system set spfile= ''/u01/app/oracle/product/12.2.0.1/db_2/dbs/spfileSRCDB1.ora''
contents of Memory Script:
{
sql clone "alter system set db_unique_name =
''SRCDB1SBY'' comment=
''Is standby'' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system set db_unique_name = ''SRCDB1SBY'' comment= ''Is standby'' scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 1593835520 bytes
Fixed Size 8793256 bytes
Variable Size 1023411032 bytes
Database Buffers 553648128 bytes
Redo Buffers 7983104 bytes
contents of Memory Script:
{
restore clone from service 'SRCDB1PRMY' standby controlfile;
}
executing Memory Script
Starting restore at 26-JUL-20
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=254 device type=DISK
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service SRCDB1PRMY
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:04
output file name=/u02/oradata/SRCDB1/control01.ctl
output file name=/u02/fra/SRCDB1/control02.ctl
Finished restore at 26-JUL-20
contents of Memory Script:
{
sql clone 'alter database mount standby database';
}
executing Memory Script
sql statement: alter database mount standby database
RMAN-05538: warning: implicitly using DB_FILE_NAME_CONVERT
contents of Memory Script:
{
set newname for tempfile 1 to
"/u02/oradata/SRCDB1/temp01.dbf";
set newname for tempfile 2 to
"/u02/oradata/SRCDB1/pdbseed/temp012020-07-19_03-15-34-672-AM.dbf";
set newname for tempfile 3 to
"/u02/oradata/SRCDB1/SRDBPLUG/temp01.dbf";
switch clone tempfile all;
set newname for datafile 1 to
"/u02/oradata/SRCDB1/system01.dbf";
set newname for datafile 3 to
"/u02/oradata/SRCDB1/sysaux01.dbf";
set newname for datafile 4 to
"/u02/oradata/SRCDB1/undotbs01.dbf";
set newname for datafile 5 to
"/u02/oradata/SRCDB1/pdbseed/system01.dbf";
set newname for datafile 6 to
"/u02/oradata/SRCDB1/pdbseed/sysaux01.dbf";
set newname for datafile 7 to
"/u02/oradata/SRCDB1/users01.dbf";
set newname for datafile 8 to
"/u02/oradata/SRCDB1/pdbseed/undotbs01.dbf";
set newname for datafile 9 to
"/u02/oradata/SRCDB1/SRDBPLUG/system01.dbf";
set newname for datafile 10 to
"/u02/oradata/SRCDB1/SRDBPLUG/sysaux01.dbf";
set newname for datafile 11 to
"/u02/oradata/SRCDB1/SRDBPLUG/undotbs01.dbf";
set newname for datafile 12 to
"/u02/oradata/SRCDB1/SRDBPLUG/users01.dbf";
restore
from nonsparse from service
'SRCDB1PRMY' clone database
;
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
renamed tempfile 1 to /u02/oradata/SRCDB1/temp01.dbf in control file
renamed tempfile 2 to /u02/oradata/SRCDB1/pdbseed/temp012020-07-19_03-15-34-672-AM.dbf in control file
renamed tempfile 3 to /u02/oradata/SRCDB1/SRDBPLUG/temp01.dbf in control file
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 26-JUL-20
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service SRCDB1PRMY
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /u02/oradata/SRCDB1/system01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:46
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service SRCDB1PRMY
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00003 to /u02/oradata/SRCDB1/sysaux01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:36
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service SRCDB1PRMY
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00004 to /u02/oradata/SRCDB1/undotbs01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service SRCDB1PRMY
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00005 to /u02/oradata/SRCDB1/pdbseed/system01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:15
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service SRCDB1PRMY
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00006 to /u02/oradata/SRCDB1/pdbseed/sysaux01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:16
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service SRCDB1PRMY
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00007 to /u02/oradata/SRCDB1/users01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service SRCDB1PRMY
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00008 to /u02/oradata/SRCDB1/pdbseed/undotbs01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service SRCDB1PRMY
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00009 to /u02/oradata/SRCDB1/SRDBPLUG/system01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:16
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service SRCDB1PRMY
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00010 to /u02/oradata/SRCDB1/SRDBPLUG/sysaux01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:25
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service SRCDB1PRMY
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00011 to /u02/oradata/SRCDB1/SRDBPLUG/undotbs01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service SRCDB1PRMY
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00012 to /u02/oradata/SRCDB1/SRDBPLUG/users01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 26-JUL-20
sql statement: alter system archive log current
current log archived
contents of Memory Script:
{
restore clone force from service 'SRCDB1PRMY'
archivelog from scn 2657276;
switch clone datafile all;
}
executing Memory Script
Starting restore at 26-JUL-20
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service SRCDB1PRMY
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=10
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service SRCDB1PRMY
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=11
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 26-JUL-20
datafile 1 switched to datafile copy
input datafile copy RECID=4 STAMP=1046759901 file name=/u02/oradata/SRCDB1/system01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=5 STAMP=1046759901 file name=/u02/oradata/SRCDB1/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=6 STAMP=1046759901 file name=/u02/oradata/SRCDB1/undotbs01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=7 STAMP=1046759901 file name=/u02/oradata/SRCDB1/pdbseed/system01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=8 STAMP=1046759901 file name=/u02/oradata/SRCDB1/pdbseed/sysaux01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=9 STAMP=1046759901 file name=/u02/oradata/SRCDB1/users01.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=10 STAMP=1046759901 file name=/u02/oradata/SRCDB1/pdbseed/undotbs01.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=11 STAMP=1046759901 file name=/u02/oradata/SRCDB1/SRDBPLUG/system01.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=12 STAMP=1046759901 file name=/u02/oradata/SRCDB1/SRDBPLUG/sysaux01.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=13 STAMP=1046759901 file name=/u02/oradata/SRCDB1/SRDBPLUG/undotbs01.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=14 STAMP=1046759901 file name=/u02/oradata/SRCDB1/SRDBPLUG/users01.dbf
contents of Memory Script:
{
set until scn 2658712;
recover
standby
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 26-JUL-20
using channel ORA_AUX_DISK_1
starting media recovery
archived log for thread 1 with sequence 10 is already on disk as file /u01/app/oracle/product/12.2.0.1/db_2/dbs/arch1_10_1046142798.dbf
archived log for thread 1 with sequence 11 is already on disk as file /u01/app/oracle/product/12.2.0.1/db_2/dbs/arch1_11_1046142798.dbf
archived log file name=/u01/app/oracle/product/12.2.0.1/db_2/dbs/arch1_10_1046142798.dbf thread=1 sequence=10
archived log file name=/u01/app/oracle/product/12.2.0.1/db_2/dbs/arch1_11_1046142798.dbf thread=1 sequence=11
media recovery complete, elapsed time: 00:00:02
Finished recover at 26-JUL-20
Finished Duplicate Db at 26-JUL-20
RMAN> exit
Recovery Manager complete.
[oracle@srlabprmy dbs]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sun Jul 26 06:52:35 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
SRCDB1
SQL> alter system set log_archive_dest_state_2='DEFER';
System altered.
SQL> alter system set log_archive_dest_state_2='ENABLE';
System altered.
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u02/archive
Oldest online log sequence 13
Next log sequence to archive 15
Current log sequence 15
SQL>
SQL> select sequence#, first_time, next_time, applied, archived from v$archived_log where name = 'SRCDB1SBY' order by first_time;
no rows selected
SQL> select sequence#, first_time, next_time, applied, archived from v$archived_log where name = 'SRCDB1' order by first_time;
no rows selected
SQL> select sequence#, first_time, next_time, applied, archived from v$archived_log;
SEQUENCE# FIRST_TIM NEXT_TIME APPLIED ARC
---------- --------- --------- --------- ---
2 19-JUL-20 19-JUL-20 NO YES
3 19-JUL-20 19-JUL-20 NO YES
4 19-JUL-20 19-JUL-20 NO YES
5 19-JUL-20 25-JUL-20 NO YES
6 25-JUL-20 25-JUL-20 NO YES
7 25-JUL-20 26-JUL-20 NO YES
8 26-JUL-20 26-JUL-20 NO YES
9 26-JUL-20 26-JUL-20 NO YES
10 26-JUL-20 26-JUL-20 NO YES
11 26-JUL-20 26-JUL-20 NO YES
12 26-JUL-20 26-JUL-20 NO YES
SEQUENCE# FIRST_TIM NEXT_TIME APPLIED ARC
---------- --------- --------- --------- ---
13 26-JUL-20 26-JUL-20 NO YES
14 26-JUL-20 26-JUL-20 NO YES
13 rows selected.
SQL> select STATUS, GAP_STATUS from V$ARCHIVE_DEST_STATUS where DEST_ID = 2;
STATUS GAP_STATUS
--------- ------------------------
ERROR RESOLVABLE GAP
SQL> alter system set log_archive_dest_state_1='DEFER';
alter system set log_archive_dest_state_1='DEFER'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16028: new LOG_ARCHIVE_DEST_STATE_1 causes less destinations than
LOG_ARCHIVE_MIN_SUCCEED_DEST requires
SQL> sho parameter log_archive_dest_state_1
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_11 string enable
log_archive_dest_state_12 string enable
log_archive_dest_state_13 string enable
log_archive_dest_state_14 string enable
log_archive_dest_state_15 string enable
log_archive_dest_state_16 string enable
log_archive_dest_state_17 string enable
log_archive_dest_state_18 string enable
log_archive_dest_state_19 string enable
SQL> select name from V$PWFILE_USERS ;
select name from V$PWFILE_USERS
*
ERROR at line 1:
ORA-00904: "NAME": invalid identifier
SQL> select username from V$PWFILE_USERS ;
USERNAME
--------------------------------------------------------------------------------
SYS
SQL> create user C##DBIDG identified by manager;
User created.
SQL> grant connect,resource to C##DBIDG;
Grant succeeded.
SQL> grant sysoper to C##DBIDG;
Grant succeeded.
SQL> select username from V$PWFILE_USERS ;
USERNAME
--------------------------------------------------------------------------------
SYS
C##DBIDG
SQL> select USERNAME, SYSDBA, SYSOPER, SYSBACKUP, SYSDG, SYSKM from V$PWFILE_USERS where USERNAME ='C##DBIDG';
USERNAME
--------------------------------------------------------------------------------
SYSDB SYSOP SYSBA SYSDG SYSKM
----- ----- ----- ----- -----
C##DBIDG
FALSE TRUE FALSE FALSE FALSE
SQL> alter system set redo_transport_user='C##DBIDG';
System altered.
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> alter system set log_archive_dest_state_2='DEFER';
System altered.
SQL> alter system set log_archive_dest_state_2='ENABLE';
System altered.
SQL> show parameter log_archive
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_config string DG_CONFIG=(SRCDB1,SRCDB1SBY)
log_archive_dest string
log_archive_dest_1 string LOCATION=/u02/archive VALID_F
OR=(ALL_LOGFILES,ALL_ROLES) DB
_UNIQUE_NAME=SRCDB1
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
log_archive_dest_2 string service=SRCDB1SBY async valid_
for=(online_logfiles,primary_r
ole) db_unique_name=SRCDB1SBY
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
log_archive_dest_23 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string
log_archive_dest_27 string
log_archive_dest_28 string
log_archive_dest_29 string
log_archive_dest_3 string
log_archive_dest_30 string
log_archive_dest_31 string
log_archive_dest_4 string
log_archive_dest_5 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_11 string enable
log_archive_dest_state_12 string enable
log_archive_dest_state_13 string enable
log_archive_dest_state_14 string enable
log_archive_dest_state_15 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_16 string enable
log_archive_dest_state_17 string enable
log_archive_dest_state_18 string enable
log_archive_dest_state_19 string enable
log_archive_dest_state_2 string ENABLE
log_archive_dest_state_20 string enable
log_archive_dest_state_21 string enable
log_archive_dest_state_22 string enable
log_archive_dest_state_23 string enable
log_archive_dest_state_24 string enable
log_archive_dest_state_25 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_26 string enable
log_archive_dest_state_27 string enable
log_archive_dest_state_28 string enable
log_archive_dest_state_29 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_30 string enable
log_archive_dest_state_31 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_max_processes integer 4
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
SQL> alter user sys identified by dba$12345;
User altered.
SQL> alter system switch logfile;
System altered.
SQL> alter system set log_archive_dest_2='service=SRCDB1 async valid_for=(online_logfiles,primary_role) db_unique_name=SRCDB1' scope=both;
System altered.
SQL> alter system set log_archive_dest_state_2='DEFER';
System altered.
SQL> alter system set log_archive_dest_state_2='ENABLE';
System altered.
SQL> select max(sequence#) from v$archived_log;
MAX(SEQUENCE#)
--------------
19
SQL> show parameter LOG_ARCHIVE_DEST_2
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string service=SRCDB1 async valid_for
=(online_logfiles,primary_role
) db_unique_name=SRCDB1
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
log_archive_dest_23 string
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string
log_archive_dest_27 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_28 string
log_archive_dest_29 string
SQL> alter system set log_archive_dest_2='service=SRCDB1SBY async valid_for=(online_logfiles,primary_role) db_unique_name=SRCDB1SBY' scope=both;
System altered.
SQL>
SQL>
SQL> alter system switch logfile;
System altered.
SQL> alter system set log_archive_dest_state_2='DEFER';
System altered.
SQL> alter system set log_archive_dest_state_2='ENABLE';
System altered.
SQL> alter system switch logfile;
System altered.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u02/archive
Oldest online log sequence 21
Next log sequence to archive 23
Current log sequence 23
SQL>
Standby Database Log:
--------------------
TNSLSNR for Linux: Version 12.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/12.2.0.1/db_2/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/srlabsby/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srlabsby)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 26-JUL-2020 06:14:35
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0.1/db_2/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/srlabsby/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srlabsby)(PORT=1521)))
Services Summary...
Service "SRCDB1" has 1 instance(s).
Instance "SRCDB1", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>
LSNRCTL> exit
[oracle@srlabsby admin]$
[oracle@srlabsby admin]$ clear
[oracle@srlabsby admin]$ ps -ef |grep pmon
oracle 22665 1 0 06:05 ? 00:00:00 ora_pmon_SRCDB1SBY
oracle 23348 6287 0 06:15 pts/0 00:00:00 grep --color=auto pmon
[oracle@srlabsby admin]$ ps -ef |grep tns
root 19 2 0 00:39 ? 00:00:00 [netns]
oracle 23312 1 0 06:14 ? 00:00:00 /u01/app/oracle/product/12.2.0.1/db_2/bin/tnslsnr LISTENER -inherit
oracle 23354 6287 0 06:15 pts/0 00:00:00 grep --color=auto tns
[oracle@srlabsby admin]$ lsnrctl status
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 26-JUL-2020 06:17:48
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 26-JUL-2020 06:14:35
Uptime 0 days 0 hr. 3 min. 13 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0.1/db_2/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/srlabsby/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srlabsby)(PORT=1521)))
Services Summary...
Service "SRCDB1" has 2 instance(s).
Instance "SRCDB1", status UNKNOWN, has 1 handler(s) for this service...
Instance "SRCDB1SBY", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
[oracle@srlabsby admin]$
[oracle@srlabsby admin]$
[oracle@srlabsby admin]$ ps -ef |grep tns
root 19 2 0 00:39 ? 00:00:00 [netns]
oracle 23312 1 0 06:14 ? 00:00:00 /u01/app/oracle/product/12.2.0.1/db_2/bin/tnslsnr LISTENER -inherit
oracle 23519 6287 0 06:18 pts/0 00:00:00 grep --color=auto tns
[oracle@srlabsby admin]$ ps -ef |grep pmon
oracle 22665 1 0 06:05 ? 00:00:00 ora_pmon_SRCDB1SBY
oracle 23535 6287 0 06:18 pts/0 00:00:00 grep --color=auto pmon
[oracle@srlabsby admin]$
[oracle@srlabsby admin]$ kill -9 22665
[oracle@srlabsby admin]$
[oracle@srlabsby admin]$ ps -ef |grep pmon
oracle 23553 6287 0 06:18 pts/0 00:00:00 grep --color=auto pmon
[oracle@srlabsby admin]$ export ORACLE_SID=SRCDB1
[oracle@srlabsby admin]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sun Jul 26 06:18:54 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile='/u01/app/oracle/product/12.2.0.1/db_2/dbs/initSRCDB1SBY.ora';
ORACLE instance started.
Total System Global Area 268435456 bytes
Fixed Size 8619496 bytes
Variable Size 201329176 bytes
Database Buffers 50331648 bytes
Redo Buffers 8155136 bytes
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@srlabsby admin]$ lsnrctl
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 26-JUL-2020 06:19:50
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 26-JUL-2020 06:14:35
Uptime 0 days 0 hr. 5 min. 16 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0.1/db_2/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/srlabsby/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srlabsby)(PORT=1521)))
Services Summary...
Service "SRCDB1" has 2 instance(s).
Instance "SRCDB1", status UNKNOWN, has 1 handler(s) for this service...
Instance "SRCDB1", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> ^[[A ". Try "help"
LSNRCTL> undefined command "
LSNRCTL>
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 26-JUL-2020 06:14:35
Uptime 0 days 0 hr. 5 min. 34 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0.1/db_2/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/srlabsby/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srlabsby)(PORT=1521)))
Services Summary...
Service "SRCDB1" has 2 instance(s).
Instance "SRCDB1", status UNKNOWN, has 1 handler(s) for this service...
Instance "SRCDB1", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>
LSNRCTL> exit
[oracle@srlabsby admin]$
[oracle@srlabsby admin]$
[oracle@srlabsby admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.2.0.1/db_2/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
SRCDB1PRMY =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.58.201)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SRCDB1)
)
)
SRDBPLUG =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.58.201)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SRCDB1)
)
)
SRCDB1SBY =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.58.202)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SRCDB1)
(UR=A)
)
)
LISTENER_SRCDB1SBY =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.58.202)(PORT = 1521))
[oracle@srlabsby admin]$ vi tnsnames.ora
[oracle@srlabsby admin]$
[oracle@srlabsby admin]$
[oracle@srlabsby admin]$ lsnrctl
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 26-JUL-2020 06:21:33
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 26-JUL-2020 06:14:35
Uptime 0 days 0 hr. 6 min. 59 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0.1/db_2/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/srlabsby/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srlabsby)(PORT=1521)))
Services Summary...
Service "SRCDB1" has 2 instance(s).
Instance "SRCDB1", status UNKNOWN, has 1 handler(s) for this service...
Instance "SRCDB1", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>
LSNRCTL> stop
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The command completed successfully
LSNRCTL> start
Starting /u01/app/oracle/product/12.2.0.1/db_2/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 12.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/12.2.0.1/db_2/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/srlabsby/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srlabsby)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 26-JUL-2020 06:21:42
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0.1/db_2/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/srlabsby/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srlabsby)(PORT=1521)))
Services Summary...
Service "SRCDB1" has 1 instance(s).
Instance "SRCDB1", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 26-JUL-2020 06:21:42
Uptime 0 days 0 hr. 0 min. 3 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0.1/db_2/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/srlabsby/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srlabsby)(PORT=1521)))
Services Summary...
Service "SRCDB1" has 1 instance(s).
Instance "SRCDB1", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 26-JUL-2020 06:21:42
Uptime 0 days 0 hr. 0 min. 5 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0.1/db_2/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/srlabsby/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srlabsby)(PORT=1521)))
Services Summary...
Service "SRCDB1" has 1 instance(s).
Instance "SRCDB1", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 26-JUL-2020 06:21:42
Uptime 0 days 0 hr. 1 min. 8 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0.1/db_2/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/srlabsby/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srlabsby)(PORT=1521)))
Services Summary...
Service "SRCDB1" has 2 instance(s).
Instance "SRCDB1", status UNKNOWN, has 1 handler(s) for this service...
Instance "SRCDB1", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>
LSNRCTL>
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 26-JUL-2020 06:21:42
Uptime 0 days 0 hr. 1 min. 12 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0.1/db_2/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/srlabsby/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srlabsby)(PORT=1521)))
Services Summary...
Service "SRCDB1" has 2 instance(s).
Instance "SRCDB1", status UNKNOWN, has 1 handler(s) for this service...
Instance "SRCDB1", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>
LSNRCTL> stauts
NL-00853: undefined command "stauts". Try "help"
LSNRCTL> staus
NL-00853: undefined command "staus". Try "help"
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 26-JUL-2020 06:21:42
Uptime 0 days 0 hr. 1 min. 18 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0.1/db_2/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/srlabsby/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srlabsby)(PORT=1521)))
Services Summary...
Service "SRCDB1" has 2 instance(s).
Instance "SRCDB1", status UNKNOWN, has 1 handler(s) for this service...
Instance "SRCDB1", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> exit
[oracle@srlabsby admin]$
[oracle@srlabsby admin]$
[oracle@srlabsby admin]$
[oracle@srlabsby admin]$ orapwd file=$ORACLE_HOME/dbs/orapwSRCDB1SBY password=ora$123 entries=10 force=y
OPW-00029: Password complexity failed for SYS user : Password must contain at least 8 characters.
[oracle@srlabsby admin]$
[oracle@srlabsby admin]$ orapwd file=$ORACLE_HOME/dbs/orapwSRCDB1SBY password=ora$1234 entries=10 force=y
OPW-00029: Password complexity failed for SYS user : Password must contain at least 8 characters.
[oracle@srlabsby admin]$ cd .
[oracle@srlabsby admin]$ cd ..
[oracle@srlabsby network]$ cd ..
[oracle@srlabsby db_2]$ cd dbs
[oracle@srlabsby dbs]$ ls -lrt
total 24
-rw-r--r--. 1 oracle oinstall 3079 May 15 2015 init.ora
-rw-r-----. 1 oracle oinstall 24 Jul 19 03:08 lkSRCDB1
-rw-r-----. 1 oracle oinstall 4096 Jul 26 05:06 orapwSRCDB1SBY
-rw-r--r--. 1 oracle oinstall 17 Jul 26 05:13 initSRCDB1SBY.ora
-rw-rw----. 1 oracle oinstall 1544 Jul 26 06:18 hc_SRCDB1SBY.dat
-rw-rw----. 1 oracle oinstall 1544 Jul 26 06:19 hc_SRCDB1.dat
[oracle@srlabsby dbs]$ v orapwSRCDB1SBY orapwSRCDB1SBY_bkp
bash: v: command not found...
[oracle@srlabsby dbs]$ mv orapwSRCDB1SBY orapwSRCDB1SBY_bkp
[oracle@srlabsby dbs]$ orapwd file=$ORACLE_HOME/dbs/orapwSRCDB1SBY password=ora$1234 entries=10 force=y
OPW-00029: Password complexity failed for SYS user : Password must contain at least 8 characters.
[oracle@srlabsby dbs]$
[oracle@srlabsby dbs]$ orapwd file=$ORACLE_HOME/dbs/orapwSRCDB1SBY entries=10 force=y
Enter password for SYS:
[oracle@srlabsby dbs]$ mv orapwSRCDB1SBY orapwSRCDB1
[oracle@srlabsby dbs]$ ls -lrt
total 32
-rw-r--r--. 1 oracle oinstall 3079 May 15 2015 init.ora
-rw-r-----. 1 oracle oinstall 24 Jul 19 03:08 lkSRCDB1
-rw-r-----. 1 oracle oinstall 4096 Jul 26 05:06 orapwSRCDB1SBY_bkp
-rw-r--r--. 1 oracle oinstall 17 Jul 26 05:13 initSRCDB1SBY.ora
-rw-rw----. 1 oracle oinstall 1544 Jul 26 06:18 hc_SRCDB1SBY.dat
-rw-rw----. 1 oracle oinstall 1544 Jul 26 06:19 hc_SRCDB1.dat
-rw-r-----. 1 oracle oinstall 6144 Jul 26 06:27 orapwSRCDB1
[oracle@srlabsby dbs]$ ps -ef |grep pmon
oracle 23627 1 0 06:19 ? 00:00:00 ora_pmon_SRCDB1
oracle 24327 6287 0 06:29 pts/0 00:00:00 grep --color=auto pmon
[oracle@srlabsby dbs]$ ps -ef |grep tns
root 19 2 0 00:39 ? 00:00:00 [netns]
oracle 23845 1 0 06:21 ? 00:00:00 /u01/app/oracle/product/12.2.0.1/db_2/bin/tnslsnr LISTENER -inherit
oracle 24337 6287 0 06:29 pts/0 00:00:00 grep --color=auto tns
[oracle@srlabsby dbs]$ lsnrctl
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 26-JUL-2020 06:29:55
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 26-JUL-2020 06:21:42
Uptime 0 days 0 hr. 8 min. 14 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0.1/db_2/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/srlabsby/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srlabsby)(PORT=1521)))
Services Summary...
Service "SRCDB1" has 2 instance(s).
Instance "SRCDB1", status UNKNOWN, has 1 handler(s) for this service...
Instance "SRCDB1", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> exit
[oracle@srlabsby dbs]$
[oracle@srlabsby dbs]$
[oracle@srlabsby dbs]$ ps -ef |grep tnsp
oracle 25129 6287 0 06:40 pts/0 00:00:00 grep --color=auto tnsp
[oracle@srlabsby dbs]$ ps -ef |grep pmon
oracle 24669 1 0 06:34 ? 00:00:00 ora_pmon_SRCDB1
oracle 25134 6287 0 06:40 pts/0 00:00:00 grep --color=auto pmon
[oracle@srlabsby dbs]$
[oracle@srlabsby dbs]$
[oracle@srlabsby dbs]$ . oraenv
ORACLE_SID = [SRCDB1] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@srlabsby dbs]$
[oracle@srlabsby dbs]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sun Jul 26 06:40:46 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> select name,log_mode,open_mode,database_role,status from v$database,v$instance;
NAME LOG_MODE OPEN_MODE DATABASE_ROLE STATUS
--------- ------------ -------------------- ---------------- ------------
SRCDB1 ARCHIVELOG MOUNTED PHYSICAL STANDBY MOUNTED
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination ?#/dbs/arch
Oldest online log sequence 0
Next log sequence to archive 0
Current log sequence 0
SQL>
SQL> show parameter fal
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fal_client string SRCDB1
fal_server string SRCDB1SBY
SQL> show parameter log_archive_dest_2
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string service=SRCDB1SBY async valid_
for=(online_logfiles,primary_r
ole) db_unique_name=SRCDB1SBY
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
log_archive_dest_23 string
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string
log_archive_dest_27 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_28 string
log_archive_dest_29 string
SQL> ALTER SYSTEM SET log_archive_dest_1='LOCATION=/u02/archive' scope=both;
System altered.
SQL> alter system set log_archive_dest_2='service=SRCDB1 async valid_for=(online_logfiles,primary_role) db_unique_ name=SRCDB1' scope=both;
System altered.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u02/archive
Oldest online log sequence 0
Next log sequence to archive 0
Current log sequence 0
SQL> show parameter standby
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enabled_PDBs_on_standby string *
standby_archive_dest string ?#/dbs/arch
standby_db_preserve_states string NONE
standby_file_management string AUTO
SQL>
SQL> alter system set standby_archive_dest='/u02/archive' scope=both;
System altered.
SQL> show parameter standby
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enabled_PDBs_on_standby string *
standby_archive_dest string /u02/archive
standby_db_preserve_states string NONE
standby_file_management string AUTO
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /u01/app/oracle/product/12.2.0
.1/db_2/dbs/spfileSRCDB1.ora
SQL> create pfile from spfile;
File created.
SQL> shut immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@srlabsby dbs]$
[oracle@srlabsby dbs]$
[oracle@srlabsby dbs]$ vi initSRCDB1.ora
[oracle@srlabsby dbs]$
[oracle@srlabsby dbs]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sun Jul 26 06:48:33 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 1593835520 bytes
Fixed Size 8793256 bytes
Variable Size 1023411032 bytes
Database Buffers 553648128 bytes
Redo Buffers 7983104 bytes
Database mounted.
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /u01/app/oracle/product/12.2.0
.1/db_2/dbs/spfileSRCDB1.ora
SQL>
SQL> select flashback_on from v$database;
FLASHBACK_ON
------------------
NO
SQL> alter database flashback on;
Database altered.
SQL> select flashback_on from v$database;
FLASHBACK_ON
------------------
YES
SQL> alter database recover managed standby database disconnect from session;
Database altered.
SQL> SELECT PROCESS, CLIENT_PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;
PROCESS CLIENT_P STATUS THREAD# SEQUENCE# BLOCK# BLOCKS
--------- -------- ------------ ---------- ---------- ---------- ----------
ARCH ARCH CONNECTED 0 0 0 0
DGRD N/A ALLOCATED 0 0 0 0
DGRD N/A ALLOCATED 0 0 0 0
ARCH ARCH CONNECTED 0 0 0 0
ARCH ARCH CONNECTED 0 0 0 0
ARCH ARCH CONNECTED 0 0 0 0
MRP0 N/A WAIT_FOR_LOG 1 12 0 0
7 rows selected.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Database altered.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
Database altered.
SQL> SELECT PROCESS, CLIENT_PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;
PROCESS CLIENT_P STATUS THREAD# SEQUENCE# BLOCK# BLOCKS
--------- -------- ------------ ---------- ---------- ---------- ----------
ARCH ARCH CONNECTED 0 0 0 0
DGRD N/A ALLOCATED 0 0 0 0
DGRD N/A ALLOCATED 0 0 0 0
ARCH ARCH CONNECTED 0 0 0 0
ARCH ARCH CONNECTED 0 0 0 0
ARCH ARCH CONNECTED 0 0 0 0
MRP0 N/A WAIT_FOR_LOG 1 12 0 0
7 rows selected.
SQL> select sequence#, applied, first_time, next_time, name filename from v$archived_log order by sequence#;
SEQUENCE# APPLIED FIRST_TIM NEXT_TIME
---------- --------- --------- ---------
FILENAME
--------------------------------------------------------------------------------
10 YES 26-JUL-20 26-JUL-20
/u01/app/oracle/product/12.2.0.1/db_2/dbs/arch1_10_1046142798.dbf
11 YES 26-JUL-20 26-JUL-20
/u01/app/oracle/product/12.2.0.1/db_2/dbs/arch1_11_1046142798.dbf
SQL> select process, status, sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
DGRD ALLOCATED 0
DGRD ALLOCATED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 12
7 rows selected.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@srlabsby dbs]$
[oracle@srlabsby dbs]$
[oracle@srlabsby dbs]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sun Jul 26 07:05:08 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> set lines 300 pages 2000
SQL> select USERNAME, SYSDBA, SYSOPER, SYSBACKUP, SYSDG, SYSKM from V$PWFILE_USERS where USERNAME ='C##DBIDG';
no rows selected
SQL> /
USERNAME SYS
-------------------------------------------------------------------------------------------------------------------------------- ---
C##DBIDG FAL
SQL> alter system set redo_transport_user='C##DBIDG';
System altered.
SQL> select process, status, sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
DGRD ALLOCATED 0
DGRD ALLOCATED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 12
7 rows selected.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Database altered.
SQL> alter database recover managed standby database disconnect from session;
Database altered.
SQL> show parameter log_archive
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_config string DG_CONFIG=(SRCDB1,SRCDB1SBY)
log_archive_dest string
log_archive_dest_1 string LOCATION=/u02/archive
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
log_archive_dest_2 string service=SRCDB1 async valid_for
=(online_logfiles,primary_role
) db_unique_name=SRCDB1
SQL> show parameter db_unique
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string SRCDB1SBY
SQL> show parameter log_archive
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_config string DG_CONFIG=(SRCDB1,SRCDB1SBY)
log_archive_dest string
log_archive_dest_1 string LOCATION=/u02/archive
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
log_archive_dest_2 string service=SRCDB1 async valid_for
=(online_logfiles,primary_role
) db_unique_name=SRCDB1
SQL> alter system set log_archive_dest_2='service=SRCDB1 async valid_for=(online_logfiles,primary_role) db_unique_n ame=SRCDB1' scope=both;
System altered.
SQL> select max(sequence#) from v$archived_log;
MAX(SEQUENCE#)
--------------
11
SQL> show parameter LOG_ARCHIVE_DEST_2
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string service=SRCDB1 async valid_for
=(online_logfiles,primary_role
) db_unique_name=SRCDB1
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
log_archive_dest_23 string
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string
log_archive_dest_27 string
log_archive_dest_28 string
log_archive_dest_29 string
SQL> select process, status, sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
DGRD ALLOCATED 0
DGRD ALLOCATED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CLOSING 21
MRP0 APPLYING_LOG 22
RFS IDLE 0
RFS IDLE 22
RFS IDLE 0
RFS IDLE 0
RFS IDLE 0
12 rows selected.
SQL> /
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CLOSING 22
DGRD ALLOCATED 0
DGRD ALLOCATED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CLOSING 21
MRP0 APPLYING_LOG 23
RFS IDLE 0
RFS IDLE 23
RFS IDLE 0
RFS IDLE 0
RFS IDLE 0
12 rows selected.
SQL> select max(sequence#) from v$archived_log;
MAX(SEQUENCE#)
--------------
22
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED MOUNTED
3 SRDBPLUG MOUNTED
SQL>
Hope this helps, Cheers!
Ramesh.
Post a Comment: