19c Physical standby configuration – Dataguard

Physical standby configuration:


Description:
         In this Blog we are going to see the step by step process of data Guard configuration, and primary to physical standby database demo.

what Is Data Guard:

  • Oracle data Guard ensures high availability, data protection, and disaster recovery for enterprise data.
  • Data Guard maintains these standby databases as transactional consistent copies of the production database.
  • if the production database becomes unavailable, Data Guard can switch any standby database to the production role.

Physical Standby

  • Physical Standby is the exact block-for-block copy of primary database.
  • REDO logs apply primary to physical standby, its always sync with primary database  
  • Physical Standby database only opened as READ ONLY mode.
  • Most of the environment used the physical standby database.

Environment Details:
Overall Steps:

1.Check Archive log mode enable and force logging enabled.
2.Add Standby log file group.
3.check listener and TNS entry both primary and standby severs.
4.Change parameters in primary database.
5.copy password file primary to standby.
6.Create PFILE in standby database.
7.Create directory Structure in Standby database.
8.Connect RMAN in standby database and run the script
9.Check database can be configured or not.
10.Connect standby database execute MRP process.
11.Switch Logs in primary database, Execute Defer Enable.
12.Check standby database log files can be switched.
13.Crosscheck Alert Log files.

Primary Server Configuration:

Step 1: Check Archive log mode enable and force logging enabled.

In the primary database check whether the archive log mode is enabled or not, also check the force logging option to enable if is not enabled please enable it.

[oracle@agent ~]$ export ORACLE_SID=agent
[oracle@agent ~]$ sqlplus / as sysdba
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.3.0.0.0

Connect database as mount stage

SQL> alter database archivelog;
Database altered.
SQL> alter database force logging;
Database altered.
SQL> alter database open;
Database altered.
SQL> select FORCE_LOGGING,log_mode from v$database;
FORCE_LOGGING                   LOG_MODE
————————-                    ————–
YES                                           ARCHIVELOG

Step 2: Add Standby logfile group.

Add logfile group in the primary database mentioned as that file creation as standby log group.

SQL> alter database add standby logfile group 4 ‘/u01/app/oracle/oradata/AGENT/redo04.log’ size 50m;
Database altered.

SQL> alter database add standby logfile group 5 ‘/u01/app/oracle/oradata/AGENT/redo05.log’ size 50m;
Database altered.

SQL> alter database add standby logfile group 6 ‘/u01/app/oracle/oradata/AGENT/redo06.log’ size 50m;
Database altered.

SQL> SELECT GROUP#,THREAD#,SEQUENCE#,ARCHIVED,STATUS FROM V$STANDBY_LOG;

GROUP# THREAD# SEQUENCE# ARC STATUS
———- ———- ———- — ———-
4 0 0 YES UNASSIGNED
5 0 0 YES UNASSIGNED
6 0 0 YES UNASSIGNED

Step 3- check listener and TNS entry both primary and standby servers.

Primary side entries.
LISTENER:
listener =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
SID_LIST_LISTENER =
(SID_DESC =
(GLOBAL_DBNAME = agent)
(ORACLE_HOME =/u01/app/oracle/product/19.0.0/dbhome_1)
(SID_NAME = agent)
)
)
TNS names:
[oracle@agent admin]$ cat tnsnames.ora
agent=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = agent)
)
)
data=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = data)
(UR=A)
)
)
Standby side entries:
LISTENER:
[oracle@data admin]$ cat listener.ora
listener =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
SID_LIST_LISTENER =
(SID_DESC =
(GLOBAL_DBNAME = data)
(ORACLE_HOME =/u01/app/oracle/product/19.0.0/dbhome_1)
(SID_NAME = data)
)
)
TNS names:
[oracle@data admin]$
data=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = data)
)
)
agent=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = agent)
(UR=A)
)
)

The output of tns ping statements connects both sides primary to standby and standby to primary.

[oracle@agent admin]$ tnsping data
TNS Ping Utility for Linux: Version 19.0.0.0.0 – Production on 18-NOV-2021 07:19:44
Copyright (c) 1997, 2019, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = data) (UR=A)))
OK (20 msec)

[oracle@agent admin]$ tnsping agent
TNS Ping Utility for Linux: Version 19.0.0.0.0 – Production on 18-NOV-2021 07:19:55
Copyright (c) 1997, 2019, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = agent)))
OK (0 msec)
[oracle@agent admin]$

Step 4:Change parameters in primary database.

1. dg_config – Specify the DG_CONFIG attribute to identify the DB_UNIQUE_NAME for the primary database and standby database.
SQL> ALTER SYSTEM SET log_archive_config=’dg_config=(agent,data)’ SCOPE=both;
System altered.

