Oracle RMAN备份（一）

第一步：查看归档

SQL> archive log list;

Database log mode        No Archive Mode

Automatic archival         Disabled

Archive destination        USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     61

Current log sequence             63

SQL>

第二步：开启归档

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

 

Total System Global Area  780824576 bytes

Fixed Size              2257312 bytes

Variable Size                511708768 bytes

Database Buffers      264241152 bytes

Redo Buffers                 2617344 bytes

Database mounted.

SQL> alter database archivelog;

 

Database altered.

 

SQL> archive log list;

Database log mode        Archive Mode

Automatic archival         Enabled

Archive destination        USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     61

Next log sequence to archive   63

Current log sequence             63

SQL> alter database open;

 

Database altered.

 

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>