?
Solved

Oracle Database Backup Failed

Posted on 2016-09-05
6
Medium Priority
?
46 Views
Last Modified: 2016-10-23
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.
0
Comment
Question by:Sudhanshum
[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
  • 2
  • 2
6 Comments
 
LVL 4

Expert Comment

by:Steven Kribbe
ID: 41785820
0
 

Author Comment

by:Sudhanshum
ID: 41786002
this link, I have already gone through.Is any different solution available?
0
 
LVL 35

Accepted Solution

by:
johnsone earned 2000 total points
ID: 41786491
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
 

Author Comment

by:Sudhanshum
ID: 41787363
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
 
LVL 35

Assisted Solution

by:johnsone
johnsone earned 2000 total points
ID: 41787599
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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…
Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

762 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