PSU and OJVM PATCH on RAC 12c R1 Database not grid PART -2

Step 1:



stop database services
[root@srv1 28689146]# srvctl stop database -d rac

Step 2 :

Take backup of oracle home if not done earlier

Step 3 :

Set path

[oracle@srv1 28440711]$ export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_2
[oracle@srv1 28440711]$ export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin
[oracle@srv1 28440711]$ export PATH=$ORACLE_HOME/perl/bin:$PATH


STEP 4:

[oracle@srv1 28440711]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_2
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/dbhome_2/oraInst.loc
OPatch version    : 12.2.0.1.16
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/opatch2019-05-31_16-19-02PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[oracle@srv1 28440711]$

STEP 5:

[oracle@srv1 28440711]$ opatch apply  (Apply on both node1 and node 2)
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_2
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/dbhome_2/oraInst.loc
OPatch version    : 12.2.0.1.16
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/opatch2019-05-31_16-20-33PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   28440711

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.1.0/dbhome_2')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '28440711' to OH '/u01/app/oracle/product/12.1.0/dbhome_2'
ApplySession: Optional component(s) [ oracle.sqlj, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.javavm.server, 12.1.0.2.0...

Patching component oracle.javavm.server.core, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.javavm.client, 12.1.0.2.0...

Patching component oracle.dbjava.jdbc, 12.1.0.2.0...

Patching component oracle.dbjava.ic, 12.1.0.2.0...
Patch 28440711 successfully applied.
Log file location: /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/opatch2019-05-31_16-20-33PM_1.log

OPatch succeeded.
[oracle@srv1 28440711]$

STEP 6:

[root@srv1 28689146]# srvctl start database -d rac

STEP 7 :

[oracle@srv1 28440711]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri May 31 16:55:49 2019

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, Real Application Clusters, Automatic Storage Management, OLAP,

Advanced Analytics and Real Application Testing options

SQL> alter system set cluster_database=false scope=spfile;

System altered.

STEP 8:

[root@srv1 28689146]# srvctl  stop database -d rac

STEP 9: 

[oracle@srv1 28440711]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri May 31 17:02:34 2019

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

Connected to an idle instance.

SQL> startup upgrade
ORACLE instance started.

Total System Global Area 1795162112 bytes
Fixed Size                  2925456 bytes
Variable Size             553651312 bytes
Database Buffers         1224736768 bytes
Redo Buffers               13848576 bytes
Database mounted.
Database opened.
SQL>

STEP 10 :

[oracle@srv1 28440711]$ cd $ORACLE_HOME/OPatch

[oracle@srv1 OPatch]$ ./datapatch -verbose

SQL Patching tool version 12.1.0.2.0 Production on Fri May 31 17:05:13 2019

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

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_19179_2019_05_31_17_05_13/sqlpatch_invocation.log

Connecting to database...OK

Bootstrapping registry and package to current versions...done

Determining current state...done

Current state of SQL patches:

Patch 28440711 (Database PSU 12.1.0.2.181016, Oracle JavaVM Component (OCT2018)):

  Installed in the binary registry only

Bundle series PSU:

  ID 181016 in the binary registry and ID 181016 in the SQL registry

Adding patches to installation queue and performing prereq checks...

Installation queue:

  Nothing to roll back

  The following patches will be applied:

    28440711 (Database PSU 12.1.0.2.181016, Oracle JavaVM Component (OCT2018))

Installing patches...

Patch installation complete.  Total patches installed: 1

Validating logfiles...

Patch 28440711 apply: SUCCESS

  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/28440711/22440644/28440711_apply_RAC_2019May31_17_05_53.log (no errors)

SQL Patching tool complete on Fri May 31 17:13:53 2019

[oracle@srv1 OPatch]$

STEP 11:

sqlplus /nolog

SQL> CONNECT / AS SYSDBA

SQL> alter system set cluster_database=true scope=spfile;

SQL> SHUTDOWN

$ORACLE_HOME/bin/srvctl start database -d rac

STEP 12:

[oracle@srv2 28440711]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Fri May 31 17:34:29 2019 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, Real Application Clusters, Automatic Storage Management, OLAP, Advanced Analytics and Real Application Testing options SQL> set lines 200 SQL> select BUNDLE_SERIES,PATCH_UID,PATCH_ID,VERSION,ACTION,STATUS,ACTION_TIME ,DESCRIPTION from dba_registry_sqlpatch; BUNDLE_SERIES PATCH_UID PATCH_ID VERSION ACTION STATUS ACTION_TIME ------------------------------ ---------- ---------- -------------------- --------------- --------------- --------------------------------------------------------------------------- DESCRIPTION ---------------------------------------------------------------------------------------------------- PSU 22488632 28259833 12.1.0.2 APPLY SUCCESS 31-MAY-19 01.28.27.449554 PM DATABASE PATCH SET UPDATE 12.1.0.2.181016 22440644 28440711 12.1.0.2 APPLY SUCCESS 31-MAY-19 05.13.52.200557 PM Database PSU 12.1.0.2.181016, Oracle JavaVM Component (OCT2018) SQL>

PSU and OJVM Patch on RAC 12c Database only not grid part 1

STEP1 :

Download Patch from oracle support.

p28689146_121020_Linux-x86-64.zip

p6880880_121010_Linux-x86-64.zip

[root@srv1 28689146]#

STEP 2 : 

Copy p6880880 patch to Oracle Home
[root@srv1 u01]# cp p6880880_121010_Linux-x86-64.zip /u01/app/oracle/product/12.1.0/dbhome_2/
[root@srv1 u01]# cd /u01/app/oracle/product/12.1.0/dbhome_2/

STEP 3 : 

OPatch status before unzip p6880880_121010_Linux-x86-64.zip

[oracle@srv1 OPatch]$ . oraenv
ORACLE_SID = [+ASM1] ? rac1
The Oracle base has been changed from /u01/app/grid to /u01/app/oracle
[oracle@srv1 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.3
Copyright (c) 2019, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_2
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/dbhome_2/oraInst.loc
OPatch version    : 12.1.0.1.3
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/opatch2019-05-31_12-23-38PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/lsinv/lsinventory2019-05-31_12-23-38PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Database 12c                                                  12.1.0.2.0
There are 1 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.


Rac system comprising of multiple nodes
  Local node = srv1
  Remote node = srv2

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

OPatch succeeded.
[oracle@srv1 OPatch]$

STEP 4 :

[oracle@srv1 dbhome_2]$ unzip p6880880_121010_Linux-x86-64.zip



[oracle@srv1 dbhome_2]$ mv OPatch/ OPatch_old

STEP 5:

Check Opatch status after unzip p6880880_121010_Linux-x86-64.zip on oracle home

[oracle@srv1 dbhome_2]$ cd OPatch
[oracle@srv1 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_2
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/dbhome_2/oraInst.loc
OPatch version    : 12.2.0.1.16
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/opatch2019-05-31_12-31-35PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/lsinv/lsinventory2019-05-31_12-31-35PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: srv1.example.com
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c                                                  12.1.0.2.0
There are 1 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.


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

OPatch succeeded.
[oracle@srv1 OPatch]$
########################################################################################


STEP 6:

Check Opatch status after unzip p6880880_121010_Linux-x86-64.zip on GRID home

[grid@srv1 OPatch]$ . oraenv
ORACLE_SID = [rac1] ? +ASM1
The Oracle base has been changed from /u01/app/oracle to /u01/app/grid
[grid@srv1 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.3
Copyright (c) 2019, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/12.1.0/grid/oraInst.loc
OPatch version    : 12.1.0.1.3
OUI version       : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2019-05-31_12-33-23PM_1.log

Lsinventory Output file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2019-05-31_12-33-23PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Grid Infrastructure 12c                                       12.1.0.2.0
There are 1 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.


Patch level status of Cluster nodes :

 Patching Level                  Nodes
 --------------                  -----
 0                               srv1,srv2

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

OPatch succeeded.
[grid@srv1 OPatch]$

STEP 7:
Stop database using SRVCTL utility

[root@srv1 oracle]# srvctl status database -d rac
Instance rac1 is running on node srv1
Instance rac2 is running on node srv2
[root@srv1 oracle]# srvctl stop database -d rac


STEP 8:
Take backup of oracle home

[oracle@srv1 12.1.0]$ tar -cvzf dbhome_2.tar.gz dbhome_2

STEP 9:

Set Environment variable  before applying patch:

[oracle@srv2 28259833]$ export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_2
[oracle@srv2 28259833]$ export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin
[oracle@srv2 28259833]$ export PATH=$ORACLE_HOME/perl/bin:$PATH

STEP 10:

Apply Pre -Requestories check command below :

[oracle@srv2 28259833]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_2
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/dbhome_2/oraInst.loc
OPatch version    : 12.2.0.1.16
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/opatch2019-05-31_12-55-27PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[oracle@srv2 28259833]$


STEP 11:

Apply Patch

[oracle@srv1 28259833]$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_2
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/dbhome_2/oraInst.loc
OPatch version    : 12.2.0.1.16
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/opatch2019-05-31_12-59-01PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   19769480  20299023  20831110  21359755  21948354  22291127  23054246  24006101  24732082  25171037  25755742  26609783  26713565  26925311  27338041  27547329  28259833

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.1.0/dbhome_2')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '19769480' to OH '/u01/app/oracle/product/12.1.0/dbhome_2'


chmod: changing permissions of `/u01/app/oracle/product/12.1.0/dbhome_2/bin/extjobO': Operation not permitted
make: [iextjob] Error 1 (ignored)

DOCID : 2265726.1

Composite patch 28259833 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/opatch2019-05-31_12-59-01PM_1.log

OPatch completed with warnings.

STEP 12:

Start the database services

[root@srv1 u01]# srvctl start database -d rac
[root@srv1 u01]# crsctl status resource -t

STEP 13:

sqlplus prompt login
[oracle@srv1 28259833]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri May 31 13:19:22 2019

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, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

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

NAME      OPEN_MODE            DATABASE_ROLE
--------- -------------------- ----------------
RAC       READ WRITE           PRIMARY

SQL> exit


#################################################################################

STEP 14 :

Apply data patch verbose  (check html file for instruction also). |No need to run datapatch verbose on 2nd node.


[oracle@srv1 OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 Production on Fri May 31 13:24:22 2019
Copyright (c) 2012, 2016, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_22774_2019_05_31_13_24_22/sqlpatch_invocation.log

Connecting to database...OK
Bootstrapping registry and package to current versions...done
Determining current state...
done

Current state of SQL patches:
Bundle series PSU:
  ID 181016 in the binary registry and not installed in the SQL registry

Adding patches to installation queue and performing prereq checks...
Installation queue:
  Nothing to roll back
  The following patches will be applied:
    28259833 (DATABASE PATCH SET UPDATE 12.1.0.2.181016)

Installing patches...
Patch installation complete.  Total patches installed: 1

Validating logfiles...
Patch 28259833 apply: SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/28259833/22488632/28259833_apply_RAC_2019May31_13_25_31.log (no errors)
SQL Patching tool complete on Fri May 31 13:28:27 2019
[oracle@srv1 OPatch]$


STEP 15:

Check Opatch lsinventory

[oracle@srv1 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_2
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/dbhome_2/oraInst.loc
OPatch version    : 12.2.0.1.16
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/opatch2019-05-31_13-29-56PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/lsinv/lsinventory2019-05-31_13-29-56PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: srv1.example.com
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c                                                  12.1.0.2.0
There are 1 products installed in this Oracle Home.


Interim patches (1) :

Patch  28259833     : applied on Fri May 31 13:07:52 IST 2019
Unique Patch ID:  22488632
Patch description:  "Database Patch Set Update : 12.1.0.2.181016 (28259833)"
   Created on 8 Oct 2018, 06:11:15 hrs PST8PDT
Sub-patch  27547329; "Database Patch Set Update : 12.1.0.2.180717 (27547329)"
Sub-patch  27338041; "Database Patch Set Update : 12.1.0.2.180417 (27338041)"
Sub-patch  26925311; "Database Patch Set Update : 12.1.0.2.180116 (26925311)"
Sub-patch  26713565; "Database Patch Set Update : 12.1.0.2.171017 (26713565)"
Sub-patch  26609783; "Database Patch Set Update : 12.1.0.2.170814 (26609783)"
Sub-patch  25755742; "Database Patch Set Update : 12.1.0.2.170718 (25755742)"
Sub-patch  25171037; "Database Patch Set Update : 12.1.0.2.170418 (25171037)"
Sub-patch  24732082; "Database Patch Set Update : 12.1.0.2.170117 (24732082)"
Sub-patch  24006101; "Database Patch Set Update : 12.1.0.2.161018 (24006101)"
Sub-patch  23054246; "Database Patch Set Update : 12.1.0.2.160719 (23054246)"
Sub-patch  22291127; "Database Patch Set Update : 12.1.0.2.160419 (22291127)"
Sub-patch  21948354; "Database Patch Set Update : 12.1.0.2.160119 (21948354)"
Sub-patch  21359755; "Database Patch Set Update : 12.1.0.2.5 (21359755)"
Sub-patch  20831110; "Database Patch Set Update : 12.1.0.2.4 (20831110)"
Sub-patch  20299023; "Database Patch Set Update : 12.1.0.2.3 (20299023)"
Sub-patch  19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"
   Bugs fixed:
     19309466, 19902195, 18250893, 25437699, 19383839, 16756406, 18456643
     26546664, 22364044, 18845653, 19915271, 20172151, 18417036, 23713236
     24796092, 23140259, 19243521, 19658708, 18272672, 21153266, 19174430
     22243719, 20688221, 20493163, 21387964, 13542050, 22734547, 21623164
     19012119, 19932634, 19869255, 22232606, 18681056, 23324000, 25427662
     22068305, 24589081, 19439759, 19303936, 22916353, 24835538, 22353346
     21106027, 26444887, 23088803, 22529728, 26256131, 19134173, 20447445
     21188584, 19390567, 26513709, 25780343, 19769480, 21097043, 21225209
     26245237, 20677396, 19284031, 19450314, 19016730, 20919320, 22075064
     22551446, 22721409, 18440095, 22496904, 16439813, 18354830, 20596234
     22022760, 20936905, 23197103, 21514877, 26111842, 18990023, 22492533
     20173897, 24624166, 17210525, 21260431, 20181030, 25056052, 19370504
     21868720, 23068169, 19124589, 19402853, 19888853, 24341675, 17722075
     20882568, 25653109, 23026585, 18604692, 20717081, 25546608, 27370965
     19081128, 22173980, 23514710, 19178851, 20951038, 22168163, 25161298
     20569094, 24308635, 19791377, 19050649, 20920911, 19189525, 19469538
     27052607, 20598042, 22458049, 18988834, 23302839, 25307368, 17409174
     22729345, 22842151, 19238590, 16941434, 20387265, 24397438, 20673810
     23108128, 20356733, 22380919, 18436647, 23065323, 20825533, 19124336
     22294260, 24790914, 20284155, 25539063, 17365043, 25914276, 20952966
     22961508, 19176223, 21300341, 23237313, 18288842, 22353199, 22083366
     25670786, 21419850, 26898563, 19577410, 23294548, 24737064, 19931709
     25423453, 25547060, 23533807, 27726780, 24600330, 25600421, 18122373
     20043616, 23124895, 18856999, 21450666, 18893947, 20076781, 26633558
     26029780, 21196809, 21354456, 23725036, 20464614, 19562381, 24808595
     27375542, 19189317, 25669791, 18307021, 21917884, 19708632, 27213224
     25633101, 20711718, 18973548, 25982666, 19718981, 22826718, 25655390
     23567857, 21773465, 20250147, 19197175, 26263721, 19597439, 21387128
     22007324, 19180770, 19879746, 21785691, 20424183, 24285405, 26544823
     20322560, 22228324, 23172924, 22520320, 21575362, 25058080, 22365117
     22645009, 25165496, 18774543, 20124446, 21429602, 26153977, 19371175
     21863727, 18940497, 19074147, 22923409, 25489342, 21380789, 19154375
     19044962, 19532017, 19662635, 22374754, 20560611, 25654936, 21492036
     18705806, 19578247, 22024071, 22238921, 22809871, 21184223, 23089357
     19404068, 18921743, 19065677, 19018447, 19018206, 18308268, 19777862
     22223463, 19304354, 22519146, 27199245, 20890311, 22977256, 21142837
     20869721, 24555417, 22179537, 21756699, 20217801, 18819908, 22760595
     25483815, 23007241, 19593445, 21080143, 27351628, 20031873, 18618122
     24737581, 26784509, 24739928, 18966843, 19077215, 20704450, 19068970
     20543011, 19023822, 24713381, 20432873, 21756677, 20328248, 18674047
     18849537, 25459958, 20315311, 22897344, 27534509, 25178179, 19308965
     18948177, 19468991, 20868862, 21780146, 20466628, 21756661, 20397490
     23315153, 19706965, 20302006, 24831514, 23240358, 22178855, 19032777
     20862087, 19329654, 18974476, 20603378, 20859910, 19307662, 21847223
     20281121, 19075256, 19076343, 18866977, 22808310, 25635149, 20844426
     20904530, 20441797, 21442094, 25079710, 24674955, 18840932, 18740837
     20294666, 25602488, 21517440, 22062517, 27337759, 19174942, 20671094
     21889720, 18411216, 20117253, 24386767, 20641666, 25264559, 22092979
     21625179, 20879709, 23003979, 20165574, 19272708, 19547370, 22624709
     23084507, 20228093, 21281532, 19805359, 19461270, 19434529, 18799063
     20378086, 17008068, 21246723, 20831538, 20424899, 20361671, 18674024
     19689979, 24411921, 19873610, 16619249, 20562898, 21641414, 21091431
     19440586, 22757364, 22175564, 21241052, 20725343, 19561643, 20736227
     19399918, 19195895, 20830459, 20017509, 25790353, 21828126, 21665897
     25555252, 20746251, 25764020, 25612095, 25357142, 23096938, 19067244
     18043064, 21329301, 18885870, 26243698, 26187943, 20324049, 19536415
     23709062, 28174827, 20446883, 27314206, 21299490, 25313154, 21744290
     18254023, 20591183, 27847259, 19185876, 27207110, 22465352, 24326444
     20402832, 19627012, 27441326, 27620950, 16863642, 19639483, 19315691
     21479753, 19174521, 20401975, 18306996, 18851894, 27034890, 20581111
     20318889, 20936731, 21060755, 26828994, 22256560, 19188927, 27229389
     24570598, 25475853, 21172913, 17655240, 21266085, 19028800, 19035573
     19366375, 24523374, 25034396, 19289642, 21291274, 18007682, 23521523
     20475845, 22148226, 22528741, 25417958, 24652769, 26088426, 19326908
     19597583, 17414008, 23019710, 20897759, 26822620, 22046677, 20938170
     24825843, 19891090, 21960504, 26318627, 24509056, 19054077, 26262953
     22657942, 20428621, 21899588, 19723336, 19835133, 17532734, 19333670
     21842017, 19285025, 21373473, 23260854, 19687159, 23061453, 14643995
     20977794, 20734332, 17551063, 27548131, 21977392, 24461826, 19676012
     20588502, 23315889, 19520602, 23053606, 19841800, 20245930, 19001359
     21476308, 26546754, 19393542, 23533524, 21099555, 25429959, 19141838
     19644859, 21915719, 19908836, 21421886, 19358317, 19524158, 23548817
     25861398, 20803014, 23025340, 19335438, 19058490, 19207117, 23642282
     18799993, 25919622, 26569225, 20835241, 24662775, 19475971, 18967382
     20347562, 20348653, 19896336, 24812585, 20048359, 21896069, 19524384
     25392535, 21147908, 20440930, 25789277, 19171086, 24718260, 17867700
     19791273, 21241829, 19591608, 22707244, 18419520, 22296366, 18914624
     19571367, 22654475, 21522582, 19501299, 20425790, 19708342, 27997875
     16870214, 18202441, 24415926, 18743542, 19001390, 21875360, 25091141
     28000269, 19149990, 20382309, 22855193, 16777441, 19606174, 20848335
     25495682, 19382851, 20528052, 22762046, 24563422, 23125826, 22503297
     25192729, 23338911, 22730454, 19176326, 19048007, 18849970, 21532755
     20860659, 22905130, 21263635, 22160989, 18499088, 21059919, 18952989
     22894949, 22518784, 25856821, 25484507, 20794034, 19468347, 17533661
     19883092, 20657441, 24401351, 21285458, 18051556, 25330273, 19699191
     24437510, 20669434, 18964978, 22972770, 20828947, 21373076, 25551676
     25492379, 14283239, 25766822, 22922076, 25575628, 20368850, 21239530
     20437153, 24848928, 20880215, 20798891, 25606091, 19013183, 21133343
     22695831, 24365589, 25634317, 19587324, 20273319, 18542562, 26758193
     21063322, 22062026, 20134339, 22077517, 22815955, 24690216, 22507210
     20101006, 16354467, 21795111, 27938623, 23501901, 18797519, 25879984
     21260397, 25029423, 19354335, 19730508, 22366558, 26658759, 6599380
     20717359, 24321547, 21297872, 18964939, 26366517, 21913183, 22366322
     20171986, 20603431, 21132297, 25957038, 21542577, 22507234, 23170620
     24719736, 25600342, 18868646, 20627866, 26637824, 18110491, 16923858
     24642295, 19518079, 20466322, 25823754, 25110233, 24908321, 20842388
     17274537, 26575788, 20474192, 21644640, 21794615, 18899974, 20471920
     22806698, 19052488, 19503821, 24350620, 20074391, 19157754, 21220620
     24316947, 19865345, 19065556, 22816287, 25947799, 20878790, 23492665
     21322887, 22305887, 20879889, 24350831, 19578350, 19363645, 21072646
     20898391, 19291380, 27060167, 27086138, 22536802, 22087683, 21656630
     20373598, 19248799, 22707866, 19155797, 19279273, 18886413, 25490238
     20922010, 19990037, 25150925, 20509482, 24717859, 20703000, 22862134
     21526048, 24929210, 24560906, 20144308, 21620471, 19670108, 19068610
     20267166, 25123585, 20476175, 18549238, 22950945, 19385656, 23528412
     19684504, 21174504, 20899461, 20557786, 21911701, 19143550, 20118035
     19024808, 25760195, 20009833, 19604659, 16359751, 26039623, 19928926
     23314180, 20212067, 24737403, 20480209, 26430737, 20856766, 27169796
     21668627, 20877664, 19487147, 23149541, 24577566, 19430401, 19676905
     20925795, 21296029, 21629064, 23229229, 22865673, 20708701, 25353983
     19280225, 21315084, 19213447, 19989009, 18191823, 27314390, 25775213
     24393981, 25639019, 17319928, 19703301, 21626377, 20122715, 6418158
     23105538, 26198926, 19258504, 21188532, 23151677, 17890099, 21649497
     26446098, 16887946, 26024732, 18791688, 19721304, 19490948, 27012701
     19619732, 21164318, 18090142, 21641760, 19818513, 20139391, 24693382
     19978542, 23543183, 22165897, 22359063, 19409212, 23035249, 18990693
     20470877, 21422580, 21632821, 22351572, 20235511, 23220453, 18604493
     23008056, 22901797, 18610915, 20832516, 24801152, 26089440, 20907061
     20505778, 19183343, 21787056, 21273804, 25093739, 17835294, 24413809
     18371441, 26714910, 24385983, 20413820, 24421668, 25897615, 25643931
     23195445, 21281607, 20513399, 20558005, 20093776, 18909599, 20618595
     23572982, 19211433, 20331945, 19512341, 22256431, 19637186, 19022470
     18607546, 24573817, 19649152, 23115139, 19201867, 21294938, 20898997
     18510194, 21842740, 22454326, 24683149, 19534363, 25489607



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

OPatch succeeded.


STEP 16 :

Check dba_registry_sqlpatch

[oracle@srv1 OPatch]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri May 31 13:30:53 2019

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, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL> set lines 200
SQL> select BUNDLE_SERIES,PATCH_UID,PATCH_ID,VERSION,ACTION,STATUS,ACTION_TIME ,DESCRIPTION from dba_registry_sqlpatch;

BUNDLE_SERIES                   PATCH_UID   PATCH_ID VERSION              ACTION          STATUS          ACTION_TIME
------------------------------ ---------- ---------- -------------------- --------------- --------------- ---------------------------------------------------------------------------
DESCRIPTION
----------------------------------------------------------------------------------------------------
PSU                              22488632   28259833 12.1.0.2             APPLY           SUCCESS         31-MAY-19 01.28.27.449554 PM
DATABASE PATCH SET UPDATE 12.1.0.2.181016


SQL>

Drop ASM DISKGROUP and RAW Partitions and Re create partions

[root@srv1 bin]# oracleasm listdisks
CRS1
CRS2
CRS3
DATA1
DATA2
FRA1
FRA2
[root@srv1 bin]# oracleasm listdis
oracleasm: 'listdis' is not an oracleasm command
Usage: oracleasm [--exec-path=<exec_path>] <command> [ <args> ]
       oracleasm --exec-path
       oracleasm -h
       oracleasm -V

The basic oracleasm commands are:
    configure        Configure the Oracle Linux ASMLib driver
    init             Load and initialize the ASMLib driver
    exit             Stop the ASMLib driver
    scandisks        Scan the system for Oracle ASMLib disks
    status           Display the status of the Oracle ASMLib driver
    listdisks        List known Oracle ASMLib disks
    querydisk        Determine if a disk belongs to Oracle ASMlib
    createdisk       Allocate a device for Oracle ASMLib use
    deletedisk       Return a device to the operating system
    renamedisk       Change the label of an Oracle ASMlib disk
    update-driver    Download the latest ASMLib driver
[root@srv1 bin]# oracleasm deletedisk CRS1
Clearing disk header: done
Dropping disk: done
[root@srv1 bin]# oracleasm deletedisk CRS2
Clearing disk header: done
Dropping disk: done
[root@srv1 bin]# oracleasm deletedisk CRS3
Clearing disk header: done
Dropping disk: done
[root@srv1 bin]# oracleasm deletedisk DATA1
Clearing disk header: done
Dropping disk: done
[root@srv1 bin]# oracleasm deletedisk DATA2
Clearing disk header: done
Dropping disk: done
[root@srv1 bin]# oracleasm deletedisk FRA1
Clearing disk header: done
Dropping disk: done
[root@srv1 bin]# oracleasm deletedisk FRA2
Clearing disk header: done
Dropping disk: done
[root@srv1 bin]# ls -ltr
total 0
[root@srv1 bin]# oracleasm listdisks
[root@srv1 bin]# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
[root@srv1 bin]# fdisk -l

Disk /dev/sda: 64.4 GB, 64424509440 bytes
255 heads, 63 sectors/track, 7832 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x000513aa

   Device Boot      Start         End      Blocks   Id  System
/dev/sda1   *           1          64      512000   83  Linux
Partition 1 does not end on cylinder boundary.
/dev/sda2              64        7833    62401536   8e  Linux LVM

Disk /dev/sdb: 10.7 GB, 10737418240 bytes
255 heads, 63 sectors/track, 1305 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x15451787

   Device Boot      Start         End      Blocks   Id  System
/dev/sdb1               1        1305    10482381   83  Linux

Disk /dev/sdc: 10.7 GB, 10737418240 bytes
255 heads, 63 sectors/track, 1305 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0xf6963cd6

   Device Boot      Start         End      Blocks   Id  System
/dev/sdc1               1        1305    10482381   83  Linux

Disk /dev/sdd: 10.7 GB, 10737418240 bytes
255 heads, 63 sectors/track, 1305 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x0c4dbca0

   Device Boot      Start         End      Blocks   Id  System
/dev/sdd1               1        1305    10482381   83  Linux

Disk /dev/sde: 16.1 GB, 16106127360 bytes
255 heads, 63 sectors/track, 1958 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0xc0c03d86

   Device Boot      Start         End      Blocks   Id  System
/dev/sde1               1        1958    15727603+  83  Linux

Disk /dev/sdf: 16.1 GB, 16106127360 bytes
255 heads, 63 sectors/track, 1958 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x1d31fcab

   Device Boot      Start         End      Blocks   Id  System
/dev/sdf1               1        1958    15727603+  83  Linux

Disk /dev/sdg: 16.1 GB, 16106127360 bytes
255 heads, 63 sectors/track, 1958 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0xb47d192e

   Device Boot      Start         End      Blocks   Id  System
/dev/sdg1               1        1958    15727603+  83  Linux

Disk /dev/sdh: 16.1 GB, 16106127360 bytes
255 heads, 63 sectors/track, 1958 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0xcd8530bd

   Device Boot      Start         End      Blocks   Id  System
/dev/sdh1               1        1958    15727603+  83  Linux

Disk /dev/mapper/vg_srv1-lv_root: 52.5 GB, 52495908864 bytes
255 heads, 63 sectors/track, 6382 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000


Disk /dev/mapper/vg_srv1-lv_swap: 6274 MB, 6274678784 bytes
255 heads, 63 sectors/track, 762 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000


Disk /dev/mapper/vg_srv1-lv_home: 5125 MB, 5125439488 bytes
255 heads, 63 sectors/track, 623 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000

#################################################################################
[root@srv1 bin]# fdisk /dev/sdc

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to
         switch off the mode (command 'c') and change display units to
         sectors (command 'u').

Command (m for help): d
Selected partition 1

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.
[root@srv1 bin]#

[root@srv1 bin]# fdisk /dev/sdd

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to

         switch off the mode (command 'c') and change display units to

         sectors (command 'u').

Command (m for help): d

Selected partition 1

Command (m for help): 1

1: unknown command

Command action

   a   toggle a bootable flag

   b   edit bsd disklabel

   c   toggle the dos compatibility flag

   d   delete a partition

   l   list known partition types

   m   print this menu

   n   add a new partition

   o   create a new empty DOS partition table

   p   print the partition table

   q   quit without saving changes

   s   create a new empty Sun disklabel

   t   change a partition's system id

   u   change display/entry units

   v   verify the partition table

   w   write table to disk and exit

   x   extra functionality (experts only)

Command (m for help): w

The partition table has been altered!

Calling ioctl() to re-read partition table.

Syncing disks.

[root@srv1 bin]#

[root@srv1 bin]# fdisk /dev/sde

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to

         switch off the mode (command 'c') and change display units to

         sectors (command 'u').

Command (m for help): d

Selected partition 1

Command (m for help): 1

1: unknown command

Command action

   a   toggle a bootable flag

   b   edit bsd disklabel

   c   toggle the dos compatibility flag

   d   delete a partition

   l   list known partition types

   m   print this menu

   n   add a new partition

   o   create a new empty DOS partition table

   p   print the partition table

   q   quit without saving changes

   s   create a new empty Sun disklabel

   t   change a partition's system id

   u   change display/entry units

   v   verify the partition table

   w   write table to disk and exit

   x   extra functionality (experts only)

Command (m for help): w

The partition table has been altered!

Calling ioctl() to re-read partition table.

Syncing disks.

[root@srv1 bin]# fdisk /dev/sdf

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to

         switch off the mode (command 'c') and change display units to

         sectors (command 'u').

Command (m for help): d

Selected partition 1

Command (m for help): w

The partition table has been altered!

Calling ioctl() to re-read partition table.

Syncing disks.

[root@srv1 bin]# fdisk /dev/sdg

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to

         switch off the mode (command 'c') and change display units to

         sectors (command 'u').

Command (m for help): d

Selected partition 1

Command (m for help): w

The partition table has been altered!

Calling ioctl() to re-read partition table.

Syncing disks.

[root@srv1 bin]# fdisk /dev/sdh

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to

         switch off the mode (command 'c') and change display units to

         sectors (command 'u').

Command (m for help):

Command (m for help):

Command (m for help):

Command (m for help): d

Selected partition 1

Command (m for help): w

The partition table has been altered!

Calling ioctl() to re-read partition table.

Syncing disks.

[root@srv1 bin]#

#################################################################################

[root@srv1 bin]# dd if=/dev/zero of=/dev/sdb1 bs=1024 count=100
100+0 records in
100+0 records out
102400 bytes (102 kB) copied, 0.00301702 s, 33.9 MB/s
[root@srv1 bin]# dd if=/dev/zero of=/dev/sdc1 bs=1024 count=100
100+0 records in
100+0 records out
102400 bytes (102 kB) copied, 0.00180986 s, 56.6 MB/s
[root@srv1 bin]# dd if=/dev/zero of=/dev/sdd1 bs=1024 count=100
100+0 records in
100+0 records out
102400 bytes (102 kB) copied, 0.00186649 s, 54.9 MB/s
[root@srv1 bin]# dd if=/dev/zero of=/dev/sde1 bs=1024 count=100
100+0 records in
100+0 records out
102400 bytes (102 kB) copied, 0.00353268 s, 29.0 MB/s
[root@srv1 bin]# dd if=/dev/zero of=/dev/sdf1 bs=1024 count=100
100+0 records in
100+0 records out
102400 bytes (102 kB) copied, 0.00200719 s, 51.0 MB/s
[root@srv1 bin]# dd if=/dev/zero of=/dev/sdg1 bs=1024 count=100
100+0 records in
100+0 records out
102400 bytes (102 kB) copied, 0.00218414 s, 46.9 MB/s
[root@srv1 bin]# dd if=/dev/zero of=/dev/sdh1 bs=1024 count=100
100+0 records in
100+0 records out
102400 bytes (102 kB) copied, 0.00203797 s, 50.2 MB/s
[root@srv1 bin]#

##################################################################

[root@srv1 bin]# fdisk /dev/sdb

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to

         switch off the mode (command 'c') and change display units to

         sectors (command 'u').

Command (m for help): n

Command action

   e   extended

   p   primary partition (1-4)

p

Partition number (1-4): 1

First cylinder (1-1305, default 1):

Using default value 1

Last cylinder, +cylinders or +size{K,M,G} (1-1305, default 1305):

Using default value 1305

Command (m for help): w

The partition table has been altered!

Calling ioctl() to re-read partition table.

Syncing disks.

[root@srv1 bin]# fdisk /dev/sdc

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to

         switch off the mode (command 'c') and change display units to

         sectors (command 'u').

Command (m for help): n

Command action

   e   extended

   p   primary partition (1-4)

p

Partition number (1-4): 1

First cylinder (1-1305, default 1):

Using default value 1

Last cylinder, +cylinders or +size{K,M,G} (1-1305, default 1305):

Using default value 1305

Command (m for help): w

The partition table has been altered!

Calling ioctl() to re-read partition table.

Syncing disks.

[root@srv1 bin]# fdisk /dev/sdd

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to

         switch off the mode (command 'c') and change display units to

         sectors (command 'u').

Command (m for help): n

Command action

   e   extended

   p   primary partition (1-4)

p

Partition number (1-4): 1

First cylinder (1-1305, default 1):

Using default value 1

Last cylinder, +cylinders or +size{K,M,G} (1-1305, default 1305):

Using default value 1305

Command (m for help): w

The partition table has been altered!

Calling ioctl() to re-read partition table.

Syncing disks.

[root@srv1 bin]# fdisk /dev/sde

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to

         switch off the mode (command 'c') and change display units to

         sectors (command 'u').

Command (m for help): n

Command action

   e   extended

   p   primary partition (1-4)

p

Partition number (1-4): 1

First cylinder (1-1958, default 1):

Using default value 1

Last cylinder, +cylinders or +size{K,M,G} (1-1958, default 1958):

Using default value 1958

Command (m for help): w

The partition table has been altered!

Calling ioctl() to re-read partition table.

Syncing disks.

[root@srv1 bin]# fdisk /dev/sdf

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to

         switch off the mode (command 'c') and change display units to

         sectors (command 'u').

Command (m for help): n

Command action

   e   extended

   p   primary partition (1-4)

p

Partition number (1-4): 1

First cylinder (1-1958, default 1):

Using default value 1

Last cylinder, +cylinders or +size{K,M,G} (1-1958, default 1958):

Using default value 1958

Command (m for help): w

The partition table has been altered!

Calling ioctl() to re-read partition table.

Syncing disks.

[root@srv1 bin]# fdisk /dev/sdg

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to

         switch off the mode (command 'c') and change display units to

         sectors (command 'u').

Command (m for help): n

Command action

   e   extended

   p   primary partition (1-4)

p

Partition number (1-4):

Value out of range.

Partition number (1-4):

Value out of range.

Partition number (1-4): 1

First cylinder (1-1958, default 1):

Using default value 1

Last cylinder, +cylinders or +size{K,M,G} (1-1958, default 1958):

Using default value 1958

Command (m for help): w

The partition table has been altered!

Calling ioctl() to re-read partition table.

Syncing disks.

[root@srv1 bin]# fdisk /dev/sdh

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to

         switch off the mode (command 'c') and change display units to

         sectors (command 'u').

Command (m for help): n

Command action

   e   extended

   p   primary partition (1-4)

p

Partition number (1-4): 1

First cylinder (1-1958, default 1):

Using default value 1

Last cylinder, +cylinders or +size{K,M,G} (1-1958, default 1958):

Using default value 1958

Command (m for help): w

The partition table has been altered!

Calling ioctl() to re-read partition table.

Syncing disks.

[root@srv1 bin]# fdisk -l

Disk /dev/sda: 64.4 GB, 64424509440 bytes

255 heads, 63 sectors/track, 7832 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x000513aa

   Device Boot      Start         End      Blocks   Id  System

/dev/sda1   *           1          64      512000   83  Linux

Partition 1 does not end on cylinder boundary.

/dev/sda2              64        7833    62401536   8e  Linux LVM

Disk /dev/sdb: 10.7 GB, 10737418240 bytes

255 heads, 63 sectors/track, 1305 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x15451787

   Device Boot      Start         End      Blocks   Id  System

/dev/sdb1               1        1305    10482381   83  Linux

Disk /dev/sdc: 10.7 GB, 10737418240 bytes

255 heads, 63 sectors/track, 1305 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0xf6963cd6

   Device Boot      Start         End      Blocks   Id  System

/dev/sdc1               1        1305    10482381   83  Linux

Disk /dev/sdd: 10.7 GB, 10737418240 bytes

255 heads, 63 sectors/track, 1305 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x0c4dbca0

   Device Boot      Start         End      Blocks   Id  System

/dev/sdd1               1        1305    10482381   83  Linux

Disk /dev/sde: 16.1 GB, 16106127360 bytes

255 heads, 63 sectors/track, 1958 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0xc0c03d86

   Device Boot      Start         End      Blocks   Id  System

/dev/sde1               1        1958    15727603+  83  Linux

Disk /dev/sdf: 16.1 GB, 16106127360 bytes

255 heads, 63 sectors/track, 1958 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x1d31fcab

   Device Boot      Start         End      Blocks   Id  System

/dev/sdf1               1        1958    15727603+  83  Linux

Disk /dev/sdg: 16.1 GB, 16106127360 bytes

255 heads, 63 sectors/track, 1958 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0xb47d192e

   Device Boot      Start         End      Blocks   Id  System

/dev/sdg1               1        1958    15727603+  83  Linux

Disk /dev/sdh: 16.1 GB, 16106127360 bytes

255 heads, 63 sectors/track, 1958 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0xcd8530bd

   Device Boot      Start         End      Blocks   Id  System

/dev/sdh1               1        1958    15727603+  83  Linux

Disk /dev/mapper/vg_srv1-lv_root: 52.5 GB, 52495908864 bytes

255 heads, 63 sectors/track, 6382 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x00000000

Disk /dev/mapper/vg_srv1-lv_swap: 6274 MB, 6274678784 bytes

255 heads, 63 sectors/track, 762 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x00000000

Disk /dev/mapper/vg_srv1-lv_home: 5125 MB, 5125439488 bytes

255 heads, 63 sectors/track, 623 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x00000000

[root@srv1 bin]#

DNS configuration for RAC setup 12 R1

(note related to nameserver)

chkconfig iptables off

chkconfig ip6tables off

service iptables stop

service ip6tables stop

vi /etc/selinux/config

change SELinux=enforcing to SELinux=disabled

yum install bind bind-chroot caching-nameserver

:~# chattr +i /etc/resolv.conf (to make permanent entry on resolv.conf entry)
########################################################################
[root@smrprodb1 named]# cat /etc/resolv.conf
# Generated by NetworkManager
search example.com
nameserver srv-scan.example.com
domain example.com
########################################################################
# No nameservers found; try putting DNS servers into your
# ifcfg files in /etc/sysconfig/network-scripts like so:
#
# DNS1=xxx.xxx.xxx.xxx
# DNS2=xxx.xxx.xxx.xxx
# DOMAIN=lab.foo.com bar.foo.com
[root@smrprodb1 named]#
########################################################################

[root@smrprodb1 named]# cat /var/named/chroot/etc/named.conf
//
// named.conf
//
// Provided by Red Hat bind package to configure the ISC BIND named(8) DNS
// server as a caching only nameserver (as a localhost DNS resolver only).
//
// See /usr/share/doc/bind*/sample/ for example named configuration files.
//

options {
# listen-on port 53 { 127.0.0.1; 20.198.242.116; };
# listen-on-v6 port 53 { ::1; };
directory "/var/named";
dump-file "/var/named/data/cache_dump.db";
statistics-file "/var/named/data/named_stats.txt";
memstatistics-file "/var/named/data/named_mem_stats.txt";
allow-query { localhost; 20.198.242.0/24; };
recursion yes;

dnssec-enable yes;
dnssec-validation yes;
dnssec-lookaside auto;

/* Path to ISC DLV key */
bindkeys-file "/etc/named.iscdlv.key";
};

logging {
channel default_debug {
file "data/named.run";
severity dynamic;
};
};

zone "example.com" IN {
type master;
file "forward.zone";
};

zone "56.168.192.in-addr.arpa" IN {
type master;
file "reverse.zone";
};
[root@smrprodb1 named]#

###############################################################
[root@smrprodb1 named]# cat forward.zone
; /var/named/chroot/var/named/forward.zone
$TTL 86400
@ IN SOA srv-scan.example.com. root.srv-scan.example.com. (
     0 ; serial
     1D ; refresh
     1H ; retry
     1W ; expire
     3H ) ; minimum
     IN NS srv-scan.example.com.
srv-scan A 192.168.56.91
srv-scan A 192.168.56.92
srv-scan A 192.168.56.93
[root@smrprodb1 named]#

###############################################################
[root@smrprodb1 named]# cat reverse.zone
;  /var/named/chroot/var/named/reverse.zone
$TTL 86400
@ IN SOA srv-scan.example.com. root.srv-scan.example.com. (
    0 ; serial
    1D ; refresh
    1H ; retry
    1W ; expire
    3H ) ; minimum
    NS srv-scan.example.com.
91 PTR srv-scan.example.com.
92 PTR srv-scan.example.com.
93 PTR srv-scan.example.com.
##############################################################
[root@smrprodb1 named]#
[root@smrprodb1 etc]# cat named.rfc1912.zones
// See /usr/share/doc/bind*/sample/ for example named configuration files.
//
zone "." IN {
type hint;
file "named.ca";
};
zone "example.com" IN {
type master;
file "forward.zone";
allow-update { none; };
};
zone "localhost" IN {
type master;
file "localhost.zone";
allow-update { none; };
};
zone "56.168.192.in-addr.arpa" IN {
type master;
file "reverse.zone";
allow-update { none; };
};
#zone "0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.ip6.arpa" IN {
#type master;
#file "named.ip6.local";
#allow-update { none; };
#};
zone "255.in-addr.arpa" IN {
type master;
file "named.broadcast";
allow-update { none; };
};
#zone "0.in-addr.arpa" IN {
#type master;Oracle 11gR2 RAC On VM - INSTALLATION
#www.reachdba.com | www.dbalounge.com | info@dbalounge.com | 011-40581394
#file "named.zero";
#allow-update { none; };
#};
[root@smrprodb1 etc]#


 service named start
 service named status
chkconfig named on

##########################################################################

Hosts entry details

[root@srv1 named]# cat /etc/hosts
127.0.0.1   localhost.localdomain localhost
# Public
192.168.56.71   srv1.example.com        srv1
192.168.56.72   srv2.example.com        srv2

# Private
192.168.10.1    srv1-priv.example.com   srv1-priv
192.168.10.2    srv2-priv.example.com   srv2-priv

# Virtual
192.168.56.81   srv1-vip.example.com    srv1-vip
192.168.56.82   srv2-vip.example.com    srv2-vip

# SCAN (in production this should be configured in DNS)
192.168.56.91   srv-scan.example.com    srv-scan
192.168.56.92   srv-scan.example.com    srv-scan
192.168.56.93   srv-scan.example.com    srv-scan

[root@srv1 named]#

OUTPUT:

[root@srv1 etc]#  nslookup srv-scan
Server:         127.0.0.1
Address:        127.0.0.1#53

Name:   srv-scan.example.com
Address: 192.168.56.92
Name:   srv-scan.example.com
Address: 192.168.56.93
Name:   srv-scan.example.com
Address: 192.168.56.91

[root@srv1 etc]#  nslookup srv-scan
Server:         127.0.0.1
Address:        127.0.0.1#53

Name:   srv-scan.example.com
Address: 192.168.56.93
Name:   srv-scan.example.com
Address: 192.168.56.91
Name:   srv-scan.example.com
Address: 192.168.56.92

[root@srv1 etc]#  nslookup srv-scan
Server:         127.0.0.1
Address:        127.0.0.1#53

Name:   srv-scan.example.com
Address: 192.168.56.91
Name:   srv-scan.example.com
Address: 192.168.56.92
Name:   srv-scan.example.com
Address: 192.168.56.93

[root@srv1 etc]#

restore rman linux to window

Restore From Windows To Linux using RMAN Fails (Doc ID 2003327.1)

Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. All rights reserved.

C:\Windows\system32>D:

D:\>
D:\>
D:\>
D:\>
D:\>
D:\>
D:\>
D:\>
D:\>
D:\>sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 16 13:12:08 2019

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

D:\>sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 16 13:14:17 2019

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

Connected to an idle instance.

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 8.2678E+10 bytes
Fixed Size                  7774968 bytes
Variable Size            1.2885E+10 bytes
Database Buffers         6.9525E+10 bytes
Redo Buffers              260657152 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

D:\>rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Tue Apr 16 13:16:49 2019

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

connected to target database: SMRPRODB (not mounted)

RMAN> restore standby controlfile from 'D:\rman_backup_smrprodb\standbycontrol_SMRPRODB_20190416_latv3rcd_1_1.ctl';

Starting restore at 16-APR-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=430 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\CONTROL01.CTL
output file name=D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\CONTROL02.CTL
Finished restore at 16-APR-19

RMAN> alter database mount;

Statement processed
released channel: ORA_DISK_1

RMAN> alter dataabse mount standby database;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 04/16/2019 13:19:15
ORA-00940: invalid ALTER command

RMAN> shutdown immediate;

database dismounted
Oracle instance shut down

RMAN> exit


Recovery Manager complete.

D:\>sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 16 13:20:06 2019

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

Connected to an idle instance.

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 8.2678E+10 bytes
Fixed Size                  7774968 bytes
Variable Size            1.2885E+10 bytes
Database Buffers         6.9525E+10 bytes
Redo Buffers              260657152 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

D:\>rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Tue Apr 16 13:22:25 2019

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

connected to target database: SMRPRODB (not mounted)

RMAN> restore standby controlfile from 'D:\rman_backup_smrprodb\standbycontrol_SMRPRODB_20190416_latv3rcd_1_1.ctl';

Starting restore at 16-APR-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=430 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\CONTROL01.CTL
output file name=D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\CONTROL02.CTL
Finished restore at 16-APR-19

RMAN> sql 'alter database mount standby database';

sql statement: alter database mount standby database
released channel: ORA_DISK_1

RMAN> catalog start with 'D:\rman_backup_smrprodb';

Starting implicit crosscheck backup at 16-APR-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=482 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=508 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=521 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=534 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=547 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=560 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=573 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=586 device type=DISK
allocated channel: ORA_DISK_9
channel ORA_DISK_9: SID=599 device type=DISK
allocated channel: ORA_DISK_10
channel ORA_DISK_10: SID=612 device type=DISK
allocated channel: ORA_DISK_11
channel ORA_DISK_11: SID=625 device type=DISK
allocated channel: ORA_DISK_12
channel ORA_DISK_12: SID=638 device type=DISK
allocated channel: ORA_DISK_13
channel ORA_DISK_13: SID=651 device type=DISK
allocated channel: ORA_DISK_14
channel ORA_DISK_14: SID=664 device type=DISK
allocated channel: ORA_DISK_15
channel ORA_DISK_15: SID=677 device type=DISK
allocated channel: ORA_DISK_16
channel ORA_DISK_16: SID=690 device type=DISK
allocated channel: ORA_DISK_17
channel ORA_DISK_17: SID=703 device type=DISK
allocated channel: ORA_DISK_18
channel ORA_DISK_18: SID=716 device type=DISK
allocated channel: ORA_DISK_19
channel ORA_DISK_19: SID=729 device type=DISK
allocated channel: ORA_DISK_20
channel ORA_DISK_20: SID=742 device type=DISK
Crosschecked 28 objects
Finished implicit crosscheck backup at 16-APR-19

Starting implicit crosscheck copy at 16-APR-19
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
using channel ORA_DISK_9
using channel ORA_DISK_10
using channel ORA_DISK_11
using channel ORA_DISK_12
using channel ORA_DISK_13
using channel ORA_DISK_14
using channel ORA_DISK_15
using channel ORA_DISK_16
using channel ORA_DISK_17
using channel ORA_DISK_18
using channel ORA_DISK_19
using channel ORA_DISK_20
Crosschecked 2 objects
Finished implicit crosscheck copy at 16-APR-19

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_05\O1_MF_1_13_GBGGMS1R_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_05\O1_MF_1_14_GBGGMS83_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_05\O1_MF_1_15_GBGGN5CL_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_05\O1_MF_1_16_GBGNCNB6_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_10_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_11_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_12_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_13_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_14_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_15_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_16_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_17_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_18_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_19_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_1_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_20_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_21_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_22_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_23_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_24_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_25_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_26_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_27_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_2_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_3_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_4_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_5_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_6_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_7_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_8_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_9_1005460847.ARC

searching for all files that match the pattern D:\rman_backup_smrprodb

List of Files Unknown to the Database
=====================================
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_01TRRD87_7169_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_02TRRD87_7170_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_03TRRD8B_7171_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0ATRRD8U_7178_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0DTRTIA2_7181_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0ETRTIA2_7182_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0FTRTIA2_7183_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0GTRTIA2_7184_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0HTRTIA5_7185_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0ITRTIA5_7186_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0PTRTIAP_7193_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0STRVVL6_7196_1_20190309
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0TTRVVL6_7197_1_20190309
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0UTRVVL6_7198_1_20190309
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0VTRVVL6_7199_1_20190309
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_10TRVVL9_7200_1_20190309
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_17TRVVLV_7207_1_20190309
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1ATS2K16_7210_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1BTS2K16_7211_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1CTS2K16_7212_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1DTS2K16_7213_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1ETS2K19_7214_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1FTS2K1C_7215_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1MTS2K22_7222_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_GDTUN01V_7693_1_20190411
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_GKTUN02J_7700_1_20190411
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_GNTUPKD6_7703_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_GRTUPKDV_7707_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_H2TUPKEJ_7714_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_H5TUQJNQ_7717_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_H7TUQJNQ_7719_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_H8TUQJNQ_7720_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_H9TUQJNT_7721_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HATUQJNT_7722_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HHTUQJOI_7729_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HKTUS5RN_7732_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HLTUS5RN_7733_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HMTUS5RN_7734_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HNTUS5RN_7735_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HOTUS5RO_7736_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HVTUS5SE_7743_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_I2TUS7IQ_7746_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_I3TUS7IQ_7747_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_I4TUS7IQ_7748_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_I5TUS7IQ_7749_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_I6TUS7IT_7750_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_I7TUS7IT_7751_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_IETUS7JF_7758_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_IHTUS8P0_7761_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_IITUS8P0_7762_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_IJTUS8P0_7763_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_IKTUS8P0_7764_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_ILTUS8P3_7765_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_IMTUS8P3_7766_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_ITTUS8PM_7773_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_J0TUUT50_7776_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_J1TUUT50_7777_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_J2TUUT50_7778_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_J3TUUT50_7779_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_J4TUUT57_7780_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_J5TUUT57_7781_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JCTUUT5P_7788_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JFTV1HH0_7791_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JGTV1HH0_7792_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JHTV1HH0_7793_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JITV1HH0_7794_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JJTV1HH7_7795_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JKTV1HH7_7796_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JRTV1HHQ_7803_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JUTV1RGP_7806_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JVTV1RGP_7807_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_K0TV1RGP_7808_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_K1TV1RGP_7809_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_K2TV1RGS_7810_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_K3TV1RGT_7811_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KATV1RHF_7818_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KFTV2EO4_7823_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KITV2EO8_7826_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KPTV2EOK_7833_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KSTV3RBH_7836_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KTTV3RBH_7837_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KUTV3RBH_7838_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KVTV3RBH_7839_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_L0TV3RBO_7840_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_L1TV3RBO_7841_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_L8TV3RCB_7848_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_ULTRNO6Q_7125_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_USTRNO7C_7132_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_UTTRNO7C_7133_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_UUTRNO7C_7134_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_UVTRNO7C_7135_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_V0TRNO7C_7136_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_V7TRO9JE_7143_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_VETRO9KI_7150_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_VLTRQTV9_7157_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_VSTRQU0B_7164_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_VVTRRD87_7167_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190412_CF_D-SMRPRODB_ID-3201394995_HITUQJOJ.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190413_CF_D-SMRPRODB_ID-3201394995_I0TUS5SF.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190413_CF_D-SMRPRODB_ID-3201394995_IFTUS7JG.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190413_CF_D-SMRPRODB_ID-3201394995_IUTUS8PN.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190414_CF_D-SMRPRODB_ID-3201394995_JDTUUT5Q.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190415_CF_D-SMRPRODB_ID-3201394995_JSTV1HHR.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190415_CF_D-SMRPRODB_ID-3201394995_KBTV1RHG.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190416_CF_D-SMRPRODB_ID-3201394995_L9TV3RCC.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\RMAN_SMRPRODB_FULL.LOG
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRIDE_FULL.LOG
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRMINDDEV_FULL.LOG
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_04TRRD8C_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_05TRRD8C_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_06TRRD8C_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_07TRRD8C_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_09TRRD8E_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_0JTRTIA6_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_0KTRTIA6_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_0LTRTIA6_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_0MTRTIA6_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_0NTRTIA7_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_0OTRTIA8_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_11TRVVLC_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_12TRVVLC_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_13TRVVLC_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_14TRVVLC_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_15TRVVLD_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_16TRVVLF_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_1GTS2K1E_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_1HTS2K1E_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_1ITS2K1E_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_1JTS2K1E_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_1KTS2K1F_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_1LTS2K1I_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_FULL.LOG
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HBTUQJNV_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HCTUQJNV_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HDTUQJNV_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HETUQJNV_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HGTUQJO1_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HPTUS5RR_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HQTUS5RR_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HRTUS5RR_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HSTUS5RR_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HTTUS5RT_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HUTUS5RU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_I8TUS7IU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_I9TUS7IU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IATUS7IU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IBTUS7IU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_ICTUS7IV_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IDTUS7J0_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_INTUS8P4_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IOTUS8P4_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IPTUS8P4_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IQTUS8P4_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IRTUS8P5_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_ISTUS8P6_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_J6TUUT58_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_J7TUUT58_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_J8TUUT58_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_J9TUUT58_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JATUUT59_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JBTUUT5A_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JLTV1HH8_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JMTV1HH8_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JNTV1HH8_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JOTV1HH8_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JPTV1HHA_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JQTV1HHB_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_K4TV1RGU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_K5TV1RGU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_K6TV1RGU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_K7TV1RGU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_K8TV1RGV_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_K9TV1RH0_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_KJTV2EOA_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_KKTV2EOA_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_KLTV2EOA_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_KMTV2EOA_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_KOTV2EOC_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L2TV3RBP_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L3TV3RBP_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L4TV3RBP_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L5TV3RBP_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L6TV3RBQ_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L7TV3RBR_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRTESTENV_FULL.LOG
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190308_0RTRTIAR_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190309_19TRVVM1_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190310_1OTS2K24_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190413_I1TUS5SH_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190413_IGTUS7JH_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190413_IVTUS8PO_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190414_JETUUT5S_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190415_JTTV1HHS_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190415_KCTV1RHI_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190415_KRTV2EOM_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190416_LATV3RCD_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: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_01TRRD87_7169_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_02TRRD87_7170_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_03TRRD8B_7171_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0ATRRD8U_7178_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0DTRTIA2_7181_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0ETRTIA2_7182_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0FTRTIA2_7183_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0GTRTIA2_7184_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0HTRTIA5_7185_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0ITRTIA5_7186_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0PTRTIAP_7193_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0STRVVL6_7196_1_20190309
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0TTRVVL6_7197_1_20190309
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0UTRVVL6_7198_1_20190309
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0VTRVVL6_7199_1_20190309
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_10TRVVL9_7200_1_20190309
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_17TRVVLV_7207_1_20190309
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1ATS2K16_7210_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1BTS2K16_7211_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1CTS2K16_7212_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1DTS2K16_7213_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1ETS2K19_7214_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1FTS2K1C_7215_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1MTS2K22_7222_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_GDTUN01V_7693_1_20190411
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_GKTUN02J_7700_1_20190411
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_GNTUPKD6_7703_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_GRTUPKDV_7707_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_H2TUPKEJ_7714_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_H5TUQJNQ_7717_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_H7TUQJNQ_7719_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_H8TUQJNQ_7720_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_H9TUQJNT_7721_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HATUQJNT_7722_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HHTUQJOI_7729_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HKTUS5RN_7732_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HLTUS5RN_7733_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HMTUS5RN_7734_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HNTUS5RN_7735_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HOTUS5RO_7736_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HVTUS5SE_7743_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_I2TUS7IQ_7746_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_I3TUS7IQ_7747_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_I4TUS7IQ_7748_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_I5TUS7IQ_7749_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_I6TUS7IT_7750_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_I7TUS7IT_7751_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_IETUS7JF_7758_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_IHTUS8P0_7761_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_IITUS8P0_7762_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_IJTUS8P0_7763_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_IKTUS8P0_7764_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_ILTUS8P3_7765_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_IMTUS8P3_7766_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_ITTUS8PM_7773_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_J0TUUT50_7776_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_J1TUUT50_7777_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_J2TUUT50_7778_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_J3TUUT50_7779_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_J4TUUT57_7780_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_J5TUUT57_7781_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JCTUUT5P_7788_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JFTV1HH0_7791_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JGTV1HH0_7792_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JHTV1HH0_7793_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JITV1HH0_7794_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JJTV1HH7_7795_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JKTV1HH7_7796_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JRTV1HHQ_7803_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JUTV1RGP_7806_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JVTV1RGP_7807_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_K0TV1RGP_7808_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_K1TV1RGP_7809_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_K2TV1RGS_7810_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_K3TV1RGT_7811_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KATV1RHF_7818_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KFTV2EO4_7823_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KITV2EO8_7826_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KPTV2EOK_7833_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KSTV3RBH_7836_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KTTV3RBH_7837_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KUTV3RBH_7838_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KVTV3RBH_7839_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_L0TV3RBO_7840_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_L1TV3RBO_7841_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_L8TV3RCB_7848_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_ULTRNO6Q_7125_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_USTRNO7C_7132_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_UTTRNO7C_7133_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_UUTRNO7C_7134_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_UVTRNO7C_7135_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_V0TRNO7C_7136_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_V7TRO9JE_7143_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_VETRO9KI_7150_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_VLTRQTV9_7157_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_VSTRQU0B_7164_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_VVTRRD87_7167_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190412_CF_D-SMRPRODB_ID-3201394995_HITUQJOJ.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190413_CF_D-SMRPRODB_ID-3201394995_I0TUS5SF.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190413_CF_D-SMRPRODB_ID-3201394995_IFTUS7JG.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190413_CF_D-SMRPRODB_ID-3201394995_IUTUS8PN.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190414_CF_D-SMRPRODB_ID-3201394995_JDTUUT5Q.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190415_CF_D-SMRPRODB_ID-3201394995_JSTV1HHR.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190415_CF_D-SMRPRODB_ID-3201394995_KBTV1RHG.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190416_CF_D-SMRPRODB_ID-3201394995_L9TV3RCC.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_04TRRD8C_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_05TRRD8C_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_06TRRD8C_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_07TRRD8C_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_09TRRD8E_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_0JTRTIA6_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_0KTRTIA6_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_0LTRTIA6_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_0MTRTIA6_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_0NTRTIA7_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_0OTRTIA8_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_11TRVVLC_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_12TRVVLC_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_13TRVVLC_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_14TRVVLC_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_15TRVVLD_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_16TRVVLF_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_1GTS2K1E_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_1HTS2K1E_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_1ITS2K1E_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_1JTS2K1E_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_1KTS2K1F_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_1LTS2K1I_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HBTUQJNV_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HCTUQJNV_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HDTUQJNV_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HETUQJNV_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HGTUQJO1_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HPTUS5RR_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HQTUS5RR_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HRTUS5RR_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HSTUS5RR_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HTTUS5RT_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HUTUS5RU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_I8TUS7IU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_I9TUS7IU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IATUS7IU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IBTUS7IU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_ICTUS7IV_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IDTUS7J0_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_INTUS8P4_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IOTUS8P4_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IPTUS8P4_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IQTUS8P4_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IRTUS8P5_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_ISTUS8P6_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_J6TUUT58_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_J7TUUT58_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_J8TUUT58_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_J9TUUT58_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JATUUT59_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JBTUUT5A_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JLTV1HH8_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JMTV1HH8_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JNTV1HH8_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JOTV1HH8_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JPTV1HHA_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JQTV1HHB_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_K4TV1RGU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_K5TV1RGU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_K6TV1RGU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_K7TV1RGU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_K8TV1RGV_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_K9TV1RH0_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_KJTV2EOA_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_KKTV2EOA_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_KLTV2EOA_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_KMTV2EOA_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_KOTV2EOC_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L2TV3RBP_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L3TV3RBP_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L4TV3RBP_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L5TV3RBP_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L6TV3RBQ_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L7TV3RBR_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190308_0RTRTIAR_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190309_19TRVVM1_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190310_1OTS2K24_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190413_I1TUS5SH_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190413_IGTUS7JH_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190413_IVTUS8PO_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190414_JETUUT5S_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190415_JTTV1HHS_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190415_KCTV1RHI_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190415_KRTV2EOM_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190416_LATV3RCD_1_1.CTL

List of Files Which Were Not Cataloged
=======================================
File Name: D:\RMAN_BACKUP_SMRPRODB\RMAN_SMRPRODB_FULL.LOG
  RMAN-07517: Reason: The file header is corrupted
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRIDE_FULL.LOG
  RMAN-07517: Reason: The file header is corrupted
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRMINDDEV_FULL.LOG
  RMAN-07517: Reason: The file header is corrupted
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_FULL.LOG
  RMAN-07517: Reason: The file header is corrupted
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRTESTENV_FULL.LOG
  RMAN-07517: Reason: The file header is corrupted

RMAN>

RMAN> RUN
2> {
3> set newname for datafile 1 to "D:\app\plmadmin\oradata\smrprodb\system01.dbf";
4> set newname for datafile 2 to "D:\app\plmadmin\oradata\smrprodb\sysaux01.dbf";
5> set newname for datafile 3 to "D:\app\plmadmin\oradata\smrprodb\undotbs01.dbf";
6> set newname for datafile 4 to "D:\app\plmadmin\oradata\smrprodb\idata01.dbf";
7> set newname for datafile 5 to "D:\app\plmadmin\oradata\smrprodb\ilog01.dbf";
8> set newname for datafile 6 to "D:\app\plmadmin\oradata\smrprodb\indx01.dbf";
9> set newname for datafile 7 to "D:\app\plmadmin\oradata\smrprodb\idata02.dbf";
10> set newname for tempfile 1 to "D:\app\plmadmin\oradata\smrprodb\temp01.dbf";
11> RESTORE DATABASE;
12>
13> SWITCH DATAFILE ALL;
14>
15> SWITCH TEMPFILE ALL;
16> }

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 16-APR-19
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
using channel ORA_DISK_9
using channel ORA_DISK_10
using channel ORA_DISK_11
using channel ORA_DISK_12
using channel ORA_DISK_13
using channel ORA_DISK_14
using channel ORA_DISK_15
using channel ORA_DISK_16
using channel ORA_DISK_17
using channel ORA_DISK_18
using channel ORA_DISK_19
using channel ORA_DISK_20

skipping datafile 1; already restored to file D:\app\plmadmin\oradata\smrprodb\system01.dbf
skipping datafile 5; already restored to file D:\app\plmadmin\oradata\smrprodb\ilog01.dbf
skipping datafile 2; already restored to file D:\app\plmadmin\oradata\smrprodb\sysaux01.dbf
skipping datafile 7; already restored to file D:\app\plmadmin\oradata\smrprodb\idata02.dbf
skipping datafile 3; already restored to file D:\app\plmadmin\oradata\smrprodb\undotbs01.dbf
skipping datafile 6; already restored to file D:\app\plmadmin\oradata\smrprodb\indx01.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 00004 to D:\app\plmadmin\oradata\smrprodb\idata01.dbf
channel ORA_DISK_1: reading from backup piece D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L2TV3RBP_1_1.BCKP
channel ORA_DISK_1: piece handle=D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L2TV3RBP_1_1.BCKP tag=TAG20190416T040513
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:45
Finished restore at 16-APR-19

datafile 1 switched to datafile copy
input datafile copy RECID=556 STAMP=1005744399 file name=D:\app\plmadmin\oradata\smrprodb\system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=557 STAMP=1005744399 file name=D:\app\plmadmin\oradata\smrprodb\sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=558 STAMP=1005744399 file name=D:\app\plmadmin\oradata\smrprodb\undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=559 STAMP=1005744399 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\IDATA01.DBF
datafile 5 switched to datafile copy
input datafile copy RECID=560 STAMP=1005744399 file name=D:\app\plmadmin\oradata\smrprodb\ilog01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=561 STAMP=1005744399 file name=D:\app\plmadmin\oradata\smrprodb\indx01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=562 STAMP=1005744399 file name=D:\app\plmadmin\oradata\smrprodb\idata02.dbf

renamed tempfile 1 to D:\app\plmadmin\oradata\smrprodb\temp01.dbf in control file

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

PROCESS   STATUS        SEQUENCE#
--------- ------------ ----------
ARCH      CONNECTED             0
ARCH      CONNECTED             0
ARCH      CONNECTED             0
ARCH      CONNECTED             0

RMAN> select max(sequence#) from v$archvied_log;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 04/16/2019 13:27:29
ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only

RMAN> select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------
            27

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

NAME      OPEN_MODE            DATABASE_ROLE
--------- -------------------- ----------------
SMRPRODB  MOUNTED              PHYSICAL STANDBY

RMAN> select member from v$logfile
2> ;



MEMBER
--------------------------------------------------------------------------------

/u04/MasterDB/oradata/SMRPRODB/redo01a.log


/u04/MasterDB/oradata/SMRPRODB/redo02a.log


/u04/MasterDB/oradata/SMRPRODB/redo03a.log


/u04/MasterDB/oradata/SMRPRODB/redo04.log


/u04/MasterDB/oradata/SMRPRODB/redo_05.log


/u04/MasterDB/oradata/SMRPRODB/redo_06.log


/u04/MasterDB/oradata/SMRPRODB/redo_07.log


/u04/MasterDB/oradata/SMRPRODB/redo/redo01b.log


/u04/MasterDB/oradata/SMRPRODB/redo/redo01c.log


/u04/MasterDB/oradata/SMRPRODB/redo/redo02b.log


/u04/MasterDB/oradata/SMRPRODB/redo/redo02c.log


/u04/MasterDB/oradata/SMRPRODB/redo/redo03b.log


/u04/MasterDB/oradata/SMRPRODB/redo/redo03c.log


13 rows selected

RMAN>

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo01a.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo01a.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo01a.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo01a.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo02a.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo02a.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo02a.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo02a.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo03a.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo03a.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo03a.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo03a.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo04.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo04.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo04.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo04.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_05.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo_05.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_05.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo_05.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_06.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo_06.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_06.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo_06.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_07.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo_07.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_07.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo_07.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo01b.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo01b.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo01b.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo01b.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo01c.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo01c.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo01c.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo01c.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo02b.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo02b.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo02b.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo02b.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo02c.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo02c.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo02c.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo02c.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo03b.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo03b.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo03b.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo03b.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo03c.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo03c.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo03c.log''  to  ''D:\app\plmadmin\oradata\smrprodb\redo03c.log''

RMAN>

RMAN>

RMAN>

RMAN>

RMAN> select member from v$logfile
2> ;



MEMBER
--------------------------------------------------------------------------------

D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO01A.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO02A.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO03A.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO04.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO_05.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO_06.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO_07.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO01B.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO01C.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO02B.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO02C.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO03B.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO03C.LOG


13 rows selected

RMAN> select member from v$logfile
2> ;



MEMBER
--------------------------------------------------------------------------------

D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO01A.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO02A.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO03A.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO04.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO_05.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO_06.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO_07.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO01B.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO01C.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO02B.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO02C.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO03B.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO03C.LOG


13 rows selected

RMAN> alter database register logfile 'D:\app\plmadmin\fast_recovery_area\smrprodb\ARCHIVELOG\2019_04_15\1_28_1005460847.arc';

Statement processed

RMAN> alter database register logfile 'D:\app\plmadmin\fast_recovery_area\smrprodb\ARCHIVELOG\2019_04_15\1_29_1005460847.arc';

Statement processed

RMAN> select member from v$logfile
2> select member from v$logfile
3> select member from v$logfile
4>
5>

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signaled during parse
RMAN-00600: internal error, arguments [2016] [4] [] [] []

RMAN> select member from v$logfile;



MEMBER
--------------------------------------------------------------------------------

D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO01A.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO02A.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO03A.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO04.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO_05.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO_06.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO_07.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO01B.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO01C.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO02B.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO02C.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO03B.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO03C.LOG


13 rows selected

RMAN> select max(sequence#) from v$archvived_log;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 04/16/2019 13:47:34
ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only

RMAN> select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------
            29

RMAN> select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------
            29

RMAN> select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------
            29

RMAN> select sequence#,archived,applied from v$archived_log;

 SEQUENCE# ARC APPLIED
---------- --- ---------
        10 YES YES
        11 YES YES
        12 YES YES
        13 YES YES
        14 YES YES
        15 YES YES
        16 YES YES
        17 YES YES
        18 YES YES
        19 YES YES
         1 YES YES
        20 YES YES
        21 YES YES
        22 YES YES
        23 YES YES
        24 YES YES
        25 YES YES
        26 YES YES
        27 YES YES
         2 YES YES
         3 YES YES
         4 YES YES
         5 YES YES
         6 YES YES
         7 YES YES
         8 YES YES
         9 YES YES
        28 YES NO
        29 YES NO

29 rows selected

RMAN> alter database register logfile 'D:\app\plmadmin\fast_recovery_area\smrprodb\ARCHIVELOG\2019_04_15\1_29_1005460847.arc';

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 04/16/2019 14:05:15
ORA-16089: archive log has already been registered

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

Statement processed

RMAN> select sequence#,archived,applied from v$archived_log;

 SEQUENCE# ARC APPLIED
---------- --- ---------
        10 YES YES
        11 YES YES
        12 YES YES
        13 YES YES
        14 YES YES
        15 YES YES
        16 YES YES
        17 YES YES
        18 YES YES
        19 YES YES
         1 YES YES
        20 YES YES
        21 YES YES
        22 YES YES
        23 YES YES
        24 YES YES
        25 YES YES
        26 YES YES
        27 YES YES
         2 YES YES
         3 YES YES
         4 YES YES
         5 YES YES
         6 YES YES
         7 YES YES
         8 YES YES
         9 YES YES
        28 YES NO
        29 YES NO

29 rows selected

RMAN> select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------
            29

RMAN> ;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "advise, allocate, alter, analyze, associate statistics, audit, backup, begin, @, call, catalog
, change, comment, commit, configure, connect, convert, copy, create, create catalog, create global, create script, create virtual, crosscheck, declar
e, delete, delete from, describe, describe catalog, disassociate statistics, drop, drop catalog, drop database, duplicate, exit, explain plan, flashba
ck, flashback table, grant, grant catalog, grant register, host, import, insert, list, lock, merge, mount, noaudit, open, print, purge, quit, recover,
 register, release, rename, repair, replace, report, "
RMAN-01007: at line 1 column 1 file: standard input

RMAN> select member from v$logfile
2> ;



MEMBER
--------------------------------------------------------------------------------

D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO01A.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO02A.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO03A.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO04.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO_05.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO_06.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO_07.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO01B.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO01C.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO02B.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO02C.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO03B.LOG


D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO03C.LOG


13 rows selected

RMAN> exit


Recovery Manager complete.

D:\>sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 16 14:07:57 2019

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> alter database reocver managed standby database disconnect from session;
alter database reocver managed standby database disconnect from session
                       *
ERROR at line 1:
ORA-02231: missing or invalid option to ALTER DATABASE


SQL> alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active


SQL> alter database recover managed standby database logfile current;
alter database recover managed standby database logfile current
*
ERROR at line 1:
ORA-00274: illegal recovery option LOGFILE


SQL> alter database recover managed standby database current logfile;
alter database recover managed standby database current logfile
*
ERROR at line 1:
ORA-00274: illegal recovery option CURRENT


SQL> alter database recover database cancel;
alter database recover database cancel
*
ERROR at line 1:
ORA-00274: illegal recovery option CANCEL


SQL> alter database recover database;
alter database recover database
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active


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

D:\>sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 16 14:11:19 2019

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 sequence#,archived,applied from v$archived_log;

 SEQUENCE# ARC APPLIED
---------- --- ---------
        10 YES YES
        11 YES YES
        12 YES YES
        13 YES YES
        14 YES YES
        15 YES YES
        16 YES YES
        17 YES YES
        18 YES YES
        19 YES YES
         1 YES YES

 SEQUENCE# ARC APPLIED
---------- --- ---------
        20 YES YES
        21 YES YES
        22 YES YES
        23 YES YES
        24 YES YES
        25 YES YES
        26 YES YES
        27 YES YES
         2 YES YES
         3 YES YES
         4 YES YES

 SEQUENCE# ARC APPLIED
---------- --- ---------
         5 YES YES
         6 YES YES
         7 YES YES
         8 YES YES
         9 YES YES
        28 YES YES
        29 YES YES

29 rows selected.

SQL>