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: Error for archivelog ?!

Re: Error for archivelog ?!

From: Andrea <netsecurity_at_tiscali.it>
Date: 23 Jun 2006 07:42:58 -0700
Message-ID: <1151073777.966452.78730@g10g2000cwb.googlegroups.com>

sybrandb ha scritto:

> Andrea wrote:
> > hi,
> >
> > i have set archive log as show:
> >
> > >alter system set log_archive_dest = 'd:\oracle\arch' scope = SPFILE;
> >
> > (mount db)
> >
> > >alter database archivelog
> >
> > "ORA-16019: cannot use db_recovery_file_dest with LOG_ARCHIVE_DEST"
> >
> > what does it mean??
> > it's a conflict with flash recovery?
> >
> > thanks for support
> >
> > bye
>
> It means the flash area (indicated by db_recovery_file_dest), is
> mutually exclusive with log_archive_dest. If you set log_archive_dest
> you can't have a flash recovery area.

therefore is not possible to able either flash recovery area and archive log mode..

which of those solution is best for full backup of database? Received on Fri Jun 23 2006 - 09:42:58 CDT

Original text of this message

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