This discussion is archived
9 Replies Latest reply: Feb 27, 2013 6:43 AM by 936666 RSS

Backup and restore

936666 Newbie
Currently Being Moderated
Hi,

What are the steps involved in Backup and restore process.
Can we do other than RMAN

Thanks!
  • 1. Re: Backup and restore
    Aman.... Oracle ACE
    Currently Being Moderated
    933663 wrote:
    Hi,

    What are the steps involved in Backup and restore process.
    Can we do other than RMAN

    Thanks!
    The steps actually are restore and recovery and obviously, to do the restore, you must have to have a valid backup as well. You can use RMAN if you have taken the backup via it or if you have taken the backup using the user-managed techniques, you can use the same commands from the sqlplus window as well.

    Aman....
  • 2. Re: Backup and restore
    Fran Guru
    Currently Being Moderated
    You can do cold and hot backups . And yes, it could be done without rman, but if you has a good and easy application to do it, why don't not use it?

    Backup and restore:
    http://docs.oracle.com/cd/E11882_01/backup.112/e10642/toc.htm

    without rman:
    http://www.orafaq.com/forum/t/177381/0/
  • 3. Re: Backup and restore
    UW (Germany) Explorer
    Currently Being Moderated
    You might have a look at the documentation
    http://docs.oracle.com/cd/E11882_01/backup.112/e10642/toc.htm
    For example look at "Part VIII Performing User-Managed Backup and Recovery"

    Edited by: UW (Germany) on 26.02.2013 13:33 (corrected typo)
  • 4. Re: Backup and restore
    936666 Newbie
    Currently Being Moderated
    How to take backup on sqlplus command window and restore the same.
  • 5. Re: Backup and restore
    Aman.... Oracle ACE
    Currently Being Moderated
    933663 wrote:
    How to take backup on sqlplus command window and restore the same.
    Read the documentation link given in the reply above by UW. That contains everything that you would ever want to know about the backup and recovery.

    Aman....
  • 6. Re: Backup and restore
    EdStevens Guru
    Currently Being Moderated
    933663 wrote:
    How to take backup on sqlplus command window and restore the same.
    You don't. You use rman. That is the tool that was designed for that task. That is the tool Oracle provides at no additional charge for that task.

    Why are looking to do it with anything other than the tool that was designed and provided for that task?

    I bought a car. The manufacturer provided a spare tire, a jack, and a lug wrench to allow me to change the tire if I get a flat. The spare tire, jack and lug wrench are conveniently packed into the trunk. Please tell me how to change my tire without using the spare tire, jack, and lug wrench that are in the trunk of my car.
  • 7. Re: Backup and restore
    moreajays Pro
    Currently Being Moderated
    Hi,

    From sqlplus , you need to take user managed backup by

    backup:
    1. putting DB in hot backup or tablespace in begin backup (archivelog mode), or shutting down db (for No-archivelog mode)
    2. copy files to staging server
    3. End hot backup or startup db
    4. switch log file

    restore:
    1. prepare init file
    2. startup nomount
    3. re-create controlfile
    4. recover database
    5. Open database

    http://docs.oracle.com/cd/B28359_01/backup.111/b28270/osbackup.htm

    Thanks,
    Ajay More
    http://www.moreajays.com
  • 8. Re: Backup and restore
    EdStevens Guru
    Currently Being Moderated
    moreajays wrote:
    Hi,

    From sqlplus , you need to take user managed backup by
    <snip>>
    Thanks,
    Ajay More
    http://www.moreajays.com
    But 'user managed backup' really means 'user managed recovery'. Don't forget that the "R" in "RMAN" stands for "Recovery" --- as in "Recovery Manager".

    Recovery scenarios are, by definition, high-pressure situations where you are always just one keystroke away from making things worse. That's when one really appreciates the value of a tool to help manage the recovery, rather than leaving it entirely to a panicking DBA.

    Yes, it is possible to take a backup and a recovery without rman, but I'm still waiting for a justification for doing so on anything but a vldb where more exotic methods are needed simply because of the time needed to back up an extremely large volume of data.

    Edited by: EdStevens on Feb 26, 2013 7:42 AM
  • 9. Re: Backup and restore
    936666 Newbie
    Currently Being Moderated
    Thanks!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points