Procedure for operation and monitoring EVERY Oracle RAC 12c, 11g database in Vietnam | Tran Van Binh

TABLE OF CONTENTS 1. Purpose 5 2. Scope of application 5 3. CONNECT WITH PROFESSIONAL TRAN VAN BINH: 5 4. List of administrative servers 5 5. Daily operations 6 5.1. Monitor system status 6 5.1.1. Monitor the status of resources 6 5.1.2. Check Listener 7 status 5.1.3. Check status of ASM 8 5.1.4. Check Database 9 5.1.5 operation. Check Database 9 Instance Status 5.1.6. Check cluster log 10 5.1.7. Check Log Database 10 5.1.8. Check capacity ASM Group 11 5.1.9. Check Tablespace 11 5.1.10 capacity. Check Invalid Object 12 5.1.11. Check unused index 12 5.1.12. Check tables for missing statistics 13 5.2. Basic system operations 13 5.2.1. Startup/Shutdown Clusterware Oracle RAC 13 5.2.2. Startup/Shutdown Oracle database 14 5.2.3. Startup/Shutdown ASM 16 5.2.4. Start/Stop Oracle Listener 17 5.2.5. Start/Stop Oracle Resource 19 6. Advanced Operating Procedures 19 6.1. Mount/Dismount DISKGROUP ASM 19 6.2. Create/Drop DISKGROUP ASM 20 6.3. Add/Drop ASM disk 21 6.3.1. Perform add disk on OS 21 6.3.2. Add disk to ASM group 24 6.3.3. Drop disk in diskgroup 24 6.4. Backup/Restore 26 6.4.1. Backup cluster configuration 26 6.4.2. Restore cluster configuration 26 6.4.3. Backup Database 28 6.4.4. Restore Database 30 6.5. Managing users on the database 31 6.5.1. Create User/Role 31 6.5.2. Change password 32 6.5.3. Unlock account 32 6.5.4. Lock account 33 6.6. Oracle administrator parameter 33 6.7. Managing Control files 33 6.8. Redo log administration 34 6.9. Managing tablespaces and Datafiles 35 6.9.1. Create new tablespace 35 6.9.2. Create temporary tablespace 36 6.9.3. Add Datafile for tablespace 36 6.9.4. Add datafile for temp tablespace 36 6.9.5. Drop tablespace 37 6.9.6. Drop temp tablespace 37 6.9.7. Drop datafile 37 6.9.8. Drop 1 tempfile 38 6.10. Check session lock 38 6.11. Kill session (session) hang 38 6.12. Delete Archived log 39 6.13. Rebuild Index 39 6.14. Compile object 39 6.15. Gather statistics 40 6.16. Adjust RAM/Process allocation for database 41 6.17. Managing and operating multitenants database 41 6.17.1. Create Pluggable database 43 6.17.2. Drop Pluggable database 48 7. Checklist operations to ensure the system is working properly (checklist) 51 8. Instructions to fix some basic errors 53 8.1. Archived log error 53 8.2. Error not writing data due to full tablespace 53 8.3. Error No longer Process to process 54 8.4. Error cannot open more Cursor 54 8.5. Handling Block corrupt error 54 —– Quickly register for the “Oracle DBA AZ Enterprise” Course to quickly become a professional DBA. In this course, you will receive full knowledge, tools, and processes about Oracle Database, RAC, Tunning, SQL, PL/SQL, OS, etc. to be able to operate ANY DATABASE large or small. online 24/7. Those of you in Hanoi, Da Nang, Ho Chi Minh or abroad all register to learn, inbox, zalo (090.29.12.888) for detailed information: or * Oracle is the leading database in the world. and used by many large enterprises in the world and Vietnam. Do you want to become an Oracle database administrator step by step? If the answer is YES, then SUBSCRIBE to the CHANNEL to be updated with the latest videos. * CONNECT WITH TRAN VAN BINH: Connect with me for the best support on Oracle Database, Tunning, Security, RAC, DataGuard, GoldenGate, Solaris, Linux, AIX and WebLogic: ? Mail: tranbinh48ca@gmail.com ☎️ Mobile: 0902912888 ?️ Website: ?️ Fanpage: ?‍ Facebook: ? Youtube: ?‍?‍?‍? Group FB: ?‍ Messenger: ⚡️ Skype: tranbinh48ca ?‍Twitter: ?‍Linkin: ? Blogger: Comment what you like Comment down below ️✏️✏️, I will help you on your way to becoming an Oracle DBA expert, let’s “Enhance Vietnamese DBA” ‍??‍??‍? Thank you ??? Tag : oracle, database, oracle database tutorial, database administration, data management, database, data comparison, database, database architecture, oracle administration tri oracle, learn oracle, optimize oracle, i uu oracle, tunning sql, sql tunning, performance tunning, backup, recovery, backup, restore, resource manager, user management, database security, storage, oracle scheduler, rac, dataguard, goldengate, weblogic, solaris, unix, aix, linux, flashback, sql, pl sql #OracleDatabase #OracleDatabaseTutorial #HocOracleDatabase #QuanTriCoSoDuLieuOracle #OracleBackup #OracleRecovery #ToiUuCoSoDuLieu #BaoMatCoOldris #UniLieu #Active

Concluzion: Quy trình vận hành, giám sát MỌI cơ sở dữ liệu Oracle RAC 12c, 11g tại Việt Nam | Trần Văn Bình – oracle,database,oracle database tutorial,quản trị cơ sở dữ liệu,quan tri co so du lieu,cơ sở dữ liệu,co so du lieu,kiến trúc cơ sở dữ liệu,quản trị oracle,quan tri oracle,học oracle,tối ưu oracle,sql tunning,performance tunning,backup,recovery,bảo mật cơ sở dữ liệu,storage,rac,dataguard,goldengate,weblogic,solaris,unix,aix,linux,sql,pl sql

source