SQL1116N A connection to or activation of database "TESTDB" cannot be made
[db2inst1@dporacle01 ~]$ db2 get db cfg for testdb | grep logretain
[db2inst1@dporacle01 ~]$ db2 get db cfg for testdb | grep -i logretain
Log retain for recovery enabled (LOGRETAIN) = OFF
[db2inst1@dporacle01 ~]$ db2 update db cfg for testdb using LOGRETAIN ON
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
[db2inst1@dporacle01 ~]$
[db2inst1@dporacle01 ~]$ db2 get db cfg for testdb | grep -i logretain
Log retain for recovery enabled (LOGRETAIN) = RECOVERY
First log archive method (LOGARCHMETH1) = LOGRETAIN
[db2inst1@dporacle01 ~]$
[db2inst1@dporacle01 ~]$ db2 backup db testdb to /tmp
Backup successful. The timestamp for this backup image is : 20201203080958
[db2inst1@dporacle01 ~]$ ls -l /tmp
total 164024
drwx------. 2 gdm gdm 4096 Dec 3 07:15 gconfd-gdm
drwx------ 2 root root 4096 Nov 26 09:25 gconfd-root
drwx------ 2 root root 4096 Dec 4 2020 keyring-1OuHkv
drwx------ 2 root root 4096 Feb 16 2019 keyring-a5G2O6
drwx------ 2 oracle oinstall 4096 Jun 6 12:33 keyring-Aq6gNH
drwx------ 2 root root 4096 Jul 19 2018 keyring-G1edTe
drwx------ 2 root root 4096 Oct 10 2019 keyring-gJAukV
drwx------ 2 oracle oinstall 4096 Feb 20 2020 keyring-GU3kqb
drwx------ 2 root root 4096 Nov 26 09:04 keyring-h1lbAS
drwx------ 2 root root 4096 Aug 5 2018 keyring-iEcUC2
drwx------. 2 root root 4096 Jul 19 2018 keyring-lwXAOj
drwx------ 2 root root 4096 Mar 19 2020 keyring-mlLOqW
drwx------ 2 root root 4096 Oct 25 2019 keyring-Ni4II5
drwx------ 2 root root 4096 Jun 21 18:11 keyring-nPtXlJ
drwx------ 2 root root 4096 Apr 3 2020 keyring-OD5mIk
drwx------ 2 root root 4096 May 19 2020 keyring-pYV2p1
drwx------ 2 oracle oinstall 4096 Dec 25 2018 keyring-sc8SLe
drwx------ 2 root root 4096 Dec 9 2020 keyring-teoFP4
drwx------ 2 root root 4096 Nov 7 13:21 keyring-ushTz4
drwx------ 2 root root 4096 May 13 2020 keyring-vSczY7
drwx------ 2 root root 4096 Apr 10 2020 keyring-ZypP2w
drwxr-xr-x 2 root sys 4096 Nov 25 2018 LOCAL_INSTALL
drwx------ 2 gdm gdm 4096 Dec 3 07:14 orbit-gdm
drwx------. 2 root root 4096 Nov 26 09:04 pulse-CPNFd1hkJpCg
drwx------. 2 gdm gdm 4096 Dec 3 07:14 pulse-XzWVToRk5SZc
drwx------ 2 oracle oinstall 4096 Jun 6 12:33 pulse-zza0ofGu5HpI
drwxrwxrwx 2 db2inst1 db2iadm1 4096 Dec 4 2020 SQLDIR.LK0
-rw------- 1 db2inst1 db2iadm1 167833600 Dec 3 08:10 TESTDB.0.db2inst1.NODE0000.CATN0000.20201203080958.001
drwx------ 2 root root 4096 Dec 4 2020 virtual-root.3BFjEo
drwx------ 2 root root 4096 Nov 26 09:04 virtual-root.9VVHWm
drwx------ 2 root root 4096 Dec 9 2020 virtual-root.kTnGBz
[db2inst1@dporacle01 ~]$ date
Thu Dec 3 08:10:15 CST 2020
[db2inst1@dporacle01 ~]$ db2 connect to testdb
Database Connection Information
Database server = DB2/LINUXX8664 9.7.0
SQL authorization ID = DB2INST1
Local database alias = TESTDB
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8520577/viewspace-2744574/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Error: Connection activation failed: Device not managed by NetworkManagerErrorAIdev
- ORA-01102: cannot mount database in EXCLUSIVE modeDatabase
- [20181011]ORA-65086 cannot openclose the pluggable database.txtDatabase
- [20181011]ORA-44777 – Pluggable database service cannot be started.txtDatabase
- Bug 12725963 - New database connection fails with ORA-12541 after vip failoverDatabaseAI
- Error establishing a database connection 的解決方法(發現黑客入侵)ErrorDatabase黑客
- Paxos Made Simple
- IDM-Activation-Script
- ORA-02062: distributed recovery 引起的 ORA-02019: connection description for remote database not foundREMDatabase
- Tomcat DBCP(Database Connection Pool) 資料庫連線池入門介紹TomcatDatabase資料庫
- The Mark by Stone and Flower Made
- oracle ORA-01102: cannot mount database in EXCLUSIVE mode(無法起到獨佔模式)OracleDatabase模式
- 人大金倉資料庫kingbase備份時老是提示sys_dump: error: connection to database or services資料庫ErrorDatabase
- nacos Connection refused (Connection refused)
- Database Connection Pool 資料庫連線池-01-概覽及簡單手寫實現Database資料庫
- Connection
- The database owner SID recorded in the master database differs from the database owner SID recorded in database 'DB_NAME'DatabaseAST
- java.net.ConnectException: Connection refused (Connection refused)JavaException
- Could not load type 'System.ServiceModel.Activation.HttpModule' from assembly 'HTTP
- Artificial、 synthetic和man made的區別
- 如何處理WordPress網站提示“建立資料庫連線時出錯”或“Error establishing a database connection”錯誤網站資料庫ErrorDatabase
- Oracle Database Cloud - Database as a Service Quick StartOracleDatabaseCloudUI
- Error querying database. XXXXXXXXXXXXX, No database selected。ErrorDatabase
- Convert a Physical Standby Database into a Snapshot Standby DatabaseDatabase
- Error:Can't connect to SOCKS proxy:Connection refused (Connection refused)Error
- nmcli connection reload
- Database TimeoutDatabase
- Database OverallDatabase
- database no shardingDatabase
- Oracle 12.2 使用Database Link優化Standby Database WorkloadOracleDatabase優化
- 684-Redundant Connection
- yarn socket connection timeoutYarn
- 關於Residual Connection
- ORACLE database vaultOracleDatabase
- Relationship Database DesignDatabase
- 3.4 Quiescing a DatabaseUIDatabase
- idea--DatabaseIdeaDatabase
- Oracle clone databaseOracleDatabase