ORA-15110: no diskgroups mounted

C:\Users\DBServer01>sqlplus / as sysasm
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Dec 13 09:58:00 2023
Version 19.15.0.0.0
Copyright (c) 1982, 2021, Oracle.  All rights reserved.
Connected to an idle instance.
SQL>
SQL>
SQL> startup
ASM instance started
Total System Global Area 1137305152 bytes
Fixed Size                  9037376 bytes
Variable Size            1103101952 bytes
ASM Cache                  25165824 bytes
ORA-15110: no diskgroups mounted

SQL> select name,state,type from v$asm_diskgroup;
NAME                           STATE       TYPE
------------------------------ ----------- ------
ORA_DATA                       DISMOUNTED

SQL> alter diskgroup ORA_DATA mount;
Diskgroup altered.

SQL> select name,state,type from v$asm_diskgroup;
NAME                           STATE       TYPE
------------------------------ ----------- ------
ORA_DATA                       MOUNTED     EXTERN
SQL>

ADDING DISK TO ASM DISK GROUP

ADDING DISK TO ASM DISK GROUP in Windows Server

 1. Check the used,free size in ASM disk group_number

SELECT

      name AS disk_group_name

     , state AS disk_state

,TYPE

    , total_mb/1024 AS Total_Size_In_GB

    , ROUND((total_mb - free_mb)/1024,2) AS Used_Size_In_GB

    , ROUND((1- (free_mb / total_mb))*100, 2)  pct_used

  FROM

      v$asm_diskgroup

  WHERE

      total_mb != 0

  ORDER BY

      Name;

  

DISK_GROUP_NAME                DISK_STATE  TYPE    TOTAL_SIZE_IN_GB USED_SIZE_IN_GB   PCT_USED

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

ORA_DATA                       MOUNTED     EXTERN                 2            1.81      89.99

2. Check the candidate disk we will add the candidate disk to asm disk group

col DISK_FILE_PATH format a70 

set pages 200 lines 192 

 SELECT 

 NVL(a.name, '[CANDIDATE]') disk_group_name 

 , b.path disk_file_path 

 , b.name disk_file_name 

 , b.failgroup disk_file_fail_group 

FROM 

 v$asm_diskgroup a RIGHT OUTER JOIN v$asm_disk b USING (group_number) 

ORDER BY  a.name;

Output

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

DISK_GROUP_NAME  DISK_FILE_PATH                                         DISK_FILE_NAME  DISK_FILE_FAIL_GROUP 

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

ORA_DATA         D:\SOFTWARE\TUTORIAL\ORACLE_GRID\ASM_DATA\DATA_DISK1   ORA_DATA_0000   ORA_DATA_0000

[CANDIDATE]      D:\SOFTWARE\TUTORIAL\ORACLE_GRID\ASM_DATA\DATA_DISK2

                 D:\SOFTWARE\TUTORIAL\ORACLE_GRID\ASM_DATA\DATA_DISK3

DATA_DISK2 and DATA_DISK3 are candidate disk, we will add only DATA_DISK2 for demonstration purpose.

C:\Users\DILIP_BAKSHI> asmcmd -p

ASMCMD [+] >

ASMCMD [+] > ls -l

State    Type    Rebal  Name

MOUNTED  EXTERN  N      ORA_DATA/

ASMCMD [+] > lsdsk

Path

D:\SOFTWARE\TUTORIAL\ORACLE_GRID\ASM_DATA\DATA_DISK1

C:\Users\DILIP_BAKSHI>sqlplus / as sysasm

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Dec 12 23:56:33 2023

Version 19.15.0.0.0

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

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

SQL>

SQL> ALTER DISKGROUP ORA_DATA ADD DISK 'D:\SOFTWARE\TUTORIAL\ORACLE_GRID\ASM_DATA\DATA_DISK2';

Diskgroup altered.

SQL>exit

C:\Users\DILIP_BAKSHI> asmcmd -p

ASMCMD [+] > lsdsk

Path

D:\SOFTWARE\TUTORIAL\ORACLE_GRID\ASM_DATA\DATA_DISK1

D:\SOFTWARE\TUTORIAL\ORACLE_GRID\ASM_DATA\DATA_DISK2

ASMCMD [+] >

SQL> col DISK_FILE_PATH format a70

SQL> set pages 200 lines 192

SQL>  SELECT

  2   NVL(a.name, '[CANDIDATE]') disk_group_name

  3   , b.path disk_file_path

  4   , b.name disk_file_name

  5   , b.failgroup disk_file_fail_group

  6  FROM

  7   v$asm_diskgroup a RIGHT OUTER JOIN v$asm_disk b USING (group_number)

  8  ORDER BY  a.name;

DISK_GROUP_NAME  DISK_FILE_PATH                                         DISK_FILE_NAME  DISK_FILE_FAIL_GROUP 

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

ORA_DATA         D:\SOFTWARE\TUTORIAL\ORACLE_GRID\ASM_DATA\DATA_DISK1   ORA_DATA_0000   ORA_DATA_0000

ORA_DATA         D:\SOFTWARE\TUTORIAL\ORACLE_GRID\ASM_DATA\DATA_DISK2   ORA_DATA_0001   ORA_DATA_0001

[CANDIDATE]      D:\SOFTWARE\TUTORIAL\ORACLE_GRID\ASM_DATA\DATA_DISK3

SQL>

SELECT

      name AS disk_group_name

     , state AS disk_state

,TYPE

    , total_mb/1024 AS Total_Size_In_GB

    , ROUND((total_mb - free_mb)/1024,2) AS Used_Size_In_GB

    , ROUND((1- (free_mb / total_mb))*100, 2)  pct_used

  FROM

      v$asm_diskgroup

  WHERE

      total_mb != 0

  ORDER BY

      Name;

DISK_GROUP_NAME                DISK_STATE  TYPE    TOTAL_SIZE_IN_GB USED_SIZE_IN_GB   PCT_USED

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

ORA_DATA                       MOUNTED     EXTERN                 4            1.81      45.29

 

ASM instance startup fail with ORA-29701 and ORA-01078

 ASM instance startup fail with below error
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service

sqlplus /nolog
C:\Users\DBServer01>sqlplus /nolog
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Dec 12 21:42:47 2023
Version 19.15.0.0.0
Copyright (c) 1982, 2021, Oracle.  All rights reserved.

SQL> connect / as sysasm
Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service

C:\Users\DBServer01>crsctl stop has

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'DBServer01'

CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'DBServer01'

CRS-2673: Attempting to stop 'ora.orcl11g.db' on 'DBServer01'

CRS-2673: Attempting to stop 'ora.ncdb19c.db' on 'DBServer01'

CRS-2673: Attempting to stop 'ora.LISTENER_ASM.lsnr' on 'DBServer01'

CRS-2677: Stop of 'ora.LISTENER_ASM.lsnr' on 'DBServer01' succeeded

CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'DBServer01' succeeded

CRS-2677: Stop of 'ora.orcl11g.db' on 'DBServer01' succeeded

CRS-2677: Stop of 'ora.ncdb19c.db' on 'DBServer01' succeeded

CRS-2673: Attempting to stop 'ora.evmd' on 'DBServer01'

CRS-2673: Attempting to stop 'ora.ons' on 'DBServer01'

CRS-2677: Stop of 'ora.evmd' on 'DBServer01' succeeded

CRS-2677: Stop of 'ora.ons' on 'DBServer01' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'DBServer01' has completed

CRS-4133: Oracle High Availability Services has been stopped.

C:\Users\DBServer01>

C:\Users\DBServer01>

C:\Users\DBServer01>crsctl start has

CRS-4123: Oracle High Availability Services has been started.

