解决：
SQL> EXEC DBMS_LOGSTDBY.SKIP('CREATE TABLESPACE', NULL, NULL, NULL);
PL/SQL procedure successfully completed.
SQL> alter database start logical standby apply immediate;
2 物理备库正常
物理备库上多了一个目录，能正常open read only:
[oracle@rac2 STD02]$ ls -al
total 32
drwxr-x--- 4 oracle oinstall 4096 Dec 14 01:37 .
drwxr-x--- 4 oracle oinstall 4096 Dec 14 01:12 ..
drwxr-x--- 2 oracle oinstall 4096 Dec 14 01:44 datafile
drwxr-x--- 2 oracle oinstall 4096 Dec 14 01:51 onlinelog
[oracle@rac2 STD02]$ cd datafile/
[oracle@rac2 datafile]$ ls -al
total 20992072
drwxr-x--- 2 oracle oinstall 4096 Dec 14 01:44 .
drwxr-x--- 4 oracle oinstall 4096 Dec 14 01:37 ..
-rw-r----- 1 oracle oinstall 10737426432 Dec 15 09:03 o1_mf_undotbs2_6jdpg45j_.dbf
-rw-r----- 1 oracle oinstall 10737426432 Dec 15 09:03 o1_mf_undotbs2_6jdpwr9m_.dbf
[oracle@rac2 datafile]$ cd ..
[oracle@rac2 STD02]$ cd ..
[oracle@rac2 orcl]$ cd STD02
[oracle@rac2 STD02]$ ls -al
total 32
drwxr-x--- 4 oracle oinstall 4096 Dec 14 01:37 .
drwxr-x--- 4 oracle oinstall 4096 Dec 14 01:12 ..
drwxr-x--- 2 oracle oinstall 4096 Dec 14 01:44 datafile
drwxr-x--- 2 oracle oinstall 4096 Dec 14 01:51 onlinelog
[oracle@rac2 STD02]$ cd onlinelog
[oracle@rac2 onlinelog]$ ls -al
total 205040
drwxr-x--- 2 oracle oinstall 4096 Dec 14 01:51 .
drwxr-x--- 4 oracle oinstall 4096 Dec 14 01:37 ..
-rw-r----- 1 oracle oinstall 104858112 Dec 14 01:51 o1_mf_18_6jdq83bb_.log
-rw-r----- 1 oracle oinstall 104858112 Dec 14 01:51 o1_mf_19_6jdq84gx_.log
[oracle@rac2 onlinelog]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Wed Dec 15 10:01:41 2010
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select open_mode from v$database;
OPEN_MODE
----------
MOUNTED
SQL> alter database recover managed standby database cancel;
Database altered.
SQL> alter database open read only;
Database altered.
SQL> select to_char(max(create_time) ,'yyyy-mm-dd hh24:mi:ss') from test;
TO_CHAR(MAX(C
-------------------
2010-12-15 10:05:40
SQL> alter database close;
Database altered.
SQL> alter database recover managed standby database disconnect from session using current logfile;
Database altered.
SQL>
SQL> select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;
TO_CHAR(SYSDATE,'YY
-------------------
2010-12-15 10:11:33
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@rac2 onlinelog]$
NAME VALUE UNIT TIME_COMPUTED
------------------------------ -------------------- ------------------------------ ------------------------------
apply finish time +00 00:00:00.0 day(2) to second(1) interval 15-DEC-2010 10:11:41
apply lag +00 00:00:26 day(2) to second(0) interval 15-DEC-2010 10:11:41
estimated startup time 24 second 15-DEC-2010 10:11:41
standby has been open Y 15-DEC-2010 10:11:41
transport lag +00 00:00:10 day(2) to second(0) interval 15-DEC-2010 10:11:41
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/758322/viewspace-681912/ ，如需转载，请注明出处，否则将追究法律责任。
