Performing Oracle User-Managed Backups - OCP: Oracle Database 12c Administrator Certified Professional - page 36

Performing Oracle Offline Backups
We have been talking a lot about ARCHIVELOG mode and preparing for online backups,
but we first need to talk about how to do offline backups in Oracle. Offline backups are
actually quite easy to do, as you will see in Exercise 1.3, where you will be backing up a
database with an offline backup.
This is the kind of manual backup you may be asked about in the OCP exam.
exeRCiSe 1.3
executing an Offline Backup
In this exercise, you will be executing an offline backup of your database. Follow these
steps to back up a database with an offline backup:
1. First, you need to determine which files to back up. You will need to know the loca-
tion of the data files, the control file, and the online redo logs. You use the FILE_NAME
column of the DBA_DATA_FILES view to find the data files:
SQL> Select file_name from dba_data_files;
FILE_NAME
--------------------------------------------
C:\ORACLE\ORADATA\ORCL\USERS01.DBF
C:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF
C:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF
C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
C:\ORACLE\ORADATA\ORCL\REVEAL_DATA_01.DBF
C:\ORACLE\ORADATA\ORCL\REVEAL_INDEX_01.DBF
C:\ORACLE\ORADATA\ORCL\USERS02.DBF
7 rows selected.
2. You use the MEMBER column in the V$LOGFILE view to find the location of all the online
redo logs:
SQL> select member from v$logfile;
MEMBER
-----------------------------------
C:\ORACLE\ORADATA\ORCL\REDO03A.LOG