| ORA-19821: an intentionally corrupt log file was found [message #519582] |
Mon, 15 August 2011 02:22  |
John Watson
Messages: 8964
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
