Home   |   Register   |   Rules   |   Calendar   |   Get Daily   |     |  
 


If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Oracle > Rman Disk Space Error

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-07-12, 11:29
CarlosinFL CarlosinFL is offline
Registered User
  
Join Date: Oct 2010
Location: Orlando, FL
Posts: 184
Question 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
File Type: txt archivelog_mode.txt (1.5 KB, 1 views)
File Type: txt rman_error.txt (5.7 KB, 1 views)
Reply With Quote
  #2 (permalink)  
Old 02-07-12, 15:28
LKBrwn_DBA LKBrwn_DBA is offline
Registered User
  
Join Date: Jun 2003
Location: West Palm Beach, FL
Posts: 2,456
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
Reply With Quote
  #3 (permalink)  
Old 02-07-12, 15:32
CarlosinFL CarlosinFL is offline
Registered User
  
Join Date: Oct 2010
Location: Orlando, FL
Posts: 184
I just allocated more space to the Flash Recovery Area (FRA):

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

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


 
 
 
Home  |   Register  |   Get New  |   FAQ's  |   Sitemap

Powered by vBulletin
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.