2013年2月10日

Linux Error: 22: Invalid argument


Linux Error: 22: Invalid argument

Discription :
做完Switch Over之後,準備將Standby DB切回本來的Standby Role時,
發生了Linux Error: 22: Invalid argument。如下:

SQL> startup nomount pfile='/oracle/product/9.2.0/dbs/standby.ora';
ORA-27123: unable to attach to shared memory segment
Linux Error: 22: Invalid argument
Additional information: 1
Additional information: 2818053

[Oracle]ORA-16139: media recovery required - Solution


ORA-16139: media recovery required

Discription :

Switch Over 成功之後,準備再做一次Switch Over,將DB回復成原本的角色時,
發生 ORA-16139的錯誤。如下:

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY ;
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
*
ERROR at line 1:
ORA-16139: media recovery required