SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.
Total System Global Area236000356 bytes
Fixed Size
451684 bytes
Variable Size
100663296 bytes
Database Buffers
134217728 bytes
Redo Buffers
667648 bytes
SQL> CREATE CONTROLFILE REUSE DATABASE "SVR11" NORESETLOGSARCHIVELOG
2--SET STANDBY TO MAXIMIZE PERFORMANCE
3MAXLOGFILES 10
4MAXLOGMEMBERS 3
5MAXDATAFILES 100
6MAXINSTANCES 1
7MAXLOGHISTORY 226
8LOGFILE
9GROUP 1 '/opt/oracle/oradata/svr11/redo01.log'SIZE 100M,
10GROUP 2 '/opt/oracle/oradata/svr11/redo02.log'SIZE 100M,
11GROUP 3 '/opt/oracle/oradata/svr11/redo03.log'SIZE 100M
12-- STANDBY LOGFILE
13DATAFILE
14'/opt/oracle/oradata/svr11/system01.dbf',
15'/opt/oracle/oradata/svr11/undotbs01.dbf',
16'/opt/oracle/oradata/svr11/indx01.dbf',
17'/opt/oracle/oradata/svr11/tools01.dbf',
18'/opt/oracle/oradata/svr11/users01.dbf'
19CHARACTER SET ZHS16GBK;
CREATE CONTROLFILE REUSE DATABASE "SVR11" NORESETLOGSARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01229: data file 5 is inconsistent with logs
ORA-01110: data file 5: '/opt/oracle/oradata/svr11/users01.dbf'
SQL> alter database mount standby database;
alter database mount standby database
*
ERROR at line 1:
ORA-01079: ORACLE database was not properly created, operation aborted
SQL> startup nomount;
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area236000356 bytes
Fixed Size
451684 bytes
Variable Size
100663296 bytes
Database Buffers
134217728 bytes
Redo Buffers
667648 bytes
SQL> alter database mount standby database;
alter database mount standby database
*
ERROR at line 1:
ORA-01079: ORACLE database was not properly created, operation aborted
最初由 chj733 发布
[B]YES,然后ALTER DATABASE MOUNT STANDBY DATABASE;
然后ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;
这个时候传输过来的日志会真实的应用到数据文件,基本就OK了
想看结果的话关闭数据库了在启动到read only状态查看 [/B]
我按你的去做,根本就不能应用日志
,一直显示这个
oracle@svr12 bdump]$ tail -f alert_svr11.log
MRP0 started with pid=11
MRP0: Background Managed Standby Recovery process started
MRP0: Background Media Recovery terminated with error 1190
Tue Nov 29 16:50:49 2005
Errors in file /opt/oracle/admin/svr11/bdump/svr11_mrp0_1579.trc:
ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: '/opt/oracle/oradata/svr11/system01.dbf'
MRP0: Background Media Recovery process shutdown
Tue Nov 29 16:50:49 2005
Completed: alter database recover managed standby database di