2. log_archive_dest_1 – The LOG_ARCHIVE_DEST parameter is used to specify the directory to which Oracle archive logs are written.
SQL> ALTER SYSTEM SET log_archive_dest_1=’location=use_db_recovery_file_dest valid_for=(all_logfiles,all_roles) db_unique_name=agent’ SCOPE=both;
System altered.

3. log_archive_dest_2 – handle the transmission of the standby site’s archived redo logs back to the original primary database.
SQL> ALTER SYSTEM SET log_archive_dest_2=’service=data async valid_for=(online_logfiles,primary_role) db_unique_name=data’ SCOPE=both;
System altered.

4. FAL_SERVER – It is used to fetch an archive log server for a standby database.
SQL> ALTER SYSTEM SET fal_server=’data’ SCOPE=both;
System altered.

5. FAL_CLIENT – It is configured for point the FAL Client.
SQL> ALTER SYSTEM SET fal_client=’agent’ SCOPE=both;
System altered.

6. standby_file_management –Check the redo changes done in Primary and sync those changes in Standby by Stopping the recovery and making STANDBY_FILE_MANAGEMENT = MANUAL value.
Then sync the primary changes with standby changes and again change the parameter to AUTO and start the recovery on Standby database.
SQL> ALTER SYSTEM SET standby_file_management=’AUTO’ SCOPE=both;
System altered.

SQL> show parameter log_archive_config;

NAME TYPE VALUE
———————————— ———– ——————————
log_archive_config string dg_config=(agent,data)
SQL>

Step 5:Copy password file primary to standby

scp orapwagent [email protected]:$ORACLE_HOME/dbs
[oracle@agent dbs]$ scp orapwagent [email protected]:$ORACLE_HOME/dbs
[email protected]’s password:
orapwagent 100% 2048 2.1MB/s 00:00
[oracle@agent dbs]$

Move the file in new name db_unique_name(standby)
oracle@data ~]$ cd $ORACLE_HOME/dbs
[oracle@data dbs]$ ls
hc_data.dat init.ora lkDATA orapwdata orapwagent spfiledata.ora
[oracle@data dbs]$ mv orapwagent orapwdata

Step 6 :- create PFILE in standby database

In the $ORACLE_HOME/dbs directory of the standby system, create an initialization parameter file named initdata.ora
Containing a single parameter: DB_NAME=agent
[oracle@data dbs]$ cat initdata.ora
db_name=agent
[oracle@data dbs]$ pwd
/u01/app/oracle/product/19.0.0/dbhome_1/dbs

Step 7 :- Create directory Structure in Standby database.

[oracle@data dbs]$ cd $ORACLE_BASE/admin/
[oracle@data dbs]$ mkdir data
[oracle@data dbs]$ cd data
[oracle@data dbs]$ mkdir adump
[oracle@data dbs]$ mkdir -p /u01/app/oracle/oradata/DATA

Step 8 :- Connect RMAN clone Database

method 1:
copy pfile primary database to standby edit the parameters after that connect RMAN and clone the database.

parameter_value_convert ‘agent’,’data’
set db_name=’agent’
set db_unique_name=’data’
set db_file_name_convert=’/u01/app/oracle/oradata/AGENT/’,’/u01/app/oracle/oradata/DATA/’
set log_file_name_convert=’/u01/app/oracle/oradata/AGENT/’,’/u01/app/oracle/oradata/DATA/’
set control_files=’/u01/app/oracle/oradata/DATA/standby1.ctl’
set log_archive_max_processes=’5′
set fal_client=’data’
set fal_server=’agent’
set standby_file_management=’AUTO’
set log_archive_config=’dg_config=(agent,data)’
set compatible=’19.3.0.0′
set memory_target=’1200m’

method 2:
craete a RMAN script mention the parameters changes in spfile to execute the script.

Target database as primary – Agent
Auxiliary database as a standby – Data

[oracle@data admin]$ export ORACLE_SID=agent
[oracle@data admin]$ rman target sys/oracle@agent auxiliary sys/oracle@data
Recovery Manager: Release 19.0.0.0.0 – Production on Thu Nov 18 08:00:22 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.

connected to target database: AGENT (DBID=396457310)
connected to auxiliary database: AGENT (not mounted)

