Home » RDBMS Server » Server Administration » ORA-19821: an intentionally corrupt log file was found (11.2.0.2, Solaris 10)
ORA-19821: an intentionally corrupt log file was found [message #519582] Mon, 15 August 2011 02:22 Go to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Anyone seen this error before? Nothing on Metalink. I don't know if I can repeat it. It occured while converting a database to archivelog mode, after completing a Data Pump export/import upgrade from 11.1.0.7.
I fixed it like this:
juno> startup mount;


ORACLE instance started.

Total System Global Area 1.7108E+10 bytes
Fixed Size                  2175440 bytes
Variable Size            8858373680 bytes
Database Buffers         8220835840 bytes
Redo Buffers               26886144 bytes
Database mounted.

juno> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-19821: an intentionally corrupt log file was found


juno> recover database until cancel;
Media recovery complete.


juno> alter database open resetlogs;



Database altered.

juno> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
juno> startup mount;
ORACLE instance started.

Total System Global Area 1.7108E+10 bytes
Fixed Size                  2175440 bytes
Variable Size            8858373680 bytes
Database Buffers         8220835840 bytes
Redo Buffers               26886144 bytes
Database mounted.

juno> alter database archivelog;

Database altered.

juno> alter database open;

Database altered.


I've run a few checks, and the DB seems OK.
Re: ORA-19821: an intentionally corrupt log file was found [message #519583 is a reply to message #519582] Mon, 15 August 2011 02:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have you any event set?

Regards
Michel
Re: ORA-19821: an intentionally corrupt log file was found [message #519584 is a reply to message #519583] Mon, 15 August 2011 02:46 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
No, I never set events.
Previous Topic: non standard block size
Next Topic: How to find the base table of a view
Goto Forum:
  


Current Time: Thu Mar 28 07:17:00 CDT 2024