Vismo Technologies — Oracle DBA Knowledge Hub: Restore & Recover Vs Clone

Restore & Recover Vs Clone - RMAN Restore and Clone differences

1. Source Database Details and Source Database Backup
2. Copy Source Database Backup to Target Server
3. RMAN Restore and Recover on Target Server to build new Database
4. RMAN Clone on Target Server to build new Database

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

This Entire Activity logs can be found at bottom of this Article:

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

1. Source Database Details and Source Database Backup

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

env |grep ORA

sqlplus / as sysdba

select DBID from v$database;

rman target /

run {

allocate channel ch1 device type disk;

crosscheck backup;

crosscheck archivelog all;

DELETE noprompt BACKUP COMPLETED BEFORE 'SYSDATE-2';

DELETE noprompt archivelog all COMPLETED BEFORE 'SYSDATE-1';

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

release channel ch1;

}

2. Copy Source Database Backup to Target Server

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

scp * oracle@10.38.4.109:/u01/backup/

scp /u01/app/oracle/fast_recovery_area/DEVDB/autobackup/2021_07_05/o1_mf_s_1077141943_jg6f6ztt_.bkp oracle@10.38.4.109:/u01/backup/

3. RMAN Restore and Recover on Target Server to build new Database

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

1. Take Source DB backup

2. Copy backups to Target Server

3. Start the Target Server DB in nomount

4. Restore Target DB controlfile

5. Restore Target DB

6. Recover Target DB

7. Open Target DB with resetlogs

Notes:

1. Target DB name is same as source DB name

2. Target DBID same as Source DBID

mkdir -p /u01/app/oracle/fast_recovery_area/DEVDB/archivelog

mkdir -p /u01/app/oracle/oradata/DEVDB/datafile

mkdir -p /u01/app/oracle/oradata/DEVDB/controlfile

mkdir -p /u01/app/oracle/fast_recovery_area/DEVDB/controlfile

sqlplus / as sysdba

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

rman target /

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

alter database mount;

run {

restore database;

switch datafile all;

recover database;

}

alter database open resetlogs;

select DBID from v$database;

4. RMAN Clone on Target Server to build new Database

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

1. Take Source DB backup

2. Copy backups to Target Server

3. Start the Target Server DB in nomount

4. Clone the the Database (Source to Target)

Notes:

1. Target DB name may or maynot be same as source DB name(As per your wish)

2. Target DBID different that the Source DBID

mkdir -p /u01/app/oracle/fast_recovery_area/DEVDB/archivelog

mkdir -p /u01/app/oracle/oradata/DEVDB/datafile

mkdir -p /u01/app/oracle/oradata/DEVDB/controlfile

mkdir -p /u01/app/oracle/fast_recovery_area/DEVDB/controlfile

sqlplus / as sysdba

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

Clone with same name as source database Name

rman AUXILIARY /

run {

DUPLICATE TARGET DATABASE TO DEVDB

SPFILE

BACKUP LOCATION '/u01/backup'

NOFILENAMECHECK;

}

Clone with different name as source database Name

sqlplus / as sysdba

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

rman AUXILIARY /

run{

DUPLICATE DATABASE TO DEV

SPFILE

parameter_value_convert ('DEVDB','DEV')

set db_file_name_convert='/u01/app/oracle/oradata/DEVDB','/u01/app/oracle/oradata/DEV'

set log_file_name_convert='/u01/app/oracle/oradata/DEVDB','/u01/app/oracle/oradata/DEV','/u01/app/oracle/fast_recovery_area/DEVDB','/u01/app/oracle/fast_recovery_area/DEV'

set control_files='/u01/app/oracle/oradata/DEV/controlfile/control01.ctl','/u01/app/oracle/fast_recovery_area/DEV/controlfile/control02.ctl'

set db_name='DEV'

set log_archive_dest_1='location=/u01/app/oracle/fast_recovery_area/DEV'

BACKUP LOCATION '/u01/backup'

NOFILENAMECHECK;

}

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

logs:

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

Source Database Details and Source Database Backup

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

[oracle@oraclelab2 ~]$ ps -ef|grep smon

salcorp1 16260 1 0 Jun24 ? 00:00:31 ora_smon_alcprd01

oracle 16686 16618 0 22:03 pts/2 00:00:00 grep --color=auto smon

salcorp2 17574 1 0 Jun24 ? 00:00:16 ora_smon_alcprd02

oracle 20280 1 0 03:09 ? 00:00:01 ora_smon_DEVDB

[oracle@oraclelab2 ~]$ . oraenv

ORACLE_SID = [oracle] ? DEVDB

The Oracle base has been set to /u01/app/oracle

[oracle@oraclelab2 ~]$ env |grep ORA

ORACLE_SID=DEVDB

ORACLE_BASE=/u01/app/oracle

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

[oracle@oraclelab2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jul 5 22:04:05 2021

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 DBID from v$database;

DBID

----------

981794806

SQL>

[oracle@oraclelab2 backup]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Mon Jul 5 22:05:05 2021

Version 19.3.0.0.0

connected to target database: DEVDB (DBID=981794806)

RMAN> run {

allocate channel ch1 device type disk;

2> 3> crosscheck backup;

4> crosscheck archivelog all;

5> DELETE noprompt BACKUP COMPLETED BEFORE 'SYSDATE-2';

DELETE noprompt archivelog all COMPLETED BEFORE 'SYSDATE-1';

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

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

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

release channel ch1;

}10> 11>

using target database control file instead of recovery catalog

allocated channel: ch1

channel ch1: SID=4 device type=DISK

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/backup/Archive_20210705_1i036bhd_1_1 RECID=50 STAMP=1077095981

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/backup/Fullback_20210705_1j036bhg_1_1 RECID=51 STAMP=1077095984

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/backup/Archive_20210705_1k036bhn_1_1 RECID=52 STAMP=1077095991

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/backup/Controlback_20210705_1l036bhp_1_1 RECID=53 STAMP=1077095994

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/app/oracle/fast_recovery_area/DEVDB/autobackup/2021_07_05/o1_mf_s_1077095995_jg50c360_.bkp RECID=54 STAMP=1077095995

Crosschecked 5 objects