RMAN-03002 RMAN-06091 error Solution

Source: Internet
Author: User
Tags file copy

The customer has reported this error since using nbu. Because it has always been normal. So we stopped the nbu backup at night. Use the previous script separately. The error message is the same. Therefore, I doubt whether it is a script problem.
The reason for querying the online analysis is as follows:

Symptoms
When attempting to delete obsolete backups from RMAN using the following command:

RMAN> delete obsolete;

The following error occurs:

RMAN-00571: ========================================================== ==============================
RMAN-00569: ==================== error message stack follows ==========================
RMAN-00571: ========================================================== ==============================
RMAN-03002: failure of delete command at 22:04:21
RMAN-06091: no channel allocated for maintenance (of an appropriate type)

.


Cause
Tape channel had not being allocated when attempt to delete obsolete backup on tape.


Using the following command to verify that there are backup sets on tape.


RMAN> list backup;
List of Backup Sets
==============================

BS Key Type LV Size Device Type Elapsed Time Completion Time
-------------------------------------------------------------
1 Incr 0 113.25 M SBT_TAPE 00:08:35 01-MAR-08
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: HOT_DB_BK_LEVEL0
Handle: bk_4_rj648250152 Media:
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name
---------------------------------
5 0 Incr 1342657 01-MAR-08/u01/Oracle/app/oracle/oradata/test/undotbs2
75 0 Incr 1342657 01-MAR-08/u01/oracle/app/oracle/oradata/test/USER_DAT_08_vg3_002
91 0 Incr 1342657 01-MAR-08/u01/oracle/app/oracle/oradata/test/USER_DAT_12_vg3_002

==> The Device Type is SBT_TAPE.

Solution
To implement the solution, please execute the following steps:

Please run the following commands to delete obsolete backup sets on both disk and tape:

RMAN> allocate channel for maintenance type disk;
RMAN> allocate channel for maintenance device type 'sbt _ tape 'parms '...';
==> Please change '...' to your actual tape params
RMAN> delete obsolete;


If you want to delete obsolete backup sets on disk, you can use the following commands:
RMAN> allocate channel for maintenance type disk;
RMAN> delete obsolete device type disk ;,

It is quite clear that there is no maintenance channel allocated.

I only modified the statements in rman_backup.sh.
# Delete noprompt obsolete;
# Allocate channel c1 type disk;
Change the preceding statement to the following one.
Allocate channel for maintenance type disk; # this is add by yt 2012 2 21
Delete obsolete device type disk; # this is add by yt 2012 2 21

 

I tried to execute these two sentences separately:

RMAN> allocate channel for maintenance type disk;

Allocated channel: ORA_MAINT_DISK_2
Channel ORA_MAINT_DISK_2: sid = 736 instance = cmsxty1 devtype = DISK

RMAN> delete noprompt obsolete device type 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
----------------------------------------------------------------
Control File Copy 1 01-JAN-12/backup/1101/standby01.ctl

RMAN-06207: WARNING: 1 objects cocould 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: Datafile Copy/backup/1101/standby01.ctl

I am prompted that a backup cannot be found and cannot be deleted.

Continue to execute the following statement

RMAN> delete force noprompt obsolete device type disk;

Deleted successfully.

I saw less force. I have to study the role of force here.

The script is changed as follows. The backup is normal.

Run {
Allocate channel c1 type disk;
Backup database include current controlfile format '/backup/rman_cmsxty_full _ % s _ % T. bak ';
SQL 'alter system archive log current ';
Backup archivelog all delete input format '/backup/rman_cmsxty_arc _ % s _ % T. bak ';
Backup current controlfile format '/backup/rman_cmsxty_ctl _ % s _ % T. bak ';
Release channel c1;
}
Report obsolete;
Crosscheck archivelog all;
Crosscheck backup;
Allocate channel for maintenance type disk;
Delete force noprompt obsolete device type disk;
EOF

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.