How to Check DB Status by Script
To check if a databae is alive or not, we already have a way to do it. However, such script can't tell NOMOUNT, MOUNT or… Read More »How to Check DB Status by Script
V$DATABASE
How to Resolve ORA-32589: unable to drop minimal supplemental logging
ORA-32589 Tried to drop the minimal supplemental logging from the database, but it failed with ORA-32589. SQL> alter database drop supplemental log data; alter database… Read More »How to Resolve ORA-32589: unable to drop minimal supplemental logging
How to Resolve ORA-16000: database or pluggable database open for read-only access
ORA-16000 Tried to update some rows, but it failed with ORA-16000. SQL> update employees set first_name = 'Ed' where last_name = 'Chen'; update employees set… Read More »How to Resolve ORA-16000: database or pluggable database open for read-only access
How to Resolve ORA-02030: can only select from fixed tables/views
ORA-02030 Tried to grant SELECT object privilege of V$SESSION to an user, but it failed with ORA-02030. SQL> grant select on v$session to erpapp; grant… Read More »How to Resolve ORA-02030: can only select from fixed tables/views
Oracle Controlfile Types
CONTROLFILE_TYPE After solving ORA-01610, you might have a question: how do I know the currently used controlfile is a BACKUP one or not? We take… Read More »Oracle Controlfile Types
How to Check Database Creation Date
Database Creation Date A simple way that can check the creation date of a database. When the data is running, no matter the instance is… Read More »How to Check Database Creation Date
Database States Differentiations in Oracle
We have already known that there're 4 states in life cycle of an instance. They are idle, nomount, mount and open. In this post, we… Read More »Database States Differentiations in Oracle
How to Find Oracle DBID
DBID Database Identifier (DBID) is a unique number that can be identified by RMAN so as to do backup and restore whenever needed. In some… Read More »How to Find Oracle DBID
How to Resolve ORA-01152: file 1 was not restored from a sufficiently old backup
When I tried to open the standby database to READ ONLY for later real-time query of Active Data Guard (ADG), I got this error message.… Read More »How to Resolve ORA-01152: file 1 was not restored from a sufficiently old backup
How to Start Oracle Database
Start Oracle Database To start an Oracle database, you have to know which database you want to start. This includes at least two things, Oracle… Read More »How to Start Oracle Database