ORACLEAGENT BLOG
By ramkumar
ORACLEAGENT BLOGMar 29, 2021
00:00
10:54
Performing point in time recovery using RMAN in 19c
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/01/performing-point-in-time-recoverry-using-rman-in-19c/
Mar 29, 202110:54
Recover a loss of all online redo log files using RMAN in Oracle 19c
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/01/recover-a-loss-of-all-online-redologs-log-files-using-rman-in-oracle-19c/
Mar 29, 202107:53
Resolve ORA-00210,ORA-00202,ORA-27041 and Restore A Loss Of Controlfile Using Autobackup in Oracle 19c
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/01/restore-a-loss-of-controlfile-using-autobackup-in-oracle19c/
Mar 29, 202112:16
Block change Tracking (BCT) in Oracle 19c – CTWR
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/01/block-change-tracking-bct-in-oracle-19c/
Mar 29, 202102:35
RMAN recovery through RESETLOGS
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/01/rman-recovery-through-resetlogs/
Mar 29, 202123:00
Recover Datafile Without Rman Backup in Oracle 19c
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/01/recovering-datafile-without-rman-backup/
Mar 29, 202139:48
AutoUpgrade 21c Release: New Features/Enhancements
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/01/autoupgrade-21c-release-new-features-enhancements/
Mar 29, 202106:46
SQL Profiles & Baselines
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/01/sql-profiles-baselines/
Mar 29, 202115:14
Oracle Database In-Memory concepts in 19c
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/03/oracle-database-in-memory-concepts-in-19c/
Mar 29, 202104:50
Change PDB name with DBNEWID Utility in 19c
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/05/change-pluggable-database-name-using-dbnewid-utility-in-19c/
Mar 29, 202103:04
RMAN
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/05/19c_rman/
Mar 29, 202101:12
UNDO scripts
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/05/undo-scripts/
Mar 29, 202107:60
TEMP scripts
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/05/temp-scripts/
Mar 29, 202106:24
Get DDL ‘s
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/11/get-ddl-s/
Mar 29, 202139:05
Session monitoring scripts
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/07/session-monitoring-scripts/
Mar 29, 202115:46
TUNING SCRIPTS
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/07/tuning-scripts/
Mar 29, 202101:13
UPGRADE ORACLE DATABASE FROM ORACLE 12.2.0.1 TO 19C USING DBUA
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/09/upgrade-oracle-database-from-oracle-12-2-0-1-to-19c-using-dbua/
Mar 29, 202126:56
Patch Oracle Home 19c (19.3 to 19.9)
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/09/upgrade-oracle-home-19c-19-3-to-19-9/
Mar 29, 202103:10:54
DBVERIFY
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/11/dbverify/
Mar 29, 202105:04
Database Upgrade from 12c to 19c using Datapump
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/11/database-upgrade-from-12c-to-19c-using-datapump/
Mar 29, 202148:42
SEND MAIL USING UTL_SMTP with attachment
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/13/mail-utl_smtp-with-attachment/
Mar 29, 202116:51
SEND MAIL USING UTL_SMTP
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/13/send-mail-utl_smtp/
Mar 29, 202105:37
Create and Configure ACLs in Oracle database
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/13/acl_oracle/
Mar 29, 202108:51
Oracle database Health check scripts
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/13/oracle-database-scripts_performance/
Mar 29, 202101:27
Configure Data guard physical Standby
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/20/oracle-dataguard-physical-standby/
Mar 29, 202125:25
How to Create a Compartment in Oracle Cloud Infrastructure (OCI)
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/23/how-to-create-a-compartment-in-oracle-cloud-infrastructure-oci/
Mar 29, 202103:08
How to Create SSH Keys Using Oracle Cloud Shell
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/24/how-to-create-ssh-keys-using-oracle-cloud-shell/
Mar 29, 202102:35
Upgrade Oracle Database Manually from 12.2 to 19c
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/26/upgrade-oracle-database-manually-from-12-2-0-1-to-19c/
Mar 29, 202144:43
How to change the db name using nid utility
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/28/how-to-change-the-db-name-using-nid-utility/
Mar 29, 202101:40
CREATING PLUGGABLE DATABASE (PDB) IN DBCA METHOD
This episode is also available as a blog post: oracleagent.wordpress.com/2021/01/19/multitenant/
Mar 29, 202101:45
Converting a physical standby database into snapshot standby database
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/28/converting-a-physical-standby-database-into-snapshot-standby-database/
Mar 29, 202107:06
Convert Physical standby to Logical standby Database
This episode is also available as a blog post: oracleagent.wordpress.com/2021/02/28/convertphysical-standby-to-logical-standy-database-in-19c/
Mar 29, 202104:18
Oracle 19c Binaries and Database installation
This episode is also available as a blog post: oracleagent.wordpress.com/2021/03/02/oracle-19c-binaries_database-installation/
Mar 29, 202105:07
Get size of the database
This episode is also available as a blog post: oracleagent.wordpress.com/2021/03/22/get-size-of-the-database/
Mar 29, 202101:40
Disable or enable all triggers of schema
This episode is also available as a blog post: oracleagent.wordpress.com/2021/03/22/disable-or-enable-all-triggers-of-schema/
Mar 29, 202101:06
row_count of all the tables of a schema
This episode is also available as a blog post: oracleagent.wordpress.com/2021/03/22/row_count-of-all-the-tables-of-a-schema/
Mar 29, 202101:22
Get sql query to html format
This episode is also available as a blog post: oracleagent.wordpress.com/2021/03/22/get-sql-query-to-html-format/
Mar 29, 202101:17
GET INDEX USAGE
This episode is also available as a blog post: oracleagent.wordpress.com/2021/03/22/get-index-usage/
Mar 29, 202101:16
Get installed sqlpatches in database
This episode is also available as a blog post: oracleagent.wordpress.com/2021/03/22/get-installed-sqlpatches-in-database/
Mar 29, 202101:53
How to Cleanup orphaned datapump jobs
This episode is also available as a blog post: oracleagent.wordpress.com/2021/03/22/how-to-cleanup-orphaned-datapump-jobs/
Mar 29, 202101:31
How to Get Alert log location in db
This episode is also available as a blog post: oracleagent.wordpress.com/2021/03/22/how-to-get-alert-log-location-in-db/
Mar 29, 202101:06
Check Installed RDBMS components
This episode is also available as a blog post: oracleagent.wordpress.com/2021/03/22/check-installed-rdbms-components/
Mar 29, 202101:11
Check the Characterset info of database
This episode is also available as a blog post: oracleagent.wordpress.com/2021/03/22/check-the-characterset-info-of-database/
Mar 29, 202101:04
How to View / Modify AWR retention period
This episode is also available as a blog post: oracleagent.wordpress.com/2021/03/22/how-to-view-modify-awr-retention-period/
Mar 29, 202101:24
Get timezone information in database
This episode is also available as a blog post: oracleagent.wordpress.com/2021/03/22/get-timezone-information-in-database/
Mar 29, 202101:11
Get DDL of privileges granted to user
This episode is also available as a blog post: oracleagent.wordpress.com/2021/03/22/get-ddl-of-privileges-granted-to-user/
Mar 29, 202102:01
Get database link details in database
This episode is also available as a blog post: oracleagent.wordpress.com/2021/03/22/get-database-link-details-in-database/
Mar 29, 202101:13
View hidden parameters
This episode is also available as a blog post: oracleagent.wordpress.com/2021/03/22/view-hidden-parameters/
Mar 29, 202101:04
How to find current redo log size in database
This episode is also available as a blog post: oracleagent.wordpress.com/2021/03/22/how-to-find-current-redo-log-size-in-database/
Mar 29, 202101:17
Generate Bulk AWR reports in database
This episode is also available as a blog post: oracleagent.wordpress.com/2021/03/22/generate-bulk-awr-reports-in-database/
Mar 29, 202103:22