我在windows的客户端cmd连接到虚拟机的oracle11g服务端,在show all之后出现异常退出,请问问题出现在哪里?
C:\>rman target sys/oracle@vincent nocatalog恢复管理器: Release 11.1.0.6.0 - Production on 星期四 4月 12 10:35:11 2012Copyright (c) 1982, 2007, Oracle. All rights reserved.连接到目标数据库: VINCENT (DBID=1819835840)
使用目标数据库控制文件替代恢复目录RMAN> show all;db_unique_name 为 VINCENT 的数据库的 RMAN 配置参数为:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
DBGANY: Mismatched message length! [10:35:20.374] (krmiduem)
DBGANY: Mismatched message length! [10:35:20.376] (krmiduem)
MAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00600: internal error, arguments [3045] [] [] [] []
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: show 命令 (在 04/12/2012 10:35:20 上) 失败
ORA-00904: "IS_DEFAULT": 标识符无效C:\>
C:\>rman target sys/oracle@vincent nocatalog恢复管理器: Release 11.1.0.6.0 - Production on 星期四 4月 12 10:35:11 2012Copyright (c) 1982, 2007, Oracle. All rights reserved.连接到目标数据库: VINCENT (DBID=1819835840)
使用目标数据库控制文件替代恢复目录RMAN> show all;db_unique_name 为 VINCENT 的数据库的 RMAN 配置参数为:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
DBGANY: Mismatched message length! [10:35:20.374] (krmiduem)
DBGANY: Mismatched message length! [10:35:20.376] (krmiduem)
MAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00600: internal error, arguments [3045] [] [] [] []
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: show 命令 (在 04/12/2012 10:35:20 上) 失败
ORA-00904: "IS_DEFAULT": 标识符无效C:\>
解决方案 »
- oracle数据库迁移的问题
- 请教ORACLE如何建立一个JOB
- 请帮忙看下这个循环into的问题怎么解决
- oracle下怎么求同一字段值对应的另一字段的集合?
- start with...... connect by ......问题求解!
- 使用oracle的一个问题(alter table table_name storage语句出错)
- 关于Oracle中old和new两个临时表
- 我在安装oracle8.1.7的时候,提示jdk_home 路径我默认是/usr/loca/java, 可是出错?
- ********如何在oracle判断一个变量是否为整形(number)?~********
- 散分喽
- oracle正则表达式处理手机吉祥号
- oracle效率问题,非常急
能不能说的具体一点,“坏境没有设好”,这个坏境是如何设置?并不是所有的命令都失效,例如
RMAN> report schema;db_unique_name 为 VINCENT 的数据库的数据库方案报表永久数据文件列表
===========================
文件大小 (MB) 表空间 回退段数据文件名称
---- -------- -------------------- ------- ------------------------
1 680 SYSTEM *** /u01/oradata/vincent/system01.dbf
2 500 SYSAUX *** /u01/oradata/vincent/sysaux01.dbf
3 90 UNDOTBS1 *** /u01/oradata/vincent/undotbs01.dbf
4 5 USERS *** /u01/oradata/vincent/users01.dbf临时文件列表
=======================
文件大小 (MB) 表空间 最大大小 (MB) 临时文件名称
---- -------- -------------------- ----------- --------------------
1 29 TEMP 32767 /u01/oradata/vincent/temp01.dbfRMAN>这个就没有出现异常退出的问题!
我在学习oracle备份与恢复你说我的oracle坏了,请问究竟坏在哪里?因为我的oracle现在同样可以对表进行增,删,查,改等操作。谢谢!