oracle 19602,ORA-19602：无法在NOARCHIVELOG模式下备份或复制活动文件

我们正在与Windows 8和10操作系统环境中的Oracle 11g数据库合作。我们需要转储(备份)数据库，然后将该转储的文件恢复到另一个oracle数据库，因此我们正在尝试使用Recovery Manager (RMAN)。我们发出以下命令：ORA-19602：无法在NOARCHIVELOG模式下备份或复制活动文件

C:UsersAdmin>rman

Recovery Manager: Release 11.2.0.1.0 - Production on Tue Mar 8 17:24:43 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

RMAN> connect target/

connected to target database: MYEMP (DBID=42934358)

RMAN> backup database;

Starting backup at 08-MAR-16

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=133 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 03/08/2016 17:25:00

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 08-MAR-16

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

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

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

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/08/2016 17:25:02

ORA-19504: failed to create file "C:USERSADMINDESKTOPTESTDATABASEBACKUP"

ORA-27038: created file already exists

OSD-04010: option specified, file already exists

我尝试了这些解决这个问题：

RMAN> run {

shutdown immediate;

startup mount;

backup database;

alter database open;

}

但没有发生，我们正在错误。我如何使用RMAN备份Oracle数据库？或任何(脚本)，可以帮助我在我的oracle服务器上生成大型数据库？

+1

你说你要“倾销”数据库，你的意思是你想运行并导出数据泵？在这种情况下，您不需要使用RMAN –

+0

我认为您可以在http://dba.stackexchange.com上获得更好的支持 –

+0

当您装入数据库但未打开数据库时，您是否仍然获得ORA-19602？或者只是ORA-27038，这是不言自明的？而且您确实需要澄清您的术语，因为不清楚您是否真的需要备份/恢复或导出/导入。 –