Results 1 to 6 of 6

Thread: Data Guard

  1. #1
    Join Date
    Feb 2011
    Posts
    4

    Unanswered: Data Guard

    Hi Guys,

    I am trying to configure data guard but unable sync standby database
    please find pfile of primary database and standby database


    prim.__db_cache_size=205520896
    prim.__java_pool_size=4194304
    prim.__large_pool_size=4194304
    prim.__shared_pool_size=67108864
    prim.__streams_pool_size=0
    *.audit_file_dest='D:\oracle\product\10.2.0/admin/prim/adump'
    *.background_dump_dest='D:\oracle\product\10.2.0/admin/prim/bdump'
    *.compatible='10.2.0.1.0'
    *.control_files='D:\oracle\product\10.2.0\oradata\ prim\control01.ctl','D:\oracle\product\10.2.0\orad ata\prim\control02.ctl','D:\oracle\product\10.2.0\ oradata\prim\control03.ctl'
    *.core_dump_dest='D:\oracle\product\10.2.0/admin/prim/cdump'
    *.db_block_size=8192
    *.db_domain=''
    *.db_file_multiblock_read_count=16
    *.db_file_name_convert='boston','prim'
    *.db_name='prim'
    *.db_recovery_file_dest='D:\oracle\product\10.2.0/flash_recovery_area'
    *.db_recovery_file_dest_size=2147483648
    *.db_unique_name='prim'
    *.dispatchers='(PROTOCOL=TCP) (SERVICE=primXDB)'
    *.fal_client='prim'
    *.fal_server='boston'
    *.job_queue_processes=10
    *.LOG_ARCHIVE_CONFIG='DG_CONFIG=(prim,boston)'
    *.log_archive_dest_1='location=D:\archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=prim'
    *.LOG_ARCHIVE_DEST_2='SERVICE=boston LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=boston'
    *.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
    *.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
    *.log_file_name_convert='D:\oracle\product\10.2.0\ oradata\boston','D:\oracle\product\10.2.0\oradata\ prim'
    *.open_cursors=300
    *.pga_aggregate_target=95420416
    *.processes=150
    *.remote_login_passwordfile='EXCLUSIVE'
    *.sga_target=287309824
    *.STANDBY_FILE_MANAGEMENT='AUTO'
    *.undo_management='AUTO'
    *.undo_tablespace='UNDOTBS1'
    *.user_dump_dest='D:\oracle\product\10.2.0/admin/prim/udump'



    Pfile for standby database


    boston.__db_cache_size=205520896
    boston.__java_pool_size=4194304
    boston.__large_pool_size=4194304
    boston.__shared_pool_size=67108864
    boston.__streams_pool_size=0
    *.audit_file_dest='D:\oracle\product\10.2.0/admin/boston/adump'
    *.background_dump_dest='D:\oracle\product\10.2.0/admin/boston/bdump'
    *.compatible='10.2.0.1.0'
    *.control_files='D:\oracle\product\10.2.0\oradata\ boston\boston01.ctl'
    *.core_dump_dest='D:\oracle\product\10.2.0/admin/prim/cdump'
    *.db_block_size=8192
    *.db_domain=''
    *.db_file_multiblock_read_count=16
    *.db_file_name_convert='boston','prim'
    *.db_name='prim'
    *.db_recovery_file_dest='D:\oracle\product\10.2.0/flash_recovery_area'
    *.db_recovery_file_dest_size=2147483648
    *.db_unique_name='boston'
    *.dispatchers='(PROTOCOL=TCP) (SERVICE=primXDB)'
    *.fal_client='boston'
    *.fal_server='prim'
    *.job_queue_processes=10
    *.LOG_ARCHIVE_CONFIG='DG_CONFIG=(prim,boston)'
    *.log_archive_dest_1='location=D:\archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=boston'
    *.LOG_ARCHIVE_DEST_2='SERVICE=boston LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=prim'
    *.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
    *.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
    *.log_file_name_convert='D:\oracle\product\10.2.0\ oradata\prim','D:\oracle\product\10.2.0\oradata\bo ston'
    *.open_cursors=300
    *.pga_aggregate_target=95420416
    *.processes=150
    *.remote_login_passwordfile='EXCLUSIVE'
    *.sga_target=287309824
    *.STANDBY_FILE_MANAGEMENT='AUTO'
    *.undo_management='AUTO'
    *.undo_tablespace='UNDOTBS1'
    *.user_dump_dest='D:\oracle\product\10.2.0/admin/boston/udump'


    please guide as

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I am trying to configure data guard but unable sync standby database
    My car won't go.
    Tell me how to make my car go.

    In the future please provide fewer details to make solving your mystery more challenging.
    When was last this worked? What changed?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Feb 2011
    Posts
    4

    Data Guard

    Hi Guys,

    I am Doing Data Guard in single Machine please find step

    Primary Database (chicago) ---- Standby database (boston)

    1) shutdown immediate
    2) startup mount
    3) alter database archivelog
    4) alter database force logging
    5) alter database open
    ----------------------------------
    The Archiving path D:\Archive

    6) creata pfile='D:\test.ora' from spfile
    Make the neccessary change

    chicago.__db_cache_size=159383552
    chicago.__java_pool_size=4194304
    chicago.__large_pool_size=4194304
    chicago.__shared_pool_size=113246208
    chicago.__streams_pool_size=0
    *.audit_file_dest='D:\oracle\product\10.2.0/admin/chicago/adump'
    *.background_dump_dest='D:\oracle\product\10.2.0/admin/chicago/bdump'
    *.compatible='10.2.0.1.0'
    *.control_files='D:\oracle\product\10.2.0\oradata\ chicago\control01.ctl','D:\oracle\product\10.2.0\o radata\chicago\control02.ctl','D:\oracle\product\1 0.2.0\oradata\chicago\control03.ctl'
    *.core_dump_dest='D:\oracle\product\10.2.0/admin/chicago/cdump'
    *.db_block_size=8192
    *.db_domain=''
    *.db_file_multiblock_read_count=16
    *.db_file_name_convert='boston','chicago'
    *.db_name='chicago'
    *.db_recovery_file_dest='D:\oracle\product\10.2.0/flash_recovery_area'
    *.db_recovery_file_dest_size=2147483648
    *.db_unique_name='chicago'
    *.dispatchers='(PROTOCOL=TCP) (SERVICE=chicagoXDB)'
    *.fal_client='chicago'
    *.fal_server='boston'
    *.job_queue_processes=10
    *.LOG_ARCHIVE_CONFIG='DG_CONFIG=(chicago,boston)'
    *.log_archive_dest_1='location=D:\archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=chicago'
    *.LOG_ARCHIVE_DEST_2='SERVICE=boston LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=boston'
    *.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
    *.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
    *.log_file_name_convert='D:\oracle\product\10.2.0\ oradata\boston','D:\oracle\product\10.2.0\oradata\ chicago'
    *.open_cursors=300
    *.pga_aggregate_target=95420416
    *.processes=150
    *.remote_login_passwordfile='EXCLUSIVE'
    *.sga_target=287309824
    *.STANDBY_FILE_MANAGEMENT='AUTO'
    *.undo_management='AUTO'
    *.undo_tablespace='UNDOTBS1'
    *.user_dump_dest='D:\oracle\product\10.2.0/admin/chicago/udump'


    7) copy the passwordfile
    8) shutdown immediate
    9) copy the datafiles and redo log
    10) oradim -new -sid boston -startmode manual
    11) create pfile for boston and make neccessary changes

    boston.__db_cache_size=180355072
    boston.__java_pool_size=4194304
    boston.__large_pool_size=4194304
    boston.__shared_pool_size=92274688
    boston.__streams_pool_size=0
    *.audit_file_dest='D:\oracle\product\10.2.0/admin/boston/adump'
    *.background_dump_dest='D:\oracle\product\10.2.0/admin/boston/bdump'
    *.compatible='10.2.0.1.0'
    *.control_files='D:\oracle\product\10.2.0\oradata\ boston\boston01.ctl'
    *.core_dump_dest='D:\oracle\product\10.2.0/admin/boston/cdump'
    *.db_block_size=8192
    *.db_domain=''
    *.db_file_multiblock_read_count=16
    *.db_name='chicago'
    *.db_unique_name='boston'
    *.db_recovery_file_dest='D:\oracle\product\10.2.0/flash_recovery_area'
    *.db_recovery_file_dest_size=2147483648
    *.dispatchers='(PROTOCOL=TCP) (SERVICE=chicagoXDB)'
    *.job_queue_processes=10
    *.open_cursors=300
    *.pga_aggregate_target=95420416
    *.processes=150
    *.remote_login_passwordfile='EXCLUSIVE'
    *.sga_target=287309824
    *.undo_management='AUTO'
    *.undo_tablespace='UNDOTBS1'
    *.user_dump_dest='D:\oracle\product\10.2.0/admin/boston/udump'
    *.db_file_name_convert='chcago','boston'
    *.LOG_ARCHIVE_CONFIG='DG_CONFIG=(chicago,boston)'
    *.log_archive_dest_1='location=D:\archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=chicago'
    *.LOG_ARCHIVE_DEST_2='SERVICE=boston LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=boston'
    *.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
    *.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
    *.log_file_name_convert='D:\oracle\product\10.2.0\ oradata\chicago','D:\oracle\product\10.2.0\oradata \boston'
    *.fal_client='boston'
    *.fal_server='chicago'
    *.STANDBY_FILE_MANAGEMENT='AUTO'

    12) now listener part

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
    (PROGRAM = extproc)
    )
    )

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    (ADDRESS = (PROTOCOL = TCP)(HOST = syedather.lan)(PORT = 1521))
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = CHICAGO)
    (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
    )
    )

    13) TNS Names

    CHICAGO =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = syedather.lan)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = chicago)
    )
    )

    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    BOSTON =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = syedather.lan)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = boston)
    )
    )

    14) Startup the primary Database
    15) startup nomount (standby database)
    16) alter database mount standby database
    17) alter database recover managed disconnect from session

    ..... Now the problem i could able sync with primary Database

    0ra-16004 backup database requires recover

    Please guide me

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >0ra-16004 backup database requires recover
    What clues exist within alert_SID.log file of STANDBY?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Aug 2003
    Location
    West
    Posts
    101
    ORA-16004: backup database requires recovery
    Cause: The control file is for a backup database which requires recovery, and cannot be opened for read-only access by this instance.
    Action: Perform the necessary recovery and re-open for read-only access.

  6. #6
    Join Date
    Feb 2011
    Posts
    4
    SQL> alter database open read only;
    alter database open read only
    *
    ERROR at line 1:
    ORA-16004: backup database requires recovery
    ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
    ORA-01110: data file 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\CHICAGO\SYSTEM01 .DBF'


    i could not open ready only mode standby database please guide me

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •