This content has been marked as final. Show 7 replies
1 person found this helpful
19602, 00000, "cannot backup or copy active file in NOARCHIVELOG mode" // *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.
// *Action: Take the tablespace offline clean or close the database and retryHow can i do that ? Pls i dono how to do
// the copy or backup.
Venkadesh wrote:How can i do that ? Pls i dono how to do
// *Action: Take the tablespace offline clean or close the database and retry
// the copy or backup.
SQL> SHUTDOWN IMMEDIATE
This error happened when The database is currently open and in NOARCHIVELOG mode. Because of this RMAN cannot backup the datafiles as they are open.1 person found this helpful
ORA-19602 Using RMAN to Backup Database [ID 246183.1]
Hello,1 person found this helpful
Your database is running in NOARCHIVE mode. You have two options here:
1. Either place your database in archive log mode and then take the backup.
SQL>alter system set log_archive_dest_1='location=<location where you want the database to generate the archives>';Now take the backup of the database through RMAN.
SQL>alter database archivelog;
SQL>alter database open;
2. If you do not want to have your database in archivelog mode, then take the backup of the database through RMAN when the database is in mount mode.
SQL>shut immediateNow take the backup of the database through RMAN and once done, open the database.
It is recommended to take the backup by placing the database in archivelog mode.
Hi,1 person found this helpful
You are trying do a inconsistent backup with archivelog mode disabled. It's not possible.
You must do a consistent backup with database mounted (i.e all datafiles closed).
RMAN> shudown immediate; RMAN> startup mount; RMAN> backup database including current controlfile; RMAN> startup;
Or enable archive log log mode to be able make a online backup.
Thank you so much for all :).