Re: Copy of an Oracle db
From: Edzard <edzard_at_volcanomail.com>
Date: 16 Feb 2002 14:06:54 -0800
Message-ID: <5d75e934.0202161406.48b3f97b_at_posting.google.com>
Date: 16 Feb 2002 14:06:54 -0800
Message-ID: <5d75e934.0202161406.48b3f97b_at_posting.google.com>
Hello,
Most safe is to take a backup while the database is shut down. You
need:
- the database files (typically *.dbf)
- the control file (*.ctl)
- the redo log files (*.log or *.rdo) Typically these files are al in the oradata directory. But you can not sure of this. You may check the names in the Oracle Dictionary: select * from v$datafile or dba_data_files select * from v$logfile
Edzard Received on Sat Feb 16 2002 - 23:06:54 CET