| ORA-03113: end-of-file on communication channel [message #476987] |
Mon, 27 September 2010 12:09  |
koff10
Messages: 58
Registered: December 2006
Location: france
|
Member |
|
|
Hi all,
My archivelog database get error because my flash_recovery_area is full.
so I disable archivelog mode.
When to restart database server I got this message:
ORA-03113: end-of-file on communication channel
processus ID : 27427
session id : 96, Numéro de série : 3
Do you think I can delete manually ( Os commande rm ) files in flash_recovery_area ?
How to restart database server
thanks for your Help .
koff
|
|
|
|
|
|
|
|
|
|
| Re: ORA-03113: end-of-file on communication channel [message #477034 is a reply to message #477026] |
Tue, 28 September 2010 01:45  |
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Quote:Do you think I can delete manually ( Os commande rm ) files in flash_recovery_area ? This will usually not help, because Oracle does not know you have done it: Oracle will still believe that the FRA is full. Try deleting some files with RMAN, which will remove them correctly. Assuming that your instance is completely down,
rman target /
startup mount;
delete archivelog all;
alter database open;
One minor point: in 11.2, the FRA is officially known as the FAST recovery area. That's helpful, isn't it?
|
|
|
|
| Re: ORA-03113: end-of-file on communication channel [message #477100 is a reply to message #477026] |
Tue, 28 September 2010 09:38 |
 |
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
|
Senior Member |
|
|
koff10 wrote on Tue, 28 September 2010 01:23
Quote:
My archivelog database get error because my flash_recovery_area is full.
so I disable archivelog mode.
Actually my Alertlog say : no space left in flash_recorvery_area.
So I make mistake using unix rm command to delete
files in flash_recorvery_area directory.
You could remove or copy the archive logs to another location by using the mv or cp/rm commands.
After moving (or re-moving) the archive logs, check the actual space usage on the disk where you have the FRA and if there is some space AND if you have fast recovery enabled, increase the DB_RECOVERY_FILE_DEST_SIZE parameter, start the database and then you could disable fast recovery (DB_FLASHBACK_RETENTION_TARGET=0).
HTH
[Updated on: Tue, 28 September 2010 09:41] by Moderator Report message to a moderator |
|
|
|
|
|
 Re: ORA-03113: end-of-file on communication channel [message #477103 is a reply to message #477101] |
Tue, 28 September 2010 09:55 |
|
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
|
Senior Member |
|
|
Michel Cadot wrote on Tue, 28 September 2010 10:42NOTHING, I repeat NOTHING proves that this (FRA space) is related to that (ORA-03113) and the question is FIRST related to the latter.
Then perhaps we are not getting the whole picture.
@koff10
Are you consistently getting (every time) this ORA-03113 error?
Post the complete sequence of errors/messages from the alert log from latest attempt to startup the database.
[Updated on: Tue, 28 September 2010 10:07] by Moderator Report message to a moderator |
|
|
|
| Re: ORA-03113: end-of-file on communication channel [message #512533 is a reply to message #476987] |
Mon, 20 June 2011 23:23 |
jschenck
Messages: 1
Registered: March 2010
Location: La Vista, NE
|
Junior Member |
|
|
Thank you John Watson - you saved me some aggrevation. My 11.2.0.2 DB in a RAC with FRA in ASM failed and wouldn't start due to ORA-03113. Google engineering lead me to your post which worked like a champ!
Quote:Assuming that your instance is completely down,
rman target /
startup mount;
delete archivelog all;
alter database open;
then I shutdown immediate and
srvctl start database -d [myOracleDB]
<happy smiley of some sort>
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
