Database Backup and Recovery (MOSC)

MOSC Banner

Have I covered everything ?

edited May 18, 2009 4:23AM in Database Backup and Recovery (MOSC) 6 commentsAnswered
 Greetings experts... I'd appreciate your imput...

I'm setting up rman to replace our old user managed backups... Linux w/ 10.2.0.4

Daily cron of a shell script that will...

run rman (nocatalog) with a command file,

checks logs for errors,

check for any entries V$DATABASE_BLOCK_CORRUPTION,

sends backups files to tape (only most recent copies stay on disk),

checks tape log for errors...

Here's the rman command file... I tried not to use "implicite" commands...

CONNECT TARGET /
set echo on;
# Keep backups listed in the controlfile repository as being usable for 365 days. Max tape history is currently 14 days.
########################################################################################################################
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 365 DAYS;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center