How Oracle Restore SPFILE
Timings to Restore SPFILE At several occasions listed below, you may need to restore it from a previously backed up SPFILE. SPFILE was accidentally deleted.… Read More »How Oracle Restore SPFILE
STARTUP NOMOUNT
How to Check Oracle Database Startup Time
Startup Time Varies To check Oracle database startup or restart time, we have to know the difference between instance startup time and database open time.… Read More »How to Check Oracle Database Startup Time
How to Resolve ORA-32002: cannot create SPFILE already being used by the instance
ORA-32002 Tried to restore the server parameter (SPFILE) to the default location from a parameter file (PFILE), but it failed with ORA-32002 like this. SQL>… Read More »How to Resolve ORA-32002: cannot create SPFILE already being used by the instance
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 to Change SPFILE Location in Oracle
ALTER SYSTEM SET SPFILE Before reading, you have to know that there's no ALTER SYSTEM SET SPFILE statement in Oracle, because we can never write… Read More »How to Change SPFILE Location in Oracle
How to Change Control File Location in Oracle
ALTER SYSTEM SET CONTROL_FILES In this post, I will show you how to change control file location in a single-instance and a cluster database. Change… Read More »How to Change Control File Location in Oracle
How to Move Oracle Database
Actually, this topic "How to Move Oracle Database" follows my previous post: How to Move ORACLE HOME. But I think it can be used in… Read More »How to Move Oracle Database
Duplicate a Standby Database (2/4) - With Backup-Based Duplication
Duplicate a Standby Database (1/4) - With Active Database Duplication Backup-Based duplication requires to connect to the target database, and one copy of database backups… Read More »Duplicate a Standby Database (2/4) - With Backup-Based Duplication
Duplicate a Standby Database (1/4) - With Active Database
Duplicate a Standby Database (0/4) - An Overview For 19c Standby database duplication, you may check the post: How to Duplicate a 19c Physical Standby… Read More »Duplicate a Standby Database (1/4) - With Active Database
How to Connect Idle, Nomount or Restricted Database Remotely
Connect an Idle, Nomount or Restricted Database Locally Users who belong to OSDBA or OSOPER can access a database in any states including idle, NOMOUNT… Read More »How to Connect Idle, Nomount or Restricted Database Remotely