Home » Server Options » Data Guard » step for creating physical standby database (merged)
step for creating physical standby database (merged) [message #320071] Wed, 14 May 2008 00:38 Go to next message
mbhavin
Messages: 32
Registered: May 2008
Location: INDIA
Member

please help me out by describing steps required to create physical standby database

Re: step for creating physical standby database [message #320077 is a reply to message #320071] Wed, 14 May 2008 01:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

please read the documentation: http://tahiti.oracle.com.

physica; standby on same server [message #320084 is a reply to message #320071] Wed, 14 May 2008 01:21 Go to previous message
malvika
Messages: 55
Registered: May 2008
Location: india
Member

if i create physical standby database on same server where primary database exist.

here is my initEASTLEG.ora (primary database)

*._job_queue_interval=60
*.aq_tm_processes=1
*.background_dump_dest='/u02/app/oracle/admin/EASTLEG/b
*.compatible='9.2.0.0.0'
*.core_dump_dest='/u02/app/oracle/admin/EASTLEG/cdump'
*.db_block_buffers=96000
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_files=1024
*.db_name='EASTLEG'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=EASTLEGXDB)'
*.fast_start_mttr_target=300
*.hash_area_size=524288
*.hash_join_enabled=TRUE
*.instance_name='EASTLEG'
*.java_pool_size=15728640
*.large_pool_size=8388608
*.log_archive_dest_1='LOCATION=/u02/app/oracle/admin/EA
*.log_archive_dest_2='SERVICE=EASTLEG'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='arch_EASTLEG_%s.log'
*.log_archive_max_processes=6
*.log_archive_start=TRUE
*.log_buffer=1048576
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.remote_os_authent=TRUE
*.shared_pool_reserved_size=26214400
*.shared_pool_size=262144000
*.sort_area_size=262144
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u02/app/oracle/admin/EASTLEG/udump'

initEASTLEG_PS.ora(standby database)

*._job_queue_interval=60
*.aq_tm_processes=1
*.background_dump_dest='/u02/app/oracle/admin/EASTLEG_PS/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/newdata/app/oracle/oradata/EASTLEG_PS/control01.ctl'
*.core_dump_dest='/u02/app/oracle/admin/EASTLEG_PS/cdump'
*.db_block_buffers=96000
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_files=1024
*.db_name='EASTLEG'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=EASTLEGXDB)'
*.fast_start_mttr_target=300
*.hash_area_size=524288
*.hash_join_enabled=TRUE
*.instance_name='ESTLG_PS'
*.java_pool_size=15728640
*.large_pool_size=8388608
*.log_archive_max_processes=6
*.log_archive_start=TRUE
*.log_buffer=1048576
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='NONE'
*.remote_os_authent=TRUE
*.shared_pool_reserved_size=26214400
*.shared_pool_size=262144000
*.sort_area_size=262144
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u02/app/oracle/admin/EASTLEG_PS/udump'
*.lock_name_space=ESTLG_PS
*.standby_archive_dest='/u02/app/oracle/admin/EASTLEG_PS/arch'
*.db_file_name_convert='/newdata/app/oracle/oradata/EASTLEG','/newdata/app/oracl
e/oradata/EASTLEG_PS'
*.log_file_name_convert='/newdata/app/oracle/oradata/EASTLEG','/newdata/app/orac
le/oradata/EASTLEG_PS'
*.remote_archive_enable=TRUE
*.standby_file_management=AUTO


and i copy all datafile from primary database. and also create controlfile for standby database and logfiles.


when i start standby database.

>startup nomount pfile='initEASTLEG_PS.ora';
startup......
>alter database mount standby database;
........
>alter database read only
not open in exclusive mode......error.....

what can i do?


Previous Topic: drop physical standby database
Next Topic: standby creation problem
Goto Forum:
  


Current Time: Thu Mar 28 15:02:21 CDT 2024