Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2010
    Location
    Orlando, FL
    Posts
    311
    Provided Answers: 1

    Question Unanswered: Rman Disk Space Error

    I've been trying to learn how to use the RMAN utility on my 11g server. I've read all the documentation on this and I think I'm having problems or confusion about configuring my flash or fast recovery area (whatever the correct term is).

    Below is my Oracle users environment variables:

    Code:
    [oracle@db1 oracle]$ env
    HOSTNAME=db1
    SHELL=/bin/bash
    TERM=xterm
    HISTSIZE=1000
    USER=oracle
    LD_LIBRARY_PATH=:/oracle/u01/app/oracle/product/11.1.0/db_1/lib
    LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
    ORACLE_SID=cqdb
    ORACLE_BASE=/oracle/u01/app/oracle
    MAIL=/var/spool/mail/oracle
    PATH=/usr/local/bin:/bin:/usr/bin:/oracle/u01/app/oracle/product/11.1.0/db_1/bin:/home/oracle/bin
    INPUTRC=/etc/inputrc
    PWD=/oracle/u01/app/oracle
    LANG=en_US.UTF-8
    SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
    SHLVL=1
    HOME=/home/oracle
    LOGNAME=oracle
    LESSOPEN=|/usr/bin/lesspipe.sh %s
    ORACLE_HOME=/oracle/u01/app/oracle/product/11.1.0/db_1
    G_BROKEN_FILENAMES=1
    _=/bin/env
    OLDPWD=/home/oracle
    I don't know if my server should or should not be in ARCHIVE_LOG mode but I read I need to place it in such in order to get what Oracle calls 'inconsistent" backups which just mean the backups are performed while the database is mounted. Below is exactly what I did on my server to enable ARCHIVE_LOG mode:

    Code:
    SQL> archive log list
    Database log mode	       No Archive Mode
    Automatic archival	       Disabled
    Archive destination	       USE_DB_RECOVERY_FILE_DEST
    Oldest online log sequence     1487
    Current log sequence	       1489
    SQL> select name, log_mode from v$database;
    
    NAME	  LOG_MODE
    --------- ------------
    CQDB	  NOARCHIVELOG
    
    SQL> show parameter spfile
    
    NAME				     TYPE	 VALUE
    ------------------------------------ ----------- ------------------------------
    spfile				     string	 /oracle/u01/app/oracle/product
    						 /11.1.0/db_1/dbs/spfilecqdb.or
    						 a
    SQL> alter system set log_archive_dest_1='location=/home/oracle/archivelog' scope=spfile;
    
    System altered.
    
    SQL> shutdown immediate
    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    SQL> startup mount;
    ORACLE instance started.
    
    Total System Global Area 1653518336 bytes
    Fixed Size		    2213896 bytes
    Variable Size		 1224738808 bytes
    Database Buffers	  419430400 bytes
    Redo Buffers		    7135232 bytes
    Database mounted.
    SQL> alter database archivelog;
    
    Database altered.
    
    SQL> alter database open;
    
    Database altered.
    
    SQL> archive log list
    Database log mode	       Archive Mode
    Automatic archival	       Enabled
    Archive destination	       /home/oracle/archivelog
    Oldest online log sequence     1487
    Next log sequence to archive   1489
    Current log sequence	       1489
    SQL> select name, log_mode from v$database;
    
    NAME	  LOG_MODE
    --------- ------------
    CQDB	  ARCHIVELOG
    
    SQL> alter system switch logfile;
    
    System altered.
    
    SQL> /
    
    System altered.
    I have no idea if what I did above was correct and or necessary to get a quick backup of the database.

    Below is the documentation instructions for performing a backup with RMAN:

    Code:
    [oracle@db1 oracle]$ ORACLE_SID=cqdb
    [oracle@db1 oracle]$ export ORACLE_SID
    [oracle@db1 oracle]$ rman target=/
    
    Recovery Manager: Release 11.2.0.1.0 - Production on Tue Feb 7 10:52:44 2012
    
    Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    
    connected to target database: CQDB (DBID=1854033249)
    
    RMAN> configure controlfile autobackup on;
    
    using target database control file instead of recovery catalog
    old RMAN configuration parameters:
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    new RMAN configuration parameters:
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    new RMAN configuration parameters are successfully stored
    
    RMAN> backup database plus archivelog;
    
    
    Starting backup at 07-FEB-12
    current log archived
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: SID=196 device type=DISK
    channel ORA_DISK_1: starting archived log backup set
    channel ORA_DISK_1: specifying archived log(s) in backup set
    input archived log thread=1 sequence=1489 RECID=1 STAMP=774614337
    input archived log thread=1 sequence=1490 RECID=2 STAMP=774614340
    input archived log thread=1 sequence=1491 RECID=3 STAMP=774615198
    channel ORA_DISK_1: starting piece 1 at 07-FEB-12
    channel ORA_DISK_1: finished piece 1 at 07-FEB-12
    piece handle=/oracle/u01/app/oracle/backup/CQDB/backupset/2012_02_07/o1_mf_annnn_TAG20120207T105319_7m2l7h9s_.bkp tag=TAG20120207T105319 comment=NONE
    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
    Finished backup at 07-FEB-12
    
    Starting backup at 07-FEB-12
    using channel ORA_DISK_1
    channel ORA_DISK_1: starting full datafile backup set
    channel ORA_DISK_1: specifying datafile(s) in backup set
    input datafile file number=00010 name=/oracle/u01/app/oracle/oradata/cqdb/CQ1_PTR_TBSP
    input datafile file number=00002 name=/oracle/u01/app/oracle/oradata/cqdb/sysaux01.dbf
    input datafile file number=00001 name=/oracle/u01/app/oracle/oradata/cqdb/system01.dbf
    input datafile file number=00025 name=/oracle/u01/app/oracle/oradata/cqdb/CTCPPR
    input datafile file number=00030 name=/oracle/u01/app/oracle/oradata/cqdb/CPM_REPOSITORY_TBSP
    input datafile file number=00003 name=/oracle/u01/app/oracle/oradata/cqdb/undotbs01.dbf
    input datafile file number=00005 name=/oracle/u01/app/oracle/oradata/cqdb/CQ_REPOSITORY_TBSP
    input datafile file number=00012 name=/oracle/u01/app/oracle/oradata/cqdb/CQ1_PR_TBSP
    input datafile file number=00018 name=/oracle/u01/app/oracle/oradata/cqdb/CQ1_CTIA_BCR_TBSP
    input datafile file number=00006 name=/oracle/u01/app/oracle/oradata/cqdb/CQ_USER_TBSP
    input datafile file number=00007 name=/oracle/u01/app/oracle/oradata/cqdb/CQ_TEST_TBSP
    input datafile file number=00008 name=/oracle/u01/app/oracle/oradata/cqdb/CQ_TEST1_TBSP
    input datafile file number=00009 name=/oracle/u01/app/oracle/oradata/cqdb/CQ_TEST2_TBSP
    input datafile file number=00011 name=/oracle/u01/app/oracle/oradata/cqdb/CQ1_AI_TBSP
    input datafile file number=00013 name=/oracle/u01/app/oracle/oradata/cqdb/CQ1_PM_TBSP
    input datafile file number=00014 name=/oracle/u01/app/oracle/oradata/cqdb/CQ1_AW_TBSP
    input datafile file number=00015 name=/oracle/u01/app/oracle/oradata/cqdb/CQ1_FCS_TBSP
    input datafile file number=00016 name=/oracle/u01/app/oracle/oradata/cqdb/CQ1_FCSPTR
    input datafile file number=00017 name=/oracle/u01/app/oracle/oradata/cqdb/CQ1_FCSPR
    input datafile file number=00019 name=/oracle/u01/app/oracle/oradata/cqdb/CQ1_FCS_BCR_TBSP
    input datafile file number=00020 name=/oracle/u01/app/oracle/oradata/cqdb/CQ1_SP
    input datafile file number=00021 name=/oracle/u01/app/oracle/oradata/cqdb/CQ1_LMSTS_TBSP
    input datafile file number=00022 name=/oracle/u01/app/oracle/oradata/cqdb/CQ1_FCS_PTR_TBSP
    input datafile file number=00023 name=/oracle/u01/app/oracle/oradata/cqdb/CTS_TBSP
    input datafile file number=00024 name=/oracle/u01/app/oracle/oradata/cqdb/CQSCHEMA
    input datafile file number=00026 name=/oracle/u01/app/oracle/oradata/cqdb/ts_duke_data_1_TBSP
    input datafile file number=00027 name=/oracle/u01/app/oracle/oradata/cqdb/ts_duke_index_1_TBSP
    input datafile file number=00028 name=/oracle/u01/app/oracle/oradata/cqdb/ts_castle_data_1_TBSP
    input datafile file number=00029 name=/oracle/u01/app/oracle/oradata/cqdb/ts_gdtest_data_TBSP
    input datafile file number=00004 name=/oracle/u01/app/oracle/oradata/cqdb/users01.dbf
    channel ORA_DISK_1: starting piece 1 at 07-FEB-12
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of backup plus archivelog command at 02/07/2012 11:02:50
    ORA-19809: limit exceeded for recovery files
    ORA-19804: cannot reclaim 52428800 bytes disk space from 4294967296 limit
    Can anyone tell from any of the info above what I did wrong or why I couldn't backup this database with RMAN?
    Attached Files Attached Files

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    RMAN is trying to write the backup files to the flash recovery destination and there is not enough space.

    I recommend you change the location of the backups to another disk, to do that, connect to rman and configure this location -- an example would be:

    Code:
    RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
    RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backupdata/oracle/rman/cqdb/%d_%T_%s_%u';
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Oct 2010
    Location
    Orlando, FL
    Posts
    311
    Provided Answers: 1
    I just allocated more space to the Flash Recovery Area (FRA):

    Code:
    alter system set db_recovery_file_dest_size=50g scope=both;

Posting Permissions

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