DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 19 of 19

Thread: archive log mode removal

  1. 02-01-2002, 04:54 PM #11
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    No, as long as you are in noarchivelog mode, you should be OK on that front.
    Jeff Hunter
    Reply With Quote Reply With Quote
  2. 02-01-2002, 05:23 PM #12
    sirhaggus
    sirhaggus is offline Member
    Join Date
    Aug 2000
    Posts
    155
    Yeah everything seems to be running great. Have a peaceful weekend Jeff. Thanks again for everyones comments.
    Chester Ney
    CODY Computer Services
    System DBA
    Reply With Quote Reply With Quote
  3. 02-01-2002, 05:42 PM #13
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Of course, you understand the implications of not running in archivelog mode, right?
    Jeff Hunter
    Reply With Quote Reply With Quote
  4. 02-07-2002, 03:36 PM #14
    sirhaggus
    sirhaggus is offline Member
    Join Date
    Aug 2000
    Posts
    155
    Implications of not running in archivelog mode? I'm not sure I understand, I am under the impression this is the preferable scenario. Could you explain?
    Chester Ney
    CODY Computer Services
    System DBA
    Reply With Quote Reply With Quote
  5. 02-07-2002, 03:50 PM #15
    tekion
    tekion is offline Junior Member
    Join Date
    Aug 2001
    Posts
    64
    no archived log no PITR
    Reply With Quote Reply With Quote
  6. 02-07-2002, 04:07 PM #16
    sambavan
    sambavan is offline Senior Advisor
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    How offen that you do a backup. If your database were to go down, or fail for some reason, then you would only be able to recover the data to the last backup. But with the archive logs, you can recover the database to the point of failure.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!

    Reply With Quote Reply With Quote
  7. 02-07-2002, 05:53 PM #17
    sirhaggus
    sirhaggus is offline Member
    Join Date
    Aug 2000
    Posts
    155
    For the vast majority of our clients we set up AT scripts to run a bat file that does an export/warm backup of the database at certain off-peak times during the day. This occurs 3 times a day for most clients.
    Chester Ney
    CODY Computer Services
    System DBA
    Reply With Quote Reply With Quote
  8. 02-07-2002, 05:55 PM #18
    sirhaggus
    sirhaggus is offline Member
    Join Date
    Aug 2000
    Posts
    155
    Here is an example of AT scripts that run once a day.

    AT 6:00 /EVERY:M CMD /C C:\DATDUMP MONDAY
    AT 6:00 /EVERY:T CMD /C C:\DATDUMP TUESDAY
    AT 6:00 /EVERY:W CMD /C C:\DATDUMP WEDNESDAY
    AT 6:00 /EVERY:Th CMD /C C:\DATDUMP THURSDAY
    AT 6:00 /EVERY:F CMD /C C:\DATDUMP FRIDAY
    AT 6:00 /EVERY:Sa CMD /C C:\DATDUMP SATURDAY
    AT 6:00 /EVERY:Su CMD /C C:\DATDUMP SUNDAY

    The DATDUMP file looks like this:

    EXP DATABASEUSERNAME/PASSWORD FILE=C:\DATADMPS\%1
    Chester Ney
    CODY Computer Services
    System DBA
    Reply With Quote Reply With Quote
  9. 02-07-2002, 06:10 PM #19
    jmodic
    jmodic is offline Super Moderator
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    So you can afford at least 8-hours worth of data loss? Good for you.

    BTW, exp/imp is *no kind of database backup* method, I hope you are aware of that. And I hope you are aware that you are actually exporting the data is inconsistent (regarding one table content to another), because you are not using CONSISTENT=Y during your exp. And if your exp batch file realy consists only that line that you have written I realy do hope you are aware that you are exporting only one users' objects all the time.....

    If your database encounters media failure you'll certanly have a lot of work to do....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width