Physical Standby Problems

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.
LVL 17
k_murli_krishnaAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Jinesh KamdarConnect With a Mentor Commented:
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.
0
 
k_murli_krishnaAuthor 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.
0
 
k_murli_krishnaAuthor 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?
0
 
Jinesh KamdarCommented:
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.
0
All Courses

From novice to tech pro — start learning today.