-
RMAN Backup
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.
Code:
CONFIGURE BACKUP OPTIMIZATION ON;
You may want to change this parameter as well.
Code:
CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
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:
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.