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

1	呈现问题： ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
2	原因： 这是由于数据库处于非归档模式，不能进行备份。
3	解决方案： 将数据库置为归档模式： 1 SQLPLUS / AS SYSDBA --登录数据库 [oracle@ENMO11G db_1]$ sqlplus / as sysdba   SQL*Plus: Release 11.2.0.4.0 Production on Sat Jan 2 11:15:49 2016   Copyright (c) 1982, 2013, Oracle.  All rights reserved.     Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options     2 SQL> shutdown immediate; --关闭数据库 SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started.   Total System Global Area  634679296 bytes Fixed Size                    2255912 bytes Variable Size                  432014296 bytes Database Buffers          192937984 bytes Redo Buffers                    7471104 bytes Database mounted.   3 SQL>startup mount;  --将数据库启动到mount 状态 SQL> startup mount ORACLE instance started.   Total System Global Area  634679296 bytes Fixed Size                    2255912 bytes Variable Size                  432014296 bytes Database Buffers          192937984 bytes Redo Buffers                    7471104 bytes Database mounted.   4 SQL>alter database archivelog;  --将数据库置为归档模式 SQL> alter database archivelog;   Database altered.     5 SQL>alter database open;  --打开数据库 SQL> alter database open;   Database altered.
4	[oracle@ENMO11G db_1]$ rman   Recovery Manager: Release 11.2.0.4.0 - Production on Sat Jan 2 11:28:47 2016   Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.   RMAN> connect target;   connected to target database: ENMO11G (DBID=1574162971)   RMAN> backup database;   Starting backup at 02-JAN-16 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=142 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=/u01/app/oracle/ENMO11G/system01.dbf input datafile file number=00002 name=/u01/app/oracle/ENMO11G/sysaux01.dbf input datafile file number=00003 name=/u01/app/oracle/ENMO11G/undotbs01.dbf input datafile file number=00004 name=/u01/app/oracle/ENMO11G/users01.dbf channel ORA_DISK_1: starting piece 1 at 02-JAN-16 channel ORA_DISK_1: finished piece 1 at 02-JAN-16 piece handle=/u01/app/oracle/product/11.2.0/db_1/dbs/0hqqbuo2_1_1 tag=TAG20160102T112906 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:01:07 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 channel ORA_DISK_1: starting piece 1 at 02-JAN-16 channel ORA_DISK_1: finished piece 1 at 02-JAN-16 piece handle=/u01/app/oracle/product/11.2.0/db_1/dbs/0iqqbuq5_1_1 tag=TAG20160102T112906 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 02-JAN-16 RMAN> list backup of database;     List of Backup Sets ===================     BS Key  Type LV Size       Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 7       Full    921.41M    DISK        00:01:04     02-JAN-16              BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20160102T112906         Piece Name: /u01/app/oracle/product/11.2.0/db_1/dbs/0hqqbuo2_1_1   List of Datafiles in backup set 7   File LV Type Ckp SCN    Ckp Time  Name   ---- -- ---- ---------- --------- ----   1       Full 889634     02-JAN-16 /u01/app/oracle/ENMO11G/system01.dbf   2       Full 889634     02-JAN-16 /u01/app/oracle/ENMO11G/sysaux01.dbf   3       Full 889634     02-JAN-16 /u01/app/oracle/ENMO11G/undotbs01.dbf   4       Full 889634     02-JAN-16 /u01/app/oracle/ENMO11G/users01.dbf

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30606702/viewspace-1969812/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30606702/viewspace-1969812/