【ORA-02011】duplicate database link name
故障描述删除物化视图信息进行重建,在进行dblink的创建过程时,由于没有删除之前创建的dblink导致新的dblink无法使用之前使用过的名字。SYS@EMREP> select db_link,owner from dba_db_links;DB_LINK--------------------------------------------------------------------------------OWNER---------------------...
【ORA-01154】database busy.Open,close,mount and dismount not allowed now
故障描述 使用DGbroker从备库切换到主库后 ,使用sql语句将备库(standby database)置为read only模式时出现ora-01154错误。DGMGRL> switchover to prodPerforming switchover NOW, please wait...Operation requires shutdown of instance "SBDB" on database "sbdb"Shutting down instance "SBD...
【ORA-38760】This database instance failed to turn on flashback database
SQL> alter database open;alter database open*ERROR at line 1:ORA-38760: This database instance failed to turn on flashback databaseSQL> alter database flashback off;Database altered.SQL> alter database open;alter database open*ERROR at line 1:ORA-38760: This database instance failed...