Home » RDBMS Server » Backup & Recovery » Error in rman backup (Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production)
Error in rman backup [message #562414] Wed, 01 August 2012 07:11 Go to next message
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..
Re: Error in rman backup [message #562425 is a reply to message #562414] Wed, 01 August 2012 07:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Error in rman backup [message #562445 is a reply to message #562425] Wed, 01 August 2012 08:14 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Error in rman backup [message #562448 is a reply to message #562445] Wed, 01 August 2012 08:25 Go to previous messageGo to next message
John Watson
Messages: 8922
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 Go to previous messageGo to next message
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;
}
Re: Error in rman backup [message #562452 is a reply to message #562446] Wed, 01 August 2012 09:02 Go to previous messageGo to next message
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
Re: Error in rman backup [message #562462 is a reply to message #562452] Wed, 01 August 2012 10:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Error in rman backup [message #562486 is a reply to message #562462] Wed, 01 August 2012 11:40 Go to previous messageGo to next message
indrajit2002
Messages: 53
Registered: November 2007
Location: INDIA
Member
Will try and let you know the output..
Re: Error in rman backup [message #562488 is a reply to message #562486] Wed, 01 August 2012 11:42 Go to previous messageGo to next message
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..
Re: Error in rman backup [message #562492 is a reply to message #562488] Wed, 01 August 2012 12:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The backup happened but you should be able to check it on your target.

Regards
Michel
Re: Error in rman backup [message #562572 is a reply to message #562492] Thu, 02 August 2012 06:16 Go to previous messageGo to next message
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'..
Re: Error in rman backup [message #562575 is a reply to message #562572] Thu, 02 August 2012 06:38 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I meant check it at backup target using the commands available with your tape software.

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


Current Time: Thu Mar 28 08:14:37 CDT 2024