Re: Taking a full Backup of Oracle Database

Dominic Cribbin wrote:
>
> Hi All,
>
> I am new to Oracle, coming from a SQL Server backround. I currently have
> Oracle Enterprise Manager 2.0.4 and Oracle8i Enterprise Edition for Windows
> NT 8.1.5 installed. I would like to take a full/complete backup of a
> database because I want to delete this DB from one machine and create it
> again from backup onto another machine.

If you want to simply copy the files at the OS level, shutdown the database (using svrmgr30.exe) & the instance (using the control panel or oradim80.exe) & copy all data files, control files, on-line redo logs, password file & the init<sid>.ora parameter file. If you are not sure which files would be included in those categories exec the following queries before shutting down:

select name from v$datafile;

select name from v$controlfile;

select member from v$logfile;

> Can anyone out there inform what would be the best method or Oracle tool to
> use so that I can be confident the I got everything related to that
> database.
>
> Also is there a backup facility with Oracle Enterprise Manager, if so is it
> reliable ? And also does anyone know where I could get online documentation
> about the Enterprise Manager.

You might look into using RMAN, though it may be difficult to use to *move* a database -- it's job is to backup & restore a database. --

Vincent Ventrone    |  The MITRE Corp.
DBA, Dept. R101     |  M/S C020
vav_at_mitre.org       |  202 Burlington Rd.
(781) 271-7048      |  Bedford, MA 01730