Cannot backup or copy ORA-19602: active file in NOARCHIVELOG mode

1434 people read comment(0) Collection Report
Classification:

1, the error record is as follows:

Impdp] [root@testoracle1# bash -x /oracle/backup/scripts/rman_full_backup.sh
+ +Date+%F
DATE= + exportTwo thousand and fifteen-Twelve-02
+ DATE=Two thousand and fifteen-Twelve-02
BACK_DIR=/pddata2/oracle/backup/data + export
+ BACK_DIR=/pddata2/oracle/backup/data
+ Oracle - -c Su '
-p /pddata2/oracle/backup/data/ MKDIRTwo thousand and fifteen-Twelve-02
RMANLog=/pddata2/oracle/backup/data/Two thousand and fifteen-Twelve-02/rman_backup.LogTarget / <<EOF
Run{
BackupAsBackupset database format'\''/pddata2/oracle/backup/data/ compressedTwo thousand and fifteen-Twelve-02/full_%d_%T_%s.bak'\'';
}
Exit;
EOF
'
RMAN>Two>Three> RMAN> + Oracle - -c Su '
ChmodSeven hundred and seventy-five/pddata2/oracle/backup/data/Two thousand and fifteen-Twelve-02*
'
Impdp] [root@testoracle1#
Impdp] [root@testoracle1#
Impdp] [root@testoracle1#
Impdp] [root@testoracle1# more /pddata2/oracle/backup/data/2015-12-02/rman_backup.log

Manager: Release RecoveryEleven point two.0.1.0- ProductionOnDec WedTwo Twenty-one:Fifteen:06 Two thousand and fifteen

Copyright (c)One thousand nine hundred and eighty-two,Two thousand and nine, OracleAnd/Or ItsAll rights reserved. affiliates.

ConnectedToDatabase: POWERDES target (DBID=Three billion three hundred and ninety-one million seven hundred and sixty-one thousand six hundred and forty-three)

RMAN>Two>Three>
Backup StartingAt 02-DEC-Fifteen
Target database control usingFile Of insteadCatalog recovery
Channel: ORA_DISK_1 allocated
ORA_DISK_1: SID= channelThree hundred and ninety-sevenType=DISK device
ORA_DISK_1: starting compressed full datafile channel backupSet
ORA_DISK_1: specifying datafile channel (s)InBackupSet
RMAN-00571===========================================================:
RMAN-00569ERROR MESSAGE STACK FOLLOWS ===============: ===============
RMAN-00571===========================================================:
RMAN-03009FailureOfCommand backupOnChannel ORA_DISK_1At Twelve/02/Two thousand and fifteen Twenty-one:Fifteen:08
ORA-Nineteen thousand six hundred and twoBackup cannotOr CopyActiveFile InMode NOARCHIVELOG

RMAN>

Manager complete. Recovery
Impdp] [root@testoracle1#
Impdp] [root@testoracle1#

2 solutions of cold backup

[oracle@testoracle1 rlwrap RMAN / target ~]$
Warning: your $TERM rlwrap:Is'xterm'ButCouldn't find rlwrapIt In TheDatabase. Expect terminfoSomeProblems.

Manager: Release RecoveryEleven point two.0.1.0- ProductionOnDec WedTwo Twenty-one:Eighteen:Thirteen Two thousand and fifteen

Copyright (c)One thousand nine hundred and eighty-two,Two thousand and nine, OracleAnd/Or ItsAll rights reserved. affiliates.

ConnectedToDatabase: POWERDES target (DBID=Three billion three hundred and ninety-one million seven hundred and sixty-one thousand six hundred and forty-three)

Shutdown immediate RMAN>;

Target database control usingFile Of insteadCatalog recovery
Closed database
Dismounted database
Instance shut down Oracle

Startup mount RMAN>;

ConnectedToDatabase target (NotStarted)
实例开始
数据库安装

全系统全局区一百一十三亿五千七百五十六万四千九百二十八字节

固定尺寸二百二十一万六千七百四十四字节
变尺寸八十二亿五千四百三十九万三千五百六十字节
数据库缓冲区三十亿八千七百万七千七百四十四字节
重做缓冲区一千三百九十四万六千八百八十字节

RMAN >

3、解决办法开启归档备份

因为磁盘不够,所以此方法省略过。


4、备份控制文件

RMAN>备份控制文件格式“/ pddata2 /甲骨文/备份/数据/ 2015-12-02 / cntrl_ % % % s_ p_ T;

开始备份02•12月十五                                                                                                                                                                   
使用目标数据库控制文件而不是恢复目录
分配信道:ora_disk_1
通道ora_disk_1:希德=装置=磁盘
通道ora_disk_1:启动数据文件备份                                                                                                                                          
通道ora_disk_1:指定数据文件(S)备份
包括当前控制文件备份                                                                                                                                                   
通道ora_disk_1:启动片02•12月十五
通道ora_disk_1:完成02•12月十五手柄=/ pddata2 /甲骨文/备份/数据/二千零一十五十二02/ cntrl_5055_1_897427607标签=tag20151202t212647评论=没有
通道ora_disk_1:备份完整,经过时间:000001
完成备份02•12月十五

启动控制文件在数据库自动备份02•12月十五手柄=/ pddata2 /甲骨文/备份/数据/ ctl_auto / C三十三亿九千一百七十六万一千六百四十三二千零一十五万一千二百零二01评论=没有                                                                                                        
完成控制文件在数据库自动备份02•12月十五

RMAN>   

5、备份参数文件

创建pfile =“/甲骨文/ pfile01口”。二;
SQL >创建pfile =“/ pddata2 /甲骨文/备份/数据/ 2015-12-02 / pfile01口”。 二;

创建文件。

SQL >

6、备份成功

[根@ testoracle1数据] # bash X /甲骨文/备份/脚本/ rman_full_backup.sh
+ +日期+ %F
+出口 日期=二千零一十五十二04
+日期=二千零一十五十二04
+出口 back_dir= / pddata2 /甲骨文/备份/数据
+back_dir= / pddata2 /甲骨文/备份/数据
+苏-甲骨文
mkdirP / pddata2 /甲骨文/备份/数据/ 2015-12-04
RMAN日志= / pddata2 /甲骨文/备份/数据/ 2015-12-04 / rman_backup.log目标/ <<EOF
运行{
    备份 电流 控制文件 格式“\”/ pddata2 /甲骨文/备份/数据/ 2015-12-04 / cntrl_ % % % s_ p_ T \”;
备份作为压缩备份集的数据库格式“\”/ pddata2 /甲骨文/备份/数据/ 2015-12-04 / full_ d_ % %t_% s.bak ' ';
}
SQLPLUS 
出口EOF
'
RMAN>>>>RMAN>RMAN+苏-甲骨文
chmod 七百七十五/ pddata2 /甲骨文/备份/数据/ 2015-12-04 / *
'
[根@ testoracle1数据# ]
猜你在找
查看评论
*以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:99999 8次
    • 积分:一万六千零四十九
    • 等级:
    • 排名:319名第
    • 原创:438篇
    • 转载:3篇
    • 译文:2篇
    • 评论:523条
    我的课程
    博客专栏
    技术网址连接
    http://dev.mysql.com/doc/
    文章分类
    文章存档
    最新评论