Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
cancel
Showing results for 
Search instead for 
Did you mean: 

archive log deleted

DeafFrog
Valued Contributor

archive log deleted

Hello Gurus,

Database is in archivelog mode , i have errors in alert.log :
ORA-27072: File I/O error
HPUX-ia64 Error: 2: No such file or directory
Additional information: 4
Additional information: 5121
Additional information: 405504
ORA-19502: write error on file "/pcard15/oradata/pcard/arch/1_135_681813764.dbf", blockno 5121 (blocksize=1024)
Tue May 19 15:00:07 2009
ARC0: Closing local archive destination LOG_ARCHIVE_DEST_1: '/pcard15/oradata/pcard/arch/1_135_681813764.dbf' (error 19502)
Tue May 19 15:00:07 2009.....archive log files have been deleted from the location.Databse is running , should i shutdown the DB with shutdown immediate or shutdown normal command ?On startup will the DB require recovery .I am not a DBA , please help .will restarting the DB , make DB normal and in archive log mode .

Regards ,
DeafFrog.
FrogIsDeaf
4 REPLIES
Steven E. Protter
Exalted Contributor

Re: archive log deleted

Shalom,

No need to shut the database down, though this will do the trick.

1) Make sure there is sufficient space for the file, you may have run out of archive log space.

2) Any database checkpoint is sufficient to set up a restore point, along with a hot backup.

That being said, I'd go for a shutdown, full backup and database start. Cold backups are much easier to work with.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
avizen9
Esteemed Contributor

Re: archive log deleted

Hello DearFrog,

db dont need any recovery for archive logs...also for archive files deletion dont need any DB reboot..if for other cause you want to shut DB's then use shut immediate

archive logs are copy of the redo log files..if redo log deleted then we need recovery

archivelog is not must for database we can run the database in no archive mode also
archive files are not the part of the DB

startup will require recovery if we shutdown?
no recovery is needed.

recovery require only if datafiles,redo log files and control files deleted from databases

for archive no need..its just like backup redo log files thats All,
let me know if you have any other query,
thanks,

DeafFrog
Valued Contributor

Re: archive log deleted

Dear Steven and Avizen9 ,
Thanks for the help. This weekend i will shutdown the DB take a cold backup and then start it again. everything goes fine, i will update the this thread and close it.Once again thanks a lot.
FrogIsDeaf
DeafFrog
Valued Contributor

Re: archive log deleted

shutdwon and then startup happened normally, and no restore/recovery was required.
FrogIsDeaf