Home > error ora 16570 > error ora-16570 database needs restart

Error Ora-16570 Database Needs Restart

Broker is easier to manage though you could do it from SQL Prompt. Steps Check the current state of DG Broker on Primary Database SQL> show parameter DG_BROKER_START NAME                     TYPE                 VALUE ------------------------------------ -------------------------------- ------------------------------ dg_broker_start              boolean                  FALSE Start the DG Broker On Primary Database SQL> alter system set DG_BROKER_START=true scope=both; System altered. SQL> Check the current state of DG Broker on Standby Database SQL> show parameter DG_BROKER_START NAME                     TYPE                 VALUE ------------------------------------ -------------------------------- ------------------------------ dg_broker_start              boolean                  FALSE Start the DG Broker On Standby Database SQL> alter system set DG_BROKER_START=true scope=both; System altered. SQL> Configure Primary Database on Primary DB server. [oracle@xnodbprtz01 ~]$ dgmgrl DGMGRL for Linux: Version 11.1.0.7.0 - 64bit Production Copyright (c) 2000, 2005, Oracle. All rights reserved. Welcome to DGMGRL, type "help" for information. DGMGRL> connect sys/oracle Connected. DGMGRL> create configuration 'PRETZEL' as primary database is 'XNOPRTZ' connect identified is xnoprtz; create configuration 'PRETZEL' as primary database is 'XNOPRTZ' connect identified is xnoprtz;                                                                         ^ Syntax error before or at "identified" DGMGRL> create configuration 'PRETZEL' as primary database is 'XNOPRTZ' connect identifier is xnoprtz; Configuration "PRETZEL" created with primary database "XNOPRTZ" DGMGRL> Verify the configuration of Primary Data

Verifies that the primary is enabled and is in the TRANSPORT-ON state and that the target standby database is enabled and is in the APPLY-ON state. 2. Shuts down all instances on the primary except for one if needed. No instances will be shutdown on the target physical standby. 3. The primary database is first transitioned to the standby role then the original standby is transitioned to the primary role. 4. The broker configuration file is updated to reflect the change in roles. 5. Restarts the new standby database and begins the redo apply service. 6. The new primary database is opened in read/wirte mode and the redo transport service is started. Connect DGMGRL https://manidba.wordpress.com/2012/06/21/setup-oracle-dataguard-broker-and-switchover/ on Primary Side.: DGMGRL> switchover to 'colldb_st'; Performing switchover NOW, please wait... New primary database "colldb_st" is opening... Operation requires shutdown of instance "colldb" on database "colldb_pm" Shutting down instance "colldb"... ORA-01031: insufficient privileges Warning: You are no longer connected to ORACLE. Please complete the following steps to finish switchover: shut down instance "colldb" of database "colldb_pm" start up instance "colldb" of database "colldb_pm" DGMGRL> DGMGRL> show http://deepakoracledba.blogspot.com/2014/05/data-guard-switch-over-using-dgmgrl.html configuration Configuration - COLDB_CONF Protection Mode: MaxPerformance Databases: colldb_st - Primary database Error: ORA-16778: redo transport error for one or more databases colldb_pm - Physical standby database Error: ORA-16570: database needs restart Fast-Start Failover: DISABLED Configuration Status: ERROR DGMGRL> DGMGRL> show configuration Configuration - COLDB_CONF Protection Mode: MaxPerformance Databases: colldb_st - Primary database colldb_pm - Physical standby database Fast-Start Failover: DISABLED Configuration Status: ORA-16610: command "SWITCHOVER TO colldb_pm" in progress DGM-17017: unable to determine configuration status DGMGRL> show configuration Configuration - COLDB_CONF Protection Mode: MaxPerformance Databases: colldb_st - Primary database colldb_pm - Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS OLD Primary database validation : [oracle@Test1 dbs]$ ps -ef | grep pmon oracle 3655 1 0 Apr24 ? 00:00:27 asm_pmon_+ASM oracle 4104 1 0 Apr24 ? 00:00:30 ora_pmon_colldb oracle 17032 14291 0 04:54 pts/1 00:00:00 grep pmon [oracle@Test1 dbs]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Tue May 13 04:54:24 2014 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Rea

Mysql Master-Slave Replication using Tungsten Install/Configure Perl DBD for Oracle http://apunhiran.blogspot.com/2009/09/how-to-configure-data-guard-fast-start.html 11.2 on Redhat Linux How to display Oracle PL/SQL 'OUT' variable in perl MongoDB install and Quick Setup Setup Data Replication from Oracle to MongoDB Quick Hadoop 2 node Cluster Setup for Oracle DBAs RAC & DG Related How to Move OCR and Voting Disk to ASM Diskgroup in 11gR2 Oracle 11gr2 Grid: root.sh fails on node2, error ora-16570 asmlib issue Oracle 11gR2 Grid Infrastructure Installation Steps Oracle: Failed to initialize GPnP How To: Configure Data Guard Fast-Start Failover Step By Step How To: Configure Data Guard Broker Step by Step Data Guard Setup for Oracle 10g What is Voting Disk & Split Brain Syndrome in RAC RAC Installation on NetApps Raw Devices with ASM: Part error ora-16570 database 1 RAC Installation on NetApps Raw Devices with ASM: Part 2 RAC Installation on NetApps Raw Devices with ASM: Part 3 10.2.0.1 CRS Installation and upgrade to 10.2.0.3 for RAC Step by Step 11gR1 RAC CRS Installation Move/Replace/Change Location of OCR & Voting Disk DBA Related Oracle Compression: To Compress Or Not To Compress dbms_metadata.get_ddl & ORA-31603 Oracle: Rename single/RAC Database IMPDP Stuck Drop Materialized View takes a long time Oracle Resource Manager Setup How to refresh MVIEW in parallel Import Error: IMP-00032: SQL statement exceeded buffer length ORA-12060: During Mview Creation Configuring and starting ons daemon in non RAC DB Country ISO Code with Calling Code Data Insert/Update XML data stored in CLOB Column How To: Setup up of Oracle Streams Replication How TO: Check for Charater Set Conversion Problems & Fix Them Oracle Partitioning VIII - Partition Indexes Oracle Partitioning - Exchange Partition Oracle Partitioning - Merge Partition Oracle Partitioning - Add Partition Oracle Partitioning - Split Partition Oracle Partitioning Types - VII (Virtual Column Based Partitioning) Or

 

Related content

No related pages.