17 Haziran 2012 Pazar

Exhausted space of FRA


I  had recovered my database prior article.  First job  will do after   especially Database have been recovered through Point In Time Recovery (PITR)  take clean a full backup.
Ok I’m connecting to RMAN  now. And I’m trying  take a  the Whole backup.

RMAN> backup  incremental  level 0 database plus archivelog ;
Starting backup at 13-JUN-12
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=75 device type=DISK
archived log +XFRA/xdb/archivelog/2012_01_31/thread_1_seq_20.260.774009069 not found or out of sync with catalog
trying alternate file for archived log of thread 1 with sequence 20
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=19 RECID=23 STAMP=774385020
input archived log thread=1 sequence=20 RECID=24 STAMP=774385020
input archived log thread=1 sequence=21 RECID=25 STAMP=774385026
channel ORA_DISK_1: starting piece 1 at 13-JUN-12
channel ORA_DISK_1: finished piece 1 at 13-JUN-12
piece handle=+XFRA/xdb/backupset/2012_06_13/annnf0_tag20120613t172937_0.270.785870979 tag=TAG20120613T172937 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08
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=1 RECID=26 STAMP=774402257
input archived log thread=1 sequence=2 RECID=27 STAMP=774402273
input archived log thread=1 sequence=3 RECID=28 STAMP=774402285
input archived log thread=1 sequence=4 RECID=29 STAMP=774485129
input archived log thread=1 sequence=5 RECID=30 STAMP=774986496
input archived log thread=1 sequence=6 RECID=31 STAMP=774986847
input archived log thread=1 sequence=7 RECID=32 STAMP=775694209
input archived log thread=1 sequence=8 RECID=33 STAMP=776307636
input archived log thread=1 sequence=9 RECID=34 STAMP=777764646
input archived log thread=1 sequence=10 RECID=35 STAMP=777766030
input archived log thread=1 sequence=11 RECID=36 STAMP=778189286
input archived log thread=1 sequence=12 RECID=37 STAMP=778194862
input archived log thread=1 sequence=13 RECID=38 STAMP=778195606
input archived log thread=1 sequence=14 RECID=39 STAMP=778196078
input archived log thread=1 sequence=15 RECID=40 STAMP=778788265
input archived log thread=1 sequence=16 RECID=41 STAMP=778810018
input archived log thread=1 sequence=17 RECID=42 STAMP=779829506
input archived log thread=1 sequence=18 RECID=43 STAMP=780101654
input archived log thread=1 sequence=19 RECID=44 STAMP=780105657
input archived log thread=1 sequence=20 RECID=45 STAMP=782004447
channel ORA_DISK_1: starting piece 1 at 13-JUN-12
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 06/13/2012 17:29:55
ORA-19504: "+XFRA" dosyas? yarat?lamad?
ORA-17502: ksfdcre:4 Dosya +XFRA yarat?lam?yor
ORA-15041: diskgroup "XFRA" space exhausted

Problem solving:
DELETE OBSOLETE:
Our FRA space exausted due to old backups . We’ll  connect to RMAN to regain the space available .
 To destruction of old backups using command.
RMAN> delete  obsolete ;
using target database control file instead of recovery catalog
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=12 device type=DISK
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           7      31-JAN-12
  Backup Piece       7      31-JAN-12          /u01/app/oracle/product/11.2.0/dbhome_1/dbs/08n24r8b_1_1
Archive Log          19     31-JAN-12          +XFRA/xdb/archivelog/2012_01_31/thread_1_seq_20.260.774009069
Backup Set           8      31-JAN-12
  Backup Piece       8      31-JAN-12          +XFRA/xdb/autobackup/2012_01_31/s_774008306.265.774008309
