Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN backup strategy on 10g r2 on linux

Re: RMAN backup strategy on 10g r2 on linux

From: Charles Hooper <>
Date: 22 Mar 2007 04:01:42 -0700
Message-ID: <>

On Mar 22, 6:01 am, "Cristi" <> wrote:
> Hi,
> Please forgive a lot of my ignorance as I am very new to the entire
> Oracle database world. I am currently working my way through the
> "Oracle Database 10g Linux Administration" book in order to understand
> how to efficiently backup and restore our instance of the db.
> Unfortunately I am in a bit of a panic/tight spot as the management
> has decided to bring forward the live date of the database without
> consulting me about the state of the backup(I am in charge of backups)
> and as such I need to be able to have a temporary way of backing up
> fully the db and a simple way of doing a full restore of it should the
> hard drives fail at least until I manage to learn a bit more.
> I wrote a shell script that is called by cron every night. This shell
> script calls an Rman script that I found on the internet, I assume
> that the rman script does a full backup of the database and then hands
> the control back to the shell script, the shell script archives the
> rman files and uploads them to an ftp site on my backup server who in
> turn copies it to tape.
> The database is not expected to be too large for the next month and
> ideally I would initially like to have a way of taking full nightly
> backups that will allow me to fully restore everything in a rush
> should the hard drives fail.
> I have enabled Archivelog mode on the db and this is the script I
> assume does the complete backup:
> RUN{
> BACKUP FULL TAG FULL_DB FORMAT '/oracle_backup/%d_DB_%u_%s_
> %p.backupfull.rman'(database);
> }
> Do you think that the files it creates are enough to do a full restore
> on a blank install of oracle without the need for any other files?
> If I had to do a full restore from the created files what commands
> would I issue?
> Would a better way of doing backups be a full weekly backup plus daily
> incremental exports? How would you script that?
> Thank you

Take a quick look through Oracle Enterprise Manager Database Control. On the Maintenance tab, select Schedule Backup. Read what is displayed on screen carefully as you are guided through scheduling a backup job. Test the backup job for several days to verify that old archive redo logs are deleted AFTER a couple days. It really is very simple to schedule an RMAN backup with 10g R2. Once you have a basic backup job in place, definitely read through the RMAN documentation as recommended by Sybrand. I suggest that you review the RMAN commands generated by OEM, which can be accomplished easily before the backup job is submitted.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Thu Mar 22 2007 - 06:01:42 CDT

Original text of this message