Showing posts with label Dataguard. Show all posts
Showing posts with label Dataguard. Show all posts

Friday, 4 February 2022

Multitenant Dataguard: Create multitenant database on priamry and standby database using FILE_NAME_CONVERT parameter

Recently we faced some issue on multitenant standby database . As we create pdb on primary same not reflected on standby database as it was conflicting  with destination directory and datafile as well. 

This scenario  about using FILE_NAME_CONVERT parameter we create multitenant  primary pluggable  database and same will reflect on standby database. 

PRIMARY Pluggable database :


SQL> sho pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB                            READ WRITE NO


  • NOTE : Create directory in pluggable standby database before creting pluggable database on primary database.

Example: 

[oracle@srv7 ~]$ mkdir -pv /u02/app/oracle/oradata/PRIMARY19C/pdb3

mkdir: created directory ‘/u02/app/oracle/oradata/PRIMARY19C/pdb3’

  • Create Pluggable database on primary database and mention file_name_convert parameter  below and provide directory of new pdb3 we have mentioned  /u02/app/oracle/oradata/PRIMARY19C/pdb3 and it will be created automatically. 

SQL> CREATE PLUGGABLE DATABASE pdb3 ADMIN USER pdb_adm IDENTIFIED BY Password1 FILE_NAME_CONVERT=('/u02/app/oracle/oradata/PRIMARY19C/pdbseed','/u02/app/oracle/oradata/PRIMARY19C/pdb3');


Pluggable database created.

SQL> sho pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB                            READ WRITE NO
         4 PDB3                           MOUNTED

  • Open primary pluggable database 
SQL> alter pluggable database all open;

Pluggable database altered.

SQL> sho pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB                            READ WRITE NO
         4 PDB3                           READ WRITE NO


SQL> sho pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB                            READ WRITE NO
         4 PDB3                           READ WRITE NO
         5 PDB4                           READ WRITE NO

  • Check the PDB service entry  

SQL> COLUMN name FORMAT A30
SQL> COLUMN PDB FORMAT a40
SQL>
SQL> set lines 200
SQL> SELECT name, pdb FROM   v$services ORDER BY name;

NAME                           PDB
------------------------------ ----------------------------------------
SYS$BACKGROUND                 CDB$ROOT
SYS$USERS                      CDB$ROOT
pdb                            PDB
pdb3                           PDB3
pdb4                           PDB4
primary19c                     CDB$ROOT
primary19cXDB                  CDB$ROOT

7 rows selected.


SQL> connect sys/sys@PDB3 as sysdba
Connected.
SQL> sho pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         4 PDB3                           READ WRITE NO
SQL>

  • Check datafile details below on primary multitenant database 
SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u02/app/oracle/oradata/PRIMARY19C/system01.dbf
/u02/app/oracle/oradata/PRIMARY19C/sysaux01.dbf
/u02/app/oracle/oradata/PRIMARY19C/undotbs01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdbseed/system01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdbseed/sysaux01.dbf
/u02/app/oracle/oradata/PRIMARY19C/users01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdbseed/undotbs01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb/system01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb/sysaux01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb/undotbs01.dbf
/u01/app/oracle/oradata/PRIMARY19C/pdb/users01.dbf

NAME
--------------------------------------------------------------------------------
/u02/app/oracle/oradata/PRIMARY19C/pdb3/system01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb3/sysaux01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb3/undotbs01.dbf

  • Check Details on Multitenant standby database 
