oracledatabase

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 might be down Check the instance status SQL>select instance_name, status from v$instance; Check whether the database can be read or write SQL>select name, …

How to check oracle database status – Interview question 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 the CONTROLFILE AUTOBACKUP parameters To backup up the SPFILE explicitly use: RMAN> BACKUP SPFILE; Controlfile backups The current controlfile can be automatically backed …

RMAN oracle database 12c backup script Read More »