Solved

RMAN Error  10038

Posted on 2002-05-03
2
1,625 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

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Query 34 99
Create table from select - oracle 6 41
Not able to drop or recreate an Oracle stored procedure 1 31
WD MybookLive Data disappear 6 37
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
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 steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

777 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