Re: Archive mode

On 12 Mar 1998 18:30:15 -0800, joelga_at_pebble.ml.org (Joel Garry) wrote:

>In article <01bd4e01$8a52fbf0$21021ec0_at_ntcowell>,
>Brad <someone_at_nowhere.com> wrote:
>>We have an Oracle Workgroup Server running on WinNT 4.0. I need to set it
>>up in archive mode so that I can do a partial backup of the database once a
>>week. I can get it to show that it will automatically archive, but it
>>still says the database is in NO ARCHIVELOG mode. Any ideas?
>
>Sounds like you need to create the database in archivelog mode. If you didn't
>create it that way, you can't change to it. I know all the docs say otherwise,
>but hey, this is usenet. Either that or ALTER DATABASE ARCHIVELOG while
>mounted but not open. Be sure you've set archive_log_dest and
>archive_log_format correctly.

might be something like:

log_archive_start = true
log_archive_dest = e:\ora_arch
log_archive_format = O_%S.%T

>
>>
>>Brad
>
>
>--
>These opinions are my own and not necessarily those of Information Quest
>jgarry@eiq.com http://www.informationquest.com
>http://ourworld.compuserve.com/homepages/joel_garry
>"See your DBA?" I AM the @#%*& DBA!

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de