From: Deepak John Cutinha (deepak_cutinha@yahoo.com)
Date: Mon Aug 07 2006 - 09:27:42 EDT
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 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 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
. exporting private type synonyms
. exporting object type definitions for user RMANF
About to export RMANF's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export RMANF's tables via Conventional Path
...
. . exporting table AL
585 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table BCB
0 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table BCF
1409 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table BDF
286938 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table BP
57879 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table BRL
107470 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table BS
57879 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table BSF
0 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table CCB
0 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table CCF
3 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table CDF
0 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table CKP
508 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table CONF
0 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table CONFIG
1 rows exported
. . exporting table DB
5 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table DBINC
5 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table DF
1098 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table DFATT
1960 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table OFFR
0 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table ORL
25 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table RCVER
1 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table RLH
109536 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table RR
0 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table RT
5 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table SCR
0 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table SCRL
0 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table TS
1059 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table TSATT
1059 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table XCF
0 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. . exporting table XDF
0 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904:
"SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT":
invalid identifier
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully with warnings.
[Normal] From: BSM@westback "djc4-K_ORA_ONLINE" Time:
8/3/06 12:39:00
OB2BAR application on
"coldb.west1jetlag.dcn.pri.o2.com" disconnected.
[Normal] From: BMA@westback "HP:Ultrium
1-SCSI_2_westback1" Time: 8/3/06 12:40:16
/dev/rmt/42mn
Medium header verification completed, 0 errors found
[Normal] From: BMA@westback "HP:Ultrium
1-SCSI_2_westback1" Time: 8/3/06 12:40:31
By: UMA@westback@/dev/rac/c8t2d2
Unloading medium to slot 30 from device /dev/rmt/42mn
[Normal] From: BMA@westback "HP:Ultrium
1-SCSI_2_westback1" Time: 8/3/06 12:40:50
ABORTED Media Agent "HP:Ultrium 1-SCSI_2_westback1"
[Normal] From: BSM@westback "djc4-K_ORA_ONLINE" Time:
8/3/06 12:40:50
Backup Statistics:
Session Queuing Time (hours) 0.00
----------------------------------------
Completed Disk Agents ........ 19
Failed Disk Agents ........... 0
Aborted Disk Agents .......... 0
----------------------------------------
Disk Agents Total ........... 19
========================================
Completed Media Agents ....... 0
Failed Media Agents .......... 1
Aborted Media Agents ......... 0
----------------------------------------
Media Agents Total .......... 1
========================================
Mbytes Total ................. 18120 MB
Used Media Total ............. 1
Disk Agent Errors Total ...... 0
Regards,
D.E.E.P.A.K.
Digital Electronic Entity Programmed for Accurate Killing
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
---> Please post QUESTIONS and SUMMARIES only!! <---
To subscribe/unsubscribe to this list, contact majordomo@dutchworks.nl
Name: hpux-admin@dutchworks.nl Owner: owner-hpux-admin@dutchworks.nl
Archives: ftp.dutchworks.nl:/pub/digests/hpux-admin (FTP, browse only)
http://www.dutchworks.nl/htbin/hpsysadmin (Web, browse & search)
This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 11:02:53 EDT