[oracle@srv7 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Feb 3 20:49:56 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> sho pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       MOUNTED
         3 PDB                            MOUNTED
         4 PDB3                           MOUNTED
SQL>  sho pdbs

  • Check datafile details below on Standby multitenant database 
SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u02/app/oracle/oradata/PRIMARY19C/system01.dbf
/u02/app/oracle/oradata/PRIMARY19C/sysaux01.dbf
/u02/app/oracle/oradata/PRIMARY19C/undotbs01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdbseed/system01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdbseed/sysaux01.dbf
/u02/app/oracle/oradata/PRIMARY19C/users01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdbseed/undotbs01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb/system01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb/sysaux01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb/undotbs01.dbf
/u01/app/oracle/oradata/PRIMARY19C/pdb/users01.dbf

NAME
--------------------------------------------------------------------------------
/u02/app/oracle/oradata/PRIMARY19C/pdb3/system01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb3/sysaux01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb3/undotbs01.dbf

14 rows selected.


Alter log file file standby database :


Recovery created pluggable database PDB3
2022-02-03T20:48:59.217732+05:30
Recovery copied files for tablespace SYSTEM
Recovery successfully copied file /u02/app/oracle/oradata/PRIMARY19C/pdb3/system01.dbf from /u02/app/oracle/oradata/PRIMARY19C/pdbseed/system01.dbf
PDB3(4):WARNING: File being created with same name as in Primary
PDB3(4):Existing file may be overwritten
PDB3(4):Recovery created file /u02/app/oracle/oradata/PRIMARY19C/pdb3/system01.dbf
PDB3(4):Successfully added datafile 25 to media recovery
PDB3(4):Datafile #25: '/u02/app/oracle/oradata/PRIMARY19C/pdb3/system01.dbf'
2022-02-03T20:49:23.126371+05:30
Recovery copied files for tablespace SYSAUX
Recovery successfully copied file /u02/app/oracle/oradata/PRIMARY19C/pdb3/sysaux01.dbf from /u02/app/oracle/oradata/PRIMARY19C/pdbseed/sysaux01.dbf
PDB3(4):WARNING: File being created with same name as in Primary
PDB3(4):Existing file may be overwritten
PDB3(4):Recovery created file /u02/app/oracle/oradata/PRIMARY19C/pdb3/sysaux01.dbf
PDB3(4):Successfully added datafile 26 to media recovery
PDB3(4):Datafile #26: '/u02/app/oracle/oradata/PRIMARY19C/pdb3/sysaux01.dbf'
2022-02-03T20:49:30.846103+05:30
Recovery copied files for tablespace UNDOTBS1
Recovery successfully copied file /u02/app/oracle/oradata/PRIMARY19C/pdb3/undotbs01.dbf from /u02/app/oracle/oradata/PRIMARY19C/pdbseed/undotbs01.dbf
PDB3(4):WARNING: File being created with same name as in Primary
PDB3(4):Existing file may be overwritten
PDB3(4):Recovery created file /u02/app/oracle/oradata/PRIMARY19C/pdb3/undotbs01.dbf
PDB3(4):Successfully added datafile 27 to media recovery
PDB3(4):Datafile #27: '/u02/app/oracle/oradata/PRIMARY19C/pdb3/undotbs01.dbf'
2022-02-03T20:52:50.952812+05:30


  • Same example now we create   PDB4 multitenant database on primary DB
  • NOTE : Create directory in pluggable standby database before creting pluggable database on primary database.
[oracle@srv7 ~]$ mkdir -pv /u02/app/oracle/oradata/PRIMARY19C/pdb4
mkdir: created directory ‘/u02/app/oracle/oradata/PRIMARY19C/pdb4’
[oracle@srv7 ~]$ cd /u02/app/oracle/oradata/PRIMARY19C/pdb4
[oracle@srv7 pdb4]$ ll

Create Pluggable database on primary database and mention file_name_convert parameter  below and provide directory of new pdb4 we have mentioned  /u02/app/oracle/oradata/PRIMARY19C/pdb4 and it will be created automatically.

SQL> CREATE PLUGGABLE DATABASE pdb4 ADMIN USER pdb_adm IDENTIFIED BY Password1 FILE_NAME_CONVERT=('/u02/app/oracle/oradata/PRIMARY19C/pdbseed','/u02/app/oracle/oradata/PRIMARY19C/pdb4');

Pluggable database created.

SQL> sho pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB                            READ WRITE NO
         4 PDB3                           READ WRITE NO
         5 PDB4                           MOUNTED

  • Open primary pluggable database 
SQL> alter pluggable database PDB4 open;

Pluggable database altered.


SQL> sho parameter file_name_convert

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert                 string      /u02/app/oracle/oradata/PRIMAR
                                                 Y19C, /u02/app/oracle/oradata/
                                                 STANDBY19C
log_file_name_convert                string      /u02/app/oracle/oradata/PRIMAR
                                                 Y19C, /u02/app/oracle/oradata/
                                                 STANDBY19C
pdb_file_name_convert                string


SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u02/app/oracle/oradata/PRIMARY19C/system01.dbf
/u02/app/oracle/oradata/PRIMARY19C/sysaux01.dbf
/u02/app/oracle/oradata/PRIMARY19C/undotbs01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdbseed/system01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdbseed/sysaux01.dbf
/u02/app/oracle/oradata/PRIMARY19C/users01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdbseed/undotbs01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb/system01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb/sysaux01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb/undotbs01.dbf
/u01/app/oracle/oradata/PRIMARY19C/pdb/users01.dbf

NAME
--------------------------------------------------------------------------------
/u02/app/oracle/oradata/PRIMARY19C/pdb3/system01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb3/sysaux01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb3/undotbs01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb4/system01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb4/sysaux01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb4/undotbs01.dbf

17 rows selected.

SQL>



STANDBY Pluggable database :

[oracle@srv7 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Feb 3 20:49:56 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> sho pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       MOUNTED
         3 PDB                            MOUNTED
         4 PDB3                           MOUNTED
SQL>  sho pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       MOUNTED
         3 PDB                            MOUNTED
         4 PDB3                           MOUNTED
SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u02/app/oracle/oradata/PRIMARY19C/system01.dbf
/u02/app/oracle/oradata/PRIMARY19C/sysaux01.dbf
/u02/app/oracle/oradata/PRIMARY19C/undotbs01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdbseed/system01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdbseed/sysaux01.dbf
/u02/app/oracle/oradata/PRIMARY19C/users01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdbseed/undotbs01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb/system01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb/sysaux01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb/undotbs01.dbf
/u01/app/oracle/oradata/PRIMARY19C/pdb/users01.dbf

NAME
--------------------------------------------------------------------------------
/u02/app/oracle/oradata/PRIMARY19C/pdb3/system01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb3/sysaux01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb3/undotbs01.dbf

14 rows selected.

SQL> host

total 0
[oracle@srv7 pdb4]$ pwd
/u02/app/oracle/oradata/PRIMARY19C/pdb4
[oracle@srv7 pdb4]$ ll
total 716828
-rw-r----- 1 oracle oinstall 346038272 Feb  3 20:53 sysaux01.dbf
-rw-r----- 1 oracle oinstall 283123712 Feb  3 20:53 system01.dbf
-rw-r----- 1 oracle oinstall 104865792 Feb  3 20:53 undotbs01.dbf
[oracle@srv7 pdb4]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Feb 3 20:54:21 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> sho parameter file_name_convert

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert                 string      /u02/app/oracle/oradata/STANDB
                                                 Y19C, /u02/app/oracle/oradata/
                                                 PRIMARY19C
log_file_name_convert                string      /u02/app/oracle/oradata/STANDB
                                                 Y19C, /u02/app/oracle/oradata/
                                                 PRIMARY19C
pdb_file_name_convert                string

  • Check datafile details below on primary multitenant database 
SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u02/app/oracle/oradata/PRIMARY19C/system01.dbf
/u02/app/oracle/oradata/PRIMARY19C/sysaux01.dbf
/u02/app/oracle/oradata/PRIMARY19C/undotbs01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdbseed/system01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdbseed/sysaux01.dbf
/u02/app/oracle/oradata/PRIMARY19C/users01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdbseed/undotbs01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb/system01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb/sysaux01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb/undotbs01.dbf
/u01/app/oracle/oradata/PRIMARY19C/pdb/users01.dbf

NAME
--------------------------------------------------------------------------------
/u02/app/oracle/oradata/PRIMARY19C/pdb3/system01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb3/sysaux01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb3/undotbs01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb4/system01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb4/sysaux01.dbf
/u02/app/oracle/oradata/PRIMARY19C/pdb4/undotbs01.dbf

17 rows selected.

  • Check the multitenant database status on standby database 

SQL> @/home/oracle/d

NAME      INSTANCE_NAME    DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE    CURRENT_SCN        FAILOVER_SCN
--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------
PRIMARY1  standby19c       standby19c                     MOUNTED              PHYSICAL STANDBY NO                 0



SQL> sho pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       MOUNTED
         3 PDB                            MOUNTED
         4 PDB3                           MOUNTED
         5 PDB4                           MOUNTED
SQL>


Alter log file file standby database :


Recovery created pluggable database PDB3
2022-02-03T20:48:59.217732+05:30
Recovery copied files for tablespace SYSTEM
Recovery successfully copied file /u02/app/oracle/oradata/PRIMARY19C/pdb3/system01.dbf from /u02/app/oracle/oradata/PRIMARY19C/pdbseed/system01.dbf
PDB3(4):WARNING: File being created with same name as in Primary
PDB3(4):Existing file may be overwritten
PDB3(4):Recovery created file /u02/app/oracle/oradata/PRIMARY19C/pdb3/system01.dbf
PDB3(4):Successfully added datafile 25 to media recovery
PDB3(4):Datafile #25: '/u02/app/oracle/oradata/PRIMARY19C/pdb3/system01.dbf'
2022-02-03T20:49:23.126371+05:30
Recovery copied files for tablespace SYSAUX
Recovery successfully copied file /u02/app/oracle/oradata/PRIMARY19C/pdb3/sysaux01.dbf from /u02/app/oracle/oradata/PRIMARY19C/pdbseed/sysaux01.dbf
PDB3(4):WARNING: File being created with same name as in Primary
PDB3(4):Existing file may be overwritten
PDB3(4):Recovery created file /u02/app/oracle/oradata/PRIMARY19C/pdb3/sysaux01.dbf
PDB3(4):Successfully added datafile 26 to media recovery
PDB3(4):Datafile #26: '/u02/app/oracle/oradata/PRIMARY19C/pdb3/sysaux01.dbf'
2022-02-03T20:49:30.846103+05:30
Recovery copied files for tablespace UNDOTBS1
Recovery successfully copied file /u02/app/oracle/oradata/PRIMARY19C/pdb3/undotbs01.dbf from /u02/app/oracle/oradata/PRIMARY19C/pdbseed/undotbs01.dbf
PDB3(4):WARNING: File being created with same name as in Primary
PDB3(4):Existing file may be overwritten
PDB3(4):Recovery created file /u02/app/oracle/oradata/PRIMARY19C/pdb3/undotbs01.dbf
PDB3(4):Successfully added datafile 27 to media recovery
PDB3(4):Datafile #27: '/u02/app/oracle/oradata/PRIMARY19C/pdb3/undotbs01.dbf'
2022-02-03T20:52:50.952812+05:30
Recovery created pluggable database PDB4
2022-02-03T20:53:08.208662+05:30
Recovery copied files for tablespace SYSTEM
Recovery successfully copied file /u02/app/oracle/oradata/PRIMARY19C/pdb4/system01.dbf from /u02/app/oracle/oradata/PRIMARY19C/pdbseed/system01.dbf
PDB4(5):WARNING: File being created with same name as in Primary
PDB4(5):Existing file may be overwritten
PDB4(5):Recovery created file /u02/app/oracle/oradata/PRIMARY19C/pdb4/system01.dbf
PDB4(5):Successfully added datafile 28 to media recovery
PDB4(5):Datafile #28: '/u02/app/oracle/oradata/PRIMARY19C/pdb4/system01.dbf'
2022-02-03T20:53:39.119703+05:30
Recovery copied files for tablespace SYSAUX
Recovery successfully copied file /u02/app/oracle/oradata/PRIMARY19C/pdb4/sysaux01.dbf from /u02/app/oracle/oradata/PRIMARY19C/pdbseed/sysaux01.dbf
PDB4(5):WARNING: File being created with same name as in Primary
PDB4(5):Existing file may be overwritten
PDB4(5):Recovery created file /u02/app/oracle/oradata/PRIMARY19C/pdb4/sysaux01.dbf
PDB4(5):Successfully added datafile 29 to media recovery
PDB4(5):Datafile #29: '/u02/app/oracle/oradata/PRIMARY19C/pdb4/sysaux01.dbf'
2022-02-03T20:53:45.814030+05:30
Recovery copied files for tablespace UNDOTBS1
Recovery successfully copied file /u02/app/oracle/oradata/PRIMARY19C/pdb4/undotbs01.dbf from /u02/app/oracle/oradata/PRIMARY19C/pdbseed/undotbs01.dbf
PDB4(5):WARNING: File being created with same name as in Primary
PDB4(5):Existing file may be overwritten
PDB4(5):Recovery created file /u02/app/oracle/oradata/PRIMARY19C/pdb4/undotbs01.dbf
PDB4(5):Successfully added datafile 30 to media recovery
PDB4(5):Datafile #30: '/u02/app/oracle/oradata/PRIMARY19C/pdb4/undotbs01.dbf'


Wednesday, 15 December 2021

Dataguard : Convert physical standby database to snapshot PDB database 12c version

 

Dataguard : Convert physical standby database to snapshot PDB database 12c version 

Scenario:

We have 2 node RAC with non rac physical standby database 

  • Login physical standby database and check the current status 

[oracle@srv4 rmanbkp]$ sqlplus / as sysdba


SQL*Plus: Release 12.2.0.1.0 Production on Wed Dec 15 12:38:12 2021


Copyright (c) 1982, 2016, Oracle.  All rights reserved.



Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production



SQL> @d


NAME   INSTANCE_NAME    DB_UNIQUE_NAME   OPEN_MODE        DATABASE_ROLE CURRENT_SCN    FAILOVER_SCN

--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------

RAC   racdr    racdr   MOUNTED        PHYSICAL STANDBY NO    0




  • Check switchover status of standby database 

SQL> select switchover_status from v$database;


SWITCHOVER_STATUS

--------------------

NOT ALLOWED


  • Checking sync status of standby database 

SQL> @/home/oracle/standby


NAME   OPEN_MODE        DATABASE_ROLE

--------- -------------------- ----------------

RAC   MOUNTED        PHYSICAL STANDBY


PROCESS   STATUS SEQUENCE#

--------- ------------ ----------

ARCH   CLOSING        32

DGRD   ALLOCATED 0

DGRD   ALLOCATED 0

ARCH   CLOSING        39

ARCH   CLOSING        40

ARCH   CLOSING        38

RFS   IDLE 0

RFS   IDLE        41

RFS   IDLE 0

RFS   IDLE 0

RFS   IDLE 0


PROCESS   STATUS SEQUENCE#

--------- ------------ ----------

RFS   IDLE 0

RFS   IDLE 0

RFS   IDLE        33

MRP0   APPLYING_LOG        33


15 rows selected.



    Thread Last Sequence Received Last Sequence Applied Difference

---------- ---------------------- --------------------- ----------

1        40      40 0

2        32      32 0


  • Stop MRP0 process and enable flashback on  in the database 


SQL> select flashback_on from v$database;


FLASHBACK_ON

------------------

NO



SQL> alter database recover managed standby database cancel;


Database altered.


SQL> alter database flashback on;


Database altered.


SQL> select flashback_on from v$database;


FLASHBACK_ON

------------------

YES

  • Increase retention target and db recovery file size as per requirements 

SQL> ALTER SYSTEM SET db_recovery_file_dest_size = 10G SCOPE = BOTH;


System altered.


SQL> ALTER SYSTEM SET db_flashback_retention_target = 10000 SCOPE = BOTH;


System altered.

  • Shut down standby database (optional ) and convert physical standby database into snapshot database Also open the database.

SQL> shut immediate;

ORA-01109: database not open



Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.


Total System Global Area 2432696320 bytes

Fixed Size     8795664 bytes

Variable Size   738200048 bytes

Database Buffers 1677721600 bytes

Redo Buffers     7979008 bytes

Database mounted.

SQL> sho pdbs                                   


    CON_ID CON_NAME   OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED   MOUNTED

3 RACPDB   MOUNTED

SQL> alter database convert to snapshot standby;


Database altered.


SQL> @d


NAME   INSTANCE_NAME    DB_UNIQUE_NAME   OPEN_MODE        DATABASE_ROLE CURRENT_SCN    FAILOVER_SCN

--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------

RAC   racdr    racdr   MOUNTED        SNAPSHOT STANDBY YES    3276602

  • Open now snapshot database it will be read write mode 

SQL> alter database open;


Database altered.


SQL> select name from v$datafile;


NAME

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

/u01/app/oracle/oradata/racdr/datafile/system.257.1088276431

/u01/app/oracle/oradata/racdr/datafile/sysaux.258.1088276477

/u01/app/oracle/oradata/racdr/datafile/undotbs1.259.1088276501

/u01/app/oracle/oradata/racdr/4700a987085b3dfae05387e5e50a8c7b/datafile/system.269.1088276619

/u01/app/oracle/oradata/racdr/4700a987085b3dfae05387e5e50a8c7b/datafile/sysaux.268.1088276619

/u01/app/oracle/oradata/racdr/datafile/users.260.1088276503

/u01/app/oracle/oradata/racdr/4700a987085b3dfae05387e5e50a8c7b/datafile/undotbs1.270.1088276619

/u01/app/oracle/oradata/racdr/datafile/undotbs2.272.1088276835

/u01/app/oracle/oradata/racdr/d0706a7d1c5f1532e0534738a8c0b3f6/datafile/system.280.1088277275

/u01/app/oracle/oradata/racdr/d0706a7d1c5f1532e0534738a8c0b3f6/datafile/sysaux.281.1088277275

/u01/app/oracle/oradata/racdr/d0706a7d1c5f1532e0534738a8c0b3f6/datafile/undotbs1.279.1088277275


NAME

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

/u01/app/oracle/oradata/racdr/d0706a7d1c5f1532e0534738a8c0b3f6/datafile/undo_2.319.1091217683

/u01/app/oracle/oradata/RACDR/D0706A7D1C5F1532E0534738A8C0B3F6/datafile/o1_mf_soetbs_jvk2n7gk_.dbf


13 rows selected.


SQL> select name from v$tempfile;


NAME

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

/u01/app/oracle/oradata/racdr/tempfile/temp.267.1088276611

/u01/app/oracle/oradata/racdr/d07045b084567d8be0534738a8c057cb/tempfile/temp.271.1088276639

/u01/app/oracle/oradata/racdr/d0706a7d1c5f1532e0534738a8c0b3f6/tempfile/temp.282.1088277333


SQL> @d


NAME   INSTANCE_NAME    DB_UNIQUE_NAME   OPEN_MODE        DATABASE_ROLE CURRENT_SCN    FAILOVER_SCN

--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------

RAC   racdr    racdr   READ WRITE        SNAPSHOT STANDBY YES    3276602


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   CLOSING 1

ARCH   CLOSING        33

LNS   CONNECTED 0

DGRD   ALLOCATED 0

RFS   IDLE 0

RFS   IDLE        42

RFS   IDLE 0


PROCESS   STATUS SEQUENCE#

--------- ------------ ----------

RFS   IDLE        34


12 rows selected.

  • In our case we have pdb standby database login to pdb and open in read write mode 

SQL> select con_id, name, open_mode, total_size from v$pdbs;


    CON_ID NAME     OPEN_MODE  TOTAL_SIZE

---------- -------------------------------------------------------------------------------------------------------------------------------- ---------- ----------

2 PDB$SEED     READ ONLY 744488960

3 RACPDB     MOUNTED 0


SQL> alter session set container=RACPDB;


Session altered.


SQL> select con_id, name, open_mode, total_size from v$pdbs;


    CON_ID NAME     OPEN_MODE  TOTAL_SIZE

---------- -------------------------------------------------------------------------------------------------------------------------------- ---------- ----------

3 RACPDB     MOUNTED 0


SQL> ALTER PLUGGABLE DATABASE OPEN READ WRITE;


Pluggable database altered.


SQL> select con_id, name, open_mode, total_size from v$pdbs;


    CON_ID NAME     OPEN_MODE  TOTAL_SIZE

---------- -------------------------------------------------------------------------------------------------------------------------------- ---------- ----------

3 RACPDB     READ WRITE 4091543552


  • For snapshot checking create table and insert the values on table 


SQL> create table soe.test1(id varchar2(255));


Table created.


SQL> insert into soe.test1 values(1);


1 row created.


SQL> /


1 row created.


SQL> /


1 row created.


SQL> /


1 row created.


SQL> /


1 row created.


SQL> select * from soe.test1;


ID

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

1

1

1

1

1


SQL> select con_id, name, open_mode, total_size from v$pdbs;


    CON_ID NAME     OPEN_MODE  TOTAL_SIZE

---------- -------------------------------------------------------------------------------------------------------------------------------- ---------- ----------

3 RACPDB     READ WRITE 4091543552


SQL> commit;


Commit complete.


SQL> @d


NAME   INSTANCE_NAME    DB_UNIQUE_NAME   OPEN_MODE        DATABASE_ROLE CURRENT_SCN    FAILOVER_SCN

--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------

RAC   racdr    racdr   READ WRITE        SNAPSHOT STANDBY YES    3276602


SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production



  • Here we can see pdb seed in read only mode and pdb is now in read write mode.


[oracle@srv4 rmanbkp]$ sqlplus / as sysdba


SQL*Plus: Release 12.2.0.1.0 Production on Wed Dec 15 13:34:06 2021


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 con_id, name, open_mode, total_size from v$pdbs;


    CON_ID

----------

NAME

----------------------------------------------------------------

OPEN_MODE  TOTAL_SIZE

---------- ----------

2

PDB$SEED

READ ONLY   744488960


3

RACPDB

READ WRITE 4091543552


    CON_ID

----------

NAME

--------------------------------------------------------------------------------

OPEN_MODE  TOTAL_SIZE

---------- ----------



SQL> set lines 200

SQL> /


    CON_ID NAME     OPEN_MODE  TOTAL_SIZE

---------- -------------------------------------------------------------------------------------------------------------------------------- ---------- ----------

2 PDB$SEED     READ ONLY 744488960

3 RACPDB     READ

 WRITE 4091543552



  • Shutdown down snapshot database database(optional) and convert back into physical standby database  

SQL> shut immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.


Total System Global Area 2432696320 bytes

Fixed Size     8795664 bytes

Variable Size   738200048 bytes

Database Buffers 1677721600 bytes

Redo Buffers     7979008 bytes

Database mounted.

SQL> sho pdbs                                   


    CON_ID CON_NAME   OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED   MOUNTED

3 RACPDB   MOUNTED

SQL> @d                                         


NAME   INSTANCE_NAME    DB_UNIQUE_NAME   OPEN_MODE        DATABASE_ROLE CURRENT_SCN    FAILOVER_SCN

--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------

RAC   racdr    racdr   MOUNTED        SNAPSHOT STANDBY YES    3276602


SQL> alter database convert to physical standby;


Database altered.


SQL> @d


NAME   INSTANCE_NAME    DB_UNIQUE_NAME   OPEN_MODE        DATABASE_ROLE CURRENT_SCN    FAILOVER_SCN

--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------

RAC   racdr    racdr   MOUNTED        PHYSICAL STANDBY YES    0


SQL> @/home/oracle/standby


NAME   OPEN_MODE        DATABASE_ROLE

--------- -------------------- ----------------

RAC   MOUNTED        PHYSICAL STANDBY



PROCESS   STATUS SEQUENCE#

--------- ------------ ----------

ARCH   CONNECTED 0

DGRD   ALLOCATED 0

DGRD   ALLOCATED 0

ARCH   CLOSING        42

ARCH   CLOSING        35

ARCH   CLOSING        43

RFS   IDLE 0

RFS   IDLE 0

RFS   IDLE        44

RFS   IDLE        36


10 rows selected.



    Thread Last Sequence Received Last Sequence Applied Difference

---------- ---------------------- --------------------- ----------

1        43      40 3

2        35       1 34


  • Start MRP0 process again to make sync with primary database 


SQL> alter database recover managed standby database disconnect from session;


Database altered.



SQL> @/home/oracle/standby


NAME   OPEN_MODE        DATABASE_ROLE

--------- -------------------- ----------------

RAC   MOUNTED        PHYSICAL STANDBY



PROCESS   STATUS SEQUENCE#

--------- ------------ ----------

ARCH   CLOSING        36

DGRD   ALLOCATED 0

DGRD   ALLOCATED 0

ARCH   CLOSING        44

ARCH   CLOSING        45

ARCH   CONNECTED 0

RFS   IDLE 0

RFS   IDLE 0

RFS   IDLE        46

RFS   IDLE        37

MRP0   APPLYING_LOG        46


11 rows selected.



    Thread Last Sequence Received Last Sequence Applied Difference

---------- ---------------------- --------------------- ----------

1        45      45 0

2        36      36 0


SQL> 


Tuesday, 5 October 2021

Dataguard : Setting protection mode from MAXIMUM PERFORMANCE to MAXIMUM AVAILABILITY

Data guard : Setting protection mode from MAXIMUM PERFORMANCE to MAXIMUM AVAILABILITY

Whenever we change the protection mode in primary database  it will automatically changed in standby database.

Before changing set  ASYNC to SYNC on log_archive_dest_2state. We set  protection mode  in mount state on primary database.

  • Connect primary database  check the current status 
 [oracle@srv6 admin]$ sqlplus / as sysdba


SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 23 16:31:53 2021

Version 19.3.0.0.0


Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0


SQL> select status,instance_name,database_role,protection_mode from v$database,v$instance;


STATUS       INSTANCE_NAME    DATABASE_ROLE    PROTECTION_MODE

------------ ---------------- ---------------- --------------------

OPEN         orcl12c          PRIMARY          MAXIMUM PERFORMANCE


SQL> sho parameter log_archive_dest_2


NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_2                   string      SERVICE=orcl12cdr LGWR ASYNC V

                                                 ALID_FOR=(ONLINE_LOGFILES,PRIM

                                                 ARY_ROLE) DB_UNIQUE_NAME=orcl1

                                                 2cdr

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


NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_27                  string

log_archive_dest_28                  string

log_archive_dest_29                  string


  • Change the value to AFFIRM SYNC state log_archive_dest_2 or standy destination location

SQL> alter system set log_archive_dest_2='service=orcl12cdr LGWR AFFIRM SYNC valid_for=(online_logfiles,primary_role) db_unique_name=orcl12cdr';


System altered.


SQL> sho parameter log_archive_dest_2


NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_2                   string      service=orcl12cdr LGWR AFFIRM

                                                 SYNC valid_for=(online_logfile

                                                 s,primary_role) db_unique_name

                                                 =orcl12cdr

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


NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_27                  string

log_archive_dest_28                  string

log_archive_dest_29                  string


  • Start primary database in mount stage and change value from MAXIMUM PERFORMANCE to MAXIMUM AVAILABILITY . Same as  MAXIMUM PROTECTION mode.
 

SQL> shut immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.


Total System Global Area 1862269648 bytes

Fixed Size                  9136848 bytes

Variable Size             687865856 bytes

Database Buffers         1157627904 bytes

Redo Buffers                7639040 bytes

Database mounted.

SQL> alter database set standby database to maximize availability;


Database altered.


SQL>  alter database open;


Database altered.


SQL> select status,instance_name,database_role,protection_mode from v$database,v$instance;


STATUS       INSTANCE_NAME    DATABASE_ROLE    PROTECTION_MODE

------------ ---------------- ---------------- --------------------

OPEN         orcl12c          PRIMARY          MAXIMUM AVAILABILITY


  • Standby database mode status before changes 
 

SQL> select status,instance_name,database_role,protection_mode from v$database,v$instance;

STATUS       INSTANCE_NAME    DATABASE_ROLE    PROTECTION_MODE
------------ ---------------- ---------------- --------------------
MOUNTED      orcl12cdr        PHYSICAL STANDBY MAXIMUM PERFORMANCE
  • Standby database mode after changes 

SQL> select status,instance_name,database_role,protection_mode from v$database,v$instance;

STATUS       INSTANCE_NAME    DATABASE_ROLE    PROTECTION_MODE
------------ ---------------- ---------------- --------------------
MOUNTED      orcl12cdr        PHYSICAL STANDBY MAXIMUM AVAILABILITY

SQL> select process, thread#, sequence#, status from v$managed_standby;

PROCESS      THREAD#  SEQUENCE# STATUS
--------- ---------- ---------- ------------
ARCH               1        305 CLOSING
DGRD               0          0 ALLOCATED
DGRD               0          0 ALLOCATED
ARCH               1        307 CLOSING
ARCH               1        304 CLOSING
ARCH               1        306 CLOSING
RFS                1          0 IDLE
RFS                1        308 IDLE
RFS                0          0 IDLE
RFS                0          0 IDLE

10 rows selected.

  • Apply recovery MRP after changes 

   
  
SQL> alter database recover managed standby database disconnect from session;

Database altered.

SQL> select process, thread#, sequence#, status from v$managed_standby;

PROCESS      THREAD#  SEQUENCE# STATUS
--------- ---------- ---------- ------------
ARCH               1        305 CLOSING
DGRD               0          0 ALLOCATED
DGRD               0          0 ALLOCATED
ARCH               1        307 CLOSING
ARCH               1        304 CLOSING
ARCH               1        306 CLOSING
RFS                1          0 IDLE
RFS                1        308 IDLE
RFS                0          0 IDLE
RFS                0          0 IDLE
MRP0               1        304 APPLYING_LOG

11 rows selected.


  • Check the sync status between primary and standby database
 
  
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#
;   2    3    4    5    6    7

    Thread Last Sequence Received Last Sequence Applied Difference
---------- ---------------------- --------------------- ----------
         1                    307                   307          0

SQL>

Monday, 4 October 2021

Dataguard: physical standby database restoration using full rman backup


Scenario Preview: Resolving gap between primary and physical standby database  resolved  by taking incremental backup  and perform recovery using rman incremental backup.

  • Query to check current SCN status of standby database. Run on standby DB.

SQL> SELECT CURRENT_SCN FROM V$DATABASE;


CURRENT_SCN

-----------

  339341431


SQL>  select min(fhscn) from x$kcvfh;


MIN(FHSCN)

----------------

339341432


SQL>  select min(f.fhscn) from x$kcvfh f, v$datafile d where f.hxfil =d.file# and d.enabled != 'READ ONLY';


MIN(F.FHSCN)

----------------

339341432

  • SCN  based  rman incremental backup  command below for reference.


run

{

allocate channel d0 type disk FORMAT 'backupscn_based%d_%s_%t.bak';

allocate channel d1 type disk FORMAT 'backupscn_based%d_%s_%t.bak';

allocate channel d2 type disk FORMAT 'backupscn_based%d_%s_%t.bak';

allocate channel d3 type disk FORMAT 'backupscn_based%d_%s_%t.bak';

backup as compressed backupset incremental from scn 339341432 database;

copy current controlfile to 'backupscn_basedcontrol01full_%d_%t_%U.bak';

backup current controlfile for standby format 'backupscn_basedstandbycontrol_%d_%T_%U.ctl';

RELEASE CHANNEL d0;

RELEASE CHANNEL d1;

RELEASE CHANNEL d2;

RELEASE CHANNEL d3;

}


  • Open database in nomount stage and restore control file 

[oracle@srv4 backup]$ . oraenv

ORACLE_SID = [ZABBIXDR] ?

The Oracle base remains unchanged with value /u01/app/oracle

[oracle@srv4 backup]$ sqlplus / as sysdba


SQL*Plus: Release 12.1.0.2.0 Production on Tue Jul 27 18:37:36 2021


Copyright (c) 1982, 2014, Oracle.  All rights reserved.



Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options


SQL> shut immediate;

ORA-01109: database not open



Database dismounted.

ORACLE instance shut down.

SQL> startup nomount;

ORACLE instance started.


Total System Global Area 1795162112 bytes

Fixed Size                  2925456 bytes

Variable Size             620760176 bytes

Database Buffers         1157627904 bytes

Redo Buffers               13848576 bytes

SQL> exit


Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

[oracle@srv4 backup]$ rman target /


Recovery Manager: Release 12.1.0.2.0 - Production on Tue Jul 27 18:40:44 2021


Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.


connected to target database: ZABBIX (not mounted)


RMAN> restore standby controlfile from '/u01/backup/standbycontrol_ZABBIX_1d051c76_1_1.ctl';

Starting restore at 27-JUL-21

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=23 device type=DISK

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

output file name=/u01/app/oracle/oradata/ZABBIXDR/control01.ctl

output file name=/u01/app/oracle/fast_recovery_area/ZABBIXDR/control02.ctl

Finished restore at 27-JUL-21

  • Open database in mount stage and restore  standby database 

RMAN> sql 'alter database mount standby database';


sql statement: alter database mount standby database

released channel: ORA_DISK_1


RMAN> catalog start with '/u01/backup';


Starting implicit crosscheck backup at 27-JUL-21

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=24 device type=DISK

Crosschecked 13 objects

Finished implicit crosscheck backup at 27-JUL-21


Starting implicit crosscheck copy at 27-JUL-21

using channel ORA_DISK_1

Crosschecked 6 objects

Finished implicit crosscheck copy at 27-JUL-21


searching for all files in the recovery area

cataloging files...

cataloging done


List of Cataloged Files

=======================

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/autobackup/2021_07_25/o1_mf_s_1078857835_jhts676p_.bkp

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/autobackup/2021_07_23/o1_mf_s_1078691869_jhopt5fk_.bkp

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/autobackup/2021_07_19/o1_mf_s_1078341966_jhc13pjr_.bkp

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_17/o1_mf_1_51_jh5txgn3_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_17/o1_mf_1_52_jh5w956q_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_27/o1_mf_1_33_jhz922g1_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_27/o1_mf_1_34_jhz923jb_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_27/o1_mf_1_32_jhz87wwc_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_27/o1_mf_1_35_jhzcszvk_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_27/o1_mf_1_31_jhz87yd4_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_26/o1_mf_1_29_jhxdgqjh_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_26/o1_mf_1_28_jhx8b6c8_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_26/o1_mf_1_26_jhx752c2_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_26/o1_mf_1_27_jhx754fs_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_26/o1_mf_1_25_jhx750kr_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_26/o1_mf_1_24_jhwmbsk6_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_26/o1_mf_1_30_jhxfy2os_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_21_jhtrwp8q_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_10_jhtr7176_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_11_jhtr72bt_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_12_jhtr73o7_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_23_jhts9kwh_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_9_jhtqv96b_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_15_jhtrmltg_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_17_jhtrnorq_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_19_jhtrwhvo_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_8_jhtqv8w7_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_16_jhtrmmh5_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_18_jhtrpgbr_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_13_jhtrmj20_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_20_jhtrwmnk_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_6_jhtpbq66_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_14_jhtrmlrt_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_22_jhts9jpq_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_7_jhtqjvr0_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_08/o1_mf_1_49_jgg446oc_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_23/o1_mf_1_2_jhokqtln_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_23/o1_mf_1_3_jhop0w97_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_23/o1_mf_1_4_jhop0wt0_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_23/o1_mf_1_5_jhopsvv9_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_19/o1_mf_1_54_jhbqjq1l_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_19/o1_mf_1_64_jhc0njy1_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_19/o1_mf_1_58_jhbw0yf3_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_19/o1_mf_1_61_jhbzy9yf_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_19/o1_mf_1_57_jhbw02oc_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_19/o1_mf_1_63_jhbzyc4y_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_19/o1_mf_1_53_jhbqjqf9_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_19/o1_mf_1_56_jhbvzxjs_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_19/o1_mf_1_60_jhbzy6vz_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_19/o1_mf_1_55_jhbr7mg0_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_19/o1_mf_1_62_jhbzy9xr_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_19/o1_mf_1_59_jhbw495f_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_19/o1_mf_1_1_jhc0tnhq_.arc


searching for all files that match the pattern /u01/backup


List of Files Unknown to the Database

=====================================

File Name: /u01/backup/standbycontrol_ZABBIX_1d051c76_1_1.ctl


Do you really want to catalog the above files (enter YES or NO)? yes

cataloging files...

cataloging done


List of Cataloged Files

=======================

File Name: /u01/backup/standbycontrol_ZABBIX_1d051c76_1_1.ctl


RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 20 BACKUP TYPE TO BACKUPSET;


new RMAN configuration parameters:

CONFIGURE DEVICE TYPE DISK PARALLELISM 20 BACKUP TYPE TO BACKUPSET;

new RMAN configuration parameters are successfully stored

released channel: ORA_DISK_1


RMAN>  RECOVER DATABASE NOREDO;


RMAN> select process,status,sequence# from v$managed_standby;


PROCESS   STATUS        SEQUENCE#

--------- ------------ ----------

ARCH      CONNECTED             0

ARCH      CONNECTED             0

ARCH      CONNECTED             0

ARCH      CONNECTED             0

  • Apply Media recovery process on standby database 

RMAN> alter database recover managed standby database disconnect from session;


Statement processed


RMAN> select process,status,sequence# from v$managed_standby;


PROCESS   STATUS        SEQUENCE#

--------- ------------ ----------

ARCH      CONNECTED             0

ARCH      CONNECTED             0

ARCH      CONNECTED             0

ARCH      CONNECTED             0

MRP0      WAIT_FOR_LOG          7




Dataguard - Restore standby database Using Full rman backup

Dataguard - Restore standby database Using Full  rman backup 


  • Create full rman backup on primary database.
  • SCP  backup file to standby database 
  • start standby database  in nomount stage
  • Restore standby control file from rman 
  • start db in mount stage
  • Catalog rman backup on standby database
  • Restore datbabase
  • Apply mrp process


  • Create full rman backup on primary database.


RMAN> run

{

allocate channel c1 device type disk format '/u01/rmanbkp/Backup_%d_DB_%u_%s_%p_%T';

2> 3> 4> 5> 6>

allocate channel c2 device type disk format '/u01/rmanbkp/Backup_%d_DB_%u_%s_%p_%T';


crosscheck backup;

crosscheck archivelog all;

report obsolete;

delete noprompt obsolete;

sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';


BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;


#backup full database format '/u01/rmanbkp/%d_%U.bckp' plus archivelog;

copy current controlfile to '/u01/rmanbkp/control_%d_%T.bak';

backup current controlfile for standby format '/u01/rmanbkp/standbycontrol_%d_%U.ctl';


release channel c1;


release channel c2;


}7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31>



[oracle@srv6 rmanbkp]$ ll


total 697904


-rw-r----- 1 oracle oinstall  11801088 Sep 15 17:04 Backup_ORCL12C_DB_0f0951pg_15_1_20210915

-rw-r----- 1 oracle oinstall   6962176 Sep 15 17:04 Backup_ORCL12C_DB_0g0951pg_16_1_20210915

-rw-r----- 1 oracle oinstall    836608 Sep 15 17:04 Backup_ORCL12C_DB_0h0951pn_17_1_20210915

-rw-r----- 1 oracle oinstall 215261184 Sep 15 17:07 Backup_ORCL12C_DB_0i0951po_18_1_20210915

-rw-r----- 1 oracle oinstall 115064832 Sep 15 17:06 Backup_ORCL12C_DB_0j0951po_19_1_20210915

-rw-r----- 1 oracle oinstall 110133248 Sep 15 17:08 Backup_ORCL12C_DB_0k0951t2_20_1_20210915

-rw-r----- 1 oracle oinstall 110051328 Sep 15 17:08 Backup_ORCL12C_DB_0l0951uf_21_1_20210915

-rw-r----- 1 oracle oinstall  54157312 Sep 15 17:08 Backup_ORCL12C_DB_0m0951vt_22_1_20210915

-rw-r----- 1 oracle oinstall  54157312 Sep 15 17:09 Backup_ORCL12C_DB_0n09521a_23_1_20210915

-rw-r----- 1 oracle oinstall    155136 Sep 15 17:09 Backup_ORCL12C_DB_0o095223_24_1_20210915

-rw-r----- 1 oracle oinstall  18006016 Sep 15 17:09 control_ORCL12C_20210915.bak

-rw-r----- 1 oracle oinstall  18055168 Sep 15 17:09 standbycontrol_ORCL12C_0q095226_1_1.ctl


  • Transfer rman backup to standby location 

[oracle@srv6 rmanbkp]$ scp * oracle@srv7:/u01/rmanbkp/

oracle@srv7's password:

Backup_ORCL12C_DB_0f0951pg_15_1_20210915                                                                                             100%   11MB  42.9MB/s   00:00

Backup_ORCL12C_DB_0g0951pg_16_1_20210915                                                                                            100% 6799KB  28.7MB/s   00:00

Backup_ORCL12C_DB_0h0951pn_17_1_20210915                                                                                             100%  817KB  26.0MB/s   00:00

Backup_ORCL12C_DB_0i0951po_18_1_20210915                                                                                             100%  205MB  52.3MB/s   00:03

Backup_ORCL12C_DB_0j0951po_19_1_20210915                                                                                             100%  110MB  48.7MB/s   00:02

Backup_ORCL12C_DB_0k0951t2_20_1_20210915                                                                                             100%  105MB  55.2MB/s   00:01

Backup_ORCL12C_DB_0l0951uf_21_1_20210915                                                                                             100%  105MB  56.2MB/s   00:01

Backup_ORCL12C_DB_0m0951vt_22_1_20210915                                                                                             100%   52MB  62.9MB/s   00:00

Backup_ORCL12C_DB_0n09521a_23_1_20210915                                                                                             100%   52MB  53.6MB/s   00:00

Backup_ORCL12C_DB_0o095223_24_1_20210915                                                                                             100%  152KB  20.6MB/s   00:00

control_ORCL12C_20210915.bak                                                                                                         100%   17MB  60.2MB/s   00:00

standbycontrol_ORCL12C_0q095226_1_1.ctl                                                                                              100%   17MB  53.3MB/s   00:00

[oracle@srv6 rmanbkp]$


  • Shut down and start standby database  in nomount stage

[oracle@srv7 rmanbkp]$ sqlplus / as sysdba


SQL*Plus: Release 12.1.0.2.0 Production on Wed Sep 15 17:28:17 2021


Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:


Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production


With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options


SQL> shut immediate;


ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup nomount;

ORACLE instance started.

Total System Global Area 1862270976 bytes

Fixed Size                  2925648 bytes

Variable Size             687868848 bytes

Database Buffers         1157627904 bytes

Redo Buffers               13848576 bytes

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production


With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options


  • Restore standby control file using rman backup 


[oracle@srv7 rmanbkp]$ rman target /


Recovery Manager: Release 12.1.0.2.0 - Production on Wed Sep 15 17:30:06 2021


Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.


connected to target database: ORCL12C (not mounted)


RMAN>  restore standby controlfile from '/u01/rmanbkp/standbycontrol_ORCL12C_0q095226_1_1.ctl'


2> ;


Starting restore at 2021-09-15:17:30:11


using target database control file instead of recovery catalog


allocated channel: ORA_DISK_1


channel ORA_DISK_1: SID=23 device type=DISK


channel ORA_DISK_1: restoring control file


channel ORA_DISK_1: restore complete, elapsed time: 00:00:01


output file name=/u01/app/oracle/oradata/orcl12cdr/control01.ctl


output file name=/u01/app/oracle/fast_recovery_area/orcl12cdr/control02.ctl


Finished restore at 2021-09-15:17:30:13


Open standby database in mount stage


RMAN> alter database mount standby database;


Statement processed


released channel: ORA_DISK_1

RMAN> catalog start with '/u01/rmanbkp';


Starting implicit crosscheck backup at 2021-09-15:17:30:44


allocated channel: ORA_DISK_1


channel ORA_DISK_1: SID=33 device type=DISK


Crosschecked 18 objects


Finished implicit crosscheck backup at 2021-09-15:17:30:45


Starting implicit crosscheck copy at 2021-09-15:17:30:45


using channel ORA_DISK_1


Crosschecked 2 objects


Finished implicit crosscheck copy at 2021-09-15:17:30:45


searching for all files in the recovery area


cataloging files...


cataloging done


List of Cataloged Files


=======================


File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_08_31/o1_mf_1_20_jlw664wb_.arc


File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_08_31/o1_mf_1_22_jlw6652v_.arc


File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_08_31/o1_mf_1_14_jlvrvoj6_.arc


File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_08_31/o1_mf_1_21_jlw6651s_.arc


File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_08_31/o1_mf_1_25_jlw6cjvw_.arc


File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_08_31/o1_mf_1_24_jlw6chrb_.arc


File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_08_31/o1_mf_1_23_jlw6650r_.arc


File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_09_15/o1_mf_1_26_jn39jqxc_.arc


File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_09_15/o1_mf_1_34_jn3pkflm_.arc


File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_09_15/o1_mf_1_27_jn39jpz2_.arc


File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_09_15/o1_mf_1_31_jn3b7hkv_.arc


File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_09_15/o1_mf_1_28_jn39zbn9_.arc


File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_09_15/o1_mf_1_37_jn3pvclg_.arc


File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_09_15/o1_mf_1_30_jn3b7ggn_.arc


File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_09_15/o1_mf_1_32_jn3myjq8_.arc


File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_09_15/o1_mf_1_36_jn3plqmh_.arc


File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_09_15/o1_mf_1_33_jn3nmy9l_.arc


File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_09_15/o1_mf_1_35_jn3plq71_.arc


File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_09_15/o1_mf_1_29_jn39zcpj_.arc


File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_08_27/o1_mf_1_12_jlkjmqwy_.arc


File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_08_27/o1_mf_1_13_jlkjnw8r_.arc


File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_08_27/o1_mf_1_11_jlkjm2o3_.arc


searching for all files that match the pattern /u01/rmanbkp


List of Files Unknown to the Database


=====================================


File Name: /u01/rmanbkp/standbycontrol_ORCL12C_0q095226_1_1.ctl


Do you really want to catalog the above files (enter YES or NO)? yes


cataloging files...


cataloging done



List of Cataloged Files


=======================


File Name: /u01/rmanbkp/standbycontrol_ORCL12C_0q095226_1_1.ctl


  • When full backup restoration on standby database 

RMAN> restore database;


Starting restore at 2021-09-15:17:30:54


using channel ORA_DISK_1


skipping datafile 5; already restored to file /u01/app/oracle/oradata/orcl12cdr/pdbseed/system01.dbf


skipping datafile 7; already restored to file /u01/app/oracle/oradata/orcl12cdr/pdbseed/sysaux01.dbf


channel ORA_DISK_1: starting datafile backup set restore


channel ORA_DISK_1: specifying datafile(s) to restore from backup set


channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/orcl12cdr/sysaux01.dbf


channel ORA_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/orcl12cdr/users01.dbf


channel ORA_DISK_1: reading from backup piece /u01/rmanbkp/Backup_ORCL12C_DB_0j0951po_19_1_20210915


channel ORA_DISK_1: piece handle=/u01/rmanbkp/Backup_ORCL12C_DB_0j0951po_19_1_20210915 tag=TAG20210915T170456


channel ORA_DISK_1: restored backup piece 1


channel ORA_DISK_1: restore complete, elapsed time: 00:00:35


channel ORA_DISK_1: starting datafile backup set restore


channel ORA_DISK_1: specifying datafile(s) to restore from backup set


channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/orcl12cdr/system01.dbf


channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/orcl12cdr/undotbs01.dbf


channel ORA_DISK_1: reading from backup piece /u01/rmanbkp/Backup_ORCL12C_DB_0i0951po_18_1_20210915


channel ORA_DISK_1: piece handle=/u01/rmanbkp/Backup_ORCL12C_DB_0i0951po_18_1_20210915 tag=TAG20210915T170456


channel ORA_DISK_1: restored backup piece 1


channel ORA_DISK_1: restore complete, elapsed time: 00:00:55


channel ORA_DISK_1: starting datafile backup set restore


channel ORA_DISK_1: specifying datafile(s) to restore from backup set


channel ORA_DISK_1: restoring datafile 00009 to /u01/app/oracle/oradata/orcl12cdr/pdb12c/sysaux01.dbf


channel ORA_DISK_1: reading from backup piece /u01/rmanbkp/Backup_ORCL12C_DB_0k0951t2_20_1_20210915


channel ORA_DISK_1: piece handle=/u01/rmanbkp/Backup_ORCL12C_DB_0k0951t2_20_1_20210915 tag=TAG20210915T170456


channel ORA_DISK_1: restored backup piece 1


channel ORA_DISK_1: restore complete, elapsed time: 00:00:35


channel ORA_DISK_1: starting datafile backup set restore


channel ORA_DISK_1: specifying datafile(s) to restore from backup set


channel ORA_DISK_1: restoring datafile 00008 to /u01/app/oracle/oradata/orcl12cdr/pdb12c/system01.dbf


channel ORA_DISK_1: restoring datafile 00010 to /u01/app/oracle/oradata/orcl12cdr/pdb12c/pdb12c_users01.dbf


channel ORA_DISK_1: reading from backup piece /u01/rmanbkp/Backup_ORCL12C_DB_0m0951vt_22_1_20210915


channel ORA_DISK_1: piece handle=/u01/rmanbkp/Backup_ORCL12C_DB_0m0951vt_22_1_20210915 tag=TAG20210915T170456


channel ORA_DISK_1: restored backup piece 1


channel ORA_DISK_1: restore complete, elapsed time: 00:00:15


Finished restore at 2021-09-15:17:33:15


  • Apply media recovery process to using command below

RMAN> alter database recover managed standby database disconnect from session;


Statement processed


RMAN> exit


Recovery Manager complete.


[oracle@srv7 rmanbkp]$ sqlplus / as sysdba


SQL*Plus: Release 12.1.0.2.0 Production on Wed Sep 15 17:53:34 2021


Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:


Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production


With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options


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


NAME      OPEN_MODE            DATABASE_ROLE


--------- -------------------- ----------------


ORCL12C   MOUNTED              PHYSICAL STANDBY


SQL> select process,status,sequence# from v$managed_standby;


PROCESS   STATUS        SEQUENCE#


--------- ------------ ----------


ARCH      CONNECTED             0


ARCH      CONNECTED             0


ARCH      CONNECTED             0


ARCH      CONNECTED             0


RFS       IDLE                 38


RFS       IDLE                  0


MRP0      APPLYING_LOG         38


7 rows selected.


SQL>