We help IT Professionals succeed at work.

Physical Standby Problems

k_murli_krishna
on
I setup standby database in same Windows XP system as primary in same Oracle 9i r2 server.
Here is the status:
SQL> conn sys/margumush@primary as sysdba
ERROR:
ORA-12520: TNS:listener could not find available handler for requested type of
server

Warning: You are no longer connected to ORACLE.

SQL> RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Media recovery complete.

SQL> RECOVER MANAGED STANDBY DATABASE CANCEL;
Media recovery complete.
SQL> ALTER DATABASE OPEN READ ONLY;
ALTER DATABASE OPEN READ ONLY
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\STANDBY\SYSTEM01.DBF'

On primary:

SQL> select dest_id,destination, archived_seq#, status,error from v$archive_dest_status;

   DEST_ID DESTINATION          ARCHIVED_SEQ# STATUS    ERROR
---------- -------------------- ------------- --------- ---------------------------------
         1 D:\oracle\ora9i2\RDB             0 VALID
           MS

         2                                  0 INACTIVE
         3                                  0 INACTIVE
         4                                  0 INACTIVE
         5                                  0 INACTIVE
         6                                  0 INACTIVE
         7                                  0 INACTIVE
         8                                  0 INACTIVE
         9                                  0 INACTIVE

   DEST_ID DESTINATION          ARCHIVED_SEQ# STATUS    ERROR
---------- -------------------- ------------- --------- ---------------------------------
        10                                  0 INACTIVE

10 rows selected.
On standby:
SQL> select process, status, thread#, sequence#, block#, blocks from v$managed_standby;

PROCESS STATUS          THREAD#  SEQUENCE#     BLOCK#     BLOCKS
------- ------------ ---------- ---------- ---------- ----------
ARCH    CONNECTED             0          0          0          0
ARCH    CONNECTED             0          0          0          0

What is all this to do with? Missing steps. Wrong order of steps? Incorrect init.ora OR NET 8 configuration? Please do advise.
Comment
Watch Question

ORA-12520: TNS:listener could not find available handler for requested type of server

Cause: None of the known and available service handlers for requested type of server (dedicated or shared) are appropriate for the client connection.

Action: Run "lsnrctl services" to ensure that the instance(s) have registered with the listener and that the appropriate handlers are accepting connections.
--------------------------------------------------------------------------------------------------------------------------
ORA-16004: backup database requires recovery

Cause: The control file is for a backup database which requires recovery, and cannot be opened for read-only access by this instance.

Action: Perform the necessary recovery and re-open for read-only access.
--------------------------------------------------------------------------------------------------------------------------
ORA-01194: file string needs more recovery to be consistent

Cause: An incomplete recovery session was started, but an insufficient number of logs were applied to make the file consistent. The reported file was not closed cleanly when it was last opened by the database. It must be recovered to a time when it was not being updated. The most likely cause of this error is forgetting to restore the file from a backup before doing incomplete recovery.

Action: Either apply more logs until the file is consistent or restore the file from an older backup and repeat recovery.

Author

Commented:
Thanks. Now things are working fine except that REDO LOGS are not getting applied unlike ARCHIVED REDO LOGS which do. I have to switch log file in PRIMARY DB to get that as well into STANDBY DB. Also, created user in PRIMARY is not getting carried over to STANDBY.

Author

Commented:
Now everything is working fine. Can you give me how using query(s), we can find out whther managed recovery is complete for all shipped archived redo logs?
I don't think such kind of info. would be available to query in any of the system tables, though I'm not a DBA and wouldn't know for sure.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.