Oracle - SQL - MySQL DBA - Life Long Learning Experience

Create Standby Database using 12c DUPLICATE FROM ACTIVE DATABASE Purpose This note explains the procedure of creating a Physical Standby database using 12c RMAN DUPLICATE FROM ACTIVE DATABASE feature which is available since 11g Release 1 onwards. This enables us to create a physical standby database without having to take a backup of the primary database as a prerequisite step. Environment Primary Database DB_UNIQUE_NAME: dgtest1_pri Standby Database DB_UNIQUE_NAME: dgtest1_sby ORACLE_SID: dgtest1 Primary hostname: kphqdbrm01ord Standby hostname: kphqdbrm02ord Oracle software version: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Enable Force Logging on the Primary database SQL> alter database force logging; Database altered. Create the password file on the Standby host Note  - ensure that the same password is used as the one used while creating the password file on the Primary host dgtest1:/app/oracle/product/12.2.0/dbhome_1/dbs> orapwd file=orapwdgtest1...

Steps to Export & Import NFS Server Permissions of  Windows Server°2012R2 Using Powershell Export NFS share permissions To export the NFS share permissions for all the NFS shares, type: PS C:\tmp> Get-NfsShare | Get-NfsSharePermission | Export-Clixml NfsSharePermission.xml Next, update the host configuration information using the following steps. You can ignore these steps if the net name and host names are going to remain the same. Open the file where the exported permissions are located (for example, c:\tmp\NfsSharePermission.xml). Find the network name and host name, and then rename them as appropriate. If necessary, update the location of the directory path. Save the file that contains the exported permissions (such as c:\tmp\NfsShares.xml).     Import NFS share permissions   Before performing this step, make sure that the Nfssharepermission.xml file is updated with the correct server names. To import NFS...

Tool that helps to diagnose SQL statements performing poorly SQLT Overview SQLTXPLAIN, also known as SQLT, is a tool provided by Oracle Server Technologies Center of Expertise - ST CoE. SQLT inputs one SQL statement and outputs a set of diagnostics files. These files are commonly used to diagnose SQL statements performing poorly. SQLT connects to the database and collects execution plans, Cost-based Optimizer CBO statistics, schema objects metadata, performance statistics, configuration parameters, and similar elements that influence the performance of the SQL being analyzed. Install Instructions : Download sqlt_latest.zip to the server and unzip its contents into the staging area .   During the installation you will be asked to enter values for these parameters: Optional Connect Identifier (mandatory when installing in a Pluggable Database) In some restricted-access systems you may need to specify a connect identifier like @PROD . If a connect ...