Re: RMAN incremental backup
- From: Wayne Smith <wts@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 10 Dec 2010 14:11:15 -0500
In practice, your production script cannot be "very simple", for there are
lots of additional concerns you might deal with ...
- You'll probably want to embed or determine the ORACLE_SID to be used
(and perhaps determine the ORACLE_HOME from oratab or oraenv), setting these
environment variables.
- You'll probably want to log the outputs of RMAN and perhaps gather
other information or do other tasks in this script, such as management of
the catalog/control file information. This may include a log rotation
system to make several recent run logs available.
- You'll probably want to do periodic level 0 backups, so you may wish to
generalize your script in this respect.
- You will probably want to invoke rman more explicitly, such as
"$ORACLE_HOME/bin/rman" if on non-windows.
- If you use something such as the NetBackup Agent for Oracle, then
invocations of your script may not be using "oracle" or have any of your
normal environment setup, as well as may have a number of variables set to
help you tailor the backup.
- If the backup is long in duration, you may want to setup multiple
streams (ALLOCATE CHANNEL).
- Other rman backup parameters such as "check logical" or "delete all
input" may be appropriate.
- You may wish to obtain, store to the logging and otherwise report the
return status from rman.
I've probably left off many other items you might consider to help minimize
risk of not seeing when backups fail.
Cheers, Wayne
On Fri, Dec 10, 2010 at 10:49 AM, Allen, Brandon
<Brandon.Allen@xxxxxxxxxxx>wrote, in part:
> Yes, just create a shell script that calls rman using a “here document”,
> and then schedule the shell script in your crontab. Here is a very simple
> example:
>
>
>
> rman target / nocatalog<<EOF
>
> backup INCREMENTAL LEVEL=1 CUMULATIVE database plus archivelog;
>
> EOF
>
>
>
> You could use an input variable or some built-in logic to set the level of
> the incremental depending on your needs. Also look into using a block
> change tracking file if you’re not already familiar with it.
>
Other related posts:
