oracle rman ora19602,ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

51 阅读 0 评论 34 点赞

我是靠谱客的博主优美鲜花，最近开发中收集的这篇文章主要介绍oracle rman ora19602,ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

用rman备份数据库时，遇到如下信息

RMAN-03009: failure of backup command on ORA_DISK_1 channel

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

Rman需要在归档模式下

SQL> connect sys/chaya as sysdba

SQL> shutdown immediate;

SQL> startup mount;

SQL> alter database archivelog;

SQL> alter database open;

[oracle@oracle ~]$ rman target /;

Recovery Manager: Release 11.2.0.1.0 - Production on Tue Sep 10 18:31:23 2013

connected to target database: PORTALDB (DBID=667359659)

RMAN> backup database;

Starting backup at 10-SEP-13

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=10 device type=DISK

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00001 name=/opt/oracle/oradata/portaldb/system01.dbf

input datafile file number=00002 name=/opt/oracle/oradata/portaldb/sysaux01.dbf

input datafile file number=00003 name=/opt/oracle/oradata/portaldb/undotbs01.dbf

input datafile file number=00005 name=/oradata/portaldb_ICMLFQ32_01.dbf

input datafile file number=00006 name=/oradata/portaldb_ICMLNF32_01.dbf

input datafile file number=00007 name=/oradata/portaldb_ICMSFQ04_01.dbf

input datafile file number=00008 name=/oradata/portaldb_ICMVFQ04_01.dbf

input datafile file number=00009 name=/oradata/portaldb_ICMLSNDX_01.dbf

input datafile file number=00004 name=/opt/oracle/oradata/portaldb/users01.dbf

channel ORA_DISK_1: starting piece 1 at 10-SEP-13

channel ORA_DISK_1: finished piece 1 at 10-SEP-13

piece handle=/opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_nnndf_TAG20130910T183137_92zkzt2y_.bkp tag=TAG20130910T183137 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:01:35

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 10-SEP-13

channel ORA_DISK_1: finished piece 1 at 10-SEP-13

piece handle=/opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_ncsnf_TAG20130910T183137_92zl2t44_.bkp tag=TAG20130910T183137 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 10-SEP-13

指定备份目录

RMAN> backup datbase format '/oradata/backup/bak_%U';

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

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

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

RMAN-00558: error encountered while parsing input commands

RMAN-01009: syntax error: found "identifier": expecting one of: "archivelog, as, auxiliary, backupset, backup, channel, check, controlfilecopy, copies, copy, cumulative, current, database, datafilecopy, datafile, db_file_name_convert, db_recovery_file_dest, device, diskratio, duration, filesperset, force, format, for, from, full, incremental, keep, maxsetsize, nochecksum, noexclude, nokeep, not, pool, proxy, recovery, reuse, section, skip readonly, skip, spfile, tablespace, tag, to, validate, ("

RMAN-01008: the bad identifier was: datbase

RMAN-01007: at line 1 column 8 file: standard input

RMAN> backup database format '/oradata/backup/bak_%U';

Starting backup at 10-SEP-13

using channel ORA_DISK_1