Oracle Error From Recovery Catalog Database Ora-00904 Invalid Identifier
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top How to restore 11gR2 fullbackup to 12c database in rman up vote 0 down vote favorite I need to transfer my database from Oracle 11gR2 to 12c database. It will be in same computer. I took full backup of Oracle 11gR2 database. Then I remove Oracle 11gR2. I installed Oracle 12c and I tried to restore my backup. I could restored spfile, controlfile, datafiles.. But I couldn't do RMAN> ALTER DATABASE OPEN RESETLOGS; ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00704: bootstap process failure ORA-00604: error occurred at recursive SQL level 2 ORA-00904: "I". "UNUSABLEBEGINNING# ": invalid identifier Process ID: 3377 Session ID: 125 Serial number: 5 What should I do to open database? Should I do Pre-Upgrade script ? I couldn't understand to do pre-upgrade script step.. oracle rman share|improve this question asked Mar 20 '15 at 15:53 user3697869 migrated from stackoverflow.com Mar 20 '15 at 17:32 This question came from our site for professional and enthusiast programmers. upgrade using backups is possible, see dba.stackexchange.com/questions/24718/… and the note Doc ID 369644.1 mentioned by @Macco. But it is rather complex and the way
20060807132742.63502.qmail () web60324 ! mail ! yahoo ! com [Download message RAW] Hello, I have trouble exporting the Recovery Catalog: Any help to troubleshoot or fix this problem wud be very useful... Thanks in advance Regards Deepak Few lines form the log are attached: archive log filename=/d/db/app/oracle/admin/djc/arc/arch1_778.dbf recid=771 stamp=597500507 Finished backup at 08/03/2006 [12:37:14] released channel: dev_1 released channel: dev_2 released channel: dev_3 released channel: dev_0 RMAN> **end-of-file** RMAN> Recovery http://dba.stackexchange.com/questions/95827/how-to-restore-11gr2-fullbackup-to-12c-database-in-rman Manager complete. [Normal] From: ob2rman.exe@colbbc2 "djc" Time: 08/03/06 12:37:19 Oracle RMAN successfully finished. [Normal] From: ob2rman.exe@colbbc2 "djc" Time: 08/03/06 12:37:19 Issuing DP Managed Control File Backup ... [Normal] From: OB2BAR_Oracle8@colbbc2.west1.jetlag.dcn.de.pri.o2.com "djc" Time: 8/3/06 12:37:21 Starting OB2BAR Backup: coldb.west1jetlag.dcn.pri.o2.com:djc DP Managed Control File Backup "Oracle8" [Normal] From: OB2BAR_Oracle8@colbbc2.west1.jetlag.dcn.de.pri.o2.com "djc" Time: 8/3/06 12:37:24 Backup Profile: Run http://marc.info/?l=hpux-admin&m=115495815318527 Time ........... 0:00:03 Backup Speed ....... 2301.33 (KB/s) [Normal] From: OB2BAR_Oracle8@colbbc2.west1.jetlag.dcn.de.pri.o2.com "djc" Time: 8/3/06 12:37:24 Completed OB2BAR Backup: coldb.west1jetlag.dcn.pri.o2.com:djc DP Managed Control File Backup "Oracle8" [Normal] From: ob2rman.exe@colbbc2 "djc" Time: 08/03/06 12:37:24 Starting backup of the Oracle Recovery Catalog Database ... [Normal] From: ob2rman.exe@colbbc2 "djc" Time: 08/03/06 12:37:25 Getting NLS_LANG and setting it into the environment .... AMERICAN_FRANCE.AL32UTF8 Default exp binary /opt/oracle/product/9i/bin/exp is used for catalog export. [Major] From: ob2rman.exe@colbbc2 "djc" Time: 08/03/06 12:37:57 Export of the Recovery Catalog Database failed. Export: Release 9.2.0.7.0 - Production on Thu Aug 3 12:37:25 2006 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production JServer Release 9.2.0.4.0 - Production Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set server uses US7ASCII character set (pdjcible charset conversion) . exporting pre-schema procedural objects and actions . exporting foreign function library names for user RMANF . exporting PUBLIC type synonyms . exp
Topic Backup and recovery Database Admin View All Cloud infrastructure Availability Database design Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL http://searchoracle.techtarget.com/tutorial/Solving-common-Oracle-errors-guide database Real Application Clusters (RAC) Applications View All Enterprise and http://www.dba-oracle.com/articles.htm business performance management Implementing and upgrading Oracle apps E-Business Suite Fusion applications Hyperion JD Edwards (JDE) PeopleSoft Siebel and Oracle CRM Data Mgmt View All BI (business intelligence) Data quality Data warehousing Metadata Database Admin View All Cloud infrastructure Availability Backup and recovery Database oracle error design Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real Application Clusters (RAC) Development View All BPEL in Oracle Open Source SQL Java / J2EE Stored procedures XML PL/SQL Fusion View All Oracle and BEA Application Server Data and application integration oracle error from SOA (service-oriented architecture) Infrastructure View All Cloud computing infrastructure Exadata and Exalogic Grid computing Oracle on Linux Operating system Oracle hardware decisions Virtual machine Oracle management View All certification Oracle acquisitions Business process management Market analysis DBA jobs training and certification Small businesses Regulatory compliance Outsourcing Oracle on demand and SaaS Oracle strategy and product roadmap Oracle support services Oracle vs. SAP Oracle Web 2.0 Sun-Oracle infrastructure View All Oracle cloud computing Oracle OS Oracle virtualization Topics Archive View All Oracle DBA jobs Oracle Resources Training and certification Tutorials, tips and FAQs Please select a category Applications Data Mgmt Database Admin Development Fusion Infrastructure Oracle management Sun-Oracle infrastructure Section Get Started News Get Started Evaluate Manage Problem Solve Sponsored Communities Solving common Oracle error codes guide bySearchOracle.com experts Solve your Oracle errors quickly and easily with help from this fast guide. It covers every expert response pertaining to Oracle errors on SearchOracle.com. In this Article Share this item with your network: Related
Remote DBAOracle TuningEmergency 911RAC SupportApps SupportAnalysisDesignImplementationOracle Support
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog Oracle Articles By Burleson Consulting Burleson Consulting is an altruistic company and we believe in sharing our Oracle extensive knowledge through publishing Oracle books and Oracle articles, video Oracle training, and one-on-one Oracle education courses. BC pledges to help the Oracle community by publishing our tips, tricks and techniques and we hope that you find our tips informative. Hot Oracle Articles & Content BC Training Catalog Consulting Prices Oracle Grant Security Oracle Stored Procedures BC Oracle Tuning Book Oracle SQL Tuning Tips Tuning SQL with dbms_stats Oracle Articles and RSS Feeds DBA Oracle Blog RSS Feed Oracle News RSS Feed/font> Register for weekly Oracle Tips BC Oracle Webcasts Oracle Articles Archive Oracle Tips Archives Oracle Quick Tips Our staff has unprecedented opportunity to see real-world Oracle database in-action and we share our experiences on this page of Oracle articles. Publish articles with BC BC is a leading publisher of Oracle articles and we are affiliated with Rampant TechPress, the leading publisher of Oracle books. If you want to publish an article or book, please call or e-mail BC today. Oracle Article Index: Free Oracle 11g Reference Poster Don Burleson Blog! Fun News page! Burleson Humor Articles Burleson Opinion Articles Burleson Oracle Webcasts Burleson Oracle Articles Archive Steve Karam Oracle Articles Kent Crotty Articles Mike Ault Oracle Articles Robert Freeman Oracle Articles John Garman