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



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

Answer / guest

Cause: You tried to copy or backup a file that was not
closed cleanly, and the database was in NOARCHIVELOG mode.
This is not allowed because when restored, the file will
require redo application before it is usable, and redo is
not currently being saved beyond the contents of the online
redo logs.

Action: Take the tablespace offline clean or close the
database and retry the copy or backup.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00135: Pragma string expects 3rd argument to be an identifier, string or numeric literal

1 Answers  


TNS-12511: TNS:service handler found but it is not accepting connections

1 Answers  


NNO-00068: warning: administrative region check failed, next check in number seconds

1 Answers  


ORA-02290: check constraint (string.string) violated

1 Answers  


NNL-00041: Object string not in domain string

1 Answers  


RMAN-06902: AS COMPRESSED BACKUPSET option cannot be used when backing up backupsets

1 Answers  


ORA-15192: invalid ASM disk header [string] [string] [string] [string] [string]

1 Answers  


ORA-22806: not an object or REF

1 Answers  


QSM-01039: selection present on right hand side of an outer join

1 Answers  


RMAN-10028: network error number-number occurred during remote RPC

1 Answers  


PLS-00360: cursor declaration without body needs return type

1 Answers  


ORA-09710: soarcv: buffer overflow.

1 Answers  


Categories