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

Level 0 Backup – Backup of spfile,control file ,database and archivelog RUN { ALLOCATE CHANNEL ch11 TYPE DISK MAXPIECESIZE 10G; ALLOCATE CHANNEL ch12 TYPE DISK MAXPIECESIZE 10G; ALLOCATE CHANNEL ch13 TYPE DISK... Read more »