Standby Database for Read only Query problems.

I wanna compare two production databases data, so I created two standby databases for comparing data.

After opening database read only, I use minus function to compare the same table on each database.

There were some error raised:

ORA-16000: database open for read-only access

It was a strange error, because not all of these tables had this error.

After some testing, I found the root cause.

The standby database leak temp tablespace. It could not be created during rman recovery process.

So, I add temp file to temp tablespace. It worked.

ps. Since the database was read only, you can add file only, create or drop temp tablespace would

be failed.

有一次進行資料比對作業的測試，目標是二個standby database。

在資料庫開到read only mode後，利用minus 的函數去進行資料比對。

結果發生以下錯誤：

ORA-16000: database open for read-only access

在經過一番測試後，發現是temp tablespace在利用rman建置時遺漏了，因此在新增temp file後，問題就解決了。

注意：由於資料庫在READ ONLY的狀況下，建立或刪除temp tablespace都會產生錯誤。