IMP metalinks

Metalink ID
201703.1
SYSADMIN
104282.1
Concurrent Processing Tables and Purge Concurrent Request and/or Manager Data Program (FNDCPPUR)
186361.1
Workflow Background Process Performance Troubleshooting Guide
184375.1
How to Setup The Report Output to Different Viewer Types in Oracle Applications 11i
1012307.6
Moving Tables Between Tablespaces Using EXPORT/IMPORT
358090.1
Workflow Administrator Field Become Uneditable after Selecting System Administrator Responisibility
297522.1
How to investigate printing issues and work towards its resolution
50270.1
Applications Object Library Top 18 Issues
105133.1
Concurrent Manager Questions and Answers Relating to Generic Platform
99687.1
Printing Character Reports with Oracle Applications Release 11
1012181.102
How To Keep Users from Using a Certain Printer
175339.1
Default Printer Defined For A User On Site Level Is Not Used
169935.1
Troubleshooting Oracle Apps Performance Issues
468013.1
Code Snippet for querying responsibilities and users in 11i Applications (user and responsibilites)
156965.1
coe_locks.sql - Session and serial# for locked Rows
1011853.7
Error: FND_POST Insert Trigger Trying to Change Printer Profile
15476.1
FAQ about Detecting and Resolving Locking Conflicts
244274.1
Oracle Application Object Library Generic Service Management (GSM) Setup Test
186893.1
Relinking Executable FNDSM Gives Unsatisified Symbols Error for dlopen, dlerror and dlsym Shared Link Libraries.
181158.1
Cannot Start GSM Service Manager - TNS Errors in Listener Log and CCM Log
74717.1
Troubleshooting Concurrent Manager Startup problems
387077.1
How to find the process identifier (pid, spid) after the corresponding session is killed
1074708.6
How to Select Current Session Information from V$SESSION
557317.1
Apps User is Locked After RDBMS CPU Patches and Utlrp.sql Script Execution
334977.1
REP-1419 Running Accrual Reconciliation Rebuild Process
360628.1
Poor Performance of Accrual Rebuild Reconciliation Report In 11.5.10

A script enabled browser is required for this page to function properly.
391175.1
JInitiator is not Installed When Downloaded to Client PC
130182.1
HOW TO TRACE FROM FORM, REPORT, PROGRAM AND OTHERS IN ORACLE APPLICATIONS
162488.1
Complete Guide to JInitiator 1.1.8 Setup & Troubleshooting for Oracle Applications 11i
1041427.6
KILLING INACTIVE SESSIONS DOES NOT REMOVE SESSION ROW FROM V$SESSION
107686.1
Why several Process remain KILLED in V$SESSION
1020720.102
ALTER SYSTEM KILL Session Marked for Killed Forever
304266.1
Where Should Custom Top Environment Variable Get Added?
216589.1
122008.1
Performance
363048.1
WHY DO DBA_TABLES DBA_OBJECTS AND DBA_SEGMENTS DIFFER WHEN SELECTED FOR TABLES?
1012307.6
Moving Tables Between Tablespaces Using EXPORT/IMPORT
1025288.6
How to Diagnose and Resolve ORA-01650,ORA-01652,ORA-01653,ORA-01654,ORA-01688 : Unable to Extend <> by %S in Tablespace %S
107899.1
Payables Patch Application Troubleshooting Guide
224875.1
Installation, Patching & Upgrade Frequently Asked Questions

ORA-00353: log corruption near block

SQL> startup;

ORACLE instance started.

Total System Global Area 1570009088 bytes

Fixed Size 2221840 bytes

Variable Size 989858032 bytes

Database Buffers 553648128 bytes

Redo Buffers 24281088 bytes

Database mounted.

ORA-03113: end-of-file on communication channel

Process ID: 35389500

Session ID: 331 Serial number: 3

Alert log shows as

Incomplete read from log member '/ora_lcd11/db01/lcd11/db/apps_st/data/log03a.dbf'. Trying next member.
ARC0: Log corruption near block 117330 change 7887289606 time ?
CORRUPTION DETECTED: thread 1 sequence 42 log 3 at block 117330. Arch found corrupt blocks
Errors in file /ora_lcd11/db01/lcd11/db/tech_st/11203/admin/lcd11_ora-lcd11/diag/rdbms/lcd11/lcd11/trace/lcd11_arc0_64028940.trc (incident=90522):
ORA-00353: log corruption near block 117330 change 7887289606 time 07/04/2014 13:06:54
ORA-00312: online log 3 thread 1: '/ora_lcd11/db01/lcd11/db/apps_st/data/log03b.dbf'
ORA-00312: online log 3 thread 1: '/ora_lcd11/db01/lcd11/db/apps_st/data/log03a.dbf'
Incident details in: /ora_lcd11/db01/lcd11/db/tech_st/11203/admin/lcd11_ora-
lcd11/diag/rdbms/lcd11/lcd11/incident/incdir_90522/lcd11_arc0_64028940_i90522.trc
Incomplete read from log member '/ora_lcd11/db01/lcd11/db/apps_st/data/log02a.dbf'. Trying next member.
Incomplete read from log member '/ora_lcd11/db01/lcd11/db/apps_st/data/log02b.dbf'. Trying next member.
ARCH: Log corruption near block 670320 change 7886861019 time ?
CORRUPTION DETECTED: thread 1 sequence 41 log 2 at block 670320. Arch found corrupt blocks
Errors in file /ora_lcd11/db01/lcd11/db/tech_st/11203/admin/lcd11_ora-lcd11/diag/rdbms/lcd11/lcd11/trace/lcd11_ora_60883278.trc (incident=90514):
ORA-00353: log corruption near block 670320 change 7886861019 time 07/03/2014 11:06:05
ORA-00312: online log 2 thread 1: '/ora_lcd11/db01/lcd11/db/apps_st/data/log02b.dbf'
ORA-00312: online log 2 thread 1: '/ora_lcd11/db01/lcd11/db/apps_st/data/log02a.dbf'
Incident details in: /ora_lcd11/db01/lcd11/db/tech_st/11203/admin/lcd11_ora-
lcd11/diag/rdbms/lcd11/lcd11/incident/incdir_90514/lcd11_ora_60883278_i90514.trc
ARC0: All Archive destinations made inactive due to error 354
ARC0: Closing local archive destination LOG_ARCHIVE_DEST_1: '/ora_lcd11/df01/bkp/arch_42_1_851175866.arc' (error 354) (lcd11)
Committing creation of archivelog '/ora_lcd11/df01/bkp/arch_42_1_851175866.arc' (error 354)




SQL> startup nomount;



Fixed Size 2221840 bytes

Variable Size 989858032 bytes

Database Buffers 553648128 bytes

Redo Buffers 24281088 bytes

SQL> alter database mount;

SQL> select name,open_mode from v$database;

NAME OPEN_MODE

--------- --------------------
LCD11 MOUNTED

SQL> alter database clear unarchived logfile group 2;
Database altered.

SQL> alter database clear unarchived logfile group 3;
Database altered.

SQL> alter database open;
SQL> select name,open_mode from v$Database;

NAME OPEN_MODE --------- --------------------
LCD11 READ WRITE