Rac Dba
As RAC
DBA: ü Deploying a Flash Recovery Area in Oracle Real Application Clusters ü Archiving in Oracle Real Application Clusters ü Performing Backups of Your Oracle RAC Database ü Preparing to Restore and Recover Your Oracle RAC Database ü Recovering an Oracle RAC Database ü Managing the Database Backups. ü Displaying Backup Reports for Your Oracle RAC Database. ü BackUp Voting Disks ü After installation ü After adding nodes to or deleting nodes from the cluster. ü After performing voting disk add or delete operations. ü Adding and Removing Voting Disks ü Adding an OCR Location, mirroring ü Repairing OCR Configuration on a local node, OCRcheck utility. ü See all the nodes resource status using crs_ stat-t ü Check the daemon status on RAC database. ü Check CSS, CRS & EVM health status. ü Viewing No. Of Nodes configured in Cluster-olsnodes-n-p-i ü Track of active instances-v$ active_ instances ü Check how connections are distributed across the nodes. Project 2: Oracle Application server 10g & 11g(Implementation) Application Server DBA: ü Install, configure and monitor Oracle Application Server 10g ü Install, configure and monitor Oracle Report Server ü Monitoring CPU and memory usage in application servers. ü Monitoring the report jobs running on report servers. ü Monitoring and resolving any issues in the components of Application server namely HTTP Server, Webcache, Report Server, OC4J instance etc. ü Troubleshooting Connectivity issues from Client PC's. ü Managing and maintaining Oracle application Server 10g. ü Assisting the developers in developing efficient SQL code to access and manipulate database objects. ü Scheduling and Monitoring Backup's. ü Staging Application Server for Development purposes. Project 3: Oracle 10g installation on HP-UX(Implementation) Involved in analysis, design, plan to use the storage options for the database. Like type of files, storage options, naming conventions & proper sizing. Given required HP-UX patches to HP team which are pre-requisites for Oracle RDBMS Creating users, roles and granted privileges Controlling and monitoring user access to the database(Using TOAD) Configuration of TCP/IP protocol, Listeners, SQLNET and Tnsnames. Maintaining archived data on multiple disk. Troubleshoot connectivity issues on Client Systems Scheduled backups for the Oracle Database. Interacted with