Home » Server Options » Data Guard » Dataguard - Primary died automatically and redo log out of sequece
Dataguard - Primary died automatically and redo log out of sequece [message #219281] Tue, 13 February 2007 15:52 Go to next message
tguha
Messages: 1
Registered: February 2007
Location: Richmond
Junior Member

Hi,

I am trying to implement Oracle Dataguard and implementing in one server.
Afte issuing following commands in the standby
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
[oracle@tg dbs]$ echo $ORACLE_SID
orclsp
[oracle@tg dbs]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 13 15:18:47 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 608174080 bytes
Fixed Size 1220844 bytes
Variable Size 167776020 bytes
Database Buffers 436207616 bytes
Redo Buffers 2969600 bytes
SQL> alter database mount standby database;
Database altered.
SQL> alter database add standby logfile '/u02/oradata/orclsp/redo01.log' s
2
SQL> alter database add standby logfile
2 '/u02/oradata/orclsp/spredo01.log' size 5M,
3 '/u02/oradata/orclsp/spredo02.log' size 5M,
4 '/u02/oradata/orclsp/spredo03.log' size 5M;
Database altered.
SQL> recover managed standby database disconnect;
Media recovery complete.
SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-01154: database busy. Open, close, mount, and dismount not allowed now
SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-01154: database busy. Open, close, mount, and dismount not allowed now
SQL> alter database recover managed standby database using current logfile;
alter database recover managed standby database using current logfile
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
SQL> alter database recover managed standby database cancel;
Database altered.
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: '/u02/oradata/orclsp/system01.dbf'
SQL> recover managed standby database disconnect;
Media recovery complete.
SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-01154: database busy. Open, close, mount, and dismount not allowed now
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

I see primary instance has shut down and when i try to start it up I ge the below message.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
[oracle@tg dbs]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 13 15:58:28 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup pfile=$ORACLE_HOME/dbs/initorcl.ora
ORACLE instance started.
Total System Global Area 608174080 bytes
Fixed Size 1220844 bytes
Variable Size 167776020 bytes
Database Buffers 436207616 bytes
Redo Buffers 2969600 bytes
Database mounted.
ORA-00314: log 2 of thread 1, expected sequence# 9 doesn't match 0
ORA-00312: online log 2 thread 1: '/u02/oradata/orcl/redo02.log'
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

This thing happened twice consecutively.
I appreciate any help on this.

Thank you
Tapas
Re: Dataguard - Primary died automatically and redo log out of sequece [message #220904 is a reply to message #219281] Thu, 22 February 2007 12:24 Go to previous messageGo to next message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
how are u creating standby copy?

Sandeep
Re: Dataguard - Primary died automatically and redo log out of sequece [message #221790 is a reply to message #219281] Wed, 28 February 2007 07:37 Go to previous message
alertmax
Messages: 4
Registered: February 2007
Junior Member
i have this error to....

if u try Alter Database Recover Managed Standby Database;
it will work!!!


my two parameters are:
PRIMARY-->
*._awr_flush_threshold_metrics=TRUE
*.audit_file_dest='C:\oracle\product\10.2.0/admin/dba/adump'
*.control_files='C:\oracle\product\10.2.0\db_1\database\control01.ctl','C:\oracle\product\10.2.0\db_1\database\control02.ctl','C:\ora cle\product\10.2.0\db_1\database\control03.ctl'

*.background_dump_dest='C:\oracle\product\10.2.0\admin\dba/bdump'
*.compatible='10.2.0.1.0'
*.core_dump_dest='C:\oracle\product\10.2.0\admin\dba\cdump'
*.db_block_size=8192
*.db_cache_size=32M
*.db_domain=''
*.db_file_multiblock_read_count=8

*.db_name=dba
*.DB_UNIQUE_NAME=dba
*.SERVICE_NAMES=dba

*.log_archive_config='DG_CONFIG=(dba,dbareser)'
*.log_archive_dest_1='location=C:\oracle\archive1
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=dba'

*.log_archive_dest_2='SERVICE=dbareser LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=dbareser'

*.LOG_ARCHIVE_DEST_STATE_1=ENABLE
*.LOG_ARCHIVE_DEST_STATE_2=ENABLE
*.remote_login_passwordfile='EXCLUSIVE'
*.log_archive_format='arch_%d_%t_%r_%s.log'


*.FAL_SERVER=dbareser
*.FAL_CLIENT=dba

*.DB_FILE_NAME_CONVERT='C:\oracle\product\10.2.0\db_1\database_reserva', 'C:\oracle\product\10.2.0\db_1\database'
*.LOG_FILE_NAME_CONVERT='C:\oracle\standby', 'C:\oracle\archive1'

*.STANDBY_FILE_MANAGEMENT=AUTO


*.db_recovery_file_dest='C:\oracle\product\10.2.0/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=dbaXDB)'
*.java_pool_size=20M
*.job_queue_processes=10
*.large_pool_size=0

*.nls_language='BRAZILIAN PORTUGUESE'
*.nls_territory='BRAZIL'
*.open_cursors=300
*.pga_aggregate_target=16777216
*.processes=150
*.shared_pool_size=80M
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='C:\oracle\product\10.2.0\admin\dba\udump'


STANDBY->
*._awr_flush_threshold_metrics=TRUE
*.audit_file_dest='C:\oracle\product\10.2.0/admin/dba/adump'
*.background_dump_dest='C:\oracle\product\10.2.0\admin\dba/bdump'
*.compatible='10.2.0.1.0'
*.control_files='C:\oracle\product\10.2.0\db_1\database_reserva\control_01.ctl','C:\oracle\product\10.2.0\db_1\database_reserva\contr ol_02.ctl','C:\oracle\product\10.2.0\db_1\database_reserva\control_03.ctl'
*.core_dump_dest='C:\oracle\product\10.2.0\admin\dba\cdump'
*.db_block_size=8192
*.db_cache_size=32M
*.db_domain=''
*.db_file_multiblock_read_count=8

*.db_name='dba'
*.DB_UNIQUE_NAME='dbareser'
*.SERVICE_NAMES='dbareser'
*.log_archive_config='DG_CONFIG=(dba,dbareser)'

*.DB_FILE_NAME_CONVERT='C:\oracle\product\10.2.0\db_1\database', 'C:\oracle\product\10.2.0\db_1\database_reserva'
*.LOG_FILE_NAME_CONVERT='C:\oracle\archive1', 'C:\oracle\standby'

*.db_recovery_file_dest='C:\oracle\product\10.2.0/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=dbareserXDB)'
*.java_pool_size=20M
*.job_queue_processes=10
*.large_pool_size=0
*.local_listener='dbareser'

*.log_archive_dest_1='location=C:\oracle\standby
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=dbareser'

*.log_archive_dest_2='SERVICE=dba LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=dba'

*.LOG_ARCHIVE_DEST_STATE_1=ENABLE
*.LOG_ARCHIVE_DEST_STATE_2=ENABLE
*.INSTANCE_NAME=dbareser

*.FAL_SERVER=dba
*.FAL_CLIENT=dbareser


*.STANDBY_FILE_MANAGEMENT=AUTO

*.log_archive_format='archreser_%d_%t_%r_%s.log'

*.nls_language='BRAZILIAN PORTUGUESE'
*.nls_territory='BRAZIL'
*.open_cursors=300
*.pga_aggregate_target=16777216
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=80M
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='C:\oracle\product\10.2.0\admin\dba\udump'
Previous Topic: DataGuard HELP!
Next Topic: ORA-00312 - ORA-00314 (Database Disconnect From Session)
Goto Forum:
  


Current Time: Fri Dec 02 22:51:50 CST 2016

Total time taken to generate the page: 0.08259 seconds