rac與邏輯備庫不能自動建表空間，物理備庫正常

aaqwsh發表於2010-12-15
1   邏輯備庫不能自動建表空間
切換後邏輯備庫： ORA-17502: ksfdcre:4 Failed to create file +DATA/prirac/datafile/undotbs02.dbf
 

解決：

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部落格 ” ，連結：http://blog.itpub.net/758322/viewspace-681912/，如需轉載，請註明出處，否則將追究法律責任。

相關文章