Modern Oracle DBA

Step1: Login and choice the system Administrator Responsibility and choice                            profile->system Step2:   Query the profile option in “ SITE%” Step3: Change the site name in your environment name like DEV,UAT,etc… Step4: Save the settings and logout the application after login and check your modified site name in EBS

What is RMAN (Recovery manager): I covered theoretical part of RMAN.the RMAN utility is performing backup, restore and recovery operation in oracle Database  RMAN Features: Backup the database, tablespace, datafiles, control files and archive logs  Store the frequently executed backup and recovery operations Its perform the incremental level backup Skip the unused blocks Types of connection in RMAN: There are three types of connection available in RMAN Target database: It is connected to target database with in SYSDBA privilege. Recovery catalog database: This is optional database which is configured for the RMAN repository Auxiliary database: Auxiliary database provide the three types of connection Duplicate database TSPITR instance Standby database This connection is using RMAN duplicate command or it may be a temporary database that is used during Tablespace point-in-time recovery (TSPITR) Standby db is a cop

I explained Cloning step by step procedure for database and R12.2 application. My Database version 11.2.0.3.0         1. Preclone db tier and application Tier     2. Copy the apps Tier  and db home only to target server     3. Take Rman full backup and copy the backup to target server            cd [RDBMS ORACLE_HOME]/appsutil/clone/bin              $ perl adcfgclone.pl dbTechStack                         Run adcfgclone dbTechStack This files are to be restored to a different location: db_file_name_convert=('/oracle/PROD/db/data' , '/oracle/CLONE/db/data') log_file_name_convert=('/oracle/PROD/db/data' , '/oracle/CLONE/db/data') $ sqlplus '/as sysdba' SQL> startup nomount pfile='/<path>/initCLONE.ora'; This will nomount  the instance using the initCLONE.ora created. Prepare for duplicate by starting the auxiliary instance Create New Folder #mkd