RE: Backup strategy with RMAN

From: Kamalakannan, D (CAP, GCF) <D.Kamalakannan_at_gecapital.com>
Date: Wed, 29 Nov 2000 11:20:35 +0100
Message-Id: <10695.123169@fatcity.com>

Hi,
I found a mail which stated that RMAN cannot be used with NO ARCHIVING . But you can use RMAN to do backup even without Archiving.This is done by mounting the database and not opening it. Then perform the usual way u take the backup. Regards,
kamal

-----Original Message-----
From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us] Sent: Tuesday, November 28, 2000 8:06 PM To: Multiple recipients of list ORACLE-L Subject: Re: Backup strategy with RMAN

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
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may

Received on Wed Nov 29 2000 - 04:20:35 CST