Re: Error for archivelog ?!

Andrea:
You can setup the database/flash area in several different ways:

1. Not use it at all (my own personal preference)
2. Setup flash area for archivelogs and RMAN backups
3. Setup flash area and archive to another file system in addition to the flash area
4. Archive to another filesystem instead of flash area but rman uses flash for backups
5. Setup flash area for archive logs only but place backups on another file system

It really is all up to you what you feel comfortable with. I am not sure there is a "best solution"

-Greg

Andrea wrote:
> 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 - 10:56:39 CDT