SYMPTOM On primary database side, ORA errors in alert log: Errors in file /u01/app/oracle/diag/rdbms/testdb001/TESTDB001/trace/TESTDB001_arc4_10114.trc: ORA-07286: cannot obtain device information. ARC4: FAL archive failed with error 7286. See trace for details …
Read MoreINTRODUCTION This blog is about, one of our non-prod OEM13C environment the Database target status was showing warning eventhough the target is actually up and running. SOLUTION Login into OEM…
Read MoreOVERVIEW: Oracle Autonomous Transaction Processing (ATP) is a cloud-based, fully managed database service by Oracle. It automates administrative tasks, enabling users to focus on application development. ATP is optimized for…
Read MoreINTRODUCTION SQL tuning is the process of improving SQL queries to accelerate your servers performance. It’s general purpose is to reduce the amount of time it takes a user to…
Read MoreBlock changing tracking improves the performance of incremental backups by recording changed blocks in the block change tracking file. During an incremental backup, instead of scanning all data blocks to identify which blocks have changed, RMAN uses this file to identify the changed blocks that need to be backed up. TO ENSURE THE CURRENT PERFORMANCE OF INCREMENTAL BACKUPS: SQL> select SESSION_KEY, INPUT_TYPE, STATUS, to_char(START_TIME,’mm/dd/yy hh24:mi’) start_time, to_char(END_TIME,’mm/dd/yy hh24:mi’) end_time, elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS order by session_key; The above command will show the performance of daily incremental backups. i.e., How many hours the database backup is running before enabling the block change tracking. TO ENSURE THE BLOCK CHANGE TRACKING IS ENABLED IN THE DATABASE: SQL> select status, filename from v$block_change_tracking; It will show the block change tracking is enabled in our database or not. If it shows disabled, we want to enable the parameter by issue the below command. SQL> alter database enable block change tracking; NOTE:- After enables the BLOCK_CHANGE_TRACKING, wait for a day to complete the database backup. Then issue the above command to ensure the incremental backup performance. It will show you the positive differences compares to the earliest performance.
Read MoreORA-20004: Error in sending an Email – You have exceeded the maximum number of email messages per workspace. Please contact your administrator. REASON: Actually, Number of mails can be sent…
Read MoreBEFORE WE HAVE CHECK THE OPATCH VERISON AND LAST UPDATE CHECK OPATCH VERSION [oracle@kaamesh OPatch]$ pwd /u01/app/oracle/product/19.0.0/dbhome_1/OPatch [oracle@kaamesh OPatch]$ [oracle@kaamesh OPatch]$ opatch version OPatch Version: 12.2.0.1.33 OPatch succeeded. CHECK LAST…
Read MoreBefore cloning we have to take full database backup using RMAN Target / COMMAND: RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Once completed,move the backup file to target server USING SCP BACKUP…
Read More