Re: to much archivelog

Originally posted by Zeb
> Hi,
>
> We have a datawarehouse, ( 8.1.7, AIX 4.3.3 )
> the database is in archivelog and we have disk space problem.
> we have a lot of archive we don't need
> we only need them to do the hot backup.
>
> do you know a method to get the archive only for the backup
> something like:
> - noarchive log
> - put the database archive log
> - do the hot backup
> - put the database no archive log
>
> Is a good method ???
>
>

This is definitely NOT a good method. There's no point switching your database to archivelog mode just for backup. If you don't want the archived redo, you can keep your database in noarchivelog mode and do a cold backup.

If archived redo is a space issue, back it up multiple times during the day and delete after its been backed up. That way you get advantages of hot-backup without excessive disk space use.

--
Posted via http://dbforums.com