在尝试使用Oracle恢复管理器(RMAN)进行数据库恢复时，遇到了错误。在10月27日08:53:00，启动数据库失败，错误消息提示参数未考虑MEMORY_TARGET，且SGA_MAX_SIZE设置超过了MEMORY_TARGET的限制。接着尝试分配通道并恢复SPFILE也失败，报错为无法获得完全授权的会话，并显示ORACLE未可用。最后尝试关闭数据库也失败，同样的错误再次出现。这表明可能存在数据库配置问题或系统资源不足的情况。
恢复管理器: Release 11.2.0.1.0 - Production on 星期四 10月 27 08:52:58 2016
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN>
回显已打开
RMAN> set dbid 1250170590;
正在执行命令: SET DBID
RMAN> set echo off;
回显已关闭
RMAN>
已连接到目标数据库 (未启动)
RMAN>
回显已打开
RMAN> startup force nomount;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: startup 命令 (在 10/27/2016 08:53:00 上) 失败
RMAN-04014: 启动失败: ORA-00844: Parameter not taking MEMORY_TARGET into account
ORA-00851: SGA_MAX_SIZE 4294967296 cannot be set to more than MEMORY_TARGET 3439329280.
RMAN> run {
2> allocate channel oem_restore_disk type disk;
3> restore spfile from autobackup;
4> }
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: allocate 命令 (在 10/27/2016 08:53:00 上) 失败
RMAN-06403: 无法获得完全授权的会话
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
RMAN> shutdown immediate;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: shutdown 命令 (在 10/27/2016 08:53:00 上) 失败
RMAN-06403: 无法获得完全授权的会话
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
RMAN> exit;
恢复管理器完成。
扫一扫
526
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
