OraFAQ Forum: Backup & Recovery » Error in rman backup

Home » RDBMS Server » Backup & Recovery » Error in rman backup (Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error in rman backup [message #562414]

Wed, 01 August 2012 07:11

indrajit2002
Messages: 53
Registered: November 2007
Location: INDIA

Member

Hi,
While running rman backup job we got the following error at last stage.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of release command at 07/06/2012 02:36:32
RMAN-06012: channel: C2 not allocated

My doubt is whether the backup is complete properly. Also received the same error while running the command BACKUP ARCHIVELOG ALL DELETE INPUT;

As per my knowlwdge that if there is any error in rman then the entire operation failes. Please suggest..

Report message to a moderator

Re: Error in rman backup [message #562425 is a reply to message #562414]

Wed, 01 August 2012 07:42

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

RMAN-06012: channel: %s not allocated
 *Cause:  A RELEASE command was found for a channel identifier
          that was not yet allocated.
 *Action: Correct the channel identifier, or add an ALLOCATE CHANNEL
          command.

Regards
Michel

Report message to a moderator

Re: Error in rman backup [message #562445 is a reply to message #562425]

Wed, 01 August 2012 08:14

indrajit2002
Messages: 53
Registered: November 2007
Location: INDIA

Member

But c2 channel was allocated. Below is the excerpt of the script..

ALLOCATE CHANNEL c1 DEVICE TYPE SBT_TAPE PARMS 'ENV=(NB_ORA_SERV=masterhp003.XXX.com,NB_ORA_SCHED=incr,NB_ORA_P
OLICY=ora_pdlk_pdlk),BLKSIZE=524288'; ALLOCATE CHANNEL c2 DEVICE TYPE SBT_TAPE PARMS 'ENV=(NB_ORA_SERV=masterhp003.XXX.com,NB_ORA_SCHED=incr,NB_ORA_POLICY=ora_p
dlk_pdlk),BLKSIZE=524288';

Also did the backup occur using other channels ? Also got the below message in the log..

channel c1 disabled, job failed on it will be run on another channel

[Updated on: Wed, 01 August 2012 08:31] by Moderator

Report message to a moderator

Re: Error in rman backup [message #562446 is a reply to message #562445]

Wed, 01 August 2012 08:19

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

But c2 channel was allocated. Below is the excerpt of the script

If you say so but Oracle disagrees and as you don't post (that copy and paste) what you did and got I tend to trust Oracle over you.

Regards
Michel

Report message to a moderator

Re: Error in rman backup [message #562448 is a reply to message #562445]

Wed, 01 August 2012 08:25

John Watson
Messages: 8968
Registered: January 2010
Location: Global Village

Senior Member

Hey, Indrajit, it looks very much as though you are on contract to XXX, you might want to be a bit careful about telling the world that their backups have failed.

--
update: I've removed the identifying information

[Updated on: Wed, 01 August 2012 08:33]

Report message to a moderator

Re: Error in rman backup [message #562451 is a reply to message #562446]

Wed, 01 August 2012 09:01

indrajit2002
Messages: 53
Registered: November 2007
Location: INDIA

Member

Hi Michel,
Below is the script that we used.

rmanp_dedupe/dedupe98@ent_rmanp
RUN
{
SQL 'alter system archive log current';
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
ALLOCATE CHANNEL c1 DEVICE TYPE SBT_TAPE PARMS 'ENV=(NB_ORA_SERV=masterhp003.thehartford.com,NB_ORA_SCHED=full,NB_ORA_POLICY=ora_tabarchp01_tabarchp),BLKSIZE=524288';
ALLOCATE CHANNEL c2 DEVICE TYPE SBT_TAPE PARMS 'ENV=(NB_ORA_SERV=masterhp003.thehartford.com,NB_ORA_SCHED=full,NB_ORA_POLICY=ora_tabarchp01_tabarchp),BLKSIZE=524288';
ALLOCATE CHANNEL c3 DEVICE TYPE SBT_TAPE PARMS 'ENV=(NB_ORA_SERV=masterhp003.thehartford.com,NB_ORA_SCHED=full,NB_ORA_POLICY=ora_tabarchp01_tabarchp),BLKSIZE=524288';
ALLOCATE CHANNEL c4 DEVICE TYPE SBT_TAPE PARMS 'ENV=(NB_ORA_SERV=masterhp003.thehartford.com,NB_ORA_SCHED=full,NB_ORA_POLICY=ora_tabarchp01_tabarchp),BLKSIZE=524288';
ALLOCATE CHANNEL c5 DEVICE TYPE SBT_TAPE PARMS 'ENV=(NB_ORA_SERV=masterhp003.thehartford.com,NB_ORA_SCHED=full,NB_ORA_POLICY=ora_tabarchp01_tabarchp),BLKSIZE=524288';
ALLOCATE CHANNEL c6 DEVICE TYPE SBT_TAPE PARMS 'ENV=(NB_ORA_SERV=masterhp003.thehartford.com,NB_ORA_SCHED=full,NB_ORA_POLICY=ora_tabarchp01_tabarchp),BLKSIZE=524288';
CONFIGURE BACKUP OPTIMIZATION OFF;
BACKUP section size 200G INCREMENTAL LEVEL 0 SKIP INACCESSIBLE TAG tabarchp_LEVEL0_190_22 FILESPERSET 1 FORMAT '%d_DB_%s_%p_%t' DATABASE;
SQL 'alter system archive log current';
BACKUP FILESPERSET 20 FORMAT '%d_AL_%s_%t' ARCHIVELOG ALL;
SQL 'alter database backup controlfile to trace';
DELETE NOPROMPT ARCHIVELOG ALL BACKED UP 1 TIMES TO DEVICE TYPE SBT_TAPE;
RELEASE CHANNEL c1;
RELEASE CHANNEL c2;
RELEASE CHANNEL c3;
RELEASE CHANNEL c4;
RELEASE CHANNEL c5;
RELEASE CHANNEL c6;
}

Report message to a moderator

Re: Error in rman backup [message #562452 is a reply to message #562446]

Wed, 01 August 2012 09:02

indrajit2002
Messages: 53
Registered: November 2007
Location: INDIA

Member

Here is the excerpt of the log:-

List of Archived Log Copies for database with db_unique_name TABARCHP

=====================================================================

Key Thrd Seq S Low Time

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

3871337 1 26712 A 07-JUL-12

Name: /jxj_tabarchp/fra/TABARCHP/archivelog/2012_07_08/o1_mf_1_26712_7zl5rbhk_.arc

3871338 1 26713 A 08-JUL-12

Name: /jxj_tabarchp/fra/TABARCHP/archivelog/2012_07_08/o1_mf_1_26713_7zlj7lrp_.arc

3871339 1 26714 A 08-JUL-12

Name: /jxj_tabarchp/fra/TABARCHP/archivelog/2012_07_08/o1_mf_1_26714_7zm1t3v5_.arc

3871340 1 26715 A 08-JUL-12

Name: /jxj_tabarchp/fra/TABARCHP/archivelog/2012_07_08/o1_mf_1_26715_7zmp6lvn_.arc

3871341 1 26716 A 08-JUL-12

Name: /jxj_tabarchp/fra/TABARCHP/archivelog/2012_07_08/o1_mf_1_26716_7zn8hmz2_.arc

3871362 1 26717 A 08-JUL-12

Name: /jxj_tabarchp/fra/TABARCHP/archivelog/2012_07_08/o1_mf_1_26717_7zngwxl9_.arc

3903452 1 26718 A 08-JUL-12

Name: /jxj_tabarchp/fra/TABARCHP/archivelog/2012_07_09/o1_mf_1_26718_7znt5st8_.arc

3903517 1 26719 A 09-JUL-12

Name: /jxj_tabarchp/fra/TABARCHP/archivelog/2012_07_09/o1_mf_1_26719_7znyy1pg_.arc

3903524 1 26720 A 09-JUL-12

Name: /jxj_tabarchp/fra/TABARCHP/archivelog/2012_07_09/o1_mf_1_26720_7znyy375_.arc

deleted archived log

archived log file name=/jxj_tabarchp/fra/TABARCHP/archivelog/2012_07_08/o1_mf_1_26712_7zl5rbhk_.arc RECID=702 STAMP=788058826

deleted archived log

archived log file name=/jxj_tabarchp/fra/TABARCHP/archivelog/2012_07_08/o1_mf_1_26713_7zlj7lrp_.arc RECID=703 STAMP=788069555

deleted archived log

archived log file name=/jxj_tabarchp/fra/TABARCHP/archivelog/2012_07_08/o1_mf_1_26714_7zm1t3v5_.arc RECID=704 STAMP=788087556

deleted archived log

archived log file name=/jxj_tabarchp/fra/TABARCHP/archivelog/2012_07_08/o1_mf_1_26715_7zmp6lvn_.arc RECID=705 STAMP=788108435

deleted archived log

archived log file name=/jxj_tabarchp/fra/TABARCHP/archivelog/2012_07_08/o1_mf_1_26716_7zn8hmz2_.arc RECID=706 STAMP=788127156

deleted archived log

archived log file name=/jxj_tabarchp/fra/TABARCHP/archivelog/2012_07_08/o1_mf_1_26717_7zngwxl9_.arc RECID=707 STAMP=788133725

deleted archived log

archived log file name=/jxj_tabarchp/fra/TABARCHP/archivelog/2012_07_09/o1_mf_1_26718_7znt5st8_.arc RECID=708 STAMP=788145274

deleted archived log

archived log file name=/jxj_tabarchp/fra/TABARCHP/archivelog/2012_07_09/o1_mf_1_26719_7znyy1pg_.arc RECID=709 STAMP=788150146

deleted archived log

archived log file name=/jxj_tabarchp/fra/TABARCHP/archivelog/2012_07_09/o1_mf_1_26720_7znyy375_.arc RECID=710 STAMP=788150147

Deleted 9 objects

released channel: c1

released channel: c2

released channel: c3

released channel: c4

released channel: c5

released channel: c6

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

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

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

RMAN-03002: failure of release command at 07/09/2012 02:36:18

RMAN-06012: channel: c1 not allocated

Report message to a moderator

Re: Error in rman backup [message #562462 is a reply to message #562452]

Wed, 01 August 2012 10:08

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I have a workaround: do not release any channel, Oracle will do it anyway at the end of the script.

Regards
Michel

Report message to a moderator

Re: Error in rman backup [message #562486 is a reply to message #562462]

Wed, 01 August 2012 11:40

indrajit2002
Messages: 53
Registered: November 2007
Location: INDIA

Member

Will try and let you know the output..

Report message to a moderator

Re: Error in rman backup [message #562488 is a reply to message #562486]

Wed, 01 August 2012 11:42

indrajit2002
Messages: 53
Registered: November 2007
Location: INDIA

Member

But did the backup happen as I do not see any backup failure... Please help to get rid of this confusion..

Report message to a moderator

Re: Error in rman backup [message #562492 is a reply to message #562488]

Wed, 01 August 2012 12:09

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The backup happened but you should be able to check it on your target.

Regards
Michel

Report message to a moderator

Re: Error in rman backup [message #562572 is a reply to message #562492]

Thu, 02 August 2012 06:16

indrajit2002
Messages: 53
Registered: November 2007
Location: INDIA

Member

Yes. I checked the status from v$rman_backup_job_details and it is showing as 'COMPLETED WITH ERRORS'..

Report message to a moderator

Re: Error in rman backup [message #562575 is a reply to message #562572]

Thu, 02 August 2012 06:38

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I meant check it at backup target using the commands available with your tape software.

Regards
Michel

Report message to a moderator

Previous Topic:	SPFILE restore from autobackup no catalog (2 Merged)
Next Topic:	RMAN recommendation for Channel

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 06:14:23 CDT 2025