Solved

error in RMAN script

Posted on 2012-04-11
4
744 Views
Last Modified: 2012-06-27
I am using the below script for RMAN archivrlog backup. I am getting the eror.
Please suggest me on it.

run {
allocate channel ch1 type 'sbt_tape'
PARMS="BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1)"
TRACE 0;
setlimit channel ch1 maxopenfiles 8;
backup archivelog all delete input ;
backup current controlfile;
RELEASE CHANNEL ch1;
}2> 3> 4> 5> 6> 7> 8> 9>

RMAN-03022: compiling command: allocate
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: allocate
RMAN-06172: not connected to recovery catalog database
0
Comment
Question by:dba1234
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 5

Accepted Solution

by:
Bajwa earned 250 total points
ID: 37834046
You are not connected to recovery catalog (if you have)  The syntax to run the RMan command is

if no recovery catalog then logon to the machine which runs the database as that user.

rman target /

If using recovery catalog then

rman TARGET / CATALOG catalog_owner/catalog_password@catalog_db
0
 

Author Comment

by:dba1234
ID: 37834095
I am not using catalog mode nad I am already connected to target database.

/home/oracle> rman TARGET/

Recovery Manager: Release 8.1.7.4.0 - Production

RMAN-06005: connected to target database: AW01 (DBID=2410801421)

RMAN> run {
allocate channel ch1 type 'sbt_tape'
PARMS="BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1)"
TRACE 0;
setlimit channel ch1 maxopenfiles 8;
backup archivelog all delete input ;
backup current controlfile;
RELEASE CHANNEL ch1;
}
2> 3> 4> 5> 6> 7> 8> 9>
RMAN-03022: compiling command: allocate
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: allocate
RMAN-06172: not connected to recovery catalog database
0
 
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 250 total points
ID: 37834286
For version 8i of Oracle try:
rman TARGET/ nocatalog
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37844279
I'm curious about the C grade.

Did you not get an answer to your question?
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question