Activate Standby Database

How to Resolve ORA-01196 and ORA-01110

by Ed Chen
March 20, 2016December 12, 2022

ORA-01196 Saw errors ORA-01196 thrown by the database when trying to activate a standby database. SQL> alter database activate standby database; alter database activate standby… Read More »

How to Resolve ORA-16009: remote archive log destination must be a STANDBY database

by Ed Chen
March 22, 2015August 5, 2020

Saw an error in the alert log.... Sat Mar 21 10:28:48 2015Errors in file /oracle/admin/ORCL/bdump/orcl_arc0_9548203.trc:ORA-16009: remote archive log destination must be a STANDBY databaseThere may… Read More »

How to Resolve ORA-25153: Temporary Tablespace is Empty

by Ed Chen
March 14, 2015March 20, 2023
2 Comments

ORA-25153 After activating a physical standby database, I found some SQL statements returned ORA-25153: Description ORA-25153: Temporary Tablespace is Empty Cause An attempt was made… Read More »