Converting a file system From ASM to Non-ASM in Oracle Database We are going to Converting a file system From ASM to Non-ASM in Oracle Database Check the database version…
Read MoreConverting a file system From Non-ASM to ASM in Oracle Database We are going to Converting a file system From Non-ASM to ASM in Oracle Database . Check the database…
Read MoreCHANGING A DATABASE NAME USING NEWID DBNEWID is a database utility that can change the internal database identifier (DBID) and the database name (DBNAME) for an operational database. The DBNEWID…
Read MoreReinstating a Failed Primary Database using Dataguard Broker Details : DETAILS SOURCE TARGET IP_ADDRESS 192.168.1.44 192.168.1.37 SERVER_NAME PRIMARY STANDBY DB_VERSION 12.2.0.1 12.2.0.1 DB_NAME DELL STANDBY The Primary Database DELL is…
Read MoreDataguard Failover Using DGMGRL Failover is an irreversible transition of a standby database to the primary role. This is only done in the event of a catastrophic failure of the…
Read MoreDataguard Switchover Using DGMGRL A switchover is a role reversal between the primary database and one of its standby databases. A switchover guarantees no data loss. This is typically done…
Read MoreDataguard Broker Configuration Description : Dataguard broker is used to automate monitoring and controlling standby setups. It is very much useful, when the organization has multiple standby sites. Broker keeps…
Read MoreOracle 19c Database Upgrade DETAILS SOURCE TARGET OS_VERSION OEL 6.4 OEL 6.4 DB_VERSION 12.2.0.1 19.3.0.0 DB_NAME PROD PROD ORACLE_HOME /u01/app/oracle/product/12.2.0.1/db_1 /u01/app/oracle/product/19.0.0/dbhome_1 INSTALL THE 19C BINARIES CREATE THE REQIRED DIRECTORIES &…
Read MoreTransportable Database from Linux to Windows Overview : – TDB requires that data files be converted to the target platform format. The data file conversion can occur on either the…
Read MoreThis Post describes about RMAN is hung or it is very slow / Clearing RMAN repository / Troubleshoot RMAN-06214 error RMAN> DELETE FORCE NOPROMPT OBSOLETE DEVICE TYPE DISK; If…
Read More