on 03-10-2019 10:19 AM
Dear Gurus,
We are upgrading our Oracle database of BI PRD to 12.2. Dev and QAS was successfully completed. But in BI PRD the upgrade is failing from pre-checks. It is giving below error.
As far as i know, my team has tried to configure DR for this Bi system, and they failed and dropped. But the parameters which they have configured for the log shipping is still present in the BI PRD system. I have tried to change the parameter in sp file and orainit file. But still giving the same error.
Please find the spfile details below
=================================
*.job_queue_processes=1 *.log_archive_config='dg_config=(pbp_kch,pbp_bom)' *.log_archive_dest_1='LOCATION=/oracle/PBP/oraarch/PBParch' *.log_archive_dest_2='service="pbp_bom"','LGWR ASYNC NOAFFIRM delay=180 optional comprCC"l`ession=enable max_failure=0 max_connections=1 reopen=300 db_unique_name="pbp_bom" net_timeout=30','valid_for=(all_logfiles,primary_role)' *.log_archive_dest_3='location="/oracle/PBP/112_64/dbs/arch"','valid_for=(STANDBY_LOGFILE,STANDBY_ROLE)' *.log_archive_dest_state_1='ENABLE' *.log_archive_dest_state_2='ENABLE' *.log_archive_dest_state_3='ENABLE' *.log_archive_format='%t_%s_%r.dbf' *.log_archive_max_processes=2 *.log_archive_min_succeed_dest=1 *.log_archive_trace=0 *.log_checkpointCC-U_interval=0 *.log_checkpoints_to_alert=TRUE *.log_file_name_convert='PBP','PBP' *.max_dump_file_size='20000' *.open_cursors=800
==================================
initPBP.ora
==================================
*.diagnostic_dest='/oracle/PBP/saptrace' *.dml_locks=4000 *.event='10027','10028','10142','10183','10191','10995 level 2','38068 level 100','38085','38087','44951 level 1024','60025'#SAP_12102170418_201705 RECOMMENDED SETTINGS *.filesystemio_options='ASYNCH' *.job_queue_processes=1 *.log_archive_config='dg_config=(pbp_kch,pbp_bom)' *.log_archive_dest_1='LOCATION="/oracle/PBP/oraarch/PBParch"','valid_for=(ONLINE_LOGFILE,ALL_ROLES)' #*.log_archive_dest_2='service="pbp_bom"','LGWR ASYNC NOAFFIRM delay=180 optional compression=enable max_failure=0 max_connections=1 reopen=300 db_unique_name="pbp_bom" net_timeout=30','valid_for=(all_logfiles,primary_role)' *.log_archive_dest_3='location="/oracle/PBP/112_64/dbs/arch"','valid_for=(STANDBY_LOGFILE,STANDBY_ROLE)' *.log_archive_dest_1='location=/oracle/PBP/oraarch/PBParch' *.log_archive_dest_state_1='ENABLE' *.log_archive_dest_state_2='DEFER' *.log_archive_dest_state_3='ENABLE' *.log_archive_format='%t_%s_%r.dbf' *.log_archive_max_processes=2 *.log_archive_min_succeed_dest=1 *.log_archive_trace=0 *.log_checkpoint_interval=0 *.log_checkpoints_to_alert=TRUE *.log_file_name_convert='PBP','PBP' *.max_dump_file_size='20000'
====================================
Please find some command output also.
1) select DEST_NAME,STATUS,DESTINATION from V$ARCHIVE_DEST;
DEST_NAME -------------------------------------------------------------------------------- STATUS --------- DESTINATION -------------------------------------------------------------------------------- LOG_ARCHIVE_DEST_1 VALID /oracle/PBP/oraarch/PBParch LOG_ARCHIVE_DEST_2 INACTIVE DEST_NAME -------------------------------------------------------------------------------- STATUS --------- DESTINATION -------------------------------------------------------------------------------- LOG_ARCHIVE_DEST_3 VALID /oracle/PBP/112_64/dbs/arch
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/PBP/112_64/dbs/arch
Oldest online log sequence 1228347
Next log sequence to archive 1228354
Current log sequence 1228354
I believe i need to disable the options, please help me to disable this and finish my upgrade.
Regards,
John
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.