Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN dumps cccccccc_1_1 files in $OH/dbs

744242Jul 20 2011 — edited Jul 21 2011
Hello,

I have had an Oracle 9i-R2 database daily RMAN backup job on AIX 5.3 working fine for more than a year. Recently, a few weeks back it started dumping cccccccc_1_1 files (cc...c are lowercase letters or digits) in $OH/dbs with no apparent reason. The file size varies from a few MB to more than 100MB.
Since RMAN task finishes with no error (exit status = 0), I only spotted the issue when the file system where $OH resides neared to be full.

I have tried searching for similar problems and nothing came up so far.
I am tackling it by purging older than 3 days files for now, which is kind of a surrogate solution. Instead of patching the symptom I would rather prefer addressing the root cause, if that's possible.
Has anybody encountered a similar issue?

Any kind of useful feedback would be highly appreciated.

Regards,
Dan

Hello everyone,

I have reviewed all responses so far. Thank you very much.
I have manually run a test backup also, by adding FORMAT after 'archivelog', which does seem to work ok - i.e. no backup files in $OH/dbs.
Now I'll leave the adjusted job to run tonight and see what comes up tomorrow in the log.

Regards,
Dan

Edited by: Parnassus on Jul 20, 2011 11:11 AM

PROBLEM SOLVED!
Thank you all!

Edited by: Parnassus on Jul 21, 2011 8:51 AM
This post has been answered by CKPT on Jul 20 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 18 2011
Added on Jul 20 2011
13 comments
303 views