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!

rman - huge data file in dbs folder

792829Oct 18 2012 — edited Oct 18 2012
Hi

I have the rman script as
run
{
allocate channel ch1 type disk;
set limit channel ch1 kbytes=2000000;
crosscheck archivelog all;
backup incremental level 0
tag backup_db_level_0
format '/u01/backup/TESTDB/db/df_fl_%d_t%t_s%s_p%p'
as compressed backupset
database;
sql 'alter system archive log current';
copy current controlfile to '/u01/backup/TESTDB/db/cntrl_%d_t%t_s%s_p%p';
backup
format '/u01/backup/TESTDB/db/al_%d_t%t_s%s_p%p'
as compressed backupset
archivelog from time 'SYSDATE-1' until time 'SYSDATE';
delete noprompt archivelog until time 'sysdate-2';
release channel ch1;
}
";

Show all
RMAN configuration parameters for database with db_unique_name PRODGRC1 are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
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 MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/apps/oracle/product/11.1.0/dbs/snapcf_TESTDB.f'; # default



After RMAN runs, I see a HUGE file in DBS folder
pdno2e4q_1_1 -> 50GB almost looks to me like a database snapshot.
Why would this file be created? Any suggestions?

The controlfile snapshot snapcf_TESTDB.f is 20M. The above pdno* fils is 50GB in size.
What am I doing wrong?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 15 2012
Added on Oct 18 2012
9 comments
2,647 views