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: How to perform a simple full database backup

Re: How to perform a simple full database backup

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Mon, 07 Apr 2003 00:46:06 +0200
Message-ID: <f6a19vgppch4q4u4hsvppk71k4d74hbhm2@4ax.com>


Norman Dunbar <Norman.Dunbar_at_lfs.co.uk> wrote:
>you'll want the 'cold backup' method then !
>
>login as system and do the following :
>
> select name from v$datafile
> union
> select member from v$logfile
> union
> select name from v$controlfile
> order by 1;
>
>

What about files of rollback segments and temp tablespace?

Bye
Rick Denoire Received on Sun Apr 06 2003 - 17:46:06 CDT

Original text of this message

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