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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jinesh KamdarCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.