Re: Backup strategy with RMAN

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Tue, 28 Nov 2000 15:04:51 -0500
Message-Id: <10694.123119@fatcity.com>

I will try to answer. See asnwers inline.

> Hi!
>
> I switched from cold nightly backups to online backups with RMAN.
>
> I took one last cold backup, then I do a full db backup using RMAN every
> day.
> Is there a need to catalog all the files from the final cold backup in the
> recovery catalog?

No , you don't need to catalog this backup. I assume you have a full rman backup taken right after this.
>
> After that I want to back up the archived logs.
>
> How can I have RMAN go into the archive_log_dest directory and back up all
> archived logs that it can find there?
> I have a job that periodically deletes archived logs fromt that directory.

You can do an archivlog backup and delete in the same script.. Here is my rman script to do this. I archive the last log before I do this.

replace script backup_dbal_all {

#
#  Backs up all archived logs to tape, then deletes them once the
#  backup has successfully completed.  It puts a maximum of 20
#  archived logs in any one backup set (filesperset 20).
#
#  Modified  By   Reason
#  981002    rg   created
#

  execute script archive_pclog_current;
  execute script alloc_db1_disk;
  backup
    filesperset 20
    format '/dbback/al_%sdb_name_%p'
    (archivelog all
     delete input);
  execute script rel_db1_disk;
}

Here is the script to archive the last log. replace script archive_dblog_current {

#
#  Modified  By   Reason
#  981002    rg   created
#

#
#  Archives the current redolog
#
#  Oracle recommends the current log is archvived immediately after

# performing any open (i.e. hot) backups. #
  sql 'alter system archive log current'; }
>
> This is 8.1.6 on Windows 2000

I have 8.0.5.1.and 8.0.6 databases in my 8.0.6 recovery catalog and the are on 3 AIX (RS/6000) servers.

I hope this helps
Ruth
>
> Thanks,
> Helmut
>
>
> --------
> Think you know someone who can answer the above question? Forward it to
them!
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
Received on Tue Nov 28 2000 - 14:04:51 CST