Re: [Veritas-bu] oracle hot backup
2007-06-06 14:59:45
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
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
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 by dy_lan018 AT yahoo DOT com via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://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 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
--
===================================
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
|
|
|