Re: Need backup help w/Oracle 7.3

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 Mon Jun 01 1998 - 00:00:00 CDT