Oracle 数据库一个大企业经常使用的一种数据.下面我们来学习一下Oralce的RMAN备份
操作环境：CentOS 6.5
Oralce 版本：Oracle 11g
一、Oracle 数据库的归档
1、查看是否归档
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
2、开启归档
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>
二、开启rman 备份
[oracle@dbaul01 rman]$ rman target /
Recovery Manager: Release 11.2.0.4.0 – Production on Fri OCT 9 00:06:54 2017
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-OCT-17
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-OCT-17
channel ORA_DISK_1: finished piece 1 at 09-OCT-17
piece handle=/u01/app/fast_recovery_area/ORCL/backupset/2017_10_09/o1_mf_nnndf_TAG20171009T000843_d4m1dgsq_.bkp tag=TAG20171009T000843 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-OCT-17
channel ORA_DISK_1: finished piece 1 at 09-OCT-17
piece handle=/u01/app/fast_recovery_area/ORCL/backupset/2017_10_09/o1_mf_ncsnf_TAG20171009T000843_d4m1nqrf_.bkp tag=TAG20171009T000843 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 09-OCT-17
三、备份完毕
