Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to perform a simple full database backup
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
![]() |
![]() |