V$DATABASE

How to Resolve ORA-02030: can only select from fixed tables/views

by Ed Chen
March 30, 2022April 9, 2022

ORA-02030 Tried to grant SELECT object privilege to an user, but it failed with ORA-02030. SQL> grant select on v$session to erpapp; grant select on… Read More »

Oracle Controlfile Types

by Ed Chen
November 20, 2021April 5, 2022

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 the… Read More »

How to Check Database Creation Date

by Ed Chen
June 21, 2021June 2, 2022

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 »

Database States Differentiations in Oracle

by Ed Chen
February 10, 2021July 1, 2022

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 »

How to Find Oracle DBID

by Ed Chen
December 30, 2020July 1, 2022

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 Resolve ORA-01152: file 1 was not restored from a sufficiently old backup

by Ed Chen
March 18, 2020December 1, 2021
4 Comments

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 Start Oracle Database

by Ed Chen
September 28, 2019June 8, 2022

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 RMAN Duplicate 19c Standby Database

by Ed Chen
August 11, 2019October 10, 2021
4 Comments

You don't have to create an empty database on the standby server for building a standby database. In this post, I will show you how… Read More »

How to Resolve ORA-01516 Error Message

by Ed Chen
June 24, 2017April 1, 2022

ORA-01516: nonexistent log file, datafile, or temporary file There're two scenarios that throw ORA-01516 going to be introduced in this post. 1. Rename Tempfile I… Read More »