【翻譯自mos文章】rman 備份時報:ORA-02396: exceeded maximum idle time,rmanora-02396

來源:互聯網
上載者:User

【翻譯自mos文章】rman 備份時報:ORA-02396: exceeded maximum idle time,rmanora-02396

rman 備份時報:ORA-02396: exceeded maximum idle time

參考原文:
RMAN backup faling with ORA-02396: exceeded maximum idle time, please connect again (Doc ID 1446182.1)

適用於:
Oracle Server - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.


癥狀:
rman 在備份db和歸檔日誌時,報下列的錯誤:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 03/26/2012 00:19:36
RMAN-03014: implicit resync of recovery catalog failed
RMAN-06004: ORACLE error from recovery catalog database: ORA-02396: exceeded maximum idle time, please connect again
ORACLE error from recovery catalog database: ORA-01012: not logged on
Process ID: 4060
Session ID: 24 Serial number: 23229


原因:
ORA-02396最有可能是 profile(with IDLE_TIME)導致的,該profile是指  Recovery Catalog 中的catalog owner

當執行rman備份的時候, rman 跟  Recovery Catalog  極少甚至不通訊。
只有當rman備份完成後,相關的資訊被從控制檔案同步到 Recovery Catalog ,此時,rman 嘗試更新 Recovery Catalog ,然後錯誤就產生了。

rman備份用的時間超過了 the catalog user's profile 中定義的idle_time,因此錯誤就出現了。

解決方案:
檢查recovery catalog owner  是否在使用 IDLE_TIME 的profile。 如果使用了,禁用掉或者增大idle_time到更大的值

SQL> select * from dba_profiles where resource_name='IDLE_TIME';

SQL> select profile from dba_users where username='<USERNAME OF CATALOG OWNER>';

If the profile of the user matches the profile with a IDLE_TIME <> UNLIMITED, you should consider using a different profile for this user with IDLE_TIME=UNLIMITED.

SQL> alter user xx PROFILE < name of a profile> with IDLE_TIME=UNLIMITED >


oracle閑置逾時,怎重新串連(急)

因為你使用的使用者被設定了最大空閑時間的profile
建議你如果遠端資料庫的使用者profile設定不能改,那每次使用完dblink後,及時關閉
用的時候再開啟
 

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.