Printable View
Hi Experts,
How can we find if an oracle instance went down? Is there is any possible way to find it? Or is there any scripts to intimate via mail if such a crash occurs?
Why the Redo Log file archive to the standby process is getting failures?
What are the possible reasons for that. Plz. help me asap?
If Archive log process fail occurs offen, the database will go down?
Thanks in advance,
Regards,
Aarif.M
Hi,
1. If you want to mail whenever the instance goes down then you will have
to write a procedure which will run continuously and read the content of
Alert.log file and whenever the entry is found then you can invoke a procedure
which will send mails.
2. If the archiver process fails the database will not go down. It will just stop archiving
and your database will hang until the files are archived.
HTH.
Vijay.
There`s another way to find if the instance is down. When you see the users getting angry or the telephone starts to ring non-stop, the instance is probably down.
F.
Quote:
Originally posted by Mnemonical
There`s another way to find if the instance is down. When you see the users getting angry or the telephone starts to ring non-stop, the instance is probably down.
F.
What an interesting comment.......
Hi aarif,
i had
question: I found the following error in the alert file, will this cause any problems for database? It did show regular archive log after those errors.
Current log# 1 seq# 5521 mem# 1: G:\DATABASES\ACDM\REDOLOGS\ACDM_LOG12.LOG
Sat Aug 24 18:39:44 2002
ARC1: Failed to archive log# 3 seq# 5519
ARC1: Beginning to archive log# 4 seq# 5520
Sat Aug 24 18:39:44 2002
Thread 1 advanced to log sequence 5522
Current log# 2 seq# 5522 mem# 0: H:\DATABASES\ACDM\REDOLOGS\ACDM_LOG21.LOG
Current log# 2 seq# 5522 mem# 1: G:\DATABASES\ACDM\REDOLOGS\ACDM_LOG22.LOG
Sat Aug 24 18:39:44 2002
ARC1: Completed archiving log# 4 seq# 5520
Sat Aug 24 18:39:44 2002
ARC2: Beginning to archive log# 3 seq# 5519
ARC2: Failed to archive log# 3 seq# 5519
(for n number of times i had copied just a few lines )
Reply 1 : Check the space in the disk where archived log files are there. Also query the V$log, V$logfile to see the status of the redolog files.( we dont have space problem)
Reply 2:check if the Directory has right permissions. Sometime (it has been seen on NT) Windows explorer changed the directory permission( i think we dont have this problem)
Reply 3:You have three archive background processes running. While one redo log is being archived by one process the other archive process also trying to archive it and resulting in error.( i think this might be a problem)
Reply 4:this is the normal behavior.Oracle does not know other process is archiving the redo, so multiple arch processes will try to archive the same one.
you can look at the alert file, all groups are finally successfully archived.
please refer to the cathy_ll question posted on 08-29-2002 07:57 AM by Sameer