Solved

error in RMAN script

Posted on 2012-04-11
4
724 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
  • 2
4 Comments
 
LVL 5

Accepted Solution

by:
Bajwa earned 250 total points
Comment Utility
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
Comment Utility
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 76

Assisted Solution

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

Expert Comment

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

Did you not get an answer to your question?
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

772 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now