How to check oracle database status – Interview question

let us find out the database health status by using following sql command. Check whether the Oracle Process run or not#> ps -ef | grep pmon If no pmon detected, your database... Read more »

How to connect to pluggable database – Interview question for oracle DBA

Read more »

How to convert Physical Standby database to Snapshot Standby Database-DataGuard

Read more »

How to install and connect to sql developer-ORACLE DBA

Read more »

RMAN oracle database 12c backup script

Change RMAN backup location configure channel device type disk format '/data/backup/%U' maxpiecesize 2 G; SPFILE backups The SPFILE can be automatically backed up with the control file during database backups by configuring... Read more »