Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connection from 12c to 9i

Nisarg OzaMay 30 2017 — edited Jun 4 2017

Hello ,

Recently I have upgraded one of my database from 9i to 12c.

I'm trying to connect oracle Oracle9i Release 9.2.0.4.0 - Production from 12c Release 12.1.0.1.0 - 64bit ,but I got message

ORA-03134: Connections to this server version are no longer supported

I can connect 9i to 12c by setting parameter in sqlnet.ora,  SQLNET.ALLOWED_LOGON_VERSION=8 , but I cannot connect 12c to 9i.

Any solution for 12c to 9i connection or any alternate solution will also appreciable.

Thanks ,

Nisarg,

Comments

KanchDev
Hi Jumbo,

You can consider an incremental rman backup from production database and recover DR database.

This method is available from 10g. otherwise you need to recreate the Standby database.


Cheers,
Kanchana.
CKPT
If the DR is not functioning from last 6 months, According to database size you can rebuild standby database.

if the data difference is not so huge, You can perform incremental roll forward.

For 10g, refer this below link

http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/scenarios.htm#CIHIAADC
Shivananda Rao
As said, you can recreate the standby database if the size of the production database is quite less. If not, then make use of the incremental or rollforwarding method.

Refer this MOS ID *Steps to perform for Rolling forward a standby database using RMAN incremental backup when primary and standby are in ASM filesystem [ID 836986.1]*
SITI
Hi SRP,

DB status:

1.*No ASM storage.*

2.*oracle 9i.*

3.*Archive logs deleted on both Primary and Standby.*

my question:

1.without recreate standby.*is their any method to recover the standby database?*

Regards,
Jumbo.
Shivananda Rao
Since you have lost the archives on the primary database, it is not possible for you to recover your standby database.

The only option is to recreate it fully (if the size of the primary database is small) or to go with the roll forwarding method.
Ganadeva
Hi,

Try this for 9i

Rolling a Standby Forward using an RMAN Incremental Backup in 9i [ID 290817.1]

Please let us know if this works...

Regards,
Ganadeva
SITI
thank you for all.
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 2 2017
Added on May 30 2017
8 comments
1,223 views