RAC Database Restore and Recover scenario - RAC to RAC Restore and Recover

RAC Database Restore & Recover:

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

RAC Database Restore and Recover scenario - RAC to RAC Restore and Recover

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

1. Prestep take source DB backups and tranfer 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@10.38.4.110:/u01/backup/.

2. Restore and Recover on target server:

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

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

restore controlfile from '/u01/backup/Controlback_20220301_1e0naptc_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;

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

Regards,

Mallik