Oracle Database Backup Failed

Hi my production database backup run everyday,I am using 9.2.0.1.0 Oracle version. But suddenly database back failed for 3 days and then it again start working properly. I am not sure what will be exact reason,I have gone through LOG created when database got failed,Here is Log:

Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
EXP-00056: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [kpotcpop1], [], [], [], [], [], [], []
ORA-19206: Invalid value for query or REF CURSOR parameter
EXP-00056: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [kpotcpop1], [], [], [], [], [], [], []
ORA-19206: Invalid value for query or REF CURSOR parameter
EXP-00000: Export terminated unsuccessfully


    I searched online and many are suggesting to run catmeta.sql .Please help me asap as it's very important to fix production issue.
SudhanshumAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Steven KribbeSoftware EngineerCommented:
0
SudhanshumAuthor Commented:
this link, I have already gone through.Is any different solution available?
0
johnsoneSenior Oracle DBACommented:
ORA-00600 is an internal Oracle error.  The best information you will get for it is to go directly to Oracle Support.  Unfortunately, they are the ones that are going to be able to do that research.  Where you are on a fairly old version, you may not get much in terms of support, but if there is existing information on this particular error, they should help you out.

Have you rerun catmeta?  I don't have a 9i version of Oracle to look at, but from a very quick glance at going through the scripts involved, it would appear that you can run them without doing any harm.  It should create a bunch of types and views.  Do a bunch of grants.  Then insert a bunch of meta data and filter information into the internal tables (really should be replacing what is already there).

As an aside, in my experience, an export isn't usually used a backup for any type of production database.  If you ever need to restore anything, you will lose data.  There is no way around it.  They cannot be rolled forward.  If you are not using CONSISTENT=Y, then there is a chance that referential integrity constraints will not be able to be re-enabled on import as well.  It will also most likely increase the recovery time as some things are not backed up and need to be rebuilt (think indexes).
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SudhanshumAuthor Commented:
Hi Thanks for reply,So can i run that catmeta.sql on my production database directly? Will it not cause any changes in existing database?
0
johnsoneSenior Oracle DBACommented:
Define changes.  You are running a set of scripts that do creates/grants/inserts.  Those would all be considered changes, wouldn't they?

Can you run it without doing harm?  Most likely.  You have always been able to run catalog and catproc in a running system without issues.  I would do it during a maintenance window where nothing else was running.  Just to avoid locking conflicts and part of it failing.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.