rman hotbackup without archive logs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: rman hotbackup without archive logs

  1. #1
    Join Date
    Oct 2002
    Posts
    182

    rman hotbackup without archive logs

    Oracle 9.2.0.4 on Solaris

    Let's say my db has been up one month.
    Can I delete all my archive logs, do a hotbackup (rman: backup database),and from that backup (and the ongoing archive logs) I can recover fine at any time right?

    (obviously not the best practice, just wondering about the scenario)

    You don't need to backup or keep PAST archive logs when you do an RMAN online hotbackup to recover?

    My tests say this works.
    The Documentation is ambiguous at best regarding the need of archive logs or if it is necessary to backup archivelogs. It just says it is helpful if you want to use logminer on them or that type of thing.
    - Cookies

  2. #2
    Join Date
    Oct 2002
    Location
    CA
    Posts
    67
    You are correct!

    I normally keep my achived logs for the last 1-2 days just in case, and the rest you can delete.
    --------------------------------------
    It's not what the world does to you that matters. It's how you respond...

  3. #3
    Join Date
    Oct 2002
    Posts
    182
    thanks.

    I just found my new friend: 'delete obsolete'
    - Cookies

  4. #4
    Join Date
    Nov 2008
    Posts
    3
    that's what i really need to know.. will a full RMAN online backup sufficient enough to recover the database to the point when the backup was taking place.
    I need a master backup for a training database that is to be restored after every training session. the backup will be done by issuing BACKUP DATABASE. all the archivelogs before and after the backup will be deleted. will the backup still function without any backup on both ends?

  5. #5
    Join Date
    Nov 2008
    Posts
    3
    Invalid Post specified. If you followed a valid link, please notify the administrator

  6. #6
    Join Date
    Nov 2008
    Posts
    9
    if you want to delete archivelog file,you will do it with rman.
    RMAN>delete obsolete;
    do not delete archivelog file using OS commands,like rm.
    good luck for you
    hehe

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