启动备库

[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>