Configuring and Backing Up Oracle Databases Using RMAN - OCP: Oracle Database 12c Administrator Certified Professional - page 148

input archived log thread=1 sequence=45 RECID=44 STAMP=664655986
channel ORA_DISK_1: starting piece 1 at 05-SEP-13
channel ORA_DISK_1: finished piece 1 at 05-SEP-13
piece handle=C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUP SET\2013_09_05\
O1_MF_ANNNN_TAG20080905T183946_4D3NBS89_.BKP tag=TAG20080905T183946
comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: deleting archived log(s)
archived log file name=C:\ORACLE\ARCH\ORCL\ARC00045_0662757171.001
RECID=44 STAMP=664655986
Finished backup at 05-SEP-13
You can also do backups of tablespaces and data files using the BACKUP command, as
shown in these examples:
RMAN>Backup tablespace users;
RMAN>Backup datafile 3;
In Exercise 3.2, you'll execute an online backup using RMAN.
exeRCiSe 3.2
executing an Online Backup
In this exercise, you will perform an online backup of your ARCHIVELOG mode database.
Your database should already be in ARCHIVELOG mode (see Exercise 3.1). Once the data-
base is in ARCHIVELOG mode, you can do this exercise.
1. Log into the database using SQL*Plus:
C:\oracle\admin\ORCL\wallet>set oracle_sid=orcl
C:\oracle\admin\ORCL\wallet>sqlplus "/ as sysdba"
SQL*Plus: Release 12.1.0.1.0 Production on Thu Feb 20 14:43:47 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing
options
2. Query the LOG_MODE column of the V$DATABASE view to confirm that the database is in
ARCHIVELOG mode. If the database is not in ARCHIVELOG mode, refer to Chapter 1
for information on how to put the database in ARCHIVELOG mode.
SQL> Select log_mode from v$database;
LOG_MODE
------------
ARCHIVELOG