How to Find Oracle DB 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 Find Oracle DB Creation Date
V$DATABASE
How Oracle Find 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 Oracle Find 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
How RMAN Duplicate 19c Standby Database
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 RMAN Duplicate 19c Standby Database
How to Resolve ORA-01516 Error Message
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 »How to Resolve ORA-01516 Error Message