Marvin Lapid
Oracle Database Systems Engineer
Marvin Lapid is an Oracle DBA for XTIVIA, working with Oracle for the Virtual-DBA team. Marvin’s technical experience started in application support for a retail software company in which he was able to expand his knowledge in SQL Server database and Windows Administration. He is an Oracle Database 12c Administrator Certified Associate and is working towards becoming an Oracle Certified Professional. Marvin enjoys learning and trying out new technologies. In his free time, Marvin plays games on PC and builds/fixes stuff for his house.
How to Identify the Problematic Session and SQL Statement Behind ORA-1652
Identifying the exact SQL statement causing ORA-1652 can often be challenging and time-consuming. Understand that Oracle uses temporary tablespaces as work areas for tasks such as sorting operations for users and sorting during index creation. Increasing the temporary... read more
Data Guard Database Migration and Upgrade to 19c Using Oracle AutoUpgrade
After completing several database migration and upgrade projects, utilizing Data Guard to migrate the database has been my preferred method when minimal downtime is required, and Golden Gate is not an option. From 11.2.0.1 onwards, it is possible to configure the... read more
Cloning 19c Oracle Home on RAC
Starting from Oracle19c cloning your oracle home is a bit different, whether you use this method for out of place patching or rolling out patches to multiple servers we no longer use clone.pl, instead oracle recommends using the software-only install option, available... read more
Refreshing a Physical Standby Using Recover from Service on 12c
If you’re in a situation where you need to resolve a gap in a Data Guard environment due to missing/corrupt archive logs, rolling forward the Physical Standby would be your best option vs. having to rebuild your entire physical standby database. It has become... read more