Re: [Veritas-bu] oracle hot backup

Yes Thanks for the help. It was SBT_TYPE and i Changed it to SBT_TAPE and backup went fine.

Thanks
Abhishek

"Steven L. Sesar" <ssesar AT mitre DOT org>
Sent by: veritas-bu-bounces AT mailman.eng.auburn DOT edu

06/05/2007 06:33 PM

To	Abhishek.Dhingra AT mindspeed DOT com
cc	ckstehman AT pepco DOT com, VERITAS-BU AT mailman.eng.auburn DOT edu, veritas-bu-bounces AT mailman.eng.auburn DOT edu
Subject	Re: [Veritas-bu] oracle hot backup

SBT_TYPE should be SBT_TAPE

--Steve

Abhishek.Dhingra AT mindspeed DOT com wrote:

Gurus,
I have configured the Oracle backup script , but it is failing with the error :-

aloe:root-$PS2 cat oracle_backup.out
oracle

Script /opt/app/oracle/hot_database_backup.sh
==== started on Mon Jun 4 17:08:31 PDT 2007 ====

RMAN: /opt/app/oracle/product/9.2.0.4_32bit/bin/rman
ORACLE_SID: EVRS
ORACLE_USER: 60075
ORACLE_HOME: /opt/app/oracle/product/9.2.0.4_32bit

NB_ORA_FULL:
NB_ORA_INCR:
NB_ORA_CINC:
NB_ORA_SERV:
NB_ORA_POLICY:

Default - Full backup requested
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> RMAN> RS (DBID=554365534)
using target database controlfile instead of recovery catalog

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on ch00 channel at 06/04/2007 17:08:34
ORA-19554: error allocating device, device type: SBT_TYPE, device name:
ORA-27001: unsupported device type
Additional information: 1

RMAN>

Recovery Manager complete.

Script /opt/app/oracle/hot_database_backup.sh
==== ended in error on Mon Jun 4 17:08:34 PDT 2007 ====

Any suggestions what could be the issue.

--Abhishek

ckstehman AT pepco DOT com
Sent by: veritas-bu-bounces AT mailman.eng.auburn DOT edu

06/05/2007 05:20 PM

To	VERITAS-BU AT mailman.eng.auburn DOT edu
cc
Subject	Re: [Veritas-bu] oracle hot backup

Recovery Catalog DB. Best to put it on a different machine to avoid the "all eggs in one basket" issue.
RMAN is fully functional and is designed to work best with the DB.

=============================
Carl Stehman
IT Distributed Services Team
Pepco Holdings, Inc.
202-331-6619
Pager 301-765-2703
ckstehman AT pepco DOT com

dy018 <netbackup-forum AT backupcentral DOT com>
Sent by: veritas-bu-bounces AT mailman.eng.auburn DOT edu

06/05/2007 01:25 AM

Please respond to
VERITAS-BU AT mailman.eng.auburn DOT edu

To	VERITAS-BU AT mailman.eng.auburn DOT edu
cc
Subject	[Veritas-bu] Re: oracle hot backup

Can anyone explain the advantage and disadvantage of using control file as compare to using Recovery Catalog DB? I heard from one DBA is that using Recovery Catalog DB will enable more RMAN features as compare to using control file? izit true? +---------------------------------------------------------------------- |This was sent bydy_lan018 AT yahoo DOT comvia Backup Central. |Forward SPAM toabuse AT backupcentral DOT com. +---------------------------------------------------------------------- _______________________________________________ Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT eduhttp://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

This Email message and any attachment may contain information that is proprietary, legally privileged, confidential and/or subject to copyright belonging to Pepco Holdings, Inc. or its affiliates ("PHI"). This Email is intended solely for the use of the person(s) to which it is addressed. If you are not an intended recipient, or the employee or agent responsible for delivery of this Email to the intended recipient(s), you are hereby notified that any dissemination, distribution or copying of this Email is strictly prohibited. If you have received this message in error, please immediately notify the sender and permanently delete this Email and any copies. PHI policies expressly prohibit employees from making defamatory or offensive statements and infringing any copyright or any other legal right by Email communication. PHI will not accept any liability in respect of such communications. _______________________________________________ Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT eduhttp://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

_______________________________________________ Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT eduhttp://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

-- =================================== Steven L. Sesar Lead Operating Systems Programmer/Analyst UNIX Application Services R101 The MITRE Corporation 202 Burlington Road - MS K101 Bedford, MA 01730 tel: (781) 271-7702 fax: (781) 271-2600 mobile: (617) 519-8933 email:ssesar AT mitre DOT org===================================_______________________________________________ Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu