ORA-01033: ORACLE initialization or shutdown in progress in log_archive_dest_2 for standby
SQL> @error
-----------------------------------------------------
Host Name : ora-gold1
Ip Address : 192.168.0.27
Error date : 18-10-2014 12:25:49
Dest ID : 2
Status : ERROR
DB Name : vihaan_stdy
DB Mode : UNKNOWN
Recovery Mode : IDLE
Protection Mode : MAXIMUM PERFORMANCE
SRL Count : 0
SRLActive : 0
Archived Thread# : 0
ArchivedSeq# : 0
Applied Thread# : 0
Destination : stdy
Archiver : LGWR
Transmit Mode : ASYNCHRONOUS
Affirm : NO
Asynchronous Blocks: 61440
Net Timeout : 30
Delay (Mins) : 0
Reopen (Secs) : 300
Register : YES
Binding : OPTIONAL
Compression : DISABLE
Error : ORA-01033: ORACLE initialization or shutdown in progress
----------------------------------------------------
check whether are you able to connect with password primary and standby database with password ?
Check Primary to primary with password [oracle@ora-gold1 ~]$ sqlplus system/sys@prim SQL*Plus: Release 12.1.0.2.0 Production on Sat Oct 18 13:06:12 2014 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> exit Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Check standby from primary
[oracle@ora-gold1 ~]$ sqlplus system/sys@stdy
SQL*Plus: Release 12.1.0.2.0 Production on Sat Oct 18 13:06:23 2014
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0
so problem with password file .
copy password file from primary to standby ...
[oracle@ora-golden2 dbs]$ scp oracle@192.168.0.27:/u01/app/oracle/product/12.1.0/db_1/dbs/ora* .
oracle@192.168.0.27's password:
orapwvihaan 100% 8704 8.5KB/s 00:00
on primary
set linesize 200 pagesize 200
col destination format a30
col ERROR format a40
select dest_id,destination,status,database_mode,recovery_mode,error from V$ARCHIVE_DEST_STATUS
where status != 'INACTIVE';
DEST_ID DESTINATION STATUS DATABASE_MODE RECOVERY_MODE ERROR
---------- ------------------------------ --------- --------------- ----------------------- ----------------------------------------
1 /u01/app/oracle/ArchiveLog VALID OPEN IDLE
2 stdy VALID MOUNTED-STANDBY MANAGED REAL TIME APPLY
1 comment:
Unless your Standby is open read only (ACTIVE), you can't connect as system as in your example, you'd have to be sys as sysdba. This was expected behavior although you may have had another underlying issue.
Post a Comment