oracledatabase
Learnomate Technologies > oracledatabase
How to check oracle database status – Interview question
11
Jun
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, […]
Tags:
How to check oracle database status ,
oracle ,
oracle 12c ,
oracle admin ,
oracle Database ,
oracle dba ,
Oracle DBA Scripts ,
oracle training ,
oracledatabase ,
oracledba ,
training ,
RMAN oracle database 12c backup script
06
Jun
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 […]
Tags:
backupScript ,
oracle ,
oracle12c ,
oracleadmin ,
oracledatabase ,
oracledba ,
RMAN ,
Script ,