DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: RMAN Backup

  1. #1
    Join Date
    Feb 2010
    Posts
    36

    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;

  2. #2
    Join Date
    Jul 2006
    Posts
    195
    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?

  3. #3
    Join Date
    Feb 2010
    Posts
    36
    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

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    do you have one set of complete backup? what is the size of backup? are you storing archive logs in recovery destination?

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  5. #5
    Join Date
    Feb 2010
    Posts
    36
    This is a new database and well, this would be the first backup of database.

  6. #6
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    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;

  7. #7
    Join Date
    Apr 2008
    Location
    Bangalore
    Posts
    96
    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'

  8. #8
    Join Date
    Feb 2010
    Posts
    36
    I have set the bd_recovery_file_det. So the backup will go to that destination.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width