Re: Backup strategy with RMAN

Hi !

I guess you are refering my mail (sent some time back) where the original poster wanted to take online backup using RMAN (when the db is in no archive)
where I said RMAN is another tool to copy (backup) the database.. Not RMAN alone
will do the magics :)

• Original Message ----- From: Kamalakannan, D (CAP, GCF) <D.Kamalakannan_at_gecapital.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, November 29, 2000 3:50 PM Subject: RE: Backup strategy with RMAN

> 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-----
> Sent: Tuesday, November 28, 2000 8:06 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kamalakannan, D (CAP, GCF)
> INET: D.Kamalakannan_at_gecapital.com
>
> 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
> also send the HELP command for other information (like subscribing).
Received on Wed Nov 29 2000 - 04:53:20 CST