standby
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 6 123 ... LastLast
Results 1 to 10 of 55

Thread: standby

  1. #1
    Join Date
    Jan 2007
    Posts
    231

    standby

    Hello,

    We have a problem in standby database.There was an error
    ORA-19505: failed to identify file "/mnt/backup/arch/ISPRO20/-1063755125_1_12802.arc"
    ORA-16055: FAL request rejected
    There was an archive file gap.So we moved manually.But after that error was occured automatic archival to remote standbydb stopped.
    We checked all parameters and then bounced primaryDB.But nothing happened. so we are moving manually till now.
    we proposed to recreate standby next week,(remove current .dbf,.log in standby,and copy from primary.dbf,.log,.ctl)by copying hotbkups.
    Also,proposed to create standby control file before hot backup begins.
    I scared whether it will show error while mounting standby stating that control file is older. OR i should create control file after the completion of moving all .dbf file to stdby.(It will a take nearly 1hr to move .dbf files from prod to stdby).

    please suggest whether i can clear the existing error(I lost hope on that),or
    i should create control file before or after.

    Thanks in advance.

  2. #2
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    show me the output from:

    show parameter archive

    On the primary server.
    Assistance is Futile...

  3. #3
    Join Date
    Jan 2007
    Posts
    231
    Hi,

    Here is that parameter value:

    SQL> show parameter archive

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    archive_lag_target integer 0
    log_archive_dest string /mnt/backup/arch/ISPRO20
    log_archive_dest_1 string
    log_archive_dest_10 string
    log_archive_dest_2 string
    log_archive_dest_3 string
    log_archive_dest_4 string
    log_archive_dest_5 string
    log_archive_dest_6 string
    log_archive_dest_7 string
    log_archive_dest_8 string

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    log_archive_dest_9 string
    log_archive_dest_state_1 string reset
    log_archive_dest_state_10 string enable
    log_archive_dest_state_2 string reset
    log_archive_dest_state_3 string enable
    log_archive_dest_state_4 string enable
    log_archive_dest_state_5 string enable
    log_archive_dest_state_6 string enable
    log_archive_dest_state_7 string enable
    log_archive_dest_state_8 string enable
    log_archive_dest_state_9 string enable

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    log_archive_duplex_dest string
    log_archive_format string %d_%t_%s.arc
    log_archive_max_processes integer 2
    log_archive_min_succeed_dest integer 1
    log_archive_start boolean TRUE
    log_archive_trace integer 0
    remote_archive_enable string TRUE
    standby_archive_dest string ?/dbs/arch

  4. #4
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Maybe I don't understand your setup.. Where are you defining your standby location? What version of Oracle?
    Assistance is Futile...

  5. #5
    Join Date
    Jan 2007
    Posts
    231
    Iam using oracle 9i Suse Linux,I too wonder why it haven't take the path from pfile.Can i modify without bouncing?.If it is possible pls help me.

    pfile:
    ##############################################
    #Archives & Standby Destinations
    ##############################################
    log_archive_start=TRUE
    log_archive_format = %d_%t_%s.arc
    log_archive_dest_1='LOCATION=/mnt/backup/arch/ISPRO20'
    log_archive_dest_2='SERVICE=ISPRO20.STANDBY1 MANDATORY LGWR SYNC REOPEN=180'
    log_archive_dest_state_1='ENABLE'
    log_archive_dest_state_2='ENABLE'
    standby_file_management='AUTO'
    remote_archive_enable=TRUE

    Thanks.

  6. #6
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Regardless of whether its a modifiable parameter, if you're using a pfile, the answer is no. Sort out your archive dest 2 and your problem will be resolved.
    Assistance is Futile...

  7. #7
    Join Date
    Jan 2007
    Posts
    231
    Hi,
    Waitecj: Can u give me more clues.Noting has changed since it was working.
    pfile in standby(archive):
    *.LOG_ARCHIVE_DEST_1='LOCATION=/mnt/backup/arch/ISPRO20'
    *.log_archive_start='TRUE'
    *.log_archive_format='%d_%t_%s.arc'
    *.standby_file_management='AUTO'
    *.standby_archive_dest='/mnt/backup/arch/ISPRO20'

  8. #8
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Quote Originally Posted by ams-jamali
    log_archive_dest_2='SERVICE=ISPRO20.STANDBY1 MANDATORY LGWR SYNC REOPEN=180'
    log_archive_dest_state_2='ENABLE'
    What further clues are required? These lines aren't in your configuration. When you restarted your server, you have used the wrong pfile (you should be using an spfile anyway)...
    Assistance is Futile...

  9. #9
    Join Date
    Jan 2007
    Posts
    231
    Thanks Waitecj,
    Can u do one more favour.I want to specify the path in OEM., if i click the browse it will show only local paths.can i use oracle@ipaddress:/path
    help pls.
    Last edited by ams-jamali; 03-01-2007 at 01:44 AM. Reason: to increase details

  10. #10
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Sorry, I don't understand the question. Specify the path to what? Your standby? Your spfile? Your house?
    Assistance is Futile...

Posting Permissions

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


Click Here to Expand Forum to Full Width