Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Backup and Recovery Suggestions

Re: Backup and Recovery Suggestions

From: frank.sara <frank.sara_at_infonie.fr>
Date: Tue, 17 Apr 2001 21:52:58 +0200
Message-ID: <987537936.64690@remus.infonie.fr>

It's a very good direction your taking. normally, a good RAID should take care of a lot of trouble. Problem is that most of the time, the reason you need to recover is not hardware but userware (i.e. oups, i deleted the wrong file), for that case:
Best thing to do:
Backup:

  1. Stop the database
  2. Copy the datafiles, logfiles, controlfiles and initSID.ora file to tape or Backup the whole disk to tape so you'll be sure you wont miss anything
  3. restart database

Recovery

  1. Stop the database if it's still running
  2. Copy files from tape to disk
  3. Start database.

   Have a nice day!

<lonnie_at_1nce.com> a écrit dans le message : 3adb6bfd.269169204_at_news.alntn1.tx.home.com...
> I was wondering if anyone has any backup and recovery plans that I
> could follow? I am wanting to have two recovery methods one being
> hardware redudancy the other being software replication is this a good
> direciton to go in?
>
> L|C
Received on Tue Apr 17 2001 - 14:52:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US