DBAsupport.com Forums - Powered by vBulletin
Page 1 of 7 123 ... LastLast
Results 1 to 10 of 61

Thread: RMAN backup

  1. #1
    Join Date
    Jan 2000
    Posts
    387

    RMAN backup

    Hi

    I am doing testing for RMAN backup. Just a few simple questions:

    1. How do I set the directory for the backup files? Everything i did a backup from RMAN, the backup set will be stored in $ORACLE_HOME/dbs.

    2. Is it possible to store the backup set into another server directly thru RMAN?

    Thank you for all your advices!

  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Hi.

    You need to do something like:

    RMAN> configure channel device type disk format '/my/path/%d_DB_%u_%s_%p';

    Take a look at this for some basic information about RMAN:

    http://www.oracle-base.com/articles/...er(RMAN)9i.php

    Cheers

    Tim...
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

  3. #3
    Join Date
    Jan 2000
    Posts
    387
    Thanks Tim! I have read the article before.. somehow and dunno why i just didn't set the path correctly!

    Anyway, what about my second question? Is it possible to backup to another server?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    not really no, you have to back up to local disks (now that could be an nfsmount from the other server)

  5. #5
    Join Date
    Jan 2000
    Posts
    387
    Hi

    Are there any solutions to copy the backup directly to another server besides tape backup? I appreciate any advices and help

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    nfsmounts the disks - but be prepared for it to be slow

  7. #7
    Join Date
    Jan 2000
    Posts
    387
    Thanks! What about any recommended storage beside tape storage? Are there any good recommendations?

  8. #8
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    We use a two stage approach to our backups; we have a dedicated area on out NetApp filer which is attached as a backup partition to our servers, we use RMAN to backup directly to the filer partition and then at regular intervals our filer contents are sent to an off-site storage facility (SunGuard).

    This gives me the ability to have recent backup sets easily availaible and the security of knowing that all my data is also stored in another off-site location.

    As the backups are done to disk we also benefit from fast backup and restore times.

    HTH
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  9. #9
    Join Date
    Jan 2000
    Posts
    387
    Thanks! In this case, do you keep all your archived logs? If you using RMAN, you will need to the sync the logs right? How often do you delete them? Upon daily backup?

    Thanks for sharing!

  10. #10
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    How long I keep the archive logs depends on the backup cycle of the database, typically after a RMAN full backup I crosscheck and delete obsolete files which will remove unrequired archive and backup files.
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

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