Datafile Copy        1      04-FEB-12          /u01/app/oracle/oradata/*.dbf
Backup Set           9      31-JAN-12
  Backup Piece       9      31-JAN-12          +XFRA/xdb/backupset/2012_01_31/annnf0_tag20120131t103219_0.259.779141
Datafile Copy        2      04-FEB-12          /u01/app/oracle/oradata/XDB/datafiles
Datafile Copy        17     04-FEB-12          +XDATA/xdb/datafile/undotbs1.258.751571183
Datafile Copy        18     04-FEB-12          +XDATA/xdb/datafile/users.259.751571183
Datafile Copy        16     04-FEB-12          +XDATA/xdb/datafile/sysaux.257.751571183
Datafile Copy        15     04-FEB-12          +XDATA/xdb/datafile/system.256.751571183
Archive Log          23     04-FEB-12          +XFRA/xdb/archivelog/2012_02_04/thread_1_seq_19.267.774385021
Archive Log          24     04-FEB-12          +XFRA/xdb/archivelog/2012_02_04/thread_1_seq_20.268.774385021
Archive Log          25     04-FEB-12          +XFRA/xdb/archivelog/2012_02_04/thread_1_seq_21.269.774385021
Backup Set           10     04-FEB-12
  Backup Piece       10     04-FEB-12          +XFRA/xdb/autobackup/2012_02_04/s_774385090.273.774385099
Backup Set           11     04-FEB-12
  Backup Piece       11     04-FEB-12          +XFRA/xdb/autobackup/2012_02_04/s_774387232.274.774387255
Backup Set           13     04-FEB-12
  Backup Piece       13     04-FEB-12          +XFRA/xdb/autobackup/2012_02_04/s_774401567.276.774401569
Backup Set           14     05-FEB-12
  Backup Piece       14     05-FEB-12          +XFRA/xdb/autobackup/2012_02_05/s_774403732.280.774403735
Backup Set           15     19-FEB-12
  Backup Piece       15     19-FEB-12          +XFRA/xdb/autobackup/2012_02_19/s_775695397.285.775695399
Backup Set           16     20-FEB-12
  Backup Piece       16     20-FEB-12          +XFRA/xdb/autobackup/2012_02_20/s_775701108.286.775701109
Backup Set           17     23-FEB-12
  Backup Piece       17     23-FEB-12          +XFRA/xdb/autobackup/2012_02_23/s_776024388.287.776024391
Backup Set           18     24-MAR-12
  Backup Piece       18     24-MAR-12          +XFRA/xdb/autobackup/2012_03_24/s_778803339.266.778803349
Backup Set           19     05-APR-12
  Backup Piece       19     05-APR-12          +XFRA/xdb/autobackup/2012_04_05/s_779828662.264.779828679
Backup Set           20     05-APR-12
  Backup Piece       20     05-APR-12          +XFRA/xdb/autobackup/2012_04_05/s_779836493.263.779836499
Backup Set           21     30-APR-12
  Backup Piece       21     30-APR-12          +XFRA/xdb/autobackup/2012_04_30/s_782005304.262.782005307
Backup Set           22     01-MAY-12
  Backup Piece       22     01-MAY-12          +XFRA/xdb/autobackup/2012_05_01/s_782093507.299.782093509
Backup Set           24     13-JUN-12
  Backup Piece       24     13-JUN-12          +XFRA/xdb/backupset/2012_06_13/annnf0_tag20120613t172937_0.270.780979

Do you really want to delete the above objects (enter YES or NO)? Y
deleted backup piece
backup piece handle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/08n24r8b_1_1 RECID=7 STAMP=774008076
deleted backup piece
backup piece handle=+XFRA/xdb/autobackup/2012_01_31/s_774008306.265.774008309 RECID=8 STAMP=774008308
deleted backup piece
backup piece handle=+XFRA/xdb/backupset/2012_01_31/annnf0_tag20120131t103219_0.259.774009141 RECID=9 STAMP=774000
deleted datafile copy
datafile copy file name=+XDATA/xdb/datafile/undotbs1.258.751571183 RECID=17 STAMP=774384337
deleted datafile copy
datafile copy file name=+XDATA/xdb/datafile/users.259.751571183 RECID=18 STAMP=774384337
deleted datafile copy
datafile copy file name=+XDATA/xdb/datafile/sysaux.257.751571183 RECID=16 STAMP=774384337
deleted datafile copy
datafile copy file name=+XDATA/xdb/datafile/system.256.751571183 RECID=15 STAMP=774384337
deleted archived log
archived log file name=+XFRA/xdb/archivelog/2012_02_04/thread_1_seq_19.267.774385021 RECID=23 STAMP=774385020
deleted archived log
archived log file name=+XFRA/xdb/archivelog/2012_02_04/thread_1_seq_20.268.774385021 RECID=24 STAMP=774385020
deleted archived log
archived log file name=+XFRA/xdb/archivelog/2012_02_04/thread_1_seq_21.269.774385021 RECID=25 STAMP=774385026
deleted backup piece
backup piece handle=+XFRA/xdb/autobackup/2012_02_04/s_774385090.273.774385099 RECID=10 STAMP=774385097
deleted backup piece
backup piece handle=+XFRA/xdb/autobackup/2012_02_04/s_774387232.274.774387255 RECID=11 STAMP=774387254
deleted backup piece
backup piece handle=+XFRA/xdb/autobackup/2012_02_04/s_774401567.276.774401569 RECID=13 STAMP=774401569
deleted backup piece
backup piece handle=+XFRA/xdb/autobackup/2012_02_05/s_774403732.280.774403735 RECID=14 STAMP=774403734
deleted backup piece
backup piece handle=+XFRA/xdb/autobackup/2012_02_19/s_775695397.285.775695399 RECID=15 STAMP=775695399
deleted backup piece
backup piece handle=+XFRA/xdb/autobackup/2012_02_20/s_775701108.286.775701109 RECID=16 STAMP=775701109
deleted backup piece
backup piece handle=+XFRA/xdb/autobackup/2012_02_23/s_776024388.287.776024391 RECID=17 STAMP=776024390
deleted backup piece
backup piece handle=+XFRA/xdb/autobackup/2012_03_24/s_778803339.266.778803349 RECID=18 STAMP=778803348
deleted backup piece
backup piece handle=+XFRA/xdb/autobackup/2012_04_05/s_779828662.264.779828679 RECID=19 STAMP=779828679
deleted backup piece
backup piece handle=+XFRA/xdb/autobackup/2012_04_05/s_779836493.263.779836499 RECID=20 STAMP=779836499
deleted backup piece
backup piece handle=+XFRA/xdb/autobackup/2012_04_30/s_782005304.262.782005307 RECID=21 STAMP=782005306
deleted backup piece
backup piece handle=+XFRA/xdb/autobackup/2012_05_01/s_782093507.299.782093509 RECID=22 STAMP=782093509
deleted backup piece
backup piece handle=+XFRA/xdb/backupset/2012_06_13/annnf0_tag20120613t172937_0.270.785870979 RECID=24 STAMP=785878
Deleted 23 objects
RMAN-06207: WARNING: 3 objects could not be deleted for DISK channel(s) due
RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212:   Object Type   Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Archivelog      +XFRA/xdb/archivelog/2012_01_31/thread_1_seq_20.260.774009069
RMAN-06214: Datafile Copy   /u01/app/oracle/oradata/*.dbf
RMAN-06214: Datafile Copy   /u01/app/oracle/oradata/XDB/datafiles

RMAN> crosscheck backup
using channel ORA_DISK_1
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+XFRA/xdb/backupset/2012_02_04/nnndn0_tag20120204t232950_0.275.774401393 RECID=12 STAMP=774492
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+XFRA/xdb/autobackup/2012_06_13/s_785870392.272.785870397 RECID=23 STAMP=785870397
Crosschecked 2 objects 
2. If you have got  more space capacity  then you try increment   size of the FRA.
SQL> show parameter db_recover_
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +XFRA
db_recovery_file_dest_size           big integer 5G
SQL> alter system set db_recovery_file_dest_size=7G scope=both;
System altered.
SQL>exit
Oracle@mhm~>RMAN TARGET /
you can  simply take full backup of a database following below command.
RMAN>backup database;
Starting backup at 13-JUN-12
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=75 device type=DISK
archived log +XFRA/xdb/archivelog/2012_01_31/thread_1_seq_20.260.774009069 not found or out of sync with catalog
trying alternate file for archived log of thread 1 with sequence 20
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=19 RECID=23 STAMP=774385020
input archived log thread=1 sequence=20 RECID=24 STAMP=774385020
input archived log thread=1 sequence=21 RECID=25 STAMP=774385026
channel ORA_DISK_1: starting piece 1 at 13-JUN-12
channel ORA_DISK_1: finished piece 1 at 13-JUN-12
piece handle=+XFRA/xdb/backupset/2012_06_13/annnf0_tag20120613t172937_0.270.785870979 tag=TAG20120613T172937 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08
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=1 RECID=26 STAMP=774402257
input archived log thread=1 sequence=2 RECID=27 STAMP=774402273
input archived log thread=1 sequence=3 RECID=28 STAMP=774402285
input archived log thread=1 sequence=4 RECID=29 STAMP=774485129
input archived log thread=1 sequence=5 RECID=30 STAMP=774986496
input archived log thread=1 sequence=6 RECID=31 STAMP=774986847
input archived log thread=1 sequence=7 RECID=32 STAMP=775694209
input archived log thread=1 sequence=8 RECID=33 STAMP=776307636
input archived log thread=1 sequence=9 RECID=34 STAMP=777764646
input archived log thread=1 sequence=10 RECID=35 STAMP=777766030
input archived log thread=1 sequence=11 RECID=36 STAMP=778189286
input archived log thread=1 sequence=12 RECID=37 STAMP=778194862
input archived log thread=1 sequence=13 RECID=38 STAMP=778195606
input archived log thread=1 sequence=14 RECID=39 STAMP=778196078
input archived log thread=1 sequence=15 RECID=40 STAMP=778788265
input archived log thread=1 sequence=16 RECID=41 STAMP=778810018
input archived log thread=1 sequence=17 RECID=42 STAMP=779829506
input archived log thread=1 sequence=18 RECID=43 STAMP=780101654
input archived log thread=1 sequence=19 RECID=44 STAMP=780105657
input archived log thread=1 sequence=20 RECID=45 STAMP=782004447
channel ORA_DISK_1: starting piece 1 at 13-JUN-12
finished.

0 yorum:

Yorum Gönder