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
三、备份完毕
关注微信