This content has been marked as final. Show 7 replies
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.
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.
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.