There are two scripts for start/stop databases.
1. $ORACLE_HOME/bin/dbstart (start databases)
2. $ORACLE_HOME/bin/dbshut (stop databases)
These scripts look for database names in file /var/opt/oracle/oratab
In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows how to copy a database user from one database to another user DBMS_METADATA. It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows syntax for various backup options while discussing how the different basic backup types work. It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…