Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

RMAN backup strategy on 10g r2 on linux

From: Cristi <cmit37_at_gmail.com>
Date: 22 Mar 2007 03:01:13 -0700
Message-ID: <1174557673.033849.65280@n59g2000hsh.googlegroups.com>


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{
ALLOCATE CHANNEL ch1 TYPE DISK;
BACKUP FULL TAG FULL_DB FORMAT '/oracle_backup/%d_DB_%u_%s_ %p.backupfull.rman'(database);
RELEASE CHANNEL ch1;
}

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 Received on Thu Mar 22 2007 - 05:01:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US