Problem with Oracle Database 8i on Win 2000 Server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Problem with Oracle Database 8i on Win 2000 Server

  1. #1
    Join Date
    Aug 2002
    Posts
    8

    Thumbs up

    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

    Aarif.M

  2. #2
    Join Date
    Mar 2002
    Posts
    301
    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.
    Say No To Plastics

  3. #3
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282

    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.

  4. #4
    Join Date
    May 2002
    Posts
    193
    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.......

  5. #5
    Join Date
    Sep 2002
    Posts
    6

    for failure archived logs in alert log page

    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






Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width