oracle19504,oracle报错解决

RMAN> backup full database format='/opt/%U_%s_%T.ora';

Starting backup at 15-SEP-10

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=39 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 09/15/2010 05:10:44

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_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 15-SEP-10

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 09/15/2010 05:10:45

ORA-19504: failed to create file "/opt/04lnu9ek_1_1_4_20100915.ora"

ORA-27040: file create error, unable to create file

Linux Error: 13: Permission denied

此问题是权限的问题,在$ORACLE_HOME/bin/

修改权限即可

chmod  6751 $ORACLE_HOME/bin/oracle

使用rman进行数据库的全备,日志必须是归档的形式。。

修改日志的归档形式

启动数据库到mount阶段:

alter database archivelog;

启动数据库

alter database open;

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值