Solved

RMAN Error  10038

Posted on 2002-05-03
2
1,620 Views
Last Modified: 2013-11-15
I'm trying to backup my database of about 400G. In my backup script I'm allocating 6 channels, each channel looks like this:

  allocate channel adsm1 type 'SBT_TAPE'
  parms 'ENV=
DSMO_NODE=mis_33_oracle,DSMI_CONFIG=/usr/tivoli/tsm/client/oracle/bin/dsm.opt,DSMI_LOG=/adsm/log,DSMI_ORC_DIR=/usr/tivoli/tsm/client/oracle/bin,DSMO_FS=adsmorc,DSMO_PSWDPATH=/usr/tivoli/tsm/client/oracle/bin,DSMI_DIR=/usr/tivo
li/tsm/client/api/bin,DSMO_DEBUG=49)';
  setlimit channel adsm1 kbytes 2097152 maxopenfiles 32 readrate 200;

After running for about 2-2.5 hours, I get this:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
RMAN-10038: database session for channel adsm1 terminated unexpectedly


I did an oerr on the error 10038. It states for me to look at the oracle trace file for detailed information on why the session terminated. First of all where is this so called trace file and what am I doing wrong? Oh, one more other thing, my log backups works great. Can anyone help with this problem? Thanks in advance.
0
Comment
Question by:rsolomon
2 Comments
 
LVL 5

Expert Comment

by:Bajwa
ID: 6988696
Run with debug on... which will produce trace for each channel allocated and a log file.
Log will be in the path that you enter and trace in udump directory., then it will be easier to find the error.
rman target / catalog or nocatalog log=/path/filename.log
run
{allocate channel adsm1 type 'SBT_TAPE'
parms 'ENV= DSMO_NODE=mis_33_oracle,DSMI_CONFIG=/usr/tivoli/tsm/client/oracle/bin/dsm.opt,DSMI_LOG=/adsm/log,DSMI_ORC_DIR=/usr/tivoli/tsm/client/oracle/bin,DSMO_FS=adsmorc,DSMO_PSWDPATH=/usr/tivoli/tsm/client/oracle/bin,DSMI_DIR=/usr/tivo
li/tsm/client/api/bin,DSMO_DEBUG=49)';
debug on;
backup filesperset 1
format 'FULL_%d_%u'
(database include current controlfile);
debug off;
}

0
 
LVL 1

Accepted Solution

by:
Moondancer earned 300 total points
ID: 7096835
Please update and finalize this question.  If you need Moderator assistance to split points or otherwise help with special handling, let us know via comment here or by posting a Zero point question with this question link in the Community Support topic area.
Thank you,
Moondancer - EE Moderator
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

This article is an update and follow-up of my previous article:   Storage 101: common concepts in the IT enterprise storage This time, I expand on more frequently used storage concepts.
Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

758 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

19 Experts available now in Live!

Get 1:1 Help Now