DBA ACTIONS

Source OS: Windows 2012 R2 Target OS: Windows 2012 R2 OEM: 13c STEP 1: Download agent deployment files on OEM host server              Login into the EMCLI as sysman         D:\EMCC_13_4_Home\bin>emcli login –username=sysman         This will prompt you for password Synchronize the EMCLI so that it is upto date with repository         D:\EMCC_13_4_Home\bin>emcli sync Query the repository to check if agent image for supported platforms are in the repository                      D :\EMCC_13_4_Home\bin>emcli get_supported_platforms                   Download the agent (In my case it is Windows x64)         D:\EMCC_13_4_Home\bin>emcli get_agentimage –destination=C:\oem_agent –platform=”Microsoft Windows x64 (64-bit)” –version=13.4.0.0.0     ...

Why to use Data Guard? Following are the main reasons why we should configure Data Guard. 1. Data Guard provides HA (high availability), Data protection, disaster recovery. 2. It also provides consistent copies of production database, in case of production database is unavailable (may be planned or unplanned outage), We can convert Standby Database into primary role. 3. It reduces downtime in case of any outage to production environment. 4. Data Guard can also be used for Database Backup (To reduce load on Production Database). Data Guard Configuration: 1. Data Guard consist of one Primary Database and one or more Standby Database. 2. Databases in a Data Guard are connected by Oracle Net services. There is no restriction on where the databases should be located, provided they can communicate with each other. 3. We can manage Primary Database and Standby Database with SQLPLUS or through Data Guard Command-Line Interface ( DGMGRL ) . Types of Standby Database: 1. Physical Standby Datab...

Partial Restoration is the easiest way to check whether the backup of database which is taken on regular basis can be restored during any disaster situation, in another terms we can say partial restoration is done for backup contingency testing. In most cases where database size is in TBs we shouldn't restore full database just to check whether database backup that we are taking can be restored or not. So in this case we can perform Partial Restoration by just restoring mandatory tablespace and one of the application tablespace. Below are the steps that you are required to do to perform Partial Restoration of Oracle database. OS:- Linux/Aix Database Version:- 11g or Higher NOTE: - Make sure you have latest backup of Production which includes control file auto backup, if not then kindly create control file and transfer it to test server. Step 1: -  Create pfile on production SQL>  create pfile='/backuplocation/initSIDNAME.ora' from spfile; Step 2: -  Check o...

There is a way to gather statistics of all stale objects in a schema or in a whole database by using dbms_stats procedure. Before running the procedure you should check which stale objects are present in the database. For this you can query dba_tab_statistics  and dba_ind_statistics views. This views will show you all the stale objects in a database. select owner, table_name from dba_tab_statistics where stale_stats='YES'; select owner, index_name from dba_ind_statistics where stale_stats='YES'; *********************************************************************************** However if you want to check stale objects by using dbms_stats procedure before gathering statistics, then please refer metalink below : How to List the Objects with Stale Statistics Using  dbms_stats.gather_schema_stats options=>'LIST STALE' ( Doc ID 457666.1 ) *********************************************************************************** Now we know the details of stale objec...