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.