Standby開啟
来源:互联网 发布:云服务器怎么安装php 编辑:程序博客网 时间:2024/06/05 17:06
Standby開啟方法
8i:
graphicsty</home/oracle>$sqlplus internal
SQL*Plus: Release 8.1.6.0.0 - Production on Fri Feb 18 11:08:31 2005
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 872292336 bytes
Fixed Size 69616 bytes
Variable Size 370864128 bytes
Database Buffers 500301824 bytes
Redo Buffers 1056768 bytes
SQL> alter database mount standby database;
Database altered.
SQL> recover standby database;
ORA-00279: change 700519891 generated at 02/18/2005 03:27:31 needed for thread
1
ORA-00289: suggestion : /data/graphic/arch/1_29844.arc
ORA-00280: change 700519891 for thread 1 is in sequence #29844
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
9i:
dmd3-db</home/oracle>$sqlplus "/as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Fri Feb 18 11:15:39 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 940644268 bytes
Fixed Size 452524 bytes
Variable Size 402653184 bytes
Database Buffers 536870912 bytes
Redo Buffers 667648 bytes
SQL> alter database mount standby database;
Database altered.
SQL> recover standby database;
ORA-00279: change 80243187 generated at 02/18/2005 08:46:50 needed for thread 1
ORA-00289: suggestion : /data/tpc/arch/1_900.dbf
ORA-00280: change 80243187 for thread 1 is in sequence #900
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
Auto
正式DB開啟
sqlplus internal
startup
exit
lsnrctl start
8i:
graphicsty</home/oracle>$sqlplus internal
SQL*Plus: Release 8.1.6.0.0 - Production on Fri Feb 18 11:08:31 2005
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 872292336 bytes
Fixed Size 69616 bytes
Variable Size 370864128 bytes
Database Buffers 500301824 bytes
Redo Buffers 1056768 bytes
SQL> alter database mount standby database;
Database altered.
SQL> recover standby database;
ORA-00279: change 700519891 generated at 02/18/2005 03:27:31 needed for thread
1
ORA-00289: suggestion : /data/graphic/arch/1_29844.arc
ORA-00280: change 700519891 for thread 1 is in sequence #29844
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
9i:
dmd3-db</home/oracle>$sqlplus "/as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Fri Feb 18 11:15:39 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 940644268 bytes
Fixed Size 452524 bytes
Variable Size 402653184 bytes
Database Buffers 536870912 bytes
Redo Buffers 667648 bytes
SQL> alter database mount standby database;
Database altered.
SQL> recover standby database;
ORA-00279: change 80243187 generated at 02/18/2005 08:46:50 needed for thread 1
ORA-00289: suggestion : /data/tpc/arch/1_900.dbf
ORA-00280: change 80243187 for thread 1 is in sequence #900
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
Auto
正式DB開啟
sqlplus internal
startup
exit
lsnrctl start
- Standby開啟
- STANDBY
- oracle standby
- Standby Database
- hot standby
- 快照standby
- 逻辑 standby
- standby 创建
- Greenplum 增加standby以及master-standby切换
- 讨厌的co-standby...
- 配置STANDBY服务器
- Hot Standby Router Protocol
- 创建logical standby
- Oracle Physical Standby
- 激活STANDBY做测试
- standby 添加 temp文件
- 快照standby实验
- Oracle Standby教程
- IE6和IE7共存方法
- 网页中层或菜单被Flash挡住的解决办法
- RUP:新一代的软件工程方法
- JavaScript经典技巧
- 我的第二次建模
- Standby開啟
- ASP.NET 2.0通過Oracle Client 訪問Oracle
- __doPostBack简单的使用方法
- javascript刷新页面
- 802.11n实测结果令人振奋
- JavaScript实现功能全集
- 如何在Apache中方便地切换http和https?
- UP还是敏捷方法?
- 国产杀毒软件又攀高峰 技术突破重大