Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

10g | RMAN | Daily backups in individual folders

rthampiNov 24 2015 — edited Nov 24 2015

Hi guys

RMAN> show all;

using target database control file instead of recovery catalog

RMAN configuration parameters are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 3;

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\oracle\rman\backup\%F';

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   'D:\oracle\rman\backup\%U';

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SNCFSCT.ORA'; # default

RMAN>

The above describes the RMAN setup I have made with the 10g installation that is in my laptop for learning purposes. Now, how can I make sure that each day the backup will be created in individual folders like below mentioned few

D:\oracle\product\10.2.0\flash_recovery_area\SCT\BACKUPSET\2015_11_21

D:\oracle\product\10.2.0\flash_recovery_area\SCT\BACKUPSET\2015_11_22

D:\oracle\product\10.2.0\flash_recovery_area\SCT\BACKUPSET\2015_11_23

D:\oracle\product\10.2.0\flash_recovery_area\SCT\BACKUPSET\2015_11_24

My backups used to get created under individual folders until I changed RMAN channel device type with "CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'D:\oracle\rman\backup\%U';"


Please suggest.


Thanks in advance

This post has been answered by EdStevens on Nov 24 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 22 2015
Added on Nov 24 2015
6 comments
1,396 views