Beinners question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Beinners question

  1. #1
    Join Date
    Jun 2001
    Posts
    316
    Me not some oracle DBA but u can say me an aspiring DBA

    I have this query in my mind rite from the day i started working as a novice DBA in my firm


    The d/b in my org is in non archive log mode...

    Which 1 is better ...archve or non archive log mode?

    If my d.b is runnin on archive log..do i necessarily need to take the backups of all the archive logs ..?

    Can any 1 pls explain me this in brief ..the funda behind this...
    Thanx a lot


  2. #2
    Join Date
    Aug 2000
    Posts
    462
    Any database which in which data is being inserted, updated or deleted should be running in archivelog mode if that changed data is ever going to be needed for any purpose. Here's why:

    Clearly, to recover from failure, you'll need a backup of the files lost or inappropriately modified. So, if you do restore from a backup, no changes beyond that restore are available without archiving redo logs. As a result, you should also back up your archived redo logs.

    If your database is read only, or can be easily recreated, or the changes don't matter (for example in a test environment), then you don't need archivelog mode. Otherwise, you should use archivelog mode.

    Start here:

    http://technet.oracle.com/docs/produ...6993/intro.htm
    Oracle DBA and Developer

  3. #3
    Join Date
    Jun 2001
    Posts
    316
    Thanx a lot!

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Which one is Better? It depends.

    When you are running in archivelog mode, your redo logs will get copied to the log_archive_dest directory specified in the init.ora before they are used again. When you are in archivelog mode, you can recover to any point in time.

    Non-archivelog mode will re-use your redo-logs without first copying them anywhere. You can not recover to any point in time with a database in non-archivelog mode.

    You don't *HAVE* to backup your archived logs, but you should. In fact, backing up your archived logs as well as purging your archvied logs should be part of your periodic maintenance.
    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