DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: organized Achieved log file per day..!!!

  1. #1
    Join Date
    Jan 2007
    Posts
    36

    organized Achieved log file per day..!!!

    Hi,

    Any one can give me a brief about how to organized Achieved log file per day for future recovery through RMAN or Hot backup. I need it urgent help because I have to develop a database before that I need to know achieve mode of Database and how them to use properly to maintaining and secure the database from any disaster

    Jubraz

  2. #2
    Join Date
    Dec 2006
    Location
    hyderabad
    Posts
    21

    archive logs

    Hi ,
    Archive log files are stored in a particular directory
    now all the logs are stored in this directory
    you could check the file details like when it was created
    (eg: ls -ltr)
    now in rman u would specify the archive destination in the configuration (e.g:log directory)
    when u take backup of database through rman
    u would give the syntax as
    rman>backup database plus archivelog;

    now whats your problem ?

    bye

  3. #3
    Join Date
    Jan 2007
    Posts
    36
    ok
    I got it so there is no extra job to do? for organize it ?

    thanks
    jubraz

  4. #4
    Join Date
    Jan 2007
    Posts
    36
    thanks for ur help here.

    jubraz

  5. #5
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Unless you tell RMAN to remove the archivelogs from the filesystem after they have backed them up (DELETE ARCHIVELOG ALL BACKED UP 2 TIMES), you will have to create a job to remove the archivelogs manually. Something like:

    find -name log*.arc -mtime +15 -exec rm {} \; >/dev/null

    In my experience, you'd be better off managing this through RMAN.
    Assistance is Futile...

  6. #6
    Join Date
    Jan 2007
    Posts
    36
    Thanks in my window 2003 server I can manually delete all right ?? like date wise ?

    tell me is that way to do?

    jubraz

  7. #7
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Probably would have been handy to mention that you were on Windows from the start (would have saved me time on typing). Yes, you can create a job using Windows Scheduler if you like, but my preference is to manage it through RMAN, that way you know the logs will have been backed up before you delete them.
    Assistance is Futile...

  8. #8
    Join Date
    Jan 2007
    Posts
    36
    ok thanks

    jubraz

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