Post reply

Backup & Restore Oracle DB!

  • February 12, 2012 at 11:54 am

    #391541

    Hi guys,

    I am very new in Oracle. I would like to know is there any way i can create a Backup of Oracle Db and Restore it Like SQL has?

    Thanks in advance!

    Roc.

  • February 12, 2012 at 12:01 pm

    #1446056

    You might want to ask this in an Oracle forum.

    This is mainly a MS SQL Server site.

    IIRC, http://asktom.oracle.com is a good resource.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • February 12, 2012 at 1:06 pm

    #1446060

    rocky_498 (2/12/2012)

    I am very new in Oracle. I would like to know is there any way i can create a Backup of Oracle Db and Restore it Like SQL has?

    Either you rely on RMAN or you write your own backup/restore scripts.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • February 13, 2012 at 8:38 am

    #1446285

    Have a look at FAQ oracle backp.

    Also read Oracle concepts documentation from the oraclewebsite.

    Needs rman:

    DBID of your database

    Backup including controlfile & spfile

    Backup of archivelogfiles

    Extra "backup": consistent expdmp (not as sysdba)

    Somewhere on this forum there is a link to various Oracle-forums

  • February 13, 2012 at 11:20 am

    #1446395

    Jo Pattyn (2/13/2012)

    Somewhere on this forum there is a link to various Oracle-forums

    You can try http://www.dbasupport.com/forums/forumdisplay.php?f=20

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • April 1, 2012 at 10:28 am

    #1467444

    You don't say which version of Oracle you are using.

    You can use RMAN, which is a command line utility. However, the syntax and concepts are a little tricky until you become familiar with them.

    It is very, very powerful and if used correctly will backup your database, archive redo logs, control file and binary parameter file:

    http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta040.htm

    A simpler way is to use either Oracle DB console (if it's installed) or Grid Control (if you have a central management server) to schedule your backups, this will act as a user friendly 'front end' to RMAN.

    BTW, do not let anyone convince you that an export using exp/imp (which are now deprecated) or data pump, constitutes a backup. It does not 😉

    It is merely logical export of database objects and should not be relied on for recovery. It is primarily a means of moving data, object structures and users from place to place.

  • April 2, 2012 at 5:41 am

    #1467576

    dba_stephanie-b (4/1/2012)BTW, do not let anyone convince you that an export using exp/imp (which are now deprecated) or data pump, constitutes a backup. It does not 😉

    It is merely logical export of database objects and should not be relied on for recovery. It is primarily a means of moving data, object structures and users from place to place.

    Couldn't agree more.

    The reason why exp/imp and expdp/impdp are not "backups" is simple - you cannot restore/recover a database from those dump files; if you cannot do it then it is not a backup.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • April 10, 2012 at 2:14 pm

    #1471500

    I'm not an Oracle expert, but IMHO creating a backup with RMAN with the control file and all the rest will not be very useful to restore that backup on a SQL Server.



    My blog

  • April 10, 2012 at 2:19 pm

    #1471503

    rocky_498 (2/12/2012)

    Hi guys,

    I am very new in Oracle. I would like to know is there any way i can create a Backup of Oracle Db and Restore it Like SQL has?

    Thanks in advance!

    Roc.

    I'm assuming that you want to copy the data from an Oracle database into a SQL Server database. If that is the case you must keep in mind that an Oracle database can't be compared to a SQL database, so don't assume that a backup of an Oracle database is the same as a SQL Server database backup, because they are not the same. If your goal is to import data from an Oracle database into SQL Server there are many ways of doing it, one of them is SSIS.



    My blog

  • April 10, 2012 at 2:22 pm

    #1471507

    rocky_498 (2/12/2012)

    Hi guys,

    I am very new in Oracle. I would like to know is there any way i can create a Backup of Oracle Db and Restore it Like SQL has?

    Thanks in advance!

    Roc.

    It looks to me that he is asking if Oracle as anything similar to BACKUP/RESTORE in MS SQL Server.

  • April 10, 2012 at 2:37 pm

    #1471515

    Lynn Pettis (4/10/2012)

    rocky_498 (2/12/2012)

    Hi guys,

    I am very new in Oracle. I would like to know is there any way i can create a Backup of Oracle Db and Restore it Like SQL has?

    Thanks in advance!

    Roc.

    It looks to me that he is asking if Oracle as anything similar to BACKUP/RESTORE in MS SQL Server.

    Agreed. Poster does not wants to restore an Oracle backup on a SQL Server database which would be something... how to put it, a very unusual business requirement. Poster just wants to know how backup/recovery is done on Oracle.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • April 11, 2012 at 5:00 am

    #1471754

    PaulB-TheOneAndOnly (4/10/2012)

    Lynn Pettis (4/10/2012)

    rocky_498 (2/12/2012)

    Hi guys,

    I am very new in Oracle. I would like to know is there any way i can create a Backup of Oracle Db and Restore it Like SQL has?

    Thanks in advance!

    Roc.

    It looks to me that he is asking if Oracle as anything similar to BACKUP/RESTORE in MS SQL Server.

    Agreed. Poster does not wants to restore an Oracle backup on a SQL Server database which would be something... how to put it, a very unusual business requirement. Poster just wants to know how backup/recovery is done on Oracle.

    Indeed, I misunderstood his question.



    My blog

  • April 11, 2012 at 4:04 pm

    #1472296

    PaulB-TheOneAndOnly (4/10/2012)

    Agreed. Poster does not wants to restore an Oracle backup on a SQL Server database which would be something... how to put it, a very unusual business requirement.

    Not to mention physically impossible :ermm:

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply