backup and recover using tar
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: backup and recover using tar

  1. #1
    Join Date
    Jan 2000
    Location
    san jose
    Posts
    149
    hi,

    my sun box and a tape driver attached to it.

    how should i backup offline files to it?
    what's my possible choice?
    tar, cpio?

    if so , give me an example.
    I guess it is a unix question instead of oracle question.

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Since I use RMAN over backup, I don't know about making the tape drive interface. But would suggest using "dump" over "tar".

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Nov 2000
    Posts
    89
    Depending on the size of your DB you have many choices. RMAN can be a good solution however it requires another instance to be the DB for the backups.

    If your DB isn't too big running nightly crons to export the DB is a great thing. I have 3 smaller DBs and have restored tables due to user mistakes very quickly because I had nightly exports. The cron looks like:

    #!/bin/sh

    ##
    ## This is a nightly export of the users of an Oracle database
    ##

    ORACLE_SID=fred
    export ORACLE_SID
    #------------------------------------------------------
    # Get the environment
    #------------------------------------------------------
    . /u00/oracle/app/oracle/product/7.3.4/.profile
    cd /u02/exports
    exp sys/password file=fred.dmp.`date +%y.%m.%d` log=fred.log.`date +%y.%m.%d` full=y

    ---------------------------

    Its simple and to the point. Don't forget to %chmod 700 because the password is in the file- you could set it up to run without a password.

    As far as the full backups are concerned, there are several great scripts out on the net that will perform HOT or COLD backups. Try this URL to start. The scripts found work almost direct out of the box:
    BACKUP CENTRAL:
    [url]http://www.backupcentral.com/toc-free-backup-software.html[/url]

    Cheers,
    Roger

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