ORACLE DATABASE Physical refresh from PROD to NON PROD || Restoring database from one system to another
Source db = ABC Dest db = DEF Considering the following: 1. the OS version and db version of both the db is same. 2. the source db is running in archivelog mode. 3. Backup mount points on source is /backup and on destination is /rman_backup Taking RMAN backup on source database Check whether the source DB is running in archivelog mode or not. run the below command su – oracle; sqlplus / as sysdba archive log list In case the source DB is running in archivelog mode, then do the below steps to take the online backup of source DB using rman: Copy the below contents into a file /tmp/archivelogdbbkp.rman RUN { CROSSCHECK BACKUPSET; CROSSCHECK BACKUP; BACKUP CURRENT CONTROLFILE FORMAT '/backup/CONTROLFILE_BACKUP_%d_%T_%t_%s_%p.rman'; CROSSCHECK COPY; CROSSCHECK ARCHIVELOG ALL; CROSSCHECK BACKUP; DELETE NOPROMPT EXPIRED BACKUPSET; DELETE NOPROMPT EXPIRED BACKUP; DELETE NOPROMPT EXPIRED COPY; DELET...