LFILEAUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
new RMANconfiguration parameters are successfully stored
RMAN>注释:配置控制文件的备份路径
RMAN> show all; ------查看所有信息,看到已经更改了默认备份路径
RMAN configurationparameters are:
CONFIGURE RETENTIONPOLICY TO REDUNDANCY 1;
CONFIGURE BACKUPOPTIMIZATION OFF; # default
CONFIGURE DEFAULTDEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILEAUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FORDEVICE TYPE DISK TO '/DBBak/ctorl_%d_%M_%D_%U_%F';
CONFIGURE DEVICE TYPEDISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILEBACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOGBACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE DISKFORMAT '/DBBak/bak_%d_%M_%D_%U';
CONFIGURE MAXSETSIZETO UNLIMITED; # default
CONFIGURE ENCRYPTIONFOR DATABASE OFF; # default
CONFIGURE ENCRYPTIONALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOGDELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOTCONTROLFILE NAME TO '/DBSoft/product/10.2.0/db_1/dbs/snapcf_WWL.f'; # default www.2cto.com
RMAN>
7、 学习并记忆备份文件的格式:
备份文件可定义的格式符号如下
%c 备份片的复制数
%D 时间日期(DD)
%M 时间月份(MM)
%F 基于DBID的唯一名称
%u 一个8个字符的名称代表备份集鱼创建时间
%p 该备份集中的备份片号,从1开始到创建的文件数
%U 一个唯一的文件名,代表%u_%p_%c
%S 备份集的编号
%t 备份集的时间戳
%T 年月日格式(YYYYMMDD)
注意: %F 是基于DBID的唯一名称,这个格式的形式为c-IIIIIIIIII-YYYYMMDD-QQ 其中IIIIIIIII是该数据库的DBID,YYYYMMDD为日期,QQ是1-256的序列号。
8、 基于上面的配置,执行一备份案例:
1、 执行rman备份必须开启数据的归档功能:
SQL> shutdown immediate ---关闭数据库
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startupmount; ----启动数据库到mount状态
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218968 bytes
Variable Size 79693416 bytes
Database Buffers 197132288 bytes
Redo Buffers 7168000 bytes
Database mounted.
SQL> alter database archivelog; ---开启归档功能
Database altered.
SQL> archivelog list; ---查看归档状态
Database logmode Archive Mode ---归档已经打开
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online logsequence 8
Next log sequence toarchive 10
Current log sequence 10
SQL>
2、 执行rman的全库备份
[oracle@wwldbDBBak]$ rman target / ---登录到rman
www.2cto.com
Recovery Manager: Release10.2.0.1.0 - Production on 5 18 18:56:47 2012
Copyright (c) 1982, 2005,
Oracle. All rights reserved.
connected to target database:WWL (DBID=5520179, not open) ---当前数据的DBID和实例名及状态
RMAN> backupdatabase; -----执行备份数据库的命令
Starting backup at 18-5 -12 ----启动备份的时间
using target database controlfile instead of recovery catalog -----描述数据的备份模式
allocated channel: ORA_DISK_1 ----分配通道
channel ORA_DISK_1: sid=159devtype=DISK ----告诉备份的设备类型是硬盘
channel ORA_DISK_1: startingfull datafile backupset ----备份方式类型是全备
channel ORA_DISK_1:specifying datafile(s) in backupset ----根据以上条件检索出需备份的数据文件
input datafile fno=00001name=/DBData/WWL/system01.dbf ----文件信息
input datafile fno=00003name=/DBData/WWL/sysaux01.dbf