RMAN> run
{
allocate channel p1 type disk;
allocate channel p2 type disk;
allocate channel p3 type disk;
allocate channel p4 type disk;
allocate auxiliary channel s1 type disk;
duplicate target database for standby from active database
spfile
parameter_value_convert ‘agent’,’data’
set db_name=’agent’
set db_unique_name=’data’
set db_file_name_convert=’/u01/app/oracle/oradata/AGENT/’,’/u01/app/oracle/oradata/DATA/’
set log_file_name_convert=’/u01/app/oracle/oradata/AGENT/’,’/u01/app/oracle/oradata/DATA/’
set control_files=’/u01/app/oracle/oradata/DATA/standby1.ctl’
set log_archive_max_processes=’5′
set fal_client=’data’
set fal_server=’agent’
set standby_file_management=’AUTO’
set log_archive_config=’dg_config=(agent,data)’
set compatible=’19.3.0.0′
set memory_target=’1200m’
nofilenamecheck;
}

the output of the script:

using target database control file instead of recovery catalog
allocated channel: p1
channel p1: SID=82 device type=DISK

allocated channel: p2
channel p2: SID=81 device type=DISK

allocated channel: p3
channel p3: SID=85 device type=DISK

allocated channel: p4
channel p4: SID=86 device type=DISK

allocated channel: s1
channel s1: SID=35 device type=DISK

Starting Duplicate Db at 18-NOV-21

contents of Memory Script:
{
backup as copy reuse
passwordfile auxiliary format ‘/u01/app/oracle/product/19.0.0/dbhome_1/dbs/orapwdata’ targetfile
‘/u01/app/oracle/product/19.0.0/dbhome_1/dbs/spfileagent.ora’ auxiliary format
‘/u01/app/oracle/product/19.0.0/dbhome_1/dbs/spfiledata.ora’ ;
sql clone “alter system set spfile= ”/u01/app/oracle/product/19.0.0/dbhome_1/dbs/spfiledata.ora””;
}
executing Memory Script

Starting backup at 18-NOV-21
Finished backup at 18-NOV-21

sql statement: alter system set spfile= ”/u01/app/oracle/product/19.0.0/dbhome_1/dbs/spfiledata.ora”

