OraFAQ Forum: Backup & Recovery » ORA-19602 during backup on closed DB (10g)

Home » RDBMS Server » Backup & Recovery » ORA-19602 during backup on closed DB (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-19602 during backup on closed DB (10g) [message #246656]

Thu, 21 June 2007 10:02

Isa06
Messages: 3
Registered: June 2007
Location: France

Junior Member

Hello

I have a RMAN backup script which runs perfectly well on a database in NOARCHIVELOG. The script first shutdowns the DB then mount it.

When I run it on another database in NOARCHIVELOG, it fails on some files with error ORA-19602
and the explanation is
"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."

I wonder how some files can remain opened while the DB is closed...
The 2 DBs are for development and I don't want to turn them to ARCHIVELOG, I just would like to understand what's going on and if I have a way to "repair" (?) these datafiles

thanks for any help
Isa

Report message to a moderator

Re: ORA-19602 during backup on closed DB (10g) [message #246697 is a reply to message #246656]

Thu, 21 June 2007 11:38

Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ora-19602: 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.

The key part in your case is: You tried to copy or backup a file that was not closed cleanly.
Are you sure the script "shutdown normal" or "immediate" but not "abort" the database?

Regards
Michel

Report message to a moderator

Re: ORA-19602 during backup on closed DB (10g) [message #246720 is a reply to message #246697]

Thu, 21 June 2007 12:13

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

In addition with micheal hints and DO NOT use startup force mount.

Report message to a moderator

Re: ORA-19602 during backup on closed DB (10g) [message #246833 is a reply to message #246656]

Fri, 22 June 2007 02:47

Isa06
Messages: 3
Registered: June 2007
Location: France

Junior Member

I agree that the pb is here You tried to copy or backup a file that was not closed cleanly. !
I wonder whether those files could be damaged in a way that Oracle doesn't "see" that they are closed (??) Confused

Here is the script

CONNECT TARGET;
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
DELETE OBSOLETE;
BACKUP INCREMENTAL LEVEL 0 DATABASE FILESPERSET 10;
ALTER DATABASE OPEN;

I will try to switch the logs before doing the backup...but I am not sure it will have any effect.

Isa

Report message to a moderator

Re: ORA-19602 during backup on closed DB (10g) [message #246884 is a reply to message #246833]

Fri, 22 June 2007 06:41

Isa06
Messages: 3
Registered: June 2007
Location: France

Junior Member

The backup was successful after the log switch...

I will monitor over a few days..

Report message to a moderator

Previous Topic:	Error Restore Control File
Next Topic:	RMAN: DUPLICATE DATABASE to same disk group?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 13 19:43:58 CDT 2024