[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 752
  • 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

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

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