Home » RDBMS Server » Backup & Recovery » delete archivelog files
icon8.gif  delete archivelog files [message #225984] Thu, 22 March 2007 03:19 Go to next message
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 #225987 is a reply to message #225984] Thu, 22 March 2007 03:31 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

HI,



My problem is that I delete some files "archivelogs"

You should take database backup.

When I put the database in "Archivelog" it does not work correctly so then the users can neither modify information nor insert.


Are you just delete archive log files or disable archive log mode what you did exactly ?

or
are you check your alert<sid>.log files.

you can also post few last lines from alert<sid>.log files.



regards
Taj
Re: delete archivelog files [message #225997 is a reply to message #225984] Thu, 22 March 2007 04:15 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You probably haven't enabled automatic archiving. Check Enabling Automatic Archiving.
Re: delete archivelog files [message #226004 is a reply to message #225987] Thu, 22 March 2007 04:31 Go to previous messageGo to next message
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

Re: delete archivelog files [message #226045 is a reply to message #226004] Thu, 22 March 2007 07:15 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

HI,
What is your LOG_ARCHIVE_FORMAT parameter values.

can you post here

check below link for right value
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch195.htm#REFRN10089




regards
Taj
Re: delete archivelog files [message #226269 is a reply to message #226045] Fri, 23 March 2007 02:23 Go to previous messageGo to next message
EMC1974
Messages: 3
Registered: March 2007
Location: BARCELONA
Junior Member
ARC%S.%T
Re: delete archivelog files [message #226304 is a reply to message #226269] Fri, 23 March 2007 04:05 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Try to change the format to a lower case s (ie. ARC%s.%T)
Previous Topic: Urgent: Archiver Hung 10g
Next Topic: Hot backup from standby database
Goto Forum:
  


Current Time: Wed May 15 11:19:16 CDT 2024