ORA-38753 ORA-01110錯誤

08:46:55 SQL> shutdown immediate;

資料庫關閉.

資料庫已卸載.

已關閉 ORACLE 執行處理.

08:53:00 SQL> startup mount;

ORACLE 執行處理已啟動.

Total System Global Area 6747725824 bytes

Fixed Size                  2213976 bytes

Variable Size            3623880616 bytes

Database Buffers         3087007744 bytes

Redo Buffers               34623488 bytes

資料庫已掛載.

08:53:14 SQL> flashback database to timestamp to_timestamp('2013/01/30 08:22:20','yyyy/mm/dd hh24:mi:ss');

flashback database to timestamp to_timestamp('2013/01/30 08:22:20','yyyy/mm/dd hh24:mi:ss')

 ERROR 在行 1:

ORA-38753: 無法倒溯資料檔 3; 沒有倒溯日誌資料.

ORA-01110: 資料檔 3: '/u/oracle/product/oradata/test/undotbs01.dbf'

08:54:05 SQL> alter database open;

08:56:59 SQL> conn / as sysdba

已連線.

08:57:04 SQL> select ts#,name, included_in_database_backup,flashback_on from v$tablespace;

       TS# NAME                                 INCLUD FLASHB

---------- -------------------------------------------------- ------ ------

         0 SYSTEM                                      YES    YES

         1 SYSAUX                                      YES    YES

         2 UNDOTBS1                                   YES    YES

         4 USERS                                       YES    YES

         3 TEMP                                       NO     YES

         6 EXAMPLE                                    YES    YES

         7 TEST                                        YES    YES

已選取 7 個資料列.

08:58:57 SQL> alter tablespace temp flashback on;

alter tablespace temp flashback on

 ERROR 在行 1:

ORA-01126: 資料庫必須在此執行處理掛載, 並且未在任何執行處理開啟

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16381228/viewspace-753543/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16381228/viewspace-753543/