Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 759
  • Last Modified:

error in RMAN script

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
dba1234
Asked:
dba1234
  • 2
2 Solutions
 
BajwaCommented:
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
 
dba1234Author Commented:
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
 
slightwv (䄆 Netminder) Commented:
For version 8i of Oracle try:
rman TARGET/ nocatalog
0
 
slightwv (䄆 Netminder) Commented:
I'm curious about the C grade.

Did you not get an answer to your question?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now