Re: Datawarehouse backup

The implication was that the poster was unable to do archive log backups during the week.

I'm with Tim, archivelog should always be on.

If there's a reason you simply cannot backup archive logs during the week, my suggestion was to backup archive logs during the weekly backup along with the rest of the database.

This would give you a recoverable backup. Yes, I was suggesting to delete the archive logs the rest of the time if you could not back them up.

This avoided taking the database down for a backup.

I don't believe this to actually be a good idea, just a poor but plausible solution to the posters problem.

Think of what you are losing by doing this:

• The need to run ETL as a recovery process (ugh!)
• The inability to restore a single file. The only possible restore is the entire database.
• The inability to do TSPITR
• The inability to do block level restores.
• etc, etc, etc.

So, yes, I really meant what you think I did.

No, I don't actually think it to be a good idea.

On Thu, 10 Mar 2005 09:57:09 -0500, Michael McMullen <ganstadba_at_hotmail.com> wrote:
> could I get more input, I'm confused.
> Do you mean run the database in archivelog mode, do an full online backup
> say once/week and delete the archivelogs during the week. If recovery is
> required just recover the full and run the etl for the week?
>
> The reason I ask is I have numerous 200-500Gb database in noarchivelog mode.
> Exports only, they churn through 30-75Gb/day. All on 8i. Most of the data is
> rebuilt completely every day. Very hard to get deltas from our feeds. So
> exports are the choice as we rebuild completely. Nobody will give the
> downtime(or disk space) to do full backups. Everyone theoretically knows the
> risks. I've recovered somewhat completely many times using this method. But
> I'm interested in new approaches for when we move to 9i.
>
> really, he can just use rman on his 9i, and do the cold backup with that.
> Easy peasy.
>
> Mike
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l