C:\Users\DBServer01>crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       DBServer01                  STABLE
ora.LISTENER_ASM.lsnr
               ONLINE  ONLINE       DBServer01                  STABLE
ora.ORA_DATA.dg
               OFFLINE OFFLINE      DBServer01                  STABLE
ora.ons
               ONLINE  ONLINE       DBServer01                  STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       DBServer01                  STABLE
ora.ncdb19c.db
      1        ONLINE  OFFLINE                               Instance Shutdown,ST
                                                             ABLE
ora.orcl11g.db
      1        ONLINE  ONLINE       DBServer01                  Open,HOME=D:\Softwar
                                                             e\ORADB\app\oracle\p
                                                             roduct\11.2.0\dbhome
                                                             _1,STABLE
--------------------------------------------------------------------------------
C:\Users\DBServer01>crsctl start res ora.cssd -init
CRS-2672: Attempting to start 'ora.cssd' on 'DBServer01'
CRS-2676: Start of 'ora.cssd' on 'DBServer01' succeeded

C:\Users\DBServer01>crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       DBServer01                  STABLE
ora.LISTENER_ASM.lsnr
               ONLINE  ONLINE       DBServer01                  STABLE
ora.ORA_DATA.dg
               OFFLINE OFFLINE      DBServer01                  STABLE
ora.ons
               ONLINE  ONLINE       DBServer01                  STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       DBServer01                  STABLE
ora.evmd
      1        ONLINE  ONLINE       DBServer01                  STABLE
ora.ncdb19c.db
      1        ONLINE  OFFLINE                               Instance Shutdown,ST
                                                             ABLE
ora.orcl11g.db
      1        ONLINE  ONLINE       DBServer01                  Open,HOME=D:\Softwar
                                                             e\ORADB\app\oracle\p
                                                             roduct\11.2.0\dbhome
                                                             _1,STABLE
--------------------------------------------------------------------------------

ORA-01031: insufficient privileges

Connecting asm instance with sysasm  and getting error ORA-01031: insufficient privileges

Reason : NO SYSASM privileges assigned to SYS user.

Once SYSASM privilege assigned to SYS then will get connected

Steps
--1.  --Connect as sysasm
      sqlplus / as sysasm 
                        
--2. --Verify the privileges  to sys user
-      select * from v$pwfile_users;         

--3. --Grant the sysasm privileges  to sys

     grant SYSASM to SYS;                  

--4.  --Again Verify the privileges  to sys user

    select * from v$pwfile_users;        

--5. --Connect with password and check 

    sqlplus sys/<Password> as sysasm 

Detail log
[oracle@rac2 dbs]$ echo $ORACLE_HOME
/u01/app/grid/product/11.2.0/grid
[oracle@rac2 dbs]$ export ORACLE_SID=+ASM2
[oracle@rac2 dbs]$ export ORACLE_HOME=/u01/app/grid/product/11.2.0/grid
[oracle@rac2 dbs]$ export PATH=$PATH:$ORACLE_HOME/bin

