Chinaunix首页 | 论坛 | 博客
  • 博客访问: 3343352
  • 博文数量: 815
  • 博客积分: 12898
  • 博客等级: 上将
  • 技术积分: 7883
  • 用 户 组: 普通用户
  • 注册时间: 2006-12-25 09:57
文章分类

全部博文(815)

文章存档

2014年(1)

2011年(46)

2010年(192)

2009年(121)

2008年(70)

2007年(385)

分类: Oracle

2010-05-08 19:56:59

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

上一篇:RMAN 恢复 system

下一篇:RHEL 5.2 Install amule

给主人留下些什么吧!~~