Mallik034: RAC to RAC Database Restore Recover Vs RMAN Clone

RAC to RAC Database Restore Recover Vs RMAN Clone:

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

1. Prestep take source DB backups and transfer it to target
2. Restore and Recover schenario:
3. RMAN Clone schenario:
4. Post Restore/Clone Steps:

1. Prestep take source DB backups and transfer it to target

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

rman target /

run {

allocate channel ch1 device type disk;

backup as backupset database format '/u01/backup/Fullback_%T_%U'

plus archivelog format '/u01/backup/Archive_%T_%U';

backup current controlfile format '/u01/backup/Controlback_%T_%U';

backup spfile format '/u01/backup/spfile_%T_%U';

release channel ch1;

}

scp /u01/backup/* oracle@target:/u01/backup/.

[oracle@oranode1 backup]$ . oraenv

ORACLE_SID = [DEVDB1] ?

ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/19.0.0.0/dbhome_1

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

[oracle@oranode1 backup]$

[oracle@oranode1 backup]$ env |grep ORA

ORACLE_SID=DEVDB1

ORACLE_BASE=/u01/app/oracle

ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1

[oracle@oranode1 backup]$

[oracle@oranode1 backup]$ pwd

/u01/backup

[oracle@oranode1 backup]$ ls -ltrh

total 0

[oracle@oranode1 backup]$

[oracle@oranode1 backup]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Fri Feb 18 19:51:40 2022

Version 19.3.0.0.0

connected to target database: DEVDB (DBID=1000656445)

RMAN> run {

allocate channel ch1 device type disk;

2> 3> backup as backupset database format '/u01/backup/Fullback_%T_%U'

4> plus archivelog format '/u01/backup/Archive_%T_%U';

5> backup current controlfile format '/u01/backup/Controlback_%T_%U';

backup spfile format '/u01/backup/spfile_%T_%U';

6> 7> release channel ch1;

8> }

using target database control file instead of recovery catalog

allocated channel: ch1

channel ch1: SID=295 instance=DEVDB1 device type=DISK

Starting backup at 18-FEB-22

current log archived

channel ch1: starting archived log backup set

channel ch1: specifying archived log(s) in backup set

input archived log thread=2 sequence=7 RECID=2 STAMP=1096938623

input archived log thread=1 sequence=19 RECID=1 STAMP=1096938621

input archived log thread=1 sequence=20 RECID=3 STAMP=1096938655

input archived log thread=2 sequence=8 RECID=4 STAMP=1096938655

input archived log thread=1 sequence=21 RECID=5 STAMP=1096940093

input archived log thread=2 sequence=9 RECID=6 STAMP=1096940093

input archived log thread=1 sequence=22 RECID=7 STAMP=1096940114

input archived log thread=2 sequence=10 RECID=8 STAMP=1096940084

input archived log thread=1 sequence=23 RECID=9 STAMP=1097005913

input archived log thread=2 sequence=11 RECID=10 STAMP=1097005882

channel ch1: starting piece 1 at 18-FEB-22

channel ch1: finished piece 1 at 18-FEB-22

piece handle=/u01/backup/Archive_20220218_050m3uhu_1_1 tag=TAG20220218T195153 comment=NONE

channel ch1: backup set complete, elapsed time: 00:00:03

Finished backup at 18-FEB-22

Starting backup at 18-FEB-22

channel ch1: starting full datafile backup set

channel ch1: specifying datafile(s) in backup set

input datafile file number=00003 name=+DATA/DEVDB/DATAFILE/sysaux.268.1095926363

input datafile file number=00001 name=+DATA/DEVDB/DATAFILE/system.267.1095926327

input datafile file number=00004 name=+DATA/DEVDB/DATAFILE/undotbs1.269.1095926387

input datafile file number=00005 name=+DATA/DEVDB/DATAFILE/undotbs2.275.1095926641

input datafile file number=00007 name=+DATA/DEVDB/DATAFILE/users.270.1095926389

channel ch1: starting piece 1 at 18-FEB-22

channel ch1: finished piece 1 at 18-FEB-22

piece handle=/u01/backup/Fullback_20220218_060m3ui1_1_1 tag=TAG20220218T195156 comment=NONE

channel ch1: backup set complete, elapsed time: 00:00:15

Finished backup at 18-FEB-22

Starting backup at 18-FEB-22

current log archived

channel ch1: starting archived log backup set

channel ch1: specifying archived log(s) in backup set

input archived log thread=1 sequence=24 RECID=11 STAMP=1097005932

input archived log thread=2 sequence=12 RECID=12 STAMP=1097005902

channel ch1: starting piece 1 at 18-FEB-22

channel ch1: finished piece 1 at 18-FEB-22

piece handle=/u01/backup/Archive_20220218_070m3uij_1_1 tag=TAG20220218T195213 comment=NONE

channel ch1: backup set complete, elapsed time: 00:00:01

Finished backup at 18-FEB-22

Starting backup at 18-FEB-22

channel ch1: starting full datafile backup set

channel ch1: specifying datafile(s) in backup set

including current control file in backup set

channel ch1: starting piece 1 at 18-FEB-22

channel ch1: finished piece 1 at 18-FEB-22

piece handle=/u01/backup/Controlback_20220218_080m3uik_1_1 tag=TAG20220218T195214 comment=NONE

channel ch1: backup set complete, elapsed time: 00:00:01

Finished backup at 18-FEB-22

Starting backup at 18-FEB-22

channel ch1: starting full datafile backup set

channel ch1: specifying datafile(s) in backup set

including current SPFILE in backup set

channel ch1: starting piece 1 at 18-FEB-22

channel ch1: finished piece 1 at 18-FEB-22

piece handle=/u01/backup/spfile_20220218_0a0m417c_1_1 tag=TAG20220218T195216 comment=NONE

channel ch1: backup set complete, elapsed time: 00:00:01

Finished backup at 18-FEB-22

Starting Control File and SPFILE Autobackup at 18-FEB-22

piece handle=+RECO/DEVDB/AUTOBACKUP/2022_02_18/s_1097005938.273.1097005939 comment=NONE

Finished Control File and SPFILE Autobackup at 18-FEB-22

released channel: ch1

RMAN> exit

Recovery Manager complete.

[oracle@oranode1 backup]$ ls

Target:

[oracle@oraclenode1 backup]$ pwd

/u01/backup

[oracle@oraclenode1 backup]$ ls -ltrh

total 0

[oracle@oraclenode1 backup]$

Source:

[oracle@oranode1 backup]$ ls -ltrh

total 2.5G

-rw-r----- 1 oracle oinstall 441M Feb 18 19:51 Archive_20220218_050m3uhu_1_1

-rw-r----- 1 oracle oinstall 2.1G Feb 18 19:52 Fullback_20220218_060m3ui1_1_1

-rw-r----- 1 oracle oinstall 12K Feb 18 19:52 Archive_20220218_070m3uij_1_1

-rw-r----- 1 oracle oinstall 11M Feb 18 19:52 Controlback_20220218_080m3uik_1_1

-rw-r----- 1 oracle oinstall 112K Feb 18 19:52 spfile_20220218_0a0m417c_1_1

[oracle@oranode1 backup]$ pwd

/u01/backup

[oracle@oranode1 backup]$ scp /u01/backup/* oracle@10.38.4.110:/u01/backup/.

oracle@10.38.4.110's password:

Archive_20220218_050m3uhu_1_1 100% 440MB 110.1MB/s 00:04

Archive_20220218_070m3uij_1_1 100% 12KB 7.7MB/s 00:00

Controlback_20220218_080m3uik_1_1 100% 10MB 89.0MB/s 00:00

Fullback_20220218_060m3ui1_1_1 100% 2079MB 139.7MB/s 00:14

spfile_20220218_0a0m417c_1_1 100% 112KB 32.1MB/s 00:00

[oracle@oranode1 backup]$

Target:

[oracle@oraclenode1 backup]$ ls -ltrh

total 2.5G

-rw-r-----. 1 oracle oinstall 441M Feb 18 19:53 Archive_20220218_050m3uhu_1_1

-rw-r-----. 1 oracle oinstall 12K Feb 18 19:54 Archive_20220218_070m3uij_1_1

-rw-r-----. 1 oracle oinstall 11M Feb 18 19:54 Controlback_20220218_080m3uik_1_1

-rw-r-----. 1 oracle oinstall 2.1G Feb 18 19:54 Fullback_20220218_060m3ui1_1_1

-rw-r-----. 1 oracle oinstall 112K Feb 18 19:54 spfile_20220218_0a0m417c_1_1

[oracle@oraclenode1 backup]$

2. Restore and Recover scenario:

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

[oracle@oraclenode1 backup]$ ll

total 2412632

-rw-r-----. 1 oracle oinstall 263259648 Feb 18 02:08 Archive_20220218_050m3uhu_1_1

-rw-r-----. 1 oracle oinstall 67072 Feb 18 02:08 Archive_20220218_070m3uij_1_1

-rw-r-----. 1 oracle oinstall 10682368 Feb 18 02:08 Controlback_20220218_080m3uik_1_1

-rw-r-----. 1 oracle oinstall 2196406272 Feb 18 02:08 Fullback_20220218_060m3ui1_1_1

-rw-r-----. 1 oracle oinstall 114688 Feb 18 02:20 spfile_20220218_0a0m417c_1_1

[oracle@oraclenode1 backup]$

sqlplus / as sysdba

startup nomount pfile='/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/initDEVDB.ora';

rman target /

restore spfile from '/u01/backup/spfile_20220218_0a0m417c_1_1';

restore controlfile from '/u01/backup/Controlback_20220218_080m3uik_1_1';

alter database mount;

catalog start with '/u01/backup/';

run {

restore database;

recover database;

}

alter database open resetlogs;

sqlplus / as sysdba

select name, open_mode from v$database;

[oracle@oraclenode1 dbs]$ pwd

/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs

[oracle@oraclenode1 dbs]$ cat initDEVDB.ora

*.db_name=DEVDB

*.db_unique_name=DEVDB

*.cluster_database=false

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

*.db_create_file_dest='+DATA'

*.db_create_online_log_dest_1='+DATA'

*.db_create_online_log_dest_2='+RECO'

#*.db_file_name_convert='+DATA/DEVDB','+DATA/TESTDB'

#*.log_file_name_convert='+DATA/DEVDB','+DATA/TESTDB','+RECO/DEVDB','+RECO/TESTDB'

*.control_files='+DATA/DEVDB/controlfile/control01.ctl','+RECO/DEVDB/controlfile/control02.ctl'

*.db_recovery_file_dest_size=8931M

*.db_recovery_file_dest='+RECO'

*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST'

[oracle@oraclenode1 dbs]$

[oracle@oraclenode1 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Feb 18 19:15:37 2022

Version 19.3.0.0.0

Connected to an idle instance.

SQL> startup nomount pfile='/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/initDEVDB.ora';

ORACLE instance started.

Total System Global Area 343932624 bytes

Fixed Size 8896208 bytes

Variable Size 276824064 bytes

Database Buffers 50331648 bytes

Redo Buffers 7880704 bytes

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

[oracle@oraclenode1 dbs]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Fri Feb 18 19:16:02 2022

Version 19.3.0.0.0

connected to target database: DEVDB (not mounted)

RMAN> restore spfile from '/u01/backup/spfile_20220218_0a0m417c_1_1';

Starting restore at 18-FEB-22

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=437 device type=DISK

channel ORA_DISK_1: restoring spfile from AUTOBACKUP /u01/backup/spfile_20220218_0a0m417c_1_1

channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete

Finished restore at 18-FEB-22

RMAN> exit

Recovery Manager complete.

[oracle@oraclenode1 dbs]$ ll

total 20

-rw-rw----. 1 oracle oinstall 1544 Feb 18 19:15 hc_DEVDB.dat

-rw-r--r--. 1 oracle oinstall 586 Feb 18 19:15 initDEVDB.ora

-rw-r--r--. 1 oracle oinstall 591 Feb 18 19:15 initTESTDB.ora

-rw-r-----. 1 oracle oinstall 5632 Feb 18 19:16 spfileDEVDB.ora

[oracle@oraclenode1 dbs]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Fri Feb 18 19:17:03 2022

Version 19.3.0.0.0

connected to target database: DEVDB (not mounted)

RMAN> restore controlfile from '/u01/backup/Controlback_20220218_080m3uik_1_1';

Starting restore at 18-FEB-22

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=437 device type=DISK

channel ORA_DISK_1: restoring control file

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

output file name=+DATA/DEVDB/controlfile/control01.ctl

output file name=+RECO/DEVDB/controlfile/control02.ctl

Finished restore at 18-FEB-22

RMAN> alter database mount;

released channel: ORA_DISK_1

Statement processed

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

Starting implicit crosscheck backup at 18-FEB-22

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=437 device type=DISK

Crosschecked 3 objects

Finished implicit crosscheck backup at 18-FEB-22

Starting implicit crosscheck copy at 18-FEB-22

using channel ORA_DISK_1

Finished implicit crosscheck copy at 18-FEB-22

searching for all files in the recovery area

cataloging files...

no files cataloged

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

List of Files Unknown to the Database

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

File Name: /u01/backup/Controlback_20220218_080m3uik_1_1

File Name: /u01/backup/spfile_20220218_0a0m417c_1_1

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

cataloging files...

cataloging done

List of Cataloged Files

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

File Name: /u01/backup/Controlback_20220218_080m3uik_1_1

File Name: /u01/backup/spfile_20220218_0a0m417c_1_1

RMAN> run {

restore database;

recover database;

}2> 3> 4>

Starting restore at 18-FEB-22

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore

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

channel ORA_DISK_1: restoring datafile 00001 to +DATA/DEVDB/DATAFILE/system.267.1095926327

channel ORA_DISK_1: restoring datafile 00003 to +DATA/DEVDB/DATAFILE/sysaux.268.1095926363

channel ORA_DISK_1: restoring datafile 00004 to +DATA/DEVDB/DATAFILE/undotbs1.269.1095926387

channel ORA_DISK_1: restoring datafile 00005 to +DATA/DEVDB/DATAFILE/undotbs2.275.1095926641

channel ORA_DISK_1: restoring datafile 00007 to +DATA/DEVDB/DATAFILE/users.270.1095926389

channel ORA_DISK_1: reading from backup piece /u01/backup/Fullback_20220218_060m3ui1_1_1

channel ORA_DISK_1: piece handle=/u01/backup/Fullback_20220218_060m3ui1_1_1 tag=TAG20220218T013457

channel ORA_DISK_1: restored backup piece 1

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

Finished restore at 18-FEB-22

Starting recover at 18-FEB-22

using channel ORA_DISK_1

starting media recovery

channel ORA_DISK_1: starting archived log restore to default destination

channel ORA_DISK_1: restoring archived log

archived log thread=1 sequence=22

channel ORA_DISK_1: restoring archived log

archived log thread=2 sequence=10

channel ORA_DISK_1: reading from backup piece /u01/backup/Archive_20220218_070m3uij_1_1

channel ORA_DISK_1: piece handle=/u01/backup/Archive_20220218_070m3uij_1_1 tag=TAG20220218T013515

channel ORA_DISK_1: restored backup piece 1

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

archived log file name=+RECO/DEVDB/ARCHIVELOG/2022_02_18/thread_1_seq_22.1199.1097003871 thread=1 sequence=22

archived log file name=+RECO/DEVDB/ARCHIVELOG/2022_02_18/thread_2_seq_10.1132.1097003871 thread=2 sequence=10

channel default: deleting archived log(s)

archived log file name=+RECO/DEVDB/ARCHIVELOG/2022_02_18/thread_1_seq_22.1199.1097003871 RECID=9 STAMP=1097003870

unable to find archived log

archived log thread=1 sequence=23

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 02/18/2022 19:17:52

RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 23 and starting SCN of 3760150

RMAN> alter database open resetlogs;

Statement processed

RMAN> exit

Recovery Manager complete.

[oracle@oraclenode1 dbs]$

[oracle@oraclenode1 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Feb 18 19:18:45 2022

Version 19.3.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

SQL> select name, open_mode from v$database;

NAME OPEN_MODE

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

DEVDB READ WRITE

SQL>

3. RMAN Clone scenario:

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

[oracle@oraclenode1 backup]$ ll

total 2412632

-rw-r-----. 1 oracle oinstall 263259648 Feb 18 02:08 Archive_20220218_050m3uhu_1_1

-rw-r-----. 1 oracle oinstall 67072 Feb 18 02:08 Archive_20220218_070m3uij_1_1

-rw-r-----. 1 oracle oinstall 10682368 Feb 18 02:08 Controlback_20220218_080m3uik_1_1

-rw-r-----. 1 oracle oinstall 2196406272 Feb 18 02:08 Fullback_20220218_060m3ui1_1_1

-rw-r-----. 1 oracle oinstall 114688 Feb 18 02:20 spfile_20220218_0a0m417c_1_1

[oracle@oraclenode1 backup]$

sqlplus / as sysdba

startup nomount pfile='/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/initTESTDB.ora';

rman auxiliary /

duplicate target database to TESTDB backup location '/u01/backup' nofilenamecheck;

sqlplus / as sysdba

select name, open_mode from v$database;

[oracle@oraclenode1 dbs]$ pwd

/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs

[oracle@oraclenode1 dbs]$ cat initTESTDB.ora

*.db_name=TESTDB

*.db_unique_name=TESTDB

*.cluster_database=false

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

*.db_create_file_dest='+DATA'

*.db_create_online_log_dest_1='+DATA'

*.db_create_online_log_dest_2='+RECO'

*.db_file_name_convert='+DATA/DEVDB','+DATA/TESTDB'

*.log_file_name_convert='+DATA/DEVDB','+DATA/TESTDB','+RECO/DEVDB','+RECO/TESTDB'

*.control_files='+DATA/TESTDB/controlfile/control01.ctl','+RECO/TESTDB/controlfile/control02.ctl'

*.db_recovery_file_dest_size=8931M

*.db_recovery_file_dest='+RECO'

*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST'

[oracle@oraclenode1 dbs]$

[oracle@oraclenode1 dbs]$ . oraenv

ORACLE_SID = [TESTDB] ?

ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/19.0.0.0/dbhome_1

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

[oracle@oraclenode1 dbs]$

[oracle@oraclenode1 dbs]$ env |grep ORA

ORACLE_SID=TESTDB

ORACLE_BASE=/u01/app/oracle

ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1

[oracle@oraclenode1 dbs]$

[oracle@oraclenode1 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Feb 18 19:32:33 2022

Version 19.3.0.0.0

Connected to an idle instance.

SQL> startup nomount pfile='/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/initTESTDB.ora';

ORACLE instance started.

Total System Global Area 343932624 bytes

Fixed Size 8896208 bytes

Variable Size 276824064 bytes

Database Buffers 50331648 bytes

Redo Buffers 7880704 bytes

SQL>

[oracle@oraclenode1 dbs]$ rman auxiliary /

Recovery Manager: Release 19.0.0.0.0 - Production on Fri Feb 18 19:37:14 2022

Version 19.3.0.0.0

connected to auxiliary database: TESTDB (not mounted)

RMAN> duplicate target database to TESTDB backup location '/u01/backup' nofilenamecheck;

Starting Duplicate Db at 18-FEB-22

searching for database ID

found backup of database ID 1000656445

contents of Memory Script:

{

sql clone "create spfile from memory";

}

executing Memory Script

sql statement: create spfile from memory

contents of Memory Script:

{

shutdown clone immediate;

startup clone nomount;

}

executing Memory Script

Oracle instance shut down

connected to auxiliary database (not started)

Oracle instance started

Total System Global Area 343932624 bytes

Fixed Size 8896208 bytes

Variable Size 276824064 bytes

Database Buffers 50331648 bytes

Redo Buffers 7880704 bytes

contents of Memory Script:

{

sql clone "alter system set db_name =

''DEVDB'' comment=

''Modified by RMAN duplicate'' scope=spfile";

sql clone "alter system set db_unique_name =

''TESTDB'' comment=

''Modified by RMAN duplicate'' scope=spfile";

shutdown clone immediate;

startup clone force nomount

restore clone primary controlfile from '/u01/backup/Controlback_20220218_080m3uik_1_1';

alter clone database mount;

}

executing Memory Script

sql statement: alter system set db_name = ''DEVDB'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set db_unique_name = ''TESTDB'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area 343932624 bytes

Fixed Size 8896208 bytes

Variable Size 276824064 bytes

Database Buffers 50331648 bytes

Redo Buffers 7880704 bytes

Starting restore at 18-FEB-22

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=424 device type=DISK

channel ORA_AUX_DISK_1: restoring control file

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03

output file name=+DATA/TESTDB/controlfile/control01.ctl

output file name=+RECO/TESTDB/controlfile/control02.ctl

Finished restore at 18-FEB-22

database mounted

released channel: ORA_AUX_DISK_1

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=424 device type=DISK

RMAN-05529: warning: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to disk group only.

contents of Memory Script:

{

set until scn 3760150;

set newname for datafile 1 to

"+DATA";

set newname for datafile 3 to

"+DATA";

set newname for datafile 4 to

"+DATA";

set newname for datafile 5 to

"+DATA";

set newname for datafile 7 to

"+DATA";

restore

clone database

;

}

executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

Starting restore at 18-FEB-22

using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore

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

channel ORA_AUX_DISK_1: restoring datafile 00001 to +DATA

channel ORA_AUX_DISK_1: restoring datafile 00003 to +DATA

channel ORA_AUX_DISK_1: restoring datafile 00004 to +DATA

channel ORA_AUX_DISK_1: restoring datafile 00005 to +DATA

channel ORA_AUX_DISK_1: restoring datafile 00007 to +DATA

channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/Fullback_20220218_060m3ui1_1_1

channel ORA_AUX_DISK_1: piece handle=/u01/backup/Fullback_20220218_060m3ui1_1_1 tag=TAG20220218T013457

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07

Finished restore at 18-FEB-22

contents of Memory Script:

{

switch clone datafile all;

}

executing Memory Script

datafile 1 switched to datafile copy

input datafile copy RECID=6 STAMP=1097005160 file name=+DATA/TESTDB/DATAFILE/system.310.1097005153

datafile 3 switched to datafile copy

input datafile copy RECID=7 STAMP=1097005160 file name=+DATA/TESTDB/DATAFILE/sysaux.340.1097005153

datafile 4 switched to datafile copy

input datafile copy RECID=8 STAMP=1097005160 file name=+DATA/TESTDB/DATAFILE/undotbs1.301.1097005153

datafile 5 switched to datafile copy

input datafile copy RECID=9 STAMP=1097005160 file name=+DATA/TESTDB/DATAFILE/undotbs2.326.1097005153

datafile 7 switched to datafile copy

input datafile copy RECID=10 STAMP=1097005160 file name=+DATA/TESTDB/DATAFILE/users.265.1097005153

contents of Memory Script:

{

set until scn 3760150;

recover

clone database

delete archivelog

;

}

executing Memory Script

executing command: SET until clause

Starting recover at 18-FEB-22

using channel ORA_AUX_DISK_1

starting media recovery

channel ORA_AUX_DISK_1: starting archived log restore to default destination

channel ORA_AUX_DISK_1: restoring archived log

archived log thread=1 sequence=22

channel ORA_AUX_DISK_1: restoring archived log

archived log thread=2 sequence=10

channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/Archive_20220218_070m3uij_1_1

channel ORA_AUX_DISK_1: piece handle=/u01/backup/Archive_20220218_070m3uij_1_1 tag=TAG20220218T013515

channel ORA_AUX_DISK_1: restored backup piece 1

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

archived log file name=+RECO/TESTDB/ARCHIVELOG/2022_02_18/thread_1_seq_22.1138.1097005161 thread=1 sequence=22

archived log file name=+RECO/TESTDB/ARCHIVELOG/2022_02_18/thread_2_seq_10.1304.1097005161 thread=2 sequence=10

channel clone_default: deleting archived log(s)

archived log file name=+RECO/TESTDB/ARCHIVELOG/2022_02_18/thread_1_seq_22.1138.1097005161 RECID=1 STAMP=1097005161

channel clone_default: deleting archived log(s)

archived log file name=+RECO/TESTDB/ARCHIVELOG/2022_02_18/thread_2_seq_10.1304.1097005161 RECID=2 STAMP=1097005161

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

Finished recover at 18-FEB-22

Oracle instance started

Total System Global Area 343932624 bytes

Fixed Size 8896208 bytes

Variable Size 276824064 bytes

Database Buffers 50331648 bytes

Redo Buffers 7880704 bytes

contents of Memory Script:

{

sql clone "alter system set db_name =

''TESTDB'' comment=

''Reset to original value by RMAN'' scope=spfile";

sql clone "alter system reset db_unique_name scope=spfile";

}

executing Memory Script

sql statement: alter system set db_name = ''TESTDB'' comment= ''Reset to original value by RMAN'' scope=spfile

sql statement: alter system reset db_unique_name scope=spfile

Oracle instance started

Total System Global Area 343932624 bytes

Fixed Size 8896208 bytes

Variable Size 276824064 bytes

Database Buffers 50331648 bytes

Redo Buffers 7880704 bytes

sql statement: CREATE CONTROLFILE REUSE SET DATABASE "TESTDB" RESETLOGS ARCHIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

MAXLOGHISTORY 292

LOGFILE

GROUP 1 ( '+RECO', '+DATA' ) SIZE 200 M REUSE,

GROUP 2 ( '+RECO', '+DATA' ) SIZE 200 M REUSE

DATAFILE

'+DATA/TESTDB/DATAFILE/system.310.1097005153'

CHARACTER SET AL32UTF8

sql statement: ALTER DATABASE ADD LOGFILE

INSTANCE 'i2'

GROUP 3 ( '+DATA', '+RECO' ) SIZE 200 M REUSE,

GROUP 4 ( '+DATA', '+RECO' ) SIZE 200 M REUSE

contents of Memory Script:

{

set newname for tempfile 1 to

"+DATA";

switch clone tempfile all;

catalog clone datafilecopy "+DATA/TESTDB/DATAFILE/sysaux.340.1097005153",

"+DATA/TESTDB/DATAFILE/undotbs1.301.1097005153",

"+DATA/TESTDB/DATAFILE/undotbs2.326.1097005153",

"+DATA/TESTDB/DATAFILE/users.265.1097005153";

switch clone datafile all;

}

executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to +DATA in control file

cataloged datafile copy

datafile copy file name=+DATA/TESTDB/DATAFILE/sysaux.340.1097005153 RECID=1 STAMP=1097005196

cataloged datafile copy

datafile copy file name=+DATA/TESTDB/DATAFILE/undotbs1.301.1097005153 RECID=2 STAMP=1097005196

cataloged datafile copy

datafile copy file name=+DATA/TESTDB/DATAFILE/undotbs2.326.1097005153 RECID=3 STAMP=1097005196

cataloged datafile copy

datafile copy file name=+DATA/TESTDB/DATAFILE/users.265.1097005153 RECID=4 STAMP=1097005196

datafile 3 switched to datafile copy

input datafile copy RECID=1 STAMP=1097005196 file name=+DATA/TESTDB/DATAFILE/sysaux.340.1097005153

datafile 4 switched to datafile copy

input datafile copy RECID=2 STAMP=1097005196 file name=+DATA/TESTDB/DATAFILE/undotbs1.301.1097005153

datafile 5 switched to datafile copy

input datafile copy RECID=3 STAMP=1097005196 file name=+DATA/TESTDB/DATAFILE/undotbs2.326.1097005153

datafile 7 switched to datafile copy

input datafile copy RECID=4 STAMP=1097005196 file name=+DATA/TESTDB/DATAFILE/users.265.1097005153

contents of Memory Script:

{

Alter clone database open resetlogs;

}

executing Memory Script

database opened

Cannot remove created server parameter file

Finished Duplicate Db at 18-FEB-22

RMAN>

Recovery Manager complete.

[oracle@oraclenode1 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Feb 18 19:40:12 2022

Version 19.3.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

SQL> select name, open_mode from v$database;

NAME OPEN_MODE

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

TESTDB READ WRITE

SQL>

4. Post Restore/Clone Steps:

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

1. Get a pfiles from source and modify according to target environemtn

2. Start target instance using pfiles

sqlplus / as sysdba

shut immediate

cp initDEVDB.ora initDEVDB.ora_for_clone

vi /u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/initDEVDB1.ora

. oraenv

>>> DEVDB1

sqlplus / as sysdba

startup mount pfile='/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/initDEVDB1.ora';

create spfile='+DATA/DEVDB/PARAMETERFILE/spfileDEVDB.ora' from pfile='/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/initDEVDB1.ora';

shut immediate;

cp initDEVDB1.ora initDEVDB1.ora_After_RAC_Parameter_Added

Create local pfile initDEVDB1.ora point to SPFILE '+DATA/DEVDB/PARAMETERFILE/spfileDEVDB.ora'

Node1>>>

cd $ORACLE_HOME/dbs

cat > initDEVDB1.ora

spfile='+DATA/DEVDB/PARAMETERFILE/spfileDEVDB.ora'

Node2 >>>

cat > initDEVDB2.ora

spfile='+DATA/RACSB/PARAMETERFILE/spfileRACSB.ora'

sqlplus / as sysdba

startup mount;

show parameter spfile

shut immediate

Convert DEVDB database to RAC

srvctl add database -d DEVDB -n DEVDB -o '/u01/app/oracle/product/19.0.0.0/dbhome_1' -p '+DATA/DEVDB/PARAMETERFILE/spfileDEVDB.ora' -t IMMEDIATE -a 'DATA,RECO'

Add the NODE instances

srvctl add instance -d DEVDB -i DEVDB1 -n oraclenode1

srvctl add instance -d DEVDB -i DEVDB2 -n oraclenode2

srvctl config database -d DEVDB

srvctl status database -d DEVDB

srvctl start database -d DEVDB

srvctl status database -d DEVDB

srvctl stop database -d DEVDB

cp initDEVDB1.ora initDEVDB1.ora_Pointing_To_spfile

Post steps logs:

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

DEVDB:

======

[oracle@oraclenode1 dbs]$ pwd

/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs

[oracle@oraclenode1 dbs]$ . oraenv

ORACLE_SID = [TESTDB] ? DEVDB

ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/19.0.0.0/dbhome_1

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

[oracle@oraclenode1 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Feb 19 00:20:43 2022

Version 19.3.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

SQL> show parameter control

NAME TYPE VALUE

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

control_file_record_keep_time integer 7

control_files string +DATA/DEVDB/controlfile/contro

l01.ctl, +RECO/DEVDB/controlfi

le/control02.ctl

control_management_pack_access string DIAGNOSTIC+TUNING

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

[oracle@oraclenode1 dbs]$

[oracle@oraclenode1 dbs]$ ll

total 21060

-rw-rw----. 1 oracle oinstall 1544 Feb 18 19:18 hc_DEVDB.dat

-rw-rw----. 1 oracle oinstall 1544 Feb 18 19:40 hc_TESTDB.dat

-rw-r--r--. 1 oracle oinstall 581 Feb 18 19:28 initDEVDB.ora

-rw-r--r--. 1 oracle oinstall 584 Feb 18 19:35 initTESTDB.ora

-rw-r-----. 1 oracle oinstall 10600448 Feb 18 19:18 snapcf_DEVDB.f

-rw-r-----. 1 oracle oinstall 10928128 Feb 18 19:40 snapcf_TESTDB.f

-rw-r-----. 1 oracle oinstall 5632 Feb 18 19:16 spfileDEVDB.ora

-rw-r-----. 1 oracle oinstall 8704 Feb 18 22:00 spfileTESTDB.ora

[oracle@oraclenode1 dbs]$ cp initTESTDB.ora initTESTDB.ora_for_clone

[oracle@oraclenode1 dbs]$ cp initDEVDB.ora initDEVDB.ora_for_clone

[oracle@oraclenode1 dbs]$ ls -ltrh

total 21M

-rw-r-----. 1 oracle oinstall 5.5K Feb 18 19:16 spfileDEVDB.ora

-rw-rw----. 1 oracle oinstall 1.6K Feb 18 19:18 hc_DEVDB.dat

-rw-r-----. 1 oracle oinstall 11M Feb 18 19:18 snapcf_DEVDB.f

-rw-r--r--. 1 oracle oinstall 581 Feb 18 19:28 initDEVDB.ora

-rw-r--r--. 1 oracle oinstall 584 Feb 18 19:35 initTESTDB.ora

-rw-rw----. 1 oracle oinstall 1.6K Feb 18 19:40 hc_TESTDB.dat

-rw-r-----. 1 oracle oinstall 11M Feb 18 19:40 snapcf_TESTDB.f

-rw-r-----. 1 oracle oinstall 8.5K Feb 18 22:00 spfileTESTDB.ora

-rw-r--r--. 1 oracle oinstall 584 Feb 19 00:25 initTESTDB.ora_for_clone

-rw-r--r--. 1 oracle oinstall 581 Feb 19 00:25 initDEVDB.ora_for_clone

[oracle@oraclenode1 dbs]$ vi initDEVDB1.ora

[oracle@oraclenode1 dbs]$ pwd

/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs

[oracle@oraclenode1 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Feb 19 00:26:40 2022

Version 19.3.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

SQL> shut immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> SQL> SQL> SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

[oracle@oraclenode1 dbs]$ . oraenv

ORACLE_SID = [DEVDB] ? DEVDB1

ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/19.0.0.0/dbhome_1

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

[oracle@oraclenode1 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Feb 19 00:27:44 2022

Version 19.3.0.0.0

Connected to an idle instance.

SQL> startup mount pfile='/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/initDEVDB1.ora';

ORACLE instance started.

Total System Global Area 3707763120 bytes

Fixed Size 8903088 bytes

Variable Size 788529152 bytes

Database Buffers 2902458368 bytes

Redo Buffers 7872512 bytes

Database mounted.

SQL> create spfile='+DATA/DEVDB/PARAMETERFILE/spfileDEVDB.ora' from pfile='/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/initDEVDB1.ora';

File created.

SQL> shut immediate;

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production