oracle rman备份时间,Oracle RMAN备份（一）

SQL>

第三步：完全备份

[oracle@dbaul01 rman]$ rman target /

Recovery Manager: Release 11.2.0.4.0 -

Production on Fri Dec 9 00:06:54 2016

Copyright (c) 1982, 2011, Oracle and/or its

affiliates.  All rights reserved.

connected to target database: ORCL

(DBID=1457544464)

RMAN> show all;

using target database control file instead

of recovery catalog

RMAN configuration parameters for database

with db_unique_name ORCL are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1;

# default

CONFIGURE BACKUP OPTIMIZATION OFF; #

default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; #

default

CONFIGURE CONTROLFILE AUTOBACKUP OFF; #

default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR

DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1

BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE

TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR

DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; #

default

CONFIGURE ENCRYPTION FOR DATABASE OFF; #

default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; #

default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS

OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO

NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO

'/u01/app/product/db/dbs/snapcf_orcl.f'; # default

RMAN>backup database;

Starting backup at 09-DEC-16

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=36 device type=DISK

channel ORA_DISK_1: starting full datafile

backup set

channel ORA_DISK_1: specifying datafile(s)

in backup set

input datafile file number=00006 name=/u01/app/oradata/rman/an.dbf

input datafile file number=00001

name=/u01/app/oradata/orcl/system01.dbf

input datafile file number=00002

name=/u01/app/oradata/orcl/sysaux01.dbf

input datafile file number=00003

name=/u01/app/oradata/orcl/undotbs01.dbf

input datafile file number=00005

name=/u01/app/oradata/rm/rm02.dbf

input datafile file number=00004

name=/u01/app/oradata/orcl/users01.dbf

channel ORA_DISK_1: starting piece 1 at

09-DEC-16

channel ORA_DISK_1: finished piece 1 at

09-DEC-16

piece handle=/u01/app/fast_recovery_area/ORCL/backupset/2016_12_09/o1_mf_nnndf_TAG20161209T000843_d4m1dgsq_.bkp

tag=TAG20161209T000843 comment=NONE

channel ORA_DISK_1: backup set complete,

elapsed time: 00:04:21

channel ORA_DISK_1: starting full datafile

backup set

channel ORA_DISK_1: specifying datafile(s)

in backup set

including current control file in backup

set

including current SPFILE in backup set

channel ORA_DISK_1: starting piece 1 at

09-DEC-16

channel ORA_DISK_1: finished piece 1 at

09-DEC-16

piece handle=/u01/app/fast_recovery_area/ORCL/backupset/2016_12_09/o1_mf_ncsnf_TAG20161209T000843_d4m1nqrf_.bkp

tag=TAG20161209T000843 comment=NONE

channel ORA_DISK_1: backup set complete,

elapsed time: 00:00:01

Finished backup at 09-DEC-16

RMAN>