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: Cristi <>
Date: 22 Mar 2007 04:10:21 -0700
Message-ID: <>

On 22 Mar, 11:01, "Charles Hooper" <> wrote:
> 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.

To complicate things a bit the person who did our install is no longer here so I am not sure how the install was done. Whenever I try to start the dbconsole I get:

$emctl start dbconsole
TZ set to GB-Eire
OC4J Configuration issue. /u01/app/oracle/product/10.2/oc4j/j2ee/ OC4J_DBConsole_localhost.localdomain_PIMMS02 not found Received on Thu Mar 22 2007 - 06:10:21 CDT

Original text of this message