delete archivelog files [message #225984] |
Thu, 22 March 2007 03:19 |
EMC1974
Messages: 3 Registered: March 2007 Location: BARCELONA
|
Junior Member |
|
|
My problem is that I delete some files "archivelogs"
Now I have the database without "archivelog"
When I put the database in "Archivelog" it does not work correctly so then the users can neither modify information nor insert.
What I can do??
Oracle 8.1.7 with windows
[Updated on: Thu, 22 March 2007 03:23] Report message to a moderator
|
|
|
|
|
Re: delete archivelog files [message #226004 is a reply to message #225987] |
Thu, 22 March 2007 04:31 |
EMC1974
Messages: 3 Registered: March 2007 Location: BARCELONA
|
Junior Member |
|
|
I do not have copies of the database previous to the disaster, nowadays I have copies of the files of the databse but not the logs
What has happened to us is that we have delete the files, then it has started trumping the database and in order that it works we have had to deactivate the "archivelog" mode, if we it activate fault.
The file " alert <sid> .log " I do not have it
I have >sid>alrt.log and one error is
"Tue Mar 20 05:19:20 2007
ARC0: Beginning to archive log# 1 seq# 116077
kcrrga: Warning. Log sequence in archive filename wrapped
to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
Old log archive with same name might be overwritten.
ARC0: Error 19504 creating archivelog file 'C:\ORACLE\ORA81\RDBMS\ARC16077.001'
ARC0: Archiving not possible: error count exceeded
ARC0: Failed to archive log# 1 seq# 116077
"
Thank you
[Updated on: Thu, 22 March 2007 04:42] Report message to a moderator
|
|
|
|
|
|