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

19.02.2025

Oracle ASM Thin Provisioned Attribute and Reclaim Storage Space – Make DBA Life Easy

ASMFD Installation & Configuration Verify the ASM Filer Driver (AFD) Kernel module has been loaded. $ lsmod | grep afdoracleafd 226702 1 To confirm ASM Filter Driver has already been installed, loaded, is supported and versions, use afddriverstate installed | loaded | supported | version. $ afddriverstate installedAFD-9203: AFD device driver installed status: 'true'$ afddriverstate loadedAFD-9205:…

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…

Contenting Logo
About UsPrivacy PolicyTerms Of UseContact