Solved

Oracle RMAN BACKUP WITH TDPO PROBLEM

Posted on 2003-12-10
13
2,014 Views
Last Modified: 2012-06-22
Hi,

I am trying to backup an oracle database (8i) on windows NT4 with rman and I get the following error messages:

Recovery Manager: Release 8.1.7.0.0 - Production

RMAN-06005: connected to target database: PRCPTN (DBID=1597124053)
RMAN-06008: connected to recovery catalog database

RMAN> run {  
2> execute script backup_level0_TDPO;
3> }
4>
RMAN-03021: executing script: backup_level0_TDPO

RMAN-03021: executing script: alloc_TDPO

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=8 devtype=SBT_TAPE
RMAN-08526: channel t1: Tivoli Data Protection for Oracle: version 2.2.1.0

RMAN-03021: executing script: set_maxcorrupt

RMAN-03022: compiling command: set

RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel t1: starting incremental level 0 datafile backupset
RMAN-08502: set_count=157 set_stamp=512403853 creation_time=10-DEC-03
RMAN-08010: channel t1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00007 name=E:\APPS\ORANT\ORADATA\PRCPTN\PERCEPTION.ORA
RMAN-08522: input datafile fno=00003 name=E:\APPS\ORANT\ORADATA\PRCPTN\USERS01.DBF
RMAN-08522: input datafile fno=00005 name=E:\APPS\ORANT\ORADATA\PRCPTN\TOOLS01.DBF
RMAN-08522: input datafile fno=00001 name=E:\APPS\ORANT\ORADATA\PRCPTN\SYSTEM01.DBF
RMAN-08011: including current controlfile in backupset
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03015: error occurred in stored script backup_level0_TDPO
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel t1
RMAN-10035: exception raised in RPC: ORA-19506: failed to create sequential file, name="df_level0_PRCPTN_s157_p1", parms=""
ORA-27028: skgfqcre: sbtbackup returned error

RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE

Recovery Manager complete.


------------------------------------------------------------------

It was working 5 days ago and suddenly, it doesn't work...

Could it be a size problem, the 4 files are 1GB total  ???

If you have any clue, please let me know.
Thanks in advance.
0
Comment
Question by:jvermeul
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
13 Comments
 
LVL 15

Expert Comment

by:Ralf Klatt
ID: 9923384
Hi,

Please ensure that your authorization code and the enabler code are error free and have not yet expired.

If there's no problem I'd suggest to have a look at Oracle8i Recovery Manager User's Guide and Reference -> if you haven't looked there already.
http://labserver01.zhwin.ch/oracle/8.1.6/server.816/a76990/troubler.htm

Please tell me when this didn't help!


Best regards, Raisor
0
 

Author Comment

by:jvermeul
ID: 9923645
Hi,
Thanks for your answer. Yes I already read Metalink problem, documentations, but still don't know.
I have tested also the backup of one tablespace at a time on TSM to verify that I don't have any problem of datafile corruption but it did work properly.
Also, I have 2 more databases on the same system and the backup works properly for these ones. Their size is even bigger so it doesn't seem to be a size problem.
So why this one doesn't work anymore is weird...
I saw in the messages that something seems to be missing between the lines:

ORA-27028: skgfqcre: sbtbackup returned error
....... here should be an other message more significative on the problem as I saw on similar problems on Metalink.......
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE

The full export works fine too...

So I really don't know what is happening.. and I don't see what changed on this environment since it doesn't work...

0
 
LVL 15

Expert Comment

by:Ralf Klatt
ID: 9926792
Hi,

As I'm not able to reproduce your error but regarding to your "file size idea" I've found out that there is a MAXPIECESIZE parameter that can be set -> even while this information is about 9i you can read and try to apply the information to your 8i settings:
http://www.engin.umich.edu/caen/wls/software/oracle/server.901/a90136/rcmsynt6.htm

In a chinese forum I've found something about "setting backup_tape_io_slaves = FALSE has been known to fix this problem" => but all explanation is in chinese which I don't know to read or speak.

If these hints lead to nothing then I'll be off of your question as I can't provide anything more productive. I'm sorry if I couldn't help!


Best regards, Raisor
0
[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

 

Author Comment

by:jvermeul
ID: 9931166

Hi Raisor,
Thanks again for your help.  
That's an idea.  I already tried to downsize the backup by using the fileperset parameter (=1) and it didn't work with the first one, the USERS tablespace which is very small.
But I will try this MAXPIECESIZE on tuesday we never know and will give you feedback about it.
Have a good weekend.
0
 
LVL 15

Expert Comment

by:Ralf Klatt
ID: 9931492
Hi,

I hope this will work => I've read that somebody has written an book about MAXPIECESIZE => I'll have a look if find what this is about => I'll get back on that book before tuesday! :)

Have a good weekend too ...


Best regards, Raisor
0
 
LVL 15

Expert Comment

by:Ralf Klatt
ID: 9940525
Hi,

I could't find the information I was looking for -> what I've foud instead is:
http://www.osborne.com/products/0072226625/0072226625_ch03.pdf

From chapter 3: "Here is an example of controlling the size of a backup set piece or the entire backup itself. In this example, we are limiting channel 1 to create each individual
backup piece at a maximum size of 100MB."

This is interesting too -> Lots of error explanations and examples! (8.1.6):
http://labserver01.zhwin.ch/oracle/8.1.6/server.816/a76990/troubler.htm


Best regards, Raisor
0
 

Author Comment

by:jvermeul
ID: 10011244
Hi,
Thanks for your help and researches.. I will have a look when I come back at work around Jan, 7th.
Sorry for the delay, I am on vacation and was on higher priority problems too weeks ago.
See you.
0
 
LVL 15

Expert Comment

by:Ralf Klatt
ID: 10012170
Hi,

No problem!

... and a happy new year ;-))


Best regards, Raisor
0
 

Author Comment

by:jvermeul
ID: 10242717

Hi Raisor,

Finally I didn't do anything and it did fix by itself.. Don't ask me why, but that's a problem in todays environments. Too many technical people work on it at the same time (network guys, system admin, etc.) and nobody tells you if they really did something.
Well I am happy it works now, but not so happy for the mystery!!
Thanks again for your help and take care.
Jacques.
0
 
LVL 15

Expert Comment

by:Ralf Klatt
ID: 11068258
Hi,

PAQ is perfect for this thread because there's lots of usefull information in the provided articles ... and points refunded to jvermeul is ok with me!

Best regards, Raisor
0
 

Accepted Solution

by:
ee_ai_construct earned 0 total points
ID: 11103035
PAQed, with points refunded (50)

ee_ai_construct - CS Mod
0

Featured Post

 Watch the Recording: Learning MySQL 5.7

MySQL 5.7 has a lot of new features. If you've dabbled with an older version of MySQL, it is definitely worth learning.

Question has a verified solution.

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

Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

626 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