Oracle - Hot Backup

 

 

HOT BACKUP

 

Step 1. Ensure That the Database Is in Archivelog Mode

 

SQL> archive log list;

Database log mode            Archive Mode

Automatic archival             Enabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     27

Next log sequence to archive   29

Current log sequence         29

 

Step 2. Determine Where to Copy the Backup Files

 

[oracle@oracle ~]$ cd u03/

[oracle@oracle u03]$ mkdir hotbackup

[oracle@oracle u03]$ ls

coldbackup  hotbackup

 

Step 3. Identify Which Files Need to Be Backed Up

 

SQL> select name from v$datafile;

 

NAME

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

/u01/app/oracle/oradata/ORACLE/datafile/o1_mf_system_jhobsyhf_.dbf

/u01/app/oracle/oradata/ORACLE/datafile/o1_mf_sysaux_jhobvcxq_.dbf

/u01/app/oracle/oradata/ORACLE/datafile/o1_mf_undotbs1_jhobw56w_.dbf

/u01/app/oracle/oradata/ORACLE/datafile/tspace.dbf

/u01/app/oracle/oradata/ORACLE/datafile/o1_mf_users_jhobw6bc_.dbf

 

SQL> select name from v$controlfile;

 

NAME

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

/u01/app/oracle/oradata/ORACLE/controlfile/control2.ctl

 

SQL> select member from v$logfile;

 

MEMBER

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

/u01/app/oracle/oradata/ORACLE/onlinelog/redo3.log

/u01/app/oracle/fast_recovery_area/ORACLE/onlinelog/redo3.log

/u01/app/oracle/oradata/ORACLE/onlinelog/redo1.log

/u01/app/oracle/fast_recovery_area/ORACLE/onlinelog/redo2.log

/u01/app/oracle/oradata/ORACLE/onlinelog/redo2.log

/u01/app/oracle/fast_recovery_area/ORACLE/onlinelog/redo1.log

 

6 rows selected.

Step 4. Alter the Database into Backup Mode

 

SQL> alter database begin backup;

 

Database altered.

 

Step 5. Copy the Data Files with an OS Utility

 

[oracle@oracle u03]$ cd

[oracle@oracle ~]$ cp /u01/app/oracle/oradata/ORACLE/datafile/o1_mf_system_jhobsyhf_.dbf u03/hotbackup/

[oracle@oracle ~]$ cp /u01/app/oracle/oradata/ORACLE/datafile/o1_mf_sysaux_jhobvcxq_.dbf u03/hotbackup/

[oracle@oracle ~]$ cp /u01/app/oracle/oradata/ORACLE/datafile/o1_mf_undotbs1_jhobw56w_.dbf u03/hotbackup/

[oracle@oracle ~]$ cp /u01/app/oracle/oradata/ORACLE/datafile/tspace.dbf u03/hotbackup/

[oracle@oracle ~]$ cp /u01/app/oracle/oradata/ORACLE/datafile/o1_mf_users_jhobw6bc_.dbf u03/hotbackup/

[oracle@oracle ~]$ cp /u01/app/oracle/oradata/ORACLE/controlfile/control2.ctl u03/hotbackup/

[oracle@oracle ~]$ cp /u01/app/oracle/oradata/ORACLE/onlinelog/redo3.log u03/hotbackup/

[oracle@oracle ~]$ cp /u01/app/oracle/fast_recovery_area/ORACLE/onlinelog/redo3.log u03/hotbackup/

[oracle@oracle ~]$ cp /u01/app/oracle/oradata/ORACLE/onlinelog/redo1.log u03/hotbackup/

[oracle@oracle ~]$ cp /u01/app/oracle/fast_recovery_area/ORACLE/onlinelog/redo2.log u03/hotbackup/

[oracle@oracle ~]$ cp /u01/app/oracle/oradata/ORACLE/onlinelog/redo2.log u03/hotbackup/

[oracle@oracle ~]$ cp /u01/app/oracle/fast_recovery_area/ORACLE/onlinelog/redo1.log u03/hotbackup/

[oracle@oracle ~]$ sqlplus / as sysdba

 

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Aug 9 23:10:22 2021

Version 19.3.0.0.0

 

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to:

 

 

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

 

 

Step 6. Alter the Database out of Backup Mode

 

SQL> alter database end backup;

 

Database altered.

 

SQL> select name from v$database;

 

NAME

---------

ORACLE