Installation/Configurations12c

RMAN backup and logical backup With Different User Step 1: Create the user CREATE USER bkp_user IDENTIFIED BY bkp_user DEFAULT TABLESPACE users TEMPORARY  TABLESPACE temp PROFILE DEFAULT;  GRANT CONNECT TO bkp_user;  GRANT exp_full_database TO bkp_user;  GRANT imp_full_database TO bkp_user;  GRANT recovery_catalog_owner TO bkp_user;  GRANT select_catalog_role TO bkp_user;  GRANT CREATE SESSION TO bkp_user;  Step 2: Connect RMAN with the Above Created User …

Oracle RMAN Commands List Here is the list of key most RMAN commands that are used for Backup and related activities:   LIST Commands LIST Commands are generic RMAN commands …

Rac Voting Disk The Voting Disk File is a file on the shared cluster system or a shared raw device file. Voting disk a key component of clusterware and its …

CRS Administration   CRS Administration starting ## Starting CRS using Oracle 10g R1 not possible ## Starting CRS using Oracle 10g R2 $ORA_CRS_HOME/bin/crsctl start crs stopping ## Stopping CRS using …

How To Add Redo Logfiles In Standby Database   Step 1. First, Check MEMBER present in Standby Database. SQL> select member from v$logfile; MEMBER ———————————- E:\STANDBYLOGS\REDO03.LOG E:\STANDBYLOGS\REDO02.LOG E:\STANDBYLOGS\REDO01.LOG   Step 2. …

RAC General Administration   Managing the Cluster starting /etc/init.d/init.crs start crsctl start crs stopping /etc/init.d/init.crs stop crsctl stop crs enable/disable at boot time /etc/init.d/init.crs enable /etc/init.d/init.crs disable crsctl enable crs …

Oracle RAC Daemons and Processes   OPROCd Process Monitor provides basic cluster integrity services EVMd Event Management spawns a child process event logger and generates callouts OCSSd Cluster Synchronization Services …

RAC Useful Parameters cluster_interconnects specify a specific IP address to use for the inetrconnect _gcs_fast_config enables fast reconfiguration for gcs locks (true|false) _lm_master_weight controls which instance will hold or (re)master …

RAC Useful Views And Tables GCS and Cache Fusion Diagnostics v$cache contains information about every cached block in the buffer cache v$cache_transfer contains information from the block headers in SGA …