How to take up Oracle Backup?
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: How to take up Oracle Backup?

  1. #1
    Join Date
    Apr 2006
    Posts
    1

    How to take up Oracle Backup?

    Hello..,

    I am developing an application using VB as front end and Oracle8i as backend..I am not able to do the Backup and restore part..How can i take the Oracle Database backup?It's urgent..could anybody help me please..

    Thanks in advance,
    Poornima.

  2. #2
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    The preference is always to use RMAN for online backups whereever possible. However, if you can afford the down time, just shut the database down and copy all the datafiles\controlfiles\archivelogs to some other storage device.
    Assistance is Futile...

  3. #3
    Join Date
    Mar 2006
    Posts
    40
    as an application developer maybe you will prefer to do an export of the database and if you need to restorer the data you can do import after that.

    You use imp and exp utilities, or the expdp and impdp in Oracle 10g.
    go to the oracle clinic
    Quick and easy Oracle database support and consulting

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    as an application developer maybe you will prefer to do an export of the database and if you need to restorer the data you can do import after that.

    You use imp and exp utilities, or the expdp and impdp in Oracle 10g.
    they arent backup methods, very bad advice
    Last edited by davey23uk; 04-12-2006 at 05:27 AM. Reason: someone being picky (Mr Cliche) :-)

  5. #5
    Join Date
    Apr 2006
    Posts
    50
    Davey,

    I think you should be a bit clearer, you make it sound like waitecj's post is also bad advice. When I'm guessing you're just talking about oracli's.

  6. #6
    Join Date
    Mar 2006
    Posts
    40
    Quote Originally Posted by davey23uk
    they arent backup methods, very bad advice
    for a developer database a import/export is a good backup method. You can separately import tables as needed. It provides convinience. You can make separate exports on separte tables/schemas after some changes in the application and can import only those if needed. If you need a image copy of the database the best is to do a backup using Recover Manager (rman).
    go to the oracle clinic
    Quick and easy Oracle database support and consulting

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    as i said, an export is not a backup method and its bad advice, you will lose data with it - doesnt matter if he is a developer a dba, a cleaner or the CEO's love child a backup needs to be a proper one

  8. #8
    Join Date
    Apr 2006
    Posts
    50
    Oracli,

    cheery_poori asked how to do a backup. Exp/imp is not a backup method, I'm not saying it doesn't have it's uses, but it isn't a valid backup method. Rather than arguing with Davey follow this http://asktom.oracle.com/pls/ask/f?p...D:832427034486
    and search for

    'do not even remotely consider use EXP as a "backup" tool'

    I think you can guess who said it from the link.

  9. #9
    Join Date
    Mar 2006
    Posts
    40
    I know it is not a proper "backup" for a production database, I recommended it to cheery_poori as he is obviously not experienced with the Oracle database as a DBA, and the database he is using is for development, so if he uses a rman ora pure copy of datafiles/redos/controlfiles he might make a mistake and not be able to restore/recover the database at all (knowing many developers treat the DB as a black box). I still say exp/imp is a better solution for this situation.

    The things are nto always black and white. If cheery_poori sais he needs a backup maybe someone should first asked him what kind of backup does he like and from what situation to be able to recover, what options does he have for backuing up does he even have a separete storage where he would do a backup or he will use a tape so he will need a media manager for RMAN.

    Sometimes there are "custimzed" solutions to problems.
    go to the oracle clinic
    Quick and easy Oracle database support and consulting

  10. #10
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    AN EXPORT IS NOT A BACKUP!!! get it? never has and never will be, it is a tool for moving data between databases

    if you use export, you will lose data - any solution that means you lose data is by definition not a backup!!!!

    Sooner everyone realises that the sooner people like him stop coming back saying i've lost my data, can i recover from an export without losing data

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