Hot Backup Script

For Data Guard on Small DB builds we can use the under mentioned Script also, which will help us to save time, and also we can use it for Hot backup as Old Fashion in case RMAN has some issues. or don't want to use it.


set echo on
spool hotbackup_script.log


ALTER TABLESPACE CHECK_LIST BEGIN BACKUP;
! cp /d1/oradata/manpreet01_data/manpreet/checklist_data01.dbf /d1/oradata/manpreet01_orabak/hotbk
ALTER TABLESPACE CHECK_LIST END BACKUP;


ALTER TABLESPACE REPORT_DATA BEGIN BACKUP;
! cp /d1/oradata/manpreet01_data/manpreet/compliancereport_data01.dbf /d1/oradata/manpreet01_orabak/hotbk
ALTER TABLESPACE REPORT_DATA END BACKUP;


ALTER TABLESPACE MENT_DATA BEGIN BACKUP;
! cp /d1/oradata/manpreet01_data/manpreet/payment_data01.dbf /d1/oradata/manpreet01_orabak/hotbk
ALTER TABLESPACE MENT_DATA END BACKUP;



ALTER TABLESPACE MNL_DATA BEGIN BACKUP;
!cp /d1/oradata/manpreet01_data/manpreet/pnleod01.dbf /d1/oradata/manpreet01_orabak/hotbk
ALTER TABLESPACE MNL_DATA END BACKUP;


ALTER TABLESPACE METRICS BEGIN BACKUP;
! cp /d1/oradata/manpreet01_data/manpreet/servicemetrics01.dbf /d1/oradata/manpreet01_orabak/hotbk
ALTER TABLESPACE METRICS END BACKUP;


ALTER TABLESPACE SYSAUX BEGIN BACKUP;
! cp /d1/oradata/manpreet01_data/manpreet/sysaux01.dbf /d1/oradata/manpreet01_orabak/hotbk
ALTER TABLESPACE SYSAUX END BACKUP;


ALTER TABLESPACE SYSTEM BEGIN BACKUP;
!cp /d1/oradata/manpreet01_data/manpreet/system01.dbf /d1/oradata/manpreet01_orabak/hotbk
ALTER TABLESPACE SYSTEM END BACKUP;


ALTER TABLESPACE TOOLS BEGIN BACKUP;
! cp /d1/oradata/manpreet01_data/manpreet/tools01.dbf /d1/oradata/manpreet01_orabak/hotbk
ALTER TABLESPACE TOOLS END BACKUP;


ALTER TABLESPACE UNDOTBS1 BEGIN BACKUP;
!cp /d1/oradata/manpreet01_data/manpreet/undotbs01.dbf /d1/oradata/manpreet01_orabak/hotbk
ALTER TABLESPACE UNDOTBS1 END BACKUP;


ALTER TABLESPACE USERS BEGIN BACKUP;
! cp /d1/oradata/manpreet01_data/manpreet/users01.dbf /d1/oradata/manpreet01_orabak/hotbk
ALTER TABLESPACE USERS END BACKUP;


ALTER SYSTEM SWITCH LOGFILE;
ALTER SYSTEM SWITCH LOGFILE;
ALTER SYSTEM SWITCH LOGFILE;
alter database create standby controlfile as '/d1/oradata/manpreet01_orabak/hotbk/control01.ctl';
spool off
exit;