[oracle@dg1 ~]$ sqlplus sys/atyu30 as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on 星期六 5月 8 19:13:05 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
未选定行
SQL> select database_role from v$database;
DATABASE_ROLE
------------------------------------------------
PHYSICAL STANDBY
SQL> alter database recover managerd standby database using current logfile disconnect from session;
alter database recover managerd standby database using current logfile disconnect from session
*
第 1 行出现错误:
ORA-00905: 缺失关键字
SQL> alter database recover managed standby database using current logfile disconnect from session;
alter database recover managed standby database using current logfile disconnect from session
*
第 1 行出现错误:
ORA-01153: 激活了不兼容的介质恢复
SQL> SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
未选定行
SQL> SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
未选定行
SQL>
SQL> SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
未选定行
SQL> select open_mode from v$database;
OPEN_MODE
------------------------------
MOUNTED
SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-01154: 数据库忙。现在不允许打开, 关闭, 装载和卸装
SQL> alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session
*
第 1 行出现错误:
ORA-01153: 激活了不兼容的介质恢复
SQL> alter database recover managerd standby database calcel;
alter database recover managerd standby database calcel
*
第 1 行出现错误:
ORA-00905: 缺失关键字
SQL> alter database recover managed standby database calcel;
alter database recover managed standby database calcel
*
第 1 行出现错误:
ORA-00274: 非法恢复选项 CALCEL
SQL> alter database recover managed standby database cancel;
数据库已更改。
SQL>
SQL>
SQL>
SQL>
SQL> alter database recover managed standby database disconnect from session;
数据库已更改。
SQL>
阅读(2256) | 评论(0) | 转发(0) |