Home » Server Options » Data Guard » Physical Standby database single host error : ORA-01034: ORACLE not available
Physical Standby database single host error : ORA-01034: ORACLE not available [message #156293] Tue, 24 January 2006 08:26 Go to next message
jaiminks
Messages: 3
Registered: January 2006
Junior Member
This is what I have done

The Primary database(ORA10g) is on the solaris box

I took the cold backup and restored it in same box. the database name here is the same as primary (ORA10g)

Created a standby control file in the primary db

using <ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/data/apps/db/oracle/oradata/ORA10g_standby/ORA10g_standby.ctl';> command on specific location.

Did the followin changes to the primary database(ORA10g)init.ora file

##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################

###########################################
# Cache and I/O
###########################################
db_block_size=8192
db_file_multiblock_read_count=16

###########################################
# Cursors and Library Cache
###########################################
open_cursors=300

###########################################
# Database Identification
###########################################
db_domain=""
db_name=ORA10g

###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=/data/apps/db/oracle/admin/ORA10g/bdump
core_dump_dest=/data/apps/db/oracle/admin/ORA10g/cdump
user_dump_dest=/data/apps/db/oracle/admin/ORA10g/udump

###########################################
# File Configuration
###########################################
control_files=("/data/apps/db/oracle/oradata/ORA10g/control01.ctl", "/data/apps/db/oracle/oradata/ORA10g/control02.ctl", "/data/apps/db/oracle/oradata/ORA10g/control03.ctl")
db_recovery_file_dest=/data/apps/db/oracle/flash_recovery_area
db_recovery_file_dest_size=2147483648

###########################################
# Job Queues
###########################################
job_queue_processes=10

###########################################
# Miscellaneous
###########################################
compatible=10.2.0.1.0

###########################################
# Processes and Sessions
###########################################
processes=150

###########################################
# SGA Memory
###########################################
sga_target=1256194048

###########################################
# Security and Auditing
###########################################
audit_file_dest=/data/apps/db/oracle/admin/ORA10g/adump
remote_login_passwordfile=EXCLUSIVE

###########################################
# Shared Server
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=ORA10gXDB)"

###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=418381824

###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_tablespace=UNDOTBS1

###########################################
#Archive
###########################################
LOG_ARCHIVE_FORMAT="%t_%s_%r.log"
LOG_ARCHIVE_CONFIG='DG_CONFIG=(ORA10g,ORA10g_standby)'
LOG_ARCHIVE_DEST_1=
'LOCATION=/data/apps/db/log/ORA10g
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=ORA10g'
LOG_ARCHIVE_DEST_2=
'SERVICE=ORA10g_standby
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=ORA10g_standby'
LOG_ARCHIVE_DEST_STATE_1=enable
LOG_ARCHIVE_DEST_STATE_2=enable
OS_AUTHENT_PREFIX=''
instance_name=ORA10g
DB_UNIQUE_NAME=ORA10g

Did the followin changes to the standby database(ORA10g_standby)init.ora file


##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################

###########################################
# Cache and I/O
###########################################
db_block_size=8192
db_file_multiblock_read_count=16

###########################################
# Cursors and Library Cache
###########################################
open_cursors=300

###########################################
# Database Identification
###########################################
db_domain=""
db_name=ORA10g

###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=/data/apps/db/oracle/admin/ORA10g_standby/bdump
core_dump_dest=/data/apps/db/oracle/admin/ORA10g_standby/cdump
user_dump_dest=/data/apps/db/oracle/admin/ORA10g_standby/udump

###########################################
# File Configuration
###########################################
#control_files=("/data/apps/db/oracle/oradata/ORA10g/control01.ctl", "/data/apps/db/oracle/oradata/ORA10g/control02.ctl", "/da
ta/apps/db/oracle/oradata/ORA10g/control03.ctl")
db_recovery_file_dest=/data/apps/db/oracle/flash_recovery_area
db_recovery_file_dest_size=2147483648

###########################################
# Job Queues
###########################################
job_queue_processes=10

###########################################
# Miscellaneous
###########################################
compatible=10.2.0.1.0

###########################################
# Processes and Sessions
###########################################
processes=150

###########################################
# SGA Memory
###########################################
#sga_target=1256194048
sga_target=956194048

###########################################
# Security and Auditing
###########################################
audit_file_dest=/data/apps/db/oracle/admin/ORA10g/adump
remote_login_passwordfile=EXCLUSIVE

###########################################
# Shared Server
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=ORA10gXDB)"

###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
#pga_aggregate_target=418381824
pga_aggregate_target=41838812


###########################################
# Security and Auditing
###########################################
audit_file_dest=/data/apps/db/oracle/admin/ORA10g/adump
remote_login_passwordfile=EXCLUSIVE

###########################################
# Shared Server
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=ORA10gXDB)"

###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
#pga_aggregate_target=418381824
pga_aggregate_target=41838812

###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_tablespace=UNDOTBS1

###########################################
#Archive
###########################################
control_files=("/data/apps/db/oracle/oradata/ORA10g_standby/ORA10g_standby.ctl")
LOG_ARCHIVE_FORMAT="%t_%s_%r.log"
LOG_ARCHIVE_CONFIG='DG_CONFIG=(ORA10g,ORA10g_standby)'
LOG_ARCHIVE_DEST_1=
'LOCATION=/data/apps/db/log/ORA10g_standby_arch
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=ORA10g_standby'
LOG_ARCHIVE_DEST_STATE_1=enable
FAL_SERVER=ORA10g
FAL_CLIENT=ORA10g_standby
DB_FILE_NAME_CONVERT='/data/apps/db/oracle/oradata/ORA10g','/data/apps/db/oracle/oradata/ORA10g_standby'
LOG_FILE_NAME_CONVERT='/data/apps/db/log/ORA10g','/data/apps/db/log/ORA10g_standby_arch'
standby_archive_dest='/data/apps/db/log/ORA10g_standby'
standby_file_management='auto'
OS_AUTHENT_PREFIX=''

Did the followin changes to the listener.ora file

ORA10g =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = myaolldap-sd12.websys.aol.com)(PORT = 1521))
)
)

SID_LIST_ORA10g =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORA10g)
(ORACLE_HOME = /data/apps/oracle/product/10.2.0.1/db_1)
)
)

ORA10g_standby =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL =ipc)(KEY=ORA10g_standby))
)
)

SID_LIST_ORA10g_standby =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORA10g_standby)
(ORACLE_HOME = /data/apps/oracle/product/10.2.0.1/db_1)
)
)

Did the followin changes to the tnsnames.ora file

ORA10G =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = myaolldap-sd12.websys.aol.com)(PORT = 1521))
(CONNECT_DATA =
(SID = ORA10g)
)
)

ORA10g_standby =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = ipc)(KEY=ORA10g_standby))
(CONNECT_DATA =
(SID = ORA10g_standby)
)
)


started the standby database in nomount state.

mounted the standby database with this command

<alter database mount standby database>

put the stanby database in recovery mode using

<alter database recover managed standby database >

on the primary site, i opened the database,

issued the log switch.checked the v$archive_deststatus is showing error

and error showing as Oracle Not available.
Re: Physical Standby database single host error : ORA-01034: ORACLE not available [message #159500 is a reply to message #156293] Mon, 20 February 2006 01:06 Go to previous messageGo to next message
sharan alva
Messages: 57
Registered: November 1999
Member
check if you have the password file created on the standby.

Next check v$archive_dest to see if there are any errors reported after a log switch .. fix these errors

check if you are able to connect via sqlplus to the standby

sqlplus sys/password@<servicename using in lad2> as sysdba;

- Sharan
Re: Physical Standby database single host error : ORA-01034: ORACLE not available [message #160415 is a reply to message #156293] Sat, 25 February 2006 06:29 Go to previous message
jaiminks
Messages: 3
Registered: January 2006
Junior Member
Yes and i am facing same problem with two diffrent linux box.I am not able to understand where i went wrong.

Please do needful.
Previous Topic: How tough is it? (10g Data Guard)
Next Topic: DataGuard Gui / What is this error
Goto Forum:
  


Current Time: Thu Oct 22 19:14:01 CDT 2020