Contenting Logo

News

Entertainment

Science & Technology

Sport

Business & Money

Life

Culture & Art

Hobbies

Sites
Lists
#tags
  1. home
    2. ›
  2. Make DBA Life Easy Blog

Make DBA Life Easy Blog

8 | Follower

Software

See All

Make DBA Life Easy Blog

01.03.2025

Convert RAC Physical Standby To Snapshot Standby – Make DBA Life Easy

Note: For snapshot standby, you do not need Flashback enabled at database level Convert physical standby to snapshot standby On Standby Database SQL> select name, open_mode from v$database;NAME OPEN_MODE--------- -----------TESTDB MOUNTEDSQL> alter database convert to snapshot standby;alter database convert to snapshot standby*ERROR at line 1:ORA-38784: Cannot create restore point 'SNAPSHOT_STANDBY_REQUIRED_02/28/202521:40:27'.ORA-01153: an incompatible media recovery is…

Make DBA Life Easy Blog

02.03.2025

Physical Standby Data Guard Health Check – Make DBA Life Easy

Check N+1 standby redo logs are created on both primary and standby -- on primary SQL> SELECT thread#, group#, sequence#, bytes, archived, status FROM v$standby_log order by thread#, group#; THREAD# GROUP# SEQUENCE# BYTES ARC STATUS---------- ---------- ---------- ---------- --- ---------- 1 11 0 1073741824 YES UNASSIGNED 1 12 0 1073741824 YES UNASSIGNED 1 13 0…

Make DBA Life Easy Blog

07.03.2025

OPW-00021: Failed to retrieve DB password file location from the CRS resource – Make DBA Life Easy

When create Oracle password file in ASM, the following errors occur: $ orapwd file='+DATA1/TESTDB/PASSWORD/pwdTESTDB' dbuniquename='TESTDB'Enter password for SYS:OPW-00021: Failed to retrieve DB password file location from the CRS resource RESOLUTION Add database and instances into CRS by running 'srvctl', but do not specify "-pwfile '+DATA1/TESTDB/PASSWORD/pwdTESTDB': $ srvctl add database -d TESTDB -oraclehome /u01/app/oracle/product/19.0.0/dbhome_1 -dbtype RAC…

Make DBA Life Easy Blog

12.03.2025

OEM Generic Alert Log Error With Message “Dumping Current Patch Information” – Make DBA Life Easy

Database alert log shows entry of patch description injected in alert log (this is a RDBMS feature which is introduced) Solution From RDBMS side: Set below parameters defined at the spfile or pfile level in the database, to avoid dumping the patch information in alert log. -- To avoid dumping the parameters information_log_segment_dump_parameter=FALSETo avoid dumping the…

Contenting Logo
About UsPrivacy PolicyTerms Of UseContact