Oracle DB 备份回复目录
日期：2014-05-16 浏览次数：20405 次
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_
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
