.

  Steps to Enable Encryption in Database   Step#1: Set Wallet location in sqlnet.ora file ## Add to $ORACLE_HOME/network/admin/sqlnet.ora file ENCRYPTION_WALLET_LOCATION =               (SOURCE = (METHOD = FILE)               (METHOD_DATA =               (DIRECTORY =/u01/app/oracle/product/19.26.0.0/db_1/network/admin/wallet)               ) ) Step#2: Create the wallet directory. In RAC, wallet directory should be shared location.   mkdir -p /u01/app/oracle/product/19.26.0.0/db_1/network/admin/wallet chmod 700 /u01/app/oracle/product/19.26.0.0/db_1/network/admin/wallet   Step#3: Create Password Based Keystore Sql> administer key management create keystore '/u01/app/oracle/product...

  RMAN BASIC COMMANDS   Sl. No. Tasks 1. RMAN Full Database Backup Script: This script performs a full backup of the entire database, including datafiles, control file, and spfile. RUN { ALLOCATE CHANNEL ch1 TYPE DISK; BACKUP DATABASE FORMAT '/backup/full_db_%t_%p%p' FILESPERSET 10; RELEASE CHANNEL ch1; ALLOCATE CHANNEL ch2 TYPE DISK; BACKUP CURRENT CONTROLFILE FORMAT '/backup/cntrl_%s_%p_%t'; RELEASE CHANNEL ch2; ALLOCATE CHANNEL ch3 TYPE DISK; BACKUP SPFILE FORMAT '/backup/spfile_%s_%p_%t'; RELEASE CHANNEL ch3; }   2. RMAN Incremental DB Backup Script: This script performs an incremental backup based on changes since the last full backup. RUN { ALLOCATE CHANNEL ch1 TYPE DISK; INCREMENTAL BACKUP DATABASE UNTIL TIME RECOVERABLE UNTIL TIME 'SYSDATE - 1'; RELEASE CHANNEL ch1; }   3. RMA...

ADRCI ·        command line interface for diagnostic utility ·        viewing diagnostics data like listener log , alert log ,incident and cor dump etc ·        creating incident packages Sl.No. Command Description 1. adrci> show base | set base /u01/app/grid Get/set current base location 2. adrci> show home | adrci> set homepath /u02/app/oracle List/Set ORACLE_HOME 3. adrci> show alert adrci> show alert -tail 100 View alert log 4. adrci> purge -age 600 -type ALERT adrci> purge -age 600 -type TRACE adrci> purge -age 600 -type incident adrci> purge -age 10080 -type cdump Purge alerts and trace files 5. adrci> show control — Get existing control policy adrci> ...