Printable View
How much space is required to take RMAN backup. I am starting the RMAn backup and ends up with error can not reclaim 52428800 bytes disk space from 161061273600.
The db size is 87GB. The db_recovery_file_det_size is 150GB. The datafile size is 145GB.
I am executing just:
RMAN>BACKUP FULL DATABASE;
how can the DB size be smaller than the datafile size? I have DB's that are
Terabytes big and they backup. Post your RMAN parameters?
The datafile size is the complete size of datafile and db size is data filled in datafiles.
Correct me if I am wrong.
Below is the RMAN configuration parameters:
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORAD2 are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
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 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\DBADMIN\PRODUCT\11.2.0\ORAD1\DATABASE\SNCFORAD2.ORA'; # default
do you have one set of complete backup? what is the size of backup? are you storing archive logs in recovery destination?
Thanks,
This is a new database and well, this would be the first backup of database.
First you should turn on backup optimization.
You may want to change this parameter as well.Code:CONFIGURE BACKUP OPTIMIZATION ON;
Then you should check to see how much of the flash recovery area that you are using. You may need to increase the size of this parameter.Code:CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
Code:col name format a40
col SPACE_AVAILABLE format a30
col SPACE_LIMIT format a20
select
name,
to_char(space_limit, '999,999,999,999') as space_limit,
to_char(space_limit - space_used + space_reclaimable,
'999,999,999,999') as space_available,
round((space_used - space_reclaimable)/space_limit * 100, 1) as pct_full
from
v$recovery_file_dest;
I would like to add one more point,Please use format while backing up the database,else the backup will be taken in the default location which will be $ORACLE_HOME/dbs,and i guess this will not have sufficient space,
I would suggest you to use
backup full database fomat='Location of dump%U'
I have set the bd_recovery_file_det. So the backup will go to that destination.