| Dataguard - Primary died automatically and redo log out of sequece [message #219281] |
Tue, 13 February 2007 15:52  |
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 #221790 is a reply to message #219281] |
Wed, 28 February 2007 07:37  |
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'
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
