What problems can occurred if the database in archive mode and 7x24
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: What problems can occurred if the database in archive mode and 7x24

Hybrid View

  1. #1
    Join Date
    Dec 2003
    Posts
    3

    Question What problems can occurred if the database in archive mode and 7x24

    Hi All,
    Iím new to Database world, and trying to learn about frequently occurred problems if a database in Archive mode ( 7x24 ). I just want to know the problem headings and then Iíll try to find solution my self.

    Thanks in advance.

    Warsi.

  2. #2
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    The only real problem I can think of is that if the log_archive_dest becomes full then the database will hang until space is cleared and Oracle can archive the current redo log. You just need to make sure that you have plenty of space in log_archive_dest and that you delete the archivelogs periodically (having backed them up of course). I backup my archivelogs every 3 hours using RMAN and this will delete them afterwards for me too.

    Archivelog mode is definitely the only choice for a 24x7 database; just make sure that log_archive_dest doesn't fill up.

    HTH

    Austin

  3. #3
    Join Date
    Dec 2003
    Posts
    3
    Thanks Austin for your input, is there any other problem I should consider.

    Can other members help me??

    Warsi.

  4. #4
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317
    Just keep track of your archives...

    A customer of mine choose to manually delete some archives before the backup with RMAN started. RMAN didn't like that. RMAN noticed that there were archives missing and refused to start the backup.

    I found the solution in a undocumented command. Here is the guiding text and the command (just in case you need it):

    Code:
    It may sometimes be neccessary to re-sync RMAN with details of which
    archive-log files are available to be backed up.  This is most likely 
    if archive logs have been removed from the archive log directory 
    outside the control of RMAN.  The RMAN command to do this is not 
    listed in the manuals, and is as follows: 
    
     change archivelog all validate;

    HTH
    An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.

  5. #5
    Join Date
    Dec 2003
    Posts
    3
    Can I collect some more day to day problems Database, just like 5 most frequently problems, can other senior members help me??

    Thanks, Warsi

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    there arent any problems with running archive log mode 24x7, its how a database should be run.

    Only thing that will cause you trouble is if you generate loads of redo and dont have anywhere to put it.

    Do you know how much redo you will generate?

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by efrijters

    I found the solution in a undocumented command. Here is the guiding text and the command (just in case you need it):

    You can do it with the crosscheck command which is documented at
    http://download-west.oracle.com/docs...cat.htm#441050
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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