数据库处于NOARCHIVELOG模式是不是不能用rman备份？

显示全部楼层 · 2004-8-2 15:25:23

我在数据库处于NOARCHIVELOG模式时用rman备份出现了ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode[/COLOR]问题，请问有没有办法解决
[oracle@hkweb bin]$ ./rman
Recovery Manager: Release 9.2.0.4.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation.All rights reserved.
RMAN> connect target /
connected to target database: JLT (DBID=2856680485)
RMAN> backup database format='/oraclebackup/%U_%s.bak';
Starting backup at 02-AUG-04
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=18 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/02/2004 15:25:23
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
RMAN> exit

Recovery Manager complete.
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode[/COLOR]

千问 · 2004-8-2 15:25:23

Normally this error (19602) occurs, if the last shutdown of the database was a "shutdown abort"
Try doing a clean shutdown and retry.

千问 · 2004-8-2 15:25:23

不是的，可以进行脱机冷备份，但你上面做的是联机热备，当然不可以。

千问 · 2004-8-2 15:25:23

非归档模式在mount下备份

千问 · 2004-8-2 15:25:23

可否进行完全恢复和不完全恢复

千问 · 2004-8-2 15:25:23

可以进行不完全恢复，前提是从你备份后所做的ＲＥＤＯ还都停留在联机日志文件中，如果发生了switch，就没希望
在startup mount时利用ＲＭＡＮ备份报错主要是因为你上次关闭数据库是abort，导致控制文件中记录的数据文件结尾ＳＣＮ无穷大，使系统误认为你的文件还在联机造成的

千问 · 2004-8-2 15:25:23

你必须在完全关闭的情况下才能备份