[[oracle@rac1 ~]$ sqlplus sys/Pssword123#_4T as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 16 17:55:34 2016
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
ERROR:
ORA-01031: insufficient privileges

Enter user-name:
[oracle@rac1 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 16 17:57:59 2016
Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> select * from v$pwfile_users;
USERNAME                       SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS                            TRUE  TRUE  FALSE
SQL>
SQL> grant SYSASM to SYS;
Grant succeeded.

SQL> select * from v$pwfile_users;
USERNAME                       SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS                            TRUE  TRUE  TRUE
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
[oracle@rac1 ~]$
[oracle@rac1 ~]$ sqlplus sys/Pssword123#_4T  as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 16 17:59:17 2016
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL>

Oracle Database restoration to new Server using RMAN backup sets

 

Steps

1. Install same version oracle software in the target environment(new Server).
2. Copy backupsets to the target environment(new server)
3. Prepare same directory structure as earlier it was.
4. Recreate tnsname, listener, pfile.
5. Create pfile for minimum parameter like db_name, controlfiles and undo.
6. Startup nomount using pfile (pfile which is created with minimum parameters)
7. Connect to RMAN
8. Restore spfile from backup sets.
9. Shutdown database
10. Startup database in nomount mode (automatically database will start with spfile because spfile restored)
11. Restore controlfile from backup sets
12. Catalog start with backup location( location where backup sets are copied)
13. Restore database
14. Recover database
15. Open database with resetlogs

Command summary

sqlplus / as sysdba
startup nomount pfile='/opt/oracle/pfile_temp.ora';
rman target /
restore spfile from '/u03/ORCL/ORCL_17012_1_1_inc';
restore controlfile from '/u03/ORCL/ORCL_17012_1_1_inc';
alter database mount;
report schema;
catalog start with '/u03/ORCL';
restore database preview;
list backup of archivelog all;
restore database until sequence 15480;
recover database until sequence 15480;
alter database open resetlogs;

cat /opt/oracle/pfile_temp.ora

db_name=orcl

control_files=('/oracle/oradata/orcl/orcl/control01.ctl',

               '/oracle/oradata/orcl/orcl/control02.ctl',

   '/oracle/oradata/orcl/orcl/control03.ctl')

undo_management=AUTO

sqlplus / as sysdba

startup nomount pfile='/opt/oracle/pfile_temp.ora';

[oracle@rac02 dbs]$ rman target /

connected to target database: ORCL (not mounted)

RMAN> restore spfile from '/u03/ORCL/ORCL_17012_1_1_inc';

Starting restore at 28-FEB-20

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=36 devtype=DISK

channel ORA_DISK_1: autobackup found: /u03/ORCL/ORCL_17012_1_1_inc

channel ORA_DISK_1: SPFILE restore from autobackup complete

Finished restore at 28-FEB-20

RMAN> exit

RMAN> restore controlfile from '/u03/ORCL/ORCL_17012_1_1_inc';

Starting restore at 27-FEB-20

using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file

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

output filename=/oracle/oradata/ORCL/ORCL/control01.ctl

output filename=/oracle/oradata/ORCL/ORCL/control02.ctl

output filename=/oracle/oradata/ORCL/ORCL/control03.ctl

Finished restore at 27-FEB-20

RMAN>

RMAN> alter database mount;

database mounted

released channel: ORA_DISK_1

RMAN> report schema;

Starting implicit crosscheck backup at 27-FEB-20

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=158 devtype=DISK

Crosschecked 13 objects

Finished implicit crosscheck backup at 27-FEB-20

Starting implicit crosscheck copy at 27-FEB-20

using channel ORA_DISK_1

Finished implicit crosscheck copy at 27-FEB-20

searching for all files in the recovery area

cataloging files...

cataloging done

List of Cataloged Files

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

File Name: /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2019_12_31/o1_mf_1_29_h0pj17ty_.arc

File Name: /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2019_12_31/o1_mf_1_30_h0pj1chf_.arc

File Name: /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2019_12_31/o1_mf_1_28_h0pj17tw_.arc

File Name: /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2019_12_31/o1_mf_1_31_h0pj25xx_.arc

File Name: /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2019_12_31/o1_mf_1_32_h0pj2q9r_.arc

File Name: /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_36_h5h5nvdl_.arc

File Name: /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_35_h5h5nlqz_.arc

File Name: /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_39_h5h5oo5h_.arc

File Name: /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_34_h5h5nc94_.arc

File Name: /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_37_h5h5o2gy_.arc

File Name: /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_33_h5h5n3g3_.arc

File Name: /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_38_h5h5obl5_.arc

RMAN-06139: WARNING: control file is not current for REPORT SCHEMA

Report of database schema

List of Permanent Datafiles

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

File Size(MB) Tablespace           RB segs Datafile Name

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

1    0        SYSTEM               ***     /oracle/oradata/ORCL/system01.dbf

2    0        UNDOTBS1             ***     /oracle/oradata/ORCL/undotbs01.dbf

3    0        SYSAUX               ***     /oracle/oradata/ORCL/sysaux01.dbf

4    0        ORCL_DATA            ***     /oracle/oradata/ORCL/ORCL_data01.dbf

5    0        ORCL_INDEX           ***     /oracle/oradata/ORCL/ORCL_INDEX01.dbf

6    0        ORCLBI_DATA          ***     /oracle/oradata/ORCL/ORCLbi_data01.dbf

7    0        ORCLBI_INDEX         ***     /oracle/oradata/ORCL/ORCLbi_index01.dbf

8    0        USERS                ***     /oracle/oradata/ORCL/users01.dbf

9    0        ORCL_DATA            ***     /oracle/oradata/ORCL/ORCL_data02.dbf

10   0        SYSTEM               ***     /oracle/oradata/ORCL/system02.dbf

11   0        SYSAUX               ***     /oracle/oradata/ORCL/sysaux03.dbf

12   0        ORCL_DATA            ***     /oracle/oradata/ORCL/ORCLbi_data02.dbf

13   0        SYSAUX               ***     /oracle/oradata/ORCL/sysaux02.dbf

List of Temporary Files

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

File Size(MB) Tablespace           Maxsize(MB) Tempfile Name

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

1    0        TEMP                 32767       /oracle/oradata/ORCL/temp01.dbf

RMAN>

RMAN> catalog start with '/u03/ORCL';

searching for all files that match the pattern /u03/ORCL

List of Files Unknown to the Database

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

File Name: /u03/ORCL/ORCL_17009_1_1_inc

File Name: /u03/ORCL/ORCL_16999_1_1_inc

File Name: /u03/ORCL/ORCL_17011_1_1_inc

File Name: /u03/ORCL/ORCL_17003_1_1_inc

File Name: /u03/ORCL/ORCL_16996_1_1_full

File Name: /u03/ORCL/ORCL_17010_1_1_inc

File Name: /u03/ORCL/ORCL_17007_1_1_inc

File Name: /u03/ORCL/ORCL_17002_1_1_inc

File Name: /u03/ORCL/ORCL_17012_1_1_inc

File Name: /u03/ORCL/ORCL_17005_1_1_inc

File Name: /u03/ORCL/ORCL_17001_1_1_inc

File Name: /u03/ORCL/ORCL_17006_1_1_inc

File Name: /u03/ORCL/ORCL_16998_1_1_inc

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

cataloging files...

cataloging done

List of Cataloged Files

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

File Name: /u03/ORCL/ORCL_17009_1_1_inc

File Name: /u03/ORCL/ORCL_16999_1_1_inc

File Name: /u03/ORCL/ORCL_17011_1_1_inc

File Name: /u03/ORCL/ORCL_17003_1_1_inc

File Name: /u03/ORCL/ORCL_16996_1_1_full

File Name: /u03/ORCL/ORCL_17010_1_1_inc

File Name: /u03/ORCL/ORCL_17007_1_1_inc

File Name: /u03/ORCL/ORCL_17002_1_1_inc

File Name: /u03/ORCL/ORCL_17012_1_1_inc

File Name: /u03/ORCL/ORCL_17005_1_1_inc

File Name: /u03/ORCL/ORCL_17001_1_1_inc

File Name: /u03/ORCL/ORCL_17006_1_1_inc

File Name: /u03/ORCL/ORCL_16998_1_1_inc

RMAN> report schema;

RMAN-06139: WARNING: control file is not current for REPORT SCHEMA

Report of database schema

List of Permanent Datafiles

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

File Size(MB) Tablespace           RB segs Datafile Name

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

1    0        SYSTEM               ***     /oracle/oradata/ORCL/system01.dbf

2    0        UNDOTBS1             ***     /oracle/oradata/ORCL/undotbs01.dbf

3    0        SYSAUX               ***     /oracle/oradata/ORCL/sysaux01.dbf

4    0        ORCL_DATA         ***     /oracle/oradata/ORCL/ORCL_data01.dbf

5    0        ORCL_INDEX         ***     /oracle/oradata/ORCL/ORCL_INDEX01.dbf

6    0        ORCLBI_DATA       ***     /oracle/oradata/ORCL/ORCLbi_data01.dbf

7    0        ORCLBI_INDEX       ***     /oracle/oradata/ORCL/ORCLbi_index01.dbf

8    0        USERS                ***     /oracle/oradata/ORCL/users01.dbf

9    0        ORCL_DATA         ***     /oracle/oradata/ORCL/ORCL_data02.dbf

10   0        SYSTEM               ***     /oracle/oradata/ORCL/system02.dbf

11   0        SYSAUX               ***     /oracle/oradata/ORCL/sysaux03.dbf

12   0        ORCL_DATA         ***     /oracle/oradata/ORCL/ORCLbi_data02.dbf

13   0        SYSAUX               ***     /oracle/oradata/ORCL/sysaux02.dbf

List of Temporary Files

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

File Size(MB) Tablespace           Maxsize(MB) Tempfile Name

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

1    0        TEMP                 32767       /oracle/oradata/ORCL/temp01.dbf

RMAN>

RMAN> restore database preview;

Starting restore at 27-FEB-20

using channel ORA_DISK_1

data file 1 will be created automatically during restore operation

data file 2 will be created automatically during restore operation

data file 3 will be created automatically during restore operation

data file 4 will be created automatically during restore operation

data file 5 will be created automatically during restore operation

data file 6 will be created automatically during restore operation

data file 7 will be created automatically during restore operation

data file 8 will be created automatically during restore operation

data file 9 will be created automatically during restore operation

data file 10 will be created automatically during restore operation

data file 11 will be created automatically during restore operation

data file 12 will be created automatically during restore operation

data file 13 will be created automatically during restore operation

no backup of log thread 1 seq 15230 lowscn 371687323 found to restore

no backup of log thread 1 seq 15232 lowscn 371725775 found to restore

no backup of log thread 1 seq 15233 lowscn 371758519 found to restore

no backup of log thread 1 seq 15234 lowscn 371794631 found to restore

no backup of log thread 1 seq 15235 lowscn 371805910 found to restore

no backup of log thread 1 seq 15236 lowscn 371806061 found to restore

no backup of log thread 1 seq 15237 lowscn 371852459 found to restore

no backup of log thread 1 seq 15238 lowscn 371866664 found to restore

no backup of log thread 1 seq 15239 lowscn 371871394 found to restore

no backup of log thread 1 seq 15240 lowscn 371871468 found to restore

no backup of log thread 1 seq 15241 lowscn 371917160 found to restore

no backup of log thread 1 seq 15242 lowscn 371935128 found to restore

no backup of log thread 1 seq 15243 lowscn 371935206 found to restore

no backup of log thread 1 seq 15244 lowscn 371981358 found to restore

no backup of log thread 1 seq 15245 lowscn 371999852 found to restore

no backup of log thread 1 seq 15246 lowscn 371999933 found to restore

no backup of log thread 1 seq 15247 lowscn 372045246 found to restore

no backup of log thread 1 seq 15248 lowscn 372063431 found to restore

no backup of log thread 1 seq 15249 lowscn 372063521 found to restore

no backup of log thread 1 seq 15250 lowscn 372109090 found to restore

no backup of log thread 1 seq 15251 lowscn 372127564 found to restore

no backup of log thread 1 seq 15253 lowscn 372166714 found to restore

no backup of log thread 1 seq 15254 lowscn 372198353 found to restore

no backup of log thread 1 seq 15255 lowscn 372234837 found to restore

no backup of log thread 1 seq 15256 lowscn 372246908 found to restore

no backup of log thread 1 seq 15257 lowscn 372246998 found to restore

no backup of log thread 1 seq 15258 lowscn 372292469 found to restore

no backup of log thread 1 seq 15259 lowscn 372305269 found to restore

no backup of log thread 1 seq 15260 lowscn 372311789 found to restore

no backup of log thread 1 seq 15261 lowscn 372311877 found to restore

no backup of log thread 1 seq 15262 lowscn 372345756 found to restore

no backup of log thread 1 seq 15263 lowscn 372370879 found to restore

no backup of log thread 1 seq 15264 lowscn 372383499 found to restore

no backup of log thread 1 seq 15265 lowscn 372383573 found to restore

no backup of log thread 1 seq 15266 lowscn 372429430 found to restore

no backup of log thread 1 seq 15267 lowscn 372447497 found to restore

no backup of log thread 1 seq 15268 lowscn 372447571 found to restore

no backup of log thread 1 seq 15269 lowscn 372492953 found to restore

no backup of log thread 1 seq 15270 lowscn 372510716 found to restore

no backup of log thread 1 seq 15271 lowscn 372510801 found to restore

no backup of log thread 1 seq 15272 lowscn 372556257 found to restore

no backup of log thread 1 seq 15273 lowscn 372574008 found to restore

no backup of log thread 1 seq 15274 lowscn 372574177 found to restore

no backup of log thread 1 seq 15275 lowscn 372611344 found to restore

no backup of log thread 1 seq 15276 lowscn 372642891 found to restore

no backup of log thread 1 seq 15277 lowscn 372682163 found to restore

no backup of log thread 1 seq 15278 lowscn 372693963 found to restore

no backup of log thread 1 seq 15279 lowscn 372694029 found to restore

no backup of log thread 1 seq 15280 lowscn 372738961 found to restore

no backup of log thread 1 seq 15281 lowscn 372750797 found to restore

no backup of log thread 1 seq 15282 lowscn 372757758 found to restore

no backup of log thread 1 seq 15283 lowscn 372757839 found to restore

no backup of log thread 1 seq 15284 lowscn 372803024 found to restore

no backup of log thread 1 seq 15285 lowscn 372820908 found to restore

no backup of log thread 1 seq 15286 lowscn 372820986 found to restore

no backup of log thread 1 seq 15287 lowscn 372865560 found to restore

no backup of log thread 1 seq 15288 lowscn 372883147 found to restore

no backup of log thread 1 seq 15289 lowscn 372883228 found to restore

no backup of log thread 1 seq 15290 lowscn 372928485 found to restore

no backup of log thread 1 seq 15291 lowscn 372945847 found to restore

no backup of log thread 1 seq 15292 lowscn 372945929 found to restore

no backup of log thread 1 seq 15293 lowscn 372990529 found to restore

no backup of log thread 1 seq 15294 lowscn 373008518 found to restore

no backup of log thread 1 seq 15295 lowscn 373008606 found to restore

no backup of log thread 1 seq 15296 lowscn 373044449 found to restore

no backup of log thread 1 seq 15297 lowscn 373075270 found to restore

no backup of log thread 1 seq 15298 lowscn 373115437 found to restore

no backup of log thread 1 seq 15299 lowscn 373127457 found to restore

no backup of log thread 1 seq 15300 lowscn 373127529 found to restore

no backup of log thread 1 seq 15301 lowscn 373172700 found to restore

no backup of log thread 1 seq 15302 lowscn 373186504 found to restore

no backup of log thread 1 seq 15303 lowscn 373191533 found to restore

no backup of log thread 1 seq 15304 lowscn 373191608 found to restore

no backup of log thread 1 seq 15305 lowscn 373236046 found to restore

no backup of log thread 1 seq 15306 lowscn 373253794 found to restore

no backup of log thread 1 seq 15307 lowscn 373253884 found to restore

no backup of log thread 1 seq 15308 lowscn 373299044 found to restore

no backup of log thread 1 seq 15309 lowscn 373316544 found to restore

no backup of log thread 1 seq 15310 lowscn 373316742 found to restore

no backup of log thread 1 seq 15311 lowscn 373360940 found to restore

no backup of log thread 1 seq 15312 lowscn 373378500 found to restore

no backup of log thread 1 seq 15313 lowscn 373378611 found to restore

no backup of log thread 1 seq 15314 lowscn 373423476 found to restore

no backup of log thread 1 seq 15315 lowscn 373441853 found to restore

no backup of log thread 1 seq 15316 lowscn 373442041 found to restore

no backup of log thread 1 seq 15317 lowscn 373442163 found to restore

no backup of log thread 1 seq 15318 lowscn 373478669 found to restore

no backup of log thread 1 seq 15319 lowscn 373510871 found to restore

no backup of log thread 1 seq 15320 lowscn 373549128 found to restore

no backup of log thread 1 seq 15321 lowscn 373561201 found to restore

no backup of log thread 1 seq 15322 lowscn 373561283 found to restore

no backup of log thread 1 seq 15323 lowscn 373605399 found to restore

no backup of log thread 1 seq 15324 lowscn 373619223 found to restore

no backup of log thread 1 seq 15325 lowscn 373623820 found to restore

no backup of log thread 1 seq 15326 lowscn 373623897 found to restore

no backup of log thread 1 seq 15327 lowscn 373669924 found to restore

no backup of log thread 1 seq 15328 lowscn 373687994 found to restore

no backup of log thread 1 seq 15329 lowscn 373688101 found to restore

no backup of log thread 1 seq 15330 lowscn 373733802 found to restore

no backup of log thread 1 seq 15331 lowscn 373751440 found to restore

no backup of log thread 1 seq 15332 lowscn 373751552 found to restore

no backup of log thread 1 seq 15333 lowscn 373796578 found to restore

no backup of log thread 1 seq 15334 lowscn 373813667 found to restore

no backup of log thread 1 seq 15335 lowscn 373813760 found to restore

no backup of log thread 1 seq 15336 lowscn 373859637 found to restore

no backup of log thread 1 seq 15337 lowscn 373877502 found to restore

no backup of log thread 1 seq 15338 lowscn 373877621 found to restore

no backup of log thread 1 seq 15339 lowscn 373914809 found to restore

no backup of log thread 1 seq 15340 lowscn 373944958 found to restore

no backup of log thread 1 seq 15341 lowscn 373985307 found to restore

no backup of log thread 1 seq 15342 lowscn 373996924 found to restore

no backup of log thread 1 seq 15343 lowscn 373997010 found to restore

no backup of log thread 1 seq 15344 lowscn 374042473 found to restore

no backup of log thread 1 seq 15345 lowscn 374056184 found to restore

no backup of log thread 1 seq 15346 lowscn 374060773 found to restore

no backup of log thread 1 seq 15347 lowscn 374060878 found to restore

no backup of log thread 1 seq 15348 lowscn 374106412 found to restore

no backup of log thread 1 seq 15349 lowscn 374124017 found to restore

no backup of log thread 1 seq 15350 lowscn 374124122 found to restore

no backup of log thread 1 seq 15351 lowscn 374170027 found to restore

no backup of log thread 1 seq 15352 lowscn 374187560 found to restore

no backup of log thread 1 seq 15353 lowscn 374187740 found to restore

no backup of log thread 1 seq 15354 lowscn 374233126 found to restore

no backup of log thread 1 seq 15355 lowscn 374250532 found to restore

no backup of log thread 1 seq 15356 lowscn 374250667 found to restore

no backup of log thread 1 seq 15357 lowscn 374296701 found to restore

no backup of log thread 1 seq 15358 lowscn 374314594 found to restore

no backup of log thread 1 seq 15359 lowscn 374314832 found to restore

no backup of log thread 1 seq 15360 lowscn 374314947 found to restore

no backup of log thread 1 seq 15361 lowscn 374354460 found to restore

no backup of log thread 1 seq 15362 lowscn 374384593 found to restore

no backup of log thread 1 seq 15363 lowscn 374421943 found to restore

no backup of log thread 1 seq 15364 lowscn 374433345 found to restore

no backup of log thread 1 seq 15365 lowscn 374433428 found to restore

no backup of log thread 1 seq 15366 lowscn 374478734 found to restore

no backup of log thread 1 seq 15367 lowscn 374490636 found to restore

no backup of log thread 1 seq 15368 lowscn 374497590 found to restore

no backup of log thread 1 seq 15369 lowscn 374497716 found to restore

no backup of log thread 1 seq 15370 lowscn 374543487 found to restore

no backup of log thread 1 seq 15371 lowscn 374561215 found to restore

no backup of log thread 1 seq 15372 lowscn 374561315 found to restore

no backup of log thread 1 seq 15373 lowscn 374607159 found to restore

no backup of log thread 1 seq 15374 lowscn 374624859 found to restore

no backup of log thread 1 seq 15375 lowscn 374624971 found to restore

no backup of log thread 1 seq 15376 lowscn 374670756 found to restore

no backup of log thread 1 seq 15377 lowscn 374687900 found to restore

no backup of log thread 1 seq 15378 lowscn 374688013 found to restore

no backup of log thread 1 seq 15379 lowscn 374733378 found to restore

no backup of log thread 1 seq 15380 lowscn 374751240 found to restore

no backup of log thread 1 seq 15381 lowscn 374751343 found to restore

no backup of log thread 1 seq 15382 lowscn 374787969 found to restore

no backup of log thread 1 seq 15383 lowscn 374817821 found to restore

no backup of log thread 1 seq 15384 lowscn 374857302 found to restore

no backup of log thread 1 seq 15385 lowscn 374870098 found to restore

no backup of log thread 1 seq 15386 lowscn 374870185 found to restore

no backup of log thread 1 seq 15387 lowscn 374916002 found to restore

no backup of log thread 1 seq 15388 lowscn 374929673 found to restore

no backup of log thread 1 seq 15389 lowscn 374934586 found to restore

no backup of log thread 1 seq 15390 lowscn 374934695 found to restore

no backup of log thread 1 seq 15391 lowscn 374980867 found to restore

no backup of log thread 1 seq 15392 lowscn 374998497 found to restore

no backup of log thread 1 seq 15393 lowscn 374998625 found to restore

no backup of log thread 1 seq 15394 lowscn 375044379 found to restore

no backup of log thread 1 seq 15395 lowscn 375061775 found to restore

no backup of log thread 1 seq 15396 lowscn 375061914 found to restore

no backup of log thread 1 seq 15397 lowscn 375108390 found to restore

no backup of log thread 1 seq 15398 lowscn 375125694 found to restore

no backup of log thread 1 seq 15399 lowscn 375125820 found to restore

no backup of log thread 1 seq 15400 lowscn 375171455 found to restore

no backup of log thread 1 seq 15401 lowscn 375187060 found to restore

no backup of log thread 1 seq 15402 lowscn 375189536 found to restore

no backup of log thread 1 seq 15403 lowscn 375189665 found to restore

no backup of log thread 1 seq 15404 lowscn 375228897 found to restore

no backup of log thread 1 seq 15405 lowscn 375259045 found to restore

no backup of log thread 1 seq 15406 lowscn 375295721 found to restore

no backup of log thread 1 seq 15407 lowscn 375308032 found to restore

no backup of log thread 1 seq 15408 lowscn 375308144 found to restore

no backup of log thread 1 seq 15409 lowscn 375354416 found to restore

no backup of log thread 1 seq 15410 lowscn 375365773 found to restore

no backup of log thread 1 seq 15411 lowscn 375372860 found to restore

no backup of log thread 1 seq 15412 lowscn 375372963 found to restore

no backup of log thread 1 seq 15413 lowscn 375420565 found to restore

no backup of log thread 1 seq 15414 lowscn 375438038 found to restore

no backup of log thread 1 seq 15415 lowscn 375438146 found to restore

no backup of log thread 1 seq 15416 lowscn 375484312 found to restore

no backup of log thread 1 seq 15417 lowscn 375502091 found to restore

no backup of log thread 1 seq 15418 lowscn 375502216 found to restore

no backup of log thread 1 seq 15419 lowscn 375548440 found to restore

no backup of log thread 1 seq 15420 lowscn 375565957 found to restore

no backup of log thread 1 seq 15421 lowscn 375566066 found to restore

no backup of log thread 1 seq 15422 lowscn 375612339 found to restore

no backup of log thread 1 seq 15423 lowscn 375630246 found to restore

no backup of log thread 1 seq 15424 lowscn 375630460 found to restore

no backup of log thread 1 seq 15425 lowscn 375630575 found to restore

no backup of log thread 1 seq 15426 lowscn 375666063 found to restore

no backup of log thread 1 seq 15427 lowscn 375695912 found to restore

no backup of log thread 1 seq 15428 lowscn 375736783 found to restore

no backup of log thread 1 seq 15429 lowscn 375749267 found to restore

no backup of log thread 1 seq 15430 lowscn 375749365 found to restore

no backup of log thread 1 seq 15431 lowscn 375793341 found to restore

no backup of log thread 1 seq 15432 lowscn 375809132 found to restore

no backup of log thread 1 seq 15433 lowscn 375811510 found to restore

no backup of log thread 1 seq 15434 lowscn 375811633 found to restore

no backup of log thread 1 seq 15435 lowscn 375857227 found to restore

no backup of log thread 1 seq 15436 lowscn 375875326 found to restore

no backup of log thread 1 seq 15437 lowscn 375875448 found to restore

no backup of log thread 1 seq 15438 lowscn 375921507 found to restore

no backup of log thread 1 seq 15439 lowscn 375939187 found to restore

no backup of log thread 1 seq 15440 lowscn 375939319 found to restore

no backup of log thread 1 seq 15441 lowscn 375984657 found to restore

no backup of log thread 1 seq 15442 lowscn 376002049 found to restore

no backup of log thread 1 seq 15443 lowscn 376002157 found to restore

no backup of log thread 1 seq 15444 lowscn 376047620 found to restore

no backup of log thread 1 seq 15445 lowscn 376065562 found to restore

no backup of log thread 1 seq 15446 lowscn 376065689 found to restore

no backup of log thread 1 seq 15447 lowscn 376065886 found to restore

no backup of log thread 1 seq 15448 lowscn 376104179 found to restore

no backup of log thread 1 seq 15449 lowscn 376134238 found to restore

no backup of log thread 1 seq 15450 lowscn 376172581 found to restore

no backup of log thread 1 seq 15451 lowscn 376184745 found to restore

no backup of log thread 1 seq 15452 lowscn 376184861 found to restore

no backup of log thread 1 seq 15453 lowscn 376229735 found to restore

no backup of log thread 1 seq 15454 lowscn 376242951 found to restore

no backup of log thread 1 seq 15455 lowscn 376248364 found to restore

no backup of log thread 1 seq 15456 lowscn 376248463 found to restore

no backup of log thread 1 seq 15457 lowscn 376294034 found to restore

no backup of log thread 1 seq 15458 lowscn 376311394 found to restore

no backup of log thread 1 seq 15459 lowscn 376311504 found to restore

no backup of log thread 1 seq 15460 lowscn 376357285 found to restore

no backup of log thread 1 seq 15461 lowscn 376374546 found to restore

no backup of log thread 1 seq 15462 lowscn 376374659 found to restore

no backup of log thread 1 seq 15463 lowscn 376420251 found to restore

no backup of log thread 1 seq 15464 lowscn 376437643 found to restore

no backup of log thread 1 seq 15465 lowscn 376437764 found to restore

no backup of log thread 1 seq 15466 lowscn 376482787 found to restore

no backup of log thread 1 seq 15467 lowscn 376500834 found to restore

no backup of log thread 1 seq 15468 lowscn 376500950 found to restore

List of Backup Sets

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

BS Key  Size       Device Type Elapsed Time Completion Time

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

16994   133.87M    DISK        00:00:23     27-FEB-20

        BP Key: 17001   Status: AVAILABLE  Compressed: YES  Tag: TAG20200227T040153

        Piece Name: /u03/ORCL/ORCL_17010_1_1_inc

  List of Archived Logs in backup set 16994

  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

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

  1    15469   376538978  22-FEB-20 376568556  23-FEB-20

  1    15470   376568556  23-FEB-20 376606639  23-FEB-20

  1    15471   376606639  23-FEB-20 376618751  24-FEB-20

  1    15472   376618751  24-FEB-20 376618845  24-FEB-20

  1    15473   376618845  24-FEB-20 376663756  24-FEB-20

  1    15474   376663756  24-FEB-20 376677937  25-FEB-20

  1    15475   376677937  25-FEB-20 376682881  25-FEB-20

  1    15476   376682881  25-FEB-20 376683008  25-FEB-20

  1    15477   376683008  25-FEB-20 376728106  25-FEB-20

  1    15478   376728106  25-FEB-20 376745863  26-FEB-20

  1    15479   376745863  26-FEB-20 376745976  26-FEB-20

  1    15480   376745976  26-FEB-20 376791447  26-FEB-20

  1    15481   376791447  26-FEB-20 376808760  27-FEB-20

List of Archived Log Copies

Key     Thrd Seq     S Low Time  Name

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

15541   1    28      A 31-DEC-19 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2019_12_31/o1_mf_1_28_h0pj17tw_.arc

15539   1    29      A 31-DEC-19 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2019_12_31/o1_mf_1_29_h0pj17ty_.arc

15540   1    30      A 31-DEC-19 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2019_12_31/o1_mf_1_30_h0pj1chf_.arc

15542   1    31      A 31-DEC-19 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2019_12_31/o1_mf_1_31_h0pj25xx_.arc

15543   1    32      A 31-DEC-19 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2019_12_31/o1_mf_1_32_h0pj2q9r_.arc

15549   1    33      A 31-DEC-19 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_33_h5h5n3g3_.arc

15547   1    34      A 27-FEB-20 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_34_h5h5nc94_.arc

15545   1    35      A 27-FEB-20 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_35_h5h5nlqz_.arc

15544   1    36      A 27-FEB-20 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_36_h5h5nvdl_.arc

15548   1    37      A 27-FEB-20 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_37_h5h5o2gy_.arc

15550   1    38      A 27-FEB-20 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_38_h5h5obl5_.arc

15546   1    39      A 27-FEB-20 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_39_h5h5oo5h_.arc

Media recovery start SCN is 10

Recovery must be done beyond SCN 109348927 to clear data files fuzziness

Finished restore at 27-FEB-20

RMAN> report schema;

RMAN-06139: WARNING: control file is not current for REPORT SCHEMA

Report of database schema

List of Permanent Datafiles

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

File Size(MB) Tablespace           RB segs Datafile Name

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

1    445      SYSTEM               ***     /oracle/oradata/ORCL/system01.dbf

2    292      UNDOTBS1             ***     /oracle/oradata/ORCL/undotbs01.dbf

3    600      SYSAUX               ***     /oracle/oradata/ORCL/sysaux01.dbf

4    800      ORCL_data         ***     /oracle/oradata/ORCL/ORCL_data01.dbf

5    50       ORCL_INDEX         ***     /oracle/oradata/ORCL/ORCL_INDEX01.dbf

6    5000     ORCLBI_data       ***     /oracle/oradata/ORCL/ORCLbi_data01.dbf

7    10       ORCLBI_INDEX       ***     /oracle/oradata/ORCL/ORCLbi_index01.dbf

8    5        USERS                ***     /oracle/oradata/ORCL/users01.dbf

9    410      ORCL_data         ***     /oracle/oradata/ORCL/ORCL_data02.dbf

10   500      SYSTEM               ***     /oracle/oradata/ORCL/system02.dbf

11   100      SYSAUX               ***     /oracle/oradata/ORCL/sysaux03.dbf

12   500      ORCL_data         ***     /oracle/oradata/ORCL/ORCLbi_data02.dbf

13   240      SYSAUX               ***     /oracle/oradata/ORCL/sysaux02.dbf

List of Temporary Files

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

File Size(MB) Tablespace           Maxsize(MB) Tempfile Name

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

1    0        TEMP                 32767       /oracle/oradata/ORCL/temp01.dbf

RMAN> list backup of archivelog all;

List of Backup Sets

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

BS Key  Size       Device Type Elapsed Time Completion Time

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

16982   38.23M     DISK        00:00:06     24-FEB-20

        BP Key: 17008   Status: AVAILABLE  Compressed: YES  Tag: TAG20200224T040132

        Piece Name: /u03/ORCL/ORCL_16998_1_1_inc

  List of Archived Logs in backup set 16982

  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

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

  1    15469   376538978  22-FEB-20 376568556  23-FEB-20

  1    15470   376568556  23-FEB-20 376606639  23-FEB-20

  1    15471   376606639  23-FEB-20 376618751  24-FEB-20

BS Key  Size       Device Type Elapsed Time Completion Time

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

16985   100.50K    DISK        00:00:01     24-FEB-20

        BP Key: 17006   Status: AVAILABLE  Compressed: YES  Tag: TAG20200224T040319

        Piece Name: /u03/ORCL/ORCL_17001_1_1_inc

  List of Archived Logs in backup set 16985

  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

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

  1    15472   376618751  24-FEB-20 376618845  24-FEB-20

BS Key  Size       Device Type Elapsed Time Completion Time

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

16986   73.32M     DISK        00:00:13     25-FEB-20

        BP Key: 17003   Status: AVAILABLE  Compressed: YES  Tag: TAG20200225T040144

        Piece Name: /u03/ORCL/ORCL_17002_1_1_inc

  List of Archived Logs in backup set 16986

  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

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

  1    15469   376538978  22-FEB-20 376568556  23-FEB-20

  1    15470   376568556  23-FEB-20 376606639  23-FEB-20

  1    15471   376606639  23-FEB-20 376618751  24-FEB-20

  1    15472   376618751  24-FEB-20 376618845  24-FEB-20

  1    15473   376618845  24-FEB-20 376663756  24-FEB-20

  1    15474   376663756  24-FEB-20 376677937  25-FEB-20

  1    15475   376677937  25-FEB-20 376682881  25-FEB-20

BS Key  Size       Device Type Elapsed Time Completion Time

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

16989   151.00K    DISK        00:00:01     25-FEB-20

        BP Key: 17005   Status: AVAILABLE  Compressed: YES  Tag: TAG20200225T040339

        Piece Name: /u03/ORCL/ORCL_17005_1_1_inc

  List of Archived Logs in backup set 16989

  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

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

  1    15476   376682881  25-FEB-20 376683008  25-FEB-20

BS Key  Size       Device Type Elapsed Time Completion Time

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

16990   105.40M    DISK        00:00:17     26-FEB-20

        BP Key: 17007   Status: AVAILABLE  Compressed: YES  Tag: TAG20200226T040140

        Piece Name: /u03/ORCL/ORCL_17006_1_1_inc

  List of Archived Logs in backup set 16990

  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

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

  1    15469   376538978  22-FEB-20 376568556  23-FEB-20

  1    15470   376568556  23-FEB-20 376606639  23-FEB-20

  1    15471   376606639  23-FEB-20 376618751  24-FEB-20

  1    15472   376618751  24-FEB-20 376618845  24-FEB-20

  1    15473   376618845  24-FEB-20 376663756  24-FEB-20

  1    15474   376663756  24-FEB-20 376677937  25-FEB-20

  1    15475   376677937  25-FEB-20 376682881  25-FEB-20

  1    15476   376682881  25-FEB-20 376683008  25-FEB-20

  1    15477   376683008  25-FEB-20 376728106  25-FEB-20

  1    15478   376728106  25-FEB-20 376745863  26-FEB-20

BS Key  Size       Device Type Elapsed Time Completion Time

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

16993   112.50K    DISK        00:00:02     26-FEB-20

        BP Key: 16996   Status: AVAILABLE  Compressed: YES  Tag: TAG20200226T040345

        Piece Name: /u03/ORCL/ORCL_17009_1_1_inc

  List of Archived Logs in backup set 16993

  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

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

  1    15479   376745863  26-FEB-20 376745976  26-FEB-20

BS Key  Size       Device Type Elapsed Time Completion Time

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

16994   133.87M    DISK        00:00:23     27-FEB-20

        BP Key: 17001   Status: AVAILABLE  Compressed: YES  Tag: TAG20200227T040153

        Piece Name: /u03/ORCL/ORCL_17010_1_1_inc

  List of Archived Logs in backup set 16994

  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

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

  1    15469   376538978  22-FEB-20 376568556  23-FEB-20

  1    15470   376568556  23-FEB-20 376606639  23-FEB-20

  1    15471   376606639  23-FEB-20 376618751  24-FEB-20

  1    15472   376618751  24-FEB-20 376618845  24-FEB-20

  1    15473   376618845  24-FEB-20 376663756  24-FEB-20

  1    15474   376663756  24-FEB-20 376677937  25-FEB-20

  1    15475   376677937  25-FEB-20 376682881  25-FEB-20

  1    15476   376682881  25-FEB-20 376683008  25-FEB-20

  1    15477   376683008  25-FEB-20 376728106  25-FEB-20

  1    15478   376728106  25-FEB-20 376745863  26-FEB-20

  1    15479   376745863  26-FEB-20 376745976  26-FEB-20

  1    15480   376745976  26-FEB-20 376791447  26-FEB-20

  1    15481   376791447  26-FEB-20 376808760  27-FEB-20

RMAN> restore database until sequence 15480;

Starting restore at 28-FEB-20

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backupset restore

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

restoring datafile 00001 to /oracle/oradata/ORCL/system01.dbf

restoring datafile 00002 to /oracle/oradata/ORCL/undotbs01.dbf

restoring datafile 00003 to /oracle/oradata/ORCL/sysaux01.dbf

restoring datafile 00004 to /oracle/oradata/ORCL/ORCL_data01.dbf

restoring datafile 00005 to /oracle/oradata/ORCL/ORCL_INDEX01.dbf

restoring datafile 00006 to /oracle/oradata/ORCL/ORCLbi_data01.dbf

restoring datafile 00007 to /oracle/oradata/ORCL/ORCLbi_index01.dbf

restoring datafile 00008 to /oracle/oradata/ORCL/users01.dbf

restoring datafile 00009 to /oracle/oradata/ORCL/ORCL_data02.dbf

restoring datafile 00010 to /oracle/oradata/ORCL/system02.dbf

restoring datafile 00011 to /oracle/oradata/ORCL/sysaux03.dbf

restoring datafile 00012 to /oracle/oradata/ORCL/ORCLbi_data02.dbf

restoring datafile 00013 to /oracle/oradata/ORCL/sysaux02.dbf

channel ORA_DISK_1: reading from backup piece /u03/ORCL/ORCL_16996_1_1_full

channel ORA_DISK_1: restored backup piece 1

piece handle=/u03/ORCL/ORCL_16996_1_1_full tag=TAG20200223T040229

channel ORA_DISK_1: restore complete, elapsed time: 00:10:46

Finished restore at 28-FEB-20

RMAN>

RMAN>

RMAN> recover database until sequence 15480;

Starting recover at 28-FEB-20

using channel ORA_DISK_1

channel ORA_DISK_1: starting incremental datafile backupset restore

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

destination for restore of datafile 00001: /oracle/oradata/ORCL/system01.dbf

destination for restore of datafile 00002: /oracle/oradata/ORCL/undotbs01.dbf

destination for restore of datafile 00003: /oracle/oradata/ORCL/sysaux01.dbf

destination for restore of datafile 00004: /oracle/oradata/ORCL/ORCL_data01.dbf

destination for restore of datafile 00005: /oracle/oradata/ORCL/ORCL_INDEX01.dbf

destination for restore of datafile 00006: /oracle/oradata/ORCL/ORCLbi_data01.dbf

destination for restore of datafile 00007: /oracle/oradata/ORCL/ORCLbi_index01.dbf

destination for restore of datafile 00008: /oracle/oradata/ORCL/users01.dbf

destination for restore of datafile 00009: /oracle/oradata/ORCL/ORCL_data02.dbf

destination for restore of datafile 00010: /oracle/oradata/ORCL/system02.dbf

destination for restore of datafile 00011: /oracle/oradata/ORCL/sysaux03.dbf

destination for restore of datafile 00012: /oracle/oradata/ORCL/ORCLbi_data02.dbf

destination for restore of datafile 00013: /oracle/oradata/ORCL/sysaux02.dbf

channel ORA_DISK_1: reading from backup piece /u03/ORCL/ORCL_16999_1_1_inc

channel ORA_DISK_1: restored backup piece 1

piece handle=/u03/ORCL/ORCL_16999_1_1_inc tag=TAG20200224T040140

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

channel ORA_DISK_1: starting incremental datafile backupset restore

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

destination for restore of datafile 00001: /oracle/oradata/ORCL/system01.dbf

destination for restore of datafile 00002: /oracle/oradata/ORCL/undotbs01.dbf

destination for restore of datafile 00003: /oracle/oradata/ORCL/sysaux01.dbf

destination for restore of datafile 00004: /oracle/oradata/ORCL/ORCL_data01.dbf

destination for restore of datafile 00005: /oracle/oradata/ORCL/ORCL_INDEX01.dbf

destination for restore of datafile 00006: /oracle/oradata/ORCL/ORCLbi_data01.dbf

destination for restore of datafile 00007: /oracle/oradata/ORCL/ORCLbi_index01.dbf

destination for restore of datafile 00008: /oracle/oradata/ORCL/users01.dbf

destination for restore of datafile 00009: /oracle/oradata/ORCL/ORCL_data02.dbf

destination for restore of datafile 00010: /oracle/oradata/ORCL/system02.dbf

destination for restore of datafile 00011: /oracle/oradata/ORCL/sysaux03.dbf

destination for restore of datafile 00012: /oracle/oradata/ORCL/ORCLbi_data02.dbf

destination for restore of datafile 00013: /oracle/oradata/ORCL/sysaux02.dbf

channel ORA_DISK_1: reading from backup piece /u03/ORCL/ORCL_17003_1_1_inc

channel ORA_DISK_1: restored backup piece 1

piece handle=/u03/ORCL/ORCL_17003_1_1_inc tag=TAG20200225T040200

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

channel ORA_DISK_1: starting incremental datafile backupset restore

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

destination for restore of datafile 00001: /oracle/oradata/ORCL/system01.dbf

destination for restore of datafile 00002: /oracle/oradata/ORCL/undotbs01.dbf

destination for restore of datafile 00003: /oracle/oradata/ORCL/sysaux01.dbf

destination for restore of datafile 00004: /oracle/oradata/ORCL/ORCL_data01.dbf

destination for restore of datafile 00005: /oracle/oradata/ORCL/ORCL_INDEX01.dbf

destination for restore of datafile 00006: /oracle/oradata/ORCL/ORCLbi_data01.dbf

destination for restore of datafile 00007: /oracle/oradata/ORCL/ORCLbi_index01.dbf

destination for restore of datafile 00008: /oracle/oradata/ORCL/users01.dbf

destination for restore of datafile 00009: /oracle/oradata/ORCL/ORCL_data02.dbf

destination for restore of datafile 00010: /oracle/oradata/ORCL/system02.dbf

destination for restore of datafile 00011: /oracle/oradata/ORCL/sysaux03.dbf

destination for restore of datafile 00012: /oracle/oradata/ORCL/ORCLbi_data02.dbf

destination for restore of datafile 00013: /oracle/oradata/ORCL/sysaux02.dbf

channel ORA_DISK_1: reading from backup piece /u03/ORCL/ORCL_17007_1_1_inc

channel ORA_DISK_1: restored backup piece 1

piece handle=/u03/ORCL/ORCL_17007_1_1_inc tag=TAG20200226T040206

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

starting media recovery

channel ORA_DISK_1: starting archive log restore to default destination

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=15479

channel ORA_DISK_1: reading from backup piece /u03/ORCL/ORCL_17010_1_1_inc

channel ORA_DISK_1: restored backup piece 1

piece handle=/u03/ORCL/ORCL_17010_1_1_inc tag=TAG20200227T040153

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

archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_28/o1_mf_1_15479_h5lhfmvz_.arc thread=1 sequence=15479

channel default: deleting archive log(s)

archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_28/o1_mf_1_15479_h5lhfmvz_.arc recid=15551 stamp=1033595403

media recovery complete, elapsed time: 00:00:02

Finished recover at 28-FEB-20

RMAN>

RMAN> alter database open resetlogs;

database opened

RMAN>

SQL> select name,open_mode from v$database;

NAME      OPEN_MODE

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

ORCL    READ WRITE

Oracle Database Cloning using Backup sets

Development environment required copy of production database, below are the steps for cloning

High Level Steps

A. Target Side
     1. Prepare Target Environment for Oracle Database cloning
     2. Install Oracle binaries same as source environment
     3. Create necessary directory structure for target database

B. Source Side
     1. Create pfile from source database and transfer to target system
     2. Full backup of database and transfer to target system

C. Target Side
     1. Verify all backup pieces copied to target
     2. Modify pfile as per the target environment
     3. Start the target database in NMOUNT using modified pfile
     4. Connect to RMAN utility
                clone database using “duplicate database to <CloneDB Name>  backup location”.
     5. Check the database status, datafile, redologs, tempfile

Create necessary directory structure at target

mkdir -p /u01/app/oracle/oradata/orclcln
mkdir -p /home/oracle/DILIP/oradata/orclcln/ARCHIVELOG
mkdir -p /u01/app/oracle/admin/orclcln/adump
mkdir -p /u01/app/oracle/admin/orclcln/adump

Take Backup of source database

RMAN_FULL_TEST.sh

#RMAN Full backup Scripts

#!/bin/ksh

ORACLE_HOSTNAME=server1.example.com; export ORACLE_HOSTNAME

ORACLE_UNQNAME=oracle; export ORACLE_UNQNAME

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME

ORACLE_SID=oracle; export ORACLE_SID

PATH=/usr/sbin:$PATH; export PATH

PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH

CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

mkdir /home/oracle/TEST_2016/ORACLE_"$(date +"%d-%m-%Y")"

test=/home/oracle/TEST_2016/ORACLE_"$(date +"%d-%m-%Y")"

rman target=/ << EOF

RUN {

  ALLOCATE CHANNEL ch1 TYPE

    DISK FORMAT '$test/%d_DB_%u_%s_%p';

  BACKUP DATABASE CURRENT CONTROLFILE SPFILE PLUS ARCHIVELOG;

  DELETE FORCE NOPROMPT EXPIRED BACKUP DEVICE TYPE DISK;

  DELETE FORCE NOPROMPT OBSOLETE;

  RELEASE CHANNEL ch1;

}

EXIT;

EOF

Check the backup files created

ls -lrt /home/oracle/TEST_2016/ORACLE_06-02-2020

total 1096672

-rw-r----- 1 oracle oinstall   2963456 Feb  6 20:14 ORACLE_DB_tqunskku_17338_1

-rw-r----- 1 oracle oinstall 559357952 Feb  6 20:15 ORACLE_DB_trunskl0_17339_1

-rw-r----- 1 oracle oinstall   1523712 Feb  6 20:16 ORACLE_DB_tsunsknv_17340_1

-rw-r----- 1 oracle oinstall     98304 Feb  6 20:16 ORACLE_DB_ttunsko1_17341_1

-rw-r----- 1 oracle oinstall     14848 Feb  6 20:16 ORACLE_DB_tuunsko2_17342_1

Now transfer the backup files from source to target system using scp command

scp /home/oracle/TEST_2016/ORACLE_06-02-2020/* oracle@192.168.5.10:/home/oracle/TEST_2016/ORACLE_06-02-2020

oracle@192.168.5.10's password:

ORACLE_DB_tqunskku_17338_1                           100% 2894KB   2.8MB/s   00:00

ORACLE_DB_trunskl0_17339_1                             100%  533MB 133.4MB/s   00:04

ORACLE_DB_tsunsknv_17340_1                            100% 1488KB   1.5MB/s   00:00

ORACLE_DB_ttunsko1_17341_1                            100%   96KB  96.0KB/s   00:00

ORACLE_DB_tuunsko2_17342_1                           100%   15KB  14.5KB/s   00:00

Modify pfile as per the target environment

cat /home/oracle/DILIP/oradata/orclcln/PFILE_ORCLCLN_NEW.ora'

orclcln.__db_cache_size=301989888

orclcln.__java_pool_size=33554432

orclcln.__large_pool_size=16777216

orclcln.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

orclcln.__pga_aggregate_target=553648128

orclcln.__sga_target=1056964608

orclcln.__shared_io_pool_size=0

orclcln.__shared_pool_size=654311424

orclcln.__streams_pool_size=33554432

*.audit_file_dest='/u01/app/oracle/admin/orclcln/adump'

*.audit_trail='db'

*.compatible='11.2.0.0.0'

*.control_files='/u01/app/oracle/oradata/orclcln/control01.ctl','/u01/app/oracle/oradata/orclcln/control02.ctl'#Restore Controlfile

*.db_file_name_convert='/u01/app/oracle/oradata/oracle/','/u01/app/oracle/oradata/orclcln/'

*.log_file_name_convert='/u01/app/oracle/oradata/oracle/','/u01/app/oracle/oradata/orclcln/'

*.db_block_size=8192

*.db_domain=''

*.db_name='orclcln'

*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area/ORCLCLN'

*.db_recovery_file_dest_size=8589934592

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclclnXDB)'

*.log_archive_dest_1='LOCATION=/home/oracle/DILIP/oradata/orclcln/ARCHIVELOG'

*.log_archive_dest_10=''

*.memory_target=1607467008

*.open_cursors=300

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.undo_tablespace='UNDOTBS'

set environment variable and start the database in nomount mode

export ORACLE_SID orclcln
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
sqlplus / as sysdba
startup nomount pfile='/home/oracle/DILIP/oradata/orclcln/PFILE_ORCLCLN_NEW.ora';

connect to rman utility and clone the database using backup location

$ORACLE_HOME/bin/rman auxiliary '/'

run
{
SET NEWNAME FOR DATABASE  TO '/u01/app/oracle/oradata/orclcln/%b';
duplicate database to orclcln  backup location '/home/oracle/TEST_2016/ORACLE_06-02-2020' nofilenamecheck;
}