Oracle Database Administration

Here is a simple manual process of copy an Oracle database. Ref: http://proora.com/oracle/copy_database 1. Copy $ORACLE_HOME/dbs/initSOURCE.ora to $ORACLE_HOME/dbs/initTARGET.ora change in initTARGET.ora:   db_name,   control_files,   user_dump_dest,   background_dump_dest,   core_dump_dest and may be audit_file_dest,log_archive_dest   Create the bdump, udump and cdump directories 2. Create the script that will re-create the controlfile ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS '/somedir/cre_controlfile.sql'; Remove everything up to the "START NOMOUNT" statement and everything after the semicolon at the end of the "CREATE CONTROLFILE" statement. Edit the line starting with "CREATE CONTROLFILE" and replace the word "REUSE" with the word "SET" right before the keyword DATABASE. On the same line, modify the database name changing it from SOURCE to TARGET. On the same line, change the ...

REF: http://www.arunsankar.in/2013/06/performance-issue-basic-checks.html?m=1 Oracle Performance Issues - Basic Checks What are the basic checks for a junior DBA when slowness reports in the system? Taking user inputs: This is the very first step for troubleshooting any performance issues, get user inputs.You may use the below tips for this. Is application is slow or any particular batch processing is slow? Slowness is observed through out the system or only few or one user Is it happening in some particular timing ? Is it slow right now? By collecting these information we will get an outline of what needs to be checked. Now login to system and start investigation. Check the resource utilization: You can check the CPU,Load,Memory utilization, use top or topas command in unix. Check any single process is holding the CPU for long time -- note the process ID. Press 'c' in top command, it will give you the time and process which is consuming more CPU. ...