contents of Memory Script:
{
sql clone “alter system set audit_file_dest =
”/u01/app/oracle/admin/data/adump” comment=
”” scope=spfile”;
sql clone “alter system set dispatchers =
”(PROTOCOL=TCP) (SERVICE=dataXDB)” comment=
”” scope=spfile”;
sql clone “alter system set db_name =
”agent” comment=
”” scope=spfile”;
sql clone “alter system set db_unique_name =
”data” comment=
”” scope=spfile”;
sql clone “alter system set db_file_name_convert =
”/u01/app/oracle/oradata/AGENT/”, ”/u01/app/oracle/oradata/DATA/” comment=
”” scope=spfile”;
sql clone “alter system set log_file_name_convert =
”/u01/app/oracle/oradata/AGENT/”, ”/u01/app/oracle/oradata/DATA/” comment=
”” scope=spfile”;
sql clone “alter system set control_files =
”/u01/app/oracle/oradata/DATA/standby1.ctl” comment=
”” scope=spfile”;
sql clone “alter system set log_archive_max_processes =
5 comment=
”” scope=spfile”;
sql clone “alter system set fal_client =
”data” comment=
”” scope=spfile”;
sql clone “alter system set fal_server =
”agent” comment=
”” scope=spfile”;
sql clone “alter system set standby_file_management =
”AUTO” comment=
”” scope=spfile”;
sql clone “alter system set log_archive_config =
”dg_config=(agent,data)” comment=
”” scope=spfile”;
sql clone “alter system set compatible =
”19.3.0.0” comment=
”” scope=spfile”;
sql clone “alter system set memory_target =
1200m comment=
”” scope=spfile”;
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script

sql statement: alter system set audit_file_dest = ”/u01/app/oracle/admin/data/adump” comment= ”” scope=spfile

sql statement: alter system set dispatchers = ”(PROTOCOL=TCP) (SERVICE=dataXDB)” comment= ”” scope=spfile

sql statement: alter system set db_name = ”agent” comment= ”” scope=spfile

sql statement: alter system set db_unique_name = ”data” comment= ”” scope=spfile

sql statement: alter system set db_file_name_convert = ”/u01/app/oracle/oradata/AGENT/”, ”/u01/app/oracle/oradata/DATA/” comment= ”” scope=spfile

sql statement: alter system set log_file_name_convert = ”/u01/app/oracle/oradata/AGENT/”, ”/u01/app/oracle/oradata/DATA/” comment= ”” scope=spfile

sql statement: alter system set control_files = ”/u01/app/oracle/oradata/DATA/standby1.ctl” comment= ”” scope=spfile

sql statement: alter system set log_archive_max_processes = 5 comment= ”” scope=spfile

sql statement: alter system set fal_client = ”data” comment= ”” scope=spfile

sql statement: alter system set fal_server = ”agent” comment= ”” scope=spfile

sql statement: alter system set standby_file_management = ”AUTO” comment= ”” scope=spfile

sql statement: alter system set log_archive_config = ”dg_config=(agent,data)” comment= ”” scope=spfile

sql statement: alter system set compatible = ”19.3.0.0” comment= ”” scope=spfile

sql statement: alter system set memory_target = 1200m comment= ”” scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area 1258290752 bytes

Fixed Size 8896064 bytes
Variable Size 738197504 bytes
Database Buffers 503316480 bytes
Redo Buffers 7880704 bytes
allocated channel: s1
channel s1: SID=35 device type=DISK

contents of Memory Script:
{
backup as copy current controlfile for standby auxiliary format ‘/u01/app/oracle/oradata/DATA/standby1.ctl’;
}
executing Memory Script

Starting backup at 18-NOV-21
channel p1: starting datafile copy
copying standby control file
output file name=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/snapcf_agent.f tag=TAG20211118T080552
channel p1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 18-NOV-21

contents of Memory Script:
{
sql clone ‘alter database mount standby database’;
}
executing Memory Script

sql statement: alter database mount standby database

contents of Memory Script:
{
set newname for tempfile 1 to
“/u01/app/oracle/oradata/DATA/datafile/o1_mf_temp_jsc8y37j_.tmp”;
switch clone tempfile all;
set newname for datafile 1 to
“/u01/app/oracle/oradata/DATA/datafile/o1_mf_system_jsc8qv1o_.dbf”;
set newname for datafile 3 to
“/u01/app/oracle/oradata/DATA/datafile/o1_mf_sysaux_jsc8smrq_.dbf”;
set newname for datafile 4 to
“/u01/app/oracle/oradata/DATA/datafile/o1_mf_undotbs1_jsc8tq0b_.dbf”;
set newname for datafile 7 to
“/u01/app/oracle/oradata/DATA/datafile/o1_mf_users_jsc8tr78_.dbf”;
backup as copy reuse
datafile 1 auxiliary format
“/u01/app/oracle/oradata/DATA/datafile/o1_mf_system_jsc8qv1o_.dbf” datafile
3 auxiliary format
“/u01/app/oracle/oradata/DATA/datafile/o1_mf_sysaux_jsc8smrq_.dbf” datafile
4 auxiliary format
“/u01/app/oracle/oradata/DATA/datafile/o1_mf_undotbs1_jsc8tq0b_.dbf” datafile
7 auxiliary format
“/u01/app/oracle/oradata/DATA/datafile/o1_mf_users_jsc8tr78_.dbf” ;
sql ‘alter system archive log current’;
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /u01/app/oracle/oradata/DATA/datafile/o1_mf_temp_jsc8y37j_.tmp in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting backup at 18-NOV-21
channel p1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/AGENT/datafile/o1_mf_system_jsc8qv1o_.dbf
channel p2: starting datafile copy
input datafile file number=00003 name=/u01/app/oracle/oradata/AGENT/datafile/o1_mf_sysaux_jsc8smrq_.dbf
channel p3: starting datafile copy
input datafile file number=00004 name=/u01/app/oracle/oradata/AGENT/datafile/o1_mf_undotbs1_jsc8tq0b_.dbf
channel p4: starting datafile copy
input datafile file number=00007 name=/u01/app/oracle/oradata/AGENT/datafile/o1_mf_users_jsc8tr78_.dbf
output file name=/u01/app/oracle/oradata/DATA/datafile/o1_mf_users_jsc8tr78_.dbf tag=TAG20211118T080558
channel p4: datafile copy complete, elapsed time: 00:00:08
output file name=/u01/app/oracle/oradata/DATA/datafile/o1_mf_sysaux_jsc8smrq_.dbf tag=TAG20211118T080558
channel p2: datafile copy complete, elapsed time: 00:01:00
output file name=/u01/app/oracle/oradata/DATA/datafile/o1_mf_undotbs1_jsc8tq0b_.dbf tag=TAG20211118T080558
channel p3: datafile copy complete, elapsed time: 00:00:59
output file name=/u01/app/oracle/oradata/DATA/datafile/o1_mf_system_jsc8qv1o_.dbf tag=TAG20211118T080558
channel p1: datafile copy complete, elapsed time: 00:01:22
Finished backup at 18-NOV-21

sql statement: alter system archive log current

contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script

datafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=1088928441 file name=/u01/app/oracle/oradata/DATA/datafile/o1_mf_system_jsc8qv1o_.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=1088928441 file name=/u01/app/oracle/oradata/DATA/datafile/o1_mf_sysaux_jsc8smrq_.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=1088928441 file name=/u01/app/oracle/oradata/DATA/datafile/o1_mf_undotbs1_jsc8tq0b_.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=4 STAMP=1088928441 file name=/u01/app/oracle/oradata/DATA/datafile/o1_mf_users_jsc8tr78_.dbf
Finished Duplicate Db at 18-NOV-21
released channel: p1
released channel: p2
released channel: p3
released channel: p4
released channel: s1
RMAN> exit

Step 9: Check database can be configured or not:

SQL> select open_mode,name from v$database;

OPEN_MODE NAME
——————– ———
MOUNTED AGENT

SQL> select open_mode,name,database_role from v$database;

OPEN_MODE NAME DATABASE_ROLE
——————– ——— —————-
MOUNTED AGENT PHYSICAL STANDBY

Step 10:- Connect standby database execute MRP process:

SQL> alter database recover managed standby database disconnect nodelay;

Database altered.

Step 11:- Switch Logs in the primary database, Execute Defer Enable.

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 7
Next log sequence to archive 9
Current log sequence 9

Set log_archive_dest_state_2 as defer
SQL> alter system set log_archive_dest_state_2=defer;

System altered.

Enable log_archive_dest_state_2 location
SQL> alter system set log_archive_dest_state_2=enable;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

Step 12: – check standby database log files can be switched

SQL> select error, status from v$archive_dest;

SQL> SELECT ARCH.THREAD# “Thread”, ARCH.SEQUENCE# “Last Sequence Received”, APPL.SEQUENCE# “Last Sequence Applied”, (ARCH.SEQUENCE# – APPL.SEQUENCE#) “Difference”
FROM
(SELECT THREAD# , SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#, FIRST_TIME ) IN (SELECT THREAD#, MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH,
(SELECT THREAD# , SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#, FIRST_TIME ) IN (SELECT THREAD#, MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL
WHERE
ARCH.THREAD# = APPL.THREAD#
ORDER BY 1;
 

Check MRP0 process status:
SQL> SELECT STATUS FROM V$MANAGED_STANDBY WHERE PROCESS=’MRP0′;

STATUS
————
WAIT_FOR_LOG

Archived log applied time and status:

SQL> SELECT sequence#, first_time, next_time, applied FROM v$archived_log ORDER BY sequence#;
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
——— ——————–
AGENT MOUNTED

Step 13:- Monitor the process in the alert log
The best method to monitor the data guard process in the alert log shows as exact data transfer reports and errors we can using the logs easily find out the mistakes.

oracle@data trace]$ pwd
/u01/app/oracle/diag/rdbms/data/data/trace
[oracle@data trace]$ tail -100f alert_data.log
MRP0 (PID:26173): Media Recovery Log /u01/app/oracle/fast_recovery_area/DATA/archivelog/2021_11_18/o1_mf_1_11_jsclfmk7_.arc
MRP0 (PID:26173): Media Recovery Waiting for T-1.S-12 (in transit)
2021-11-18T09:05:44.267442+05:30
rfs (PID:29555): Archived Log entry 7 added for B-1088922080.T-1.S-12 ID 0x17a1415e LAD:2
rfs (PID:29555): No SRLs created for T-1
2021-11-18T09:05:44.297904+05:30
rfs (PID:29555): Opened log for T-1.S-13 dbid 396457310 branch 1088922080
2021-11-18T09:05:44.346775+05:30
MRP0 (PID:26173): Media Recovery Log /u01/app/oracle/fast_recovery_area/DATA/archivelog/2021_11_18/o1_mf_1_12_jsclfnxx_.arc
MRP0 (PID:26173): Media Recovery Waiting for T-1.S-13 (in transit)
2021-11-18T09:05:45.670215+05:30
rfs (PID:29555): Archived Log entry 8 added for B-1088922080.T-1.S-13 ID 0x17a1415e LAD:2
rfs (PID:29555): No SRLs created for T-1
2021-11-18T09:05:45.699219+05:30
rfs (PID:29555): Opened log for T-1.S-14 dbid 396457310 branch 1088922080
2021-11-18T09:05:46.482970+05:30
MRP0 (PID:26173): Media Recovery Log /u01/app/oracle/fast_recovery_area/DATA/archivelog/2021_11_18/o1_mf_1_13_jscljj95_.arc
MRP0 (PID:26173): Media Recovery Waiting for T-1.S-14 (in transit)
2021-11-18T09:16:20.023804+05:30

 

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter: https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8