Difficulties in configuring Data Guard environment [message #582574] |
Fri, 19 April 2013 09:10 |
|
ramanujam.y@gmail.com
Messages: 5 Registered: April 2013 Location: India
|
Junior Member |
|
|
HI,
I am new to DBA. i am trying to setup a datagaurd environment. but i am facing some difficulties in configuring. can some one please help me to achieve this datagaurd configuration.
My primary database name is ourdb and stand by is oursby
steps i followed,
ourdb:-
pfile
[oracle@oracle10g dbs]$ cat initourdb.ora
ourdb.__db_cache_size=96468992
ourdb.__java_pool_size=4194304
ourdb.__large_pool_size=4194304
ourdb.__shared_pool_size=54525952
ourdb.__streams_pool_size=4194304
*.audit_file_dest='/u01/app/oracle/product/10.2.0/db_1/admin/ourdb/adump'
*.background_dump_dest='/u01/app/oracle/product/10.2.0/db_1/admin/ourdb/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/oracle/product/10.2.0/db_1/oradata/ourdb/control01.ctl','/u01/app/oracle/product/10.2.0/db_1/oradata/ourdb/ control02.ctl','/u01/app/oracle/product/10.2.0/db_1/oradata/ourdb/control03.ctl'
*.core_dump_dest='/u01/app/oracle/product/10.2.0/db_1/admin/ourdb/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_file_name_convert='/u01/app/oracle/product/10.2.0/db_1/oradata/ourdb/','/u01/app/oracle/product/10.2.0/db_1/oradata/oursby/'
*.db_name='ourdb'
*.db_recovery_file_dest='/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.db_unique_name='OURDB'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ourdbXDB)'
*.fal_client='oursby'
*.fal_server='ourdb'
*.job_queue_processes=10
*.LOCAL_LISTENER='(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =stbyoracle10g.raja.com)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = oursby)))'
*.log_archive_config='DG_CONFIG=(ourdb,oursby)'
*.log_archive_dest_1='LOCATION=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area VALID_FOR=(ALL_LOGFILES,ALL_ROLES) db_unique_name=ourdb'
*.log_archive_dest_2='SERVICE=ourdb VALID_FOR=(ALL_LOGFILES,PRIMARY_ROLE) db_unique_name=oursby'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s_%r.arc'
*.LOG_ARCHIVE_MAX_PROCESSES=30
*.log_file_name_convert='/u01/app/oracle/product/10.2.0/db_1/oradata/ourdb/','/u01/app/oracle/product/10.2.0/db_1/oradata/oursby/'
*.open_cursors=300
*.pga_aggregate_target=16777216
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.REMOTE_OS_AUTHENT=TRUE
*.service_names='OURDB'
*.sga_target=167772160
*.standby_file_management='AUTO'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/product/10.2.0/db_1/admin/ourdb/udump'
[oracle@oracle10g dbs]$
And my standby pfile:-
oursby:-
pfile
[oracle@stbyoracle10g dbs]$ cat /u01/app/oracle/product/10.2.0/db_1/dbs/initoursby.ora
ourdb.__db_cache_size=83886080
ourdb.__java_pool_size=4194304
ourdb.__large_pool_size=4194304
ourdb.__shared_pool_size=67108864
ourdb.__streams_pool_size=4194304
*.audit_file_dest='/u01/app/oracle/product/10.2.0/db_1/admin/ourdb/adump'
*.background_dump_dest='/u01/app/oracle/product/10.2.0/db_1/admin/ourdb/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/oracle/product/10.2.0/db_1/oradata/ourdb/control01.ctl','/u01/app/oracle/product/10.2.0/db_1/oradata/ourdb/ control02.ctl','/u01/app/oracle/product/10.2.0/db_1/oradata/ourdb/control03.ctl'
*.core_dump_dest='/u01/app/oracle/product/10.2.0/db_1/admin/ourdb/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='ourdb'
*.db_recovery_file_dest='/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.db_unique_name='oursby'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ourdbXDB)'
*.fal_client='oursby'
*.fal_server='ourdb'
*.job_queue_processes=10
*.log_archive_config='DG_CONFIG=(oursby,ourdb)'
*.log_archive_dest_1='LOCATION=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area VALID_FOR=(ALL_LOGFILES,ALL_ROLES) db_unique_name=oursby'
*.log_archive_dest_2='SERVICE=ourdb LGWR ASYNC VALID_FOR=(ALL_LOGFILES,PRIMARY_ROLE) db_unique_name=ourdb'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s_%r.arc'
*.LOG_ARCHIVE_MAX_PROCESSES=30
*.open_cursors=300
*.pga_aggregate_target=16777216
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=167772160
*.standby_file_management='AUTO'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/product/10.2.0/db_1/admin/ourdb/udump'
=========================================================================================
tnsentry:-
=========================================================================================
OURDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle10g.raja.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ourdb)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
oursby =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =stbyoracle10g.raja.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oursby)
)
)
=======================================================================================
i am trying to duplicate the primary to stand by as below.
i have taken the backup from primary(database+archive logs,current controlfile, password file)
i have moved the backups to the same location.from oracle10g to stboracle10g(both servers both location(/u01/backup).
now i am trying to perform
rman target / auxiliary system@oursby
error :-
[oracle@oracle10g admin]$ rman target / auxiliary system@oursby
Recovery Manager: Release 10.2.0.1.0 - Production on Wed Dec 7 07:48:25 2005
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: OURDB (DBID=543793856)
auxiliary database Password:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges
[oracle@oracle10g admin]$
listener:-
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(SID_NAME = ourdb)
)
(SID_DESC =
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(SID_NAME = oursby)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle10g.raja.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
please help me what is wrong in this
Thanks,
Raja.S
[SPLIT from someone else's topic by LF]
[Updated on: Sat, 20 April 2013 16:43] by Moderator Report message to a moderator
|
|
|
|
|
Re: dataguard error in startup using pfileORCL.ora [message #582646 is a reply to message #582596] |
Sat, 20 April 2013 14:11 |
|
ramanujam.y@gmail.com
Messages: 5 Registered: April 2013 Location: India
|
Junior Member |
|
|
Hi Michel,
First of all sorry for the delayed reply. my net is not working properly.
As you said i made the changes in the pfile, still i am getting the same error.
[oracle@oracle10g ~]$ rman target / auxiliary sys@oursby
Recovery Manager: Release 10.2.0.1.0 - Production on Thu Dec 8 12:49:36 2005
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: OURDB (DBID=543793856)
auxiliary database Password:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges
[oracle@oracle10g ~]$
Thanks,Raja
[Updated on: Sat, 20 April 2013 14:12] Report message to a moderator
|
|
|
|
|
Re: Difficulties in configuring Data Guard environment [message #582673 is a reply to message #582574] |
Sun, 21 April 2013 02:38 |
John Watson
Messages: 8938 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Your parameter files are way off. In the primary file, you need to look at local_listener, %_file_name_convert, fal_%. In the standby file, many are missing.
Youe listener.ora file is wrong, you seem to be confused about which machine the listener is running on and which machine the databases are on.
I think you may need to go back to the docs, and start again.
|
|
|
|
Re: dataguard error in startup using pfileORCL.ora [message #582698 is a reply to message #582654] |
Mon, 22 April 2013 00:31 |
|
ramanujam.y@gmail.com
Messages: 5 Registered: April 2013 Location: India
|
Junior Member |
|
|
Hi Blackswan,
Actually from the beginning i am trying to connect but it is not allowing to connect from primary(oracle10g.raja.com) to standby(stbyoracle10g.raja.com) .But i tried from stand by to primary which works perfectly.
[oracle@stbyoracle10g ~]$ sqlplus system/sys123@ourdb
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Dec 9 23:18:28 2005
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> show parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string ourdb
SQL> sho parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string OURDB
SQL> sho parameter db_unique
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string OURDB
SQL>
Thanks,
Raja
[Updated on: Mon, 22 April 2013 00:42] Report message to a moderator
|
|
|
|
|
|