Home » Server Options » Data Guard » Physical standby configuration (Oracle 10g (10.2.0.1.0) - 64bit RHEL4 On Both Primery & Standby )
Physical standby configuration [message #498539] Thu, 10 March 2011 03:51 Go to next message
abhijeet007
Messages: 13
Registered: January 2011
Location: IN
Junior Member
Dear associate,

I did the all necessary steps required for the physical standby
configuration. My standby db is mounted but not able to open.

Please help me out.

Below are the steps.

SQL> startup mount

ORACLE instance started.

Total System Global Area 1845493760 bytes
Fixed Size 2021568 bytes
Variable Size 452986688 bytes
Database Buffers 1375731712 bytes
Redo Buffers 14753792 bytes
Database mounted.

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=demodb' scope=both;

System altered.

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE SCOPE=BOTH;

System altered.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

Database altered.

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-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u002/app/OraDB10g/stdemo/oradata/system01.dbf'


SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH; ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcrfrsetnab_found], [1], [136], [],
[], [], [], []
ORA-00600: internal error code, arguments: [kcrfrgv_scn7], [], [], [], [], [],
[], []


SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kccocx_01], [], [], [], [], [], [],
[]




Thanks
Abhijeet K



Re: Physical standby configuration [message #498550 is a reply to message #498539] Thu, 10 March 2011 04:15 Go to previous messageGo to next message
Michel Cadot
Messages: 67369
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
Have a look at alert.log and trace files.

But the first step will be to upgrade to 10.2.0.4 or 10.2.0.5.

Regards
Michel

[Updated on: Thu, 10 March 2011 04:16]

Report message to a moderator

Re: Physical standby configuration [message #498581 is a reply to message #498550] Thu, 10 March 2011 05:52 Go to previous messageGo to next message
abhijeet007
Messages: 13
Registered: January 2011
Location: IN
Junior Member
Hi Michel,

Do you mean that it will not be possible in my current version (10.2.0.1.0).

Thanks,
Abhijeet K.
Re: Physical standby configuration [message #498584 is a reply to message #498581] Thu, 10 March 2011 05:56 Go to previous message
Michel Cadot
Messages: 67369
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, I don't know where the error comes from, you have to call Oracle for this but the first thing that Oracle will tell you is to upgrade.

Regards
Michel
Previous Topic: ora-1552
Next Topic: ORACLE BACKUP
Goto Forum:
  


Current Time: Fri Sep 25 18:08:56 CDT 2020