Oracle DB 备份恢复目录
将配置恢复目录的保留策略,然后备份该恢复目录。
1) 为 ORCL 数据库设置环境。
[oracle@rtest ~]$ export ORACLE_SID=test0924
2) 启动 RMAN,在不指定目录的情况下使用恢复目录数据库作为目标。
[oracle@rtest ~]$ rman target sys@rcat1028
Recovery Manager: Release 11.2.0.3.0 - Production on Mon Oct 28 16:17:22 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
target database Password: ******
connected to target database: RCAT1028 (DBID=2744053659)
RMAN>
3) 确保已将恢复目录的保留策略设置为冗余大于 1 。如果该值不大于 1 ,则至少将其设置为 2 。
RMAN> show retention policy;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name RCAT1028 are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 2
2> ;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters are successfully stored
4) 尝试备份数据库。
RMAN> backup database;
Starting backup at 28-OCT-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=190 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/28/2013 16:18:54
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
continuing other job steps, job failed will not be re-run
channel ORA_DISK_