Shulou(Shulou.com)06/01 Report--

AIX platform Oracle 10G, today found that the database archive space is full, after the crosscheck, execute delete force obsolete times no channel allocated for maintenance(of an appropriate type) error,

Cause analysis: After inquiry, it may be that expired backups cannot be deleted normally because backups of different device types were used in the previous backup process

Solution:

Let's start with a description of CROSSCHECK.

When archivelog or backup has been manually deleted, crossscheck needs to be run. This command ensures that the data recorded in the recovery catalog or control file matches the files on the hard disk.

CROSSCHEK will mark the status of the missing file as EXPIRED. Then, you can delete the related records in the rman repository and the files on the hard disk by running Delete EXPIRED.

If some files are incorrectly marked as EXPIRED, running CROSSCHECK BACKUP again resets them to AVAILABLE when the files are confirmed to exist.

That is, for files that no longer exist on the hard disk, delete EXPIRED to delete the relevant records in RMAN. For backups that have exceeded the retention policy, delete from hard disks and tape devices with Delete OBSOLETE, and delete records from RMAN.

performing the

Crosscheck backup;

Crossscheck backuppiece;

Crosscheck archivelog all;

Delete obsolet; UNIT-06091: no channel allocated for maintenance (of an appropriate type)

After a bit of research, some of the previous backups were directly backed up on hard disk, and some were backed up on tape via DP. This error occurs because there is data on the tape, but no channel for the tape type is requested.

RMAN> allocate channel for maintenance type disk;

allocated channel: ORA_MAINT_DISK_6

channel ORA_MAINT_DISK_6: sid=137 devtype=DISK

RMAN> delete expired archivelog all;

specification does not match any archive log in the recovery catalog

This should be normal, no expired log found.

RMAN> delete obsolete;

RMAN retention policy will be applied to the command

RMAN retention policy is set to redundancy 1

Deleting the following obsolete backups and copies:

Type Key Completion Time Filename/Handle

-------------------- ------ ------------------ --------------------

Backup Set 2499 2011-11-24 11:39:28

Backup Piece 2511 2011-11-24 11:39:28 swt-oracle-full.dbf

…

Backup Set 2564 2011-11-26 21:18:57

Backup Piece 2567 2011-11-26 21:18:57 /backup/arc0dmsld1e

…

Backup Set 2950 2011-12-14 14:45:40

Backup Piece 2955 2011-12-14 14:45:40 /u01/oracle/flash_recovery_area/GZ/backupset/2011_12_14/o1_mf_annnn_TAG20111214T144526_7gjkjly0_.bkp

…

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of delete command at 12/15/2011 17:05:42

RMAN-06091: no channel allocated for maintenance (of an appropriate type)

Something's wrong here.

The solution is to delete the expired backup data on the hard disk and tape separately.

RMAN>delete obsolete device type disk;--Specifies the device type so that data from the specified device can be deleted

Delete expired backups on hard disk

RMAN retention policy will be applied to the command

RMAN retention policy is set to redundancy 1

Deleting the following obsolete backups and copies:

Type Key Completion Time Filename/Handle

-------------------- ------ ------------------ --------------------

Backup Set 2509 2011-11-24 14:28:32

Backup Piece 2521 2011-11-24 14:28:32 /backup/sp

Backup Set 2564 2011-11-26 21:18:57

Backup Piece 2567 2011-11-26 21:18:57 /backup/arc0dmsld1e

Backup Set 2565 2011-11-26 21:19:20

Backup Piece 2568 2011-11-26 21:19:20 /backup/arc0emsld29

Control File Copy 2709 2011-11-26 21:42:33 /var/opt/omni/tmp/ctrl_gz.dbf

Backup Set 2885 2011-11-27 20:44:15

Backup Piece 2888 2011-11-27 20:44:15 /backup/db_full_31.1

Control File Copy 2898 2011-11-27 20:43:57 /backup/bj.ctl

Backup Set 2886 2011-11-27 20:44:21

Backup Piece 2889 2011-11-27 20:44:21 /backup/db_full_32.1

Backup Set 2950 2011-12-14 14:45:40

Backup Piece 2955 2011-12-14 14:45:40 /u01/oracle/flash_recovery_area/GZ/backupset/2011_12_14/o1_mf_annnn_TAG20111214T144526_7gjkjly0_.bkp

Backup Set 2951 2011-12-14 14:45:46

…

Do you really want to delete the above objects (enter YES or NO)? YES

deleted backup piece

backup piece handle=/backup/db_full_31.1 recid=31 stamp=768343384

deleted control file copy

control file copy filename=/backup/bj.ctl recid=4 stamp=768343437

deleted backup piece

backup piece handle=/backup/db_full_32.1 recid=32 stamp=768343461

deleted backup piece

backup piece handle=/u01/oracle/flash_recovery_area/GZ/backupset/2011_12_14/o1_mf_annnn_TAG20111214T144526_7gjkjly0_.bkp recid=38 stamp=769877137

deleted backup piece

…

Deleted 17 objects

deleted backup piece

backup piece handle=/backup/sp recid=11 stamp=768061712

deleted backup piece

backup piece handle=/backup/arc0dmsld1e recid=13 stamp=768259119

deleted backup piece

backup piece handle=/backup/arc0emsld29 recid=14 stamp=768259146

Deleted 3 objects

It worked.

RMAN> allocate channel for maintenance device type 'sbt_tape' PARMS 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=gz,OB2BARLIST=swt-oracle-full)';

Here the parameters after PARMS are the same as those in the RMAN script at backup time

allocated channel: ORA_MAINT_SBT_TAPE_7

channel ORA_MAINT_SBT_TAPE_7: sid=136 devtype=SBT_TAPE

channel ORA_MAINT_SBT_TAPE_7: Data Protector A.06.11/243

RMAN> delete obsolete;

RMAN retention policy will be applied to the command

RMAN retention policy is set to redundancy 1

Deleting the following obsolete backups and copies:

Type Key Completion Time Filename/Handle

-------------------- ------ ------------------ --------------------

Backup Set 2499 2011-11-24 11:39:28

Backup Piece 2511 2011-11-24 11:39:28 swt-oracle-full.dbf

…

Do you really want to delete the above objects (enter YES or NO)? yes

deleted backup piece

backup piece handle=swt-oracle-full.dbf recid=1 stamp=768051562

…

Deleted 26 objects

And that's it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.