Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2004
    Location
    Apeldoorn, the Netherlands
    Posts
    9

    Talking Unanswered: ORacle 9i RAC and RMAN backup

    Hey all!

    I've got a little question;

    We've got a RAC up and running here, configuration is as follows:
    2 nodes, both running Windows 2000 Advanced Server
    1 NAS-filer from NetApp for storage.
    We use OCFS for the datafiles etc.
    Controlfiles, redologfiles, datafiles and the spfile are stored on the OFCS-share.
    Next to that, we have an extra CIFS-share (normal windows NTFS) for the archived redolog files and the RMAN-backups.

    At the moment there are only 2 RAC-databases running, one of them is my testing-database.
    Both are running in archivelog-mode.
    Both are being hot-backed up with the use of the Snapshot-technology of the filer.
    (set databases in hot backup mode -> make snapshot -> take databases out of hot backup mode)

    Ofcourse the snapshot is only usefull in a complete disaster recovery.
    For the recovery of a table of tablespace or point in time, I need to make RMAN-backups.

    I found some documentation on metalink and asktom, but not very much.

    Does any of you have an example of a backup-configuration, scripts, etc.?

    Thanks in Advance!

  2. #2
    Join Date
    Dec 2004
    Location
    Apeldoorn, the Netherlands
    Posts
    9
    *bumpiebump*

  3. #3
    Join Date
    Dec 2004
    Location
    Apeldoorn, the Netherlands
    Posts
    9
    and another bump..

    no-one who can help me out here?!?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    When all else fails, RTFM

    http://download-west.oracle.com/docs...a96565/toc.htm

    http://download-west.oracle.com/docs...a96566/toc.htm

    With free advice, you get what you paid for it.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Dec 2004
    Location
    Apeldoorn, the Netherlands
    Posts
    9
    Quote Originally Posted by anacedent
    When all else fails, RTFM

    http://download-west.oracle.com/docs...a96565/toc.htm

    http://download-west.oracle.com/docs...a96566/toc.htm

    With free advice, you get what you paid for it.
    when you do not read the entire posting, STFU

    As I allready said, I read the documentation, I searched on metalink, etc.etc.
    Do you really think I managed to install and configure a production RAC-environment without any documentation?

    The thing is, I allready got a rman-backup, but I want to make it better. That's why I ask for examples here..

  6. #6
    Join Date
    Sep 2004
    Location
    London, UK
    Posts
    565
    I had to STFW to find out what STFU meant.

  7. #7
    Join Date
    Jul 2003
    Posts
    2,296
    do a search on RMAN backups on this forum.

    other than that, I would create a catalog database (different server preferably) and
    connect to target (production) and the catalog. Run rman db backups and also backup
    your controlfiles and archivelogs to a drive (or tape) on the production box. If rman is
    not writing directly to tape, then be sure to copy all backups to tape.

    If your db is fairly large then you might consider incremental backups each day
    and only a full backup every 2-4 days. Then backup the archivelogs each hour or so
    and you should be all set.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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