Database Backup and Recovery (MOSC)

MOSC Banner

RMAN - delete obsolete issue

edited Feb 15, 2010 10:21PM in Database Backup and Recovery (MOSC) 10 commentsAnswered
 Hi,

We are using 9i database on windows 2003 server with the following details.

Configuration details:

uses target database controlfile instead of recovery catalog

CONFIGURE RETENTION POLICY TO REDUNDANCY 4;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '\\<server>\<db_name>\cf_%F';
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '\\<server>\<db_name>\%t_%s_%p.rman';
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE\ORA92\DATABASE\SNCF<db_name>.ORA';

----------------------------

We take cold backup 2 times in weekly (Sunday and Wednes day) only.

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