standby

[ams-jamali]

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.

[waitecj]

show me the output from:

show parameter archive

On the primary server.

[ams-jamali]

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

[waitecj]

Maybe I don't understand your setup.. Where are you defining your standby location? What version of Oracle?

[ams-jamali]

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.

[waitecj]

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.

[waitecj]

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)...

[ams-jamali]

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'

[ams-jamali]

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.

[waitecj]

Sorry, I don't understand the question. Specify the path to what? Your standby? Your spfile? Your house?