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: Need backup help w/Oracle 7.3

Re: Need backup help w/Oracle 7.3

From: <gilb_at_xxx.senate.gov>
Date: 1998/06/09
Message-ID: <357d3609.1218110350@news.senate.gov>#1/1

Even if you're running in ARCHIVELOG mode I still believe a full COLD backup is your best bet as often as you can take one. The cold backup procedure CM outlined below is the same for ARCHIVELOG and NOARCHIVELOG modes.

Gilbert

On Mon, 01 Jun 1998 20:14:01 GMT, cmohan_at_iname.com wrote:

>First of all, you should know if your database is running in ARCHIVELOG mode
>or NOARCHIVELOG mode. Issue SELECT * from v$database. There you can find
>this out. If you are running in ARCHIVELOG mode, I can not help you in a forum
>like this. Since you have not done this before, you should have some one
>looking over your shoulders (or at least on the phone with you).
>If you are running in NOARCHIVELOG mode,
>Issue the following commands, and print the results.
>
>select * from v$datafile;
>select * from v$controlfile;
>select * from v$logfile;
>
>Identify the INITxxx.ORA parameter file.
>
>Shutdown the database normally. Copy the above files and you would have
>performed a cold backup.
>
>Good luck,
>CM
>
>
>In article <6kugdh$u3l$1_at_nnrp2.dejanews.com>,
> bmolish_at_my-dejanews.com wrote:
>>
>>
>> I need to do a complete backup of all datafile, control files, online redo
>> logs, and the init.ora file what is the easiest way to accomplish this?
>>
>> Our DBA left, and there is no one here to tell me how to do a complete
 backup
>> of our Oracle 7.34 database. This resides on an HP UX 10.2 box.
>>
>> Any help would be appreciated.
>>
>> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
>> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>>
>
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Tue Jun 09 1998 - 00:00:00 CDT

Original text of this message

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