Oracle Database Discussions

HP-UX vscdsh01 B.11.23 U ia64
10.2.0 oracle

I have a primary/standby set up that just "stopped" receiving the archive files for some reason. There was no error in the alert log, so I received no notification.

I had to rebuild everything due to archive log retention issues....the configuration was calling for an archive log much older than what was available.
I did a new hot backup, created the new standby control file...transferred everything, brought it back on line doing recover standby database and alter database mount standby database...
everything worked fine.

I then issued an alter system switch logfile on the primary, while watching the alert logs...it showed the switch, but I don't see any activity for sending the log file from the primary to the secondary...

I then issue show parameter on both systems to see what is showing as the destinations. Looks fine.

So I decide to restart the process.

On the primary, I issued the following command...

alter system set log_archive_dest_state_2 = DEFER' --to shut off the shipping of log files.

it came back as system altered.
Then I issued the following, resulting in error...

SQL> alter system set log_archive_dest_2 = "MANDATORY service=SWESC reopen=30";
alter system set log_archive_dest_2 = "MANDATORY service=SWESC reopen=30"
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16052: DB_UNIQUE_NAME attribute is required


Below are the init file for the primary....

##################################################
## Original Init parameters
##################################################

peregrine.__db_cache_size=2332033024
peregrine.__java_pool_size=16777216
peregrine.__large_pool_size=184549376
peregrine.__shared_pool_size=2533359616
peregrine.__streams_pool_size=0
*.audit_file_dest='/opt/oracle/admin/peregrine/adump'
*.background_dump_dest='/opt/oracle/admin/peregrine/bdump'
*.compatible='10.2.0.2.0'
*.control_files='/ora1/oradata/peregrine/control01.ctl','/ora2/oradata/peregrine/cont
rol02.ctl','/ora3/oradata/peregrine/control03.ctl'
*.core_dump_dest='/opt/oracle/admin/peregrine/cdump'
*.db_block_size=8192
*.db_domain='vscdsh01.northgrum.com'
*.db_file_multiblock_read_count=16
*.db_name='peregrin'
*.db_recovery_file_dest='/ora10/oradata/peregrine'
*.db_recovery_file_dest_size=2147483648
*.db_unique_name='peregrine'
*.dispatchers='(protocol=TCP)'
*.job_queue_processes=10
*.log_archive_dest_1='LOCATION=/oraarch/peregrine'
*.log_archive_format='peregrine_%t_%s_%r.arc'
*.nls_date_format='SYYYY-MM-DD HH24:MI:SS'
*.open_cursors=300
*.pga_aggregate_target=1692401664
*.processes=350
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=390
*.sga_target=5079302144
*.shared_servers=30
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/opt/oracle/admin/peregrine/udump'
##################################################
## End original parameters
##################################################
log_archive_dest_1='LOCATION=/oraarch/peregrine'
log_archive_dest_2='SERVICE=swesc reopen=60'
log_archive_dest_state_1=enable
log_archive_dsst_state_2=enable
log_archive_format=%t_%s.dbf
log_archive_start=true
remote_archive_enable=true
log_archive_config DG_CONFIG=(peregrine,swesc)
fal_client peregrine
fal_server swesc



And here is the init file for the standby

peregrine.__db_cache_size=4647288832
peregrine.__java_pool_size=16777216
peregrine.__large_pool_size=184549376
peregrine.__shared_pool_size=218103808
peregrine.__streams_pool_size=0
*.audit_file_dest='/opt/oracle/admin/peregrine/adump'
*.background_dump_dest='/opt/oracle/admin/peregrine/bdump'
*.compatible='10.2.0.2.0'
*.control_file_record_keep_time=14
*.CONTROL_FILES='/ora1/oradata/peregrine/control01.ctl'
*.core_dump_dest='/opt/oracle/admin/peregrine/cdump'
*.db_block_size=8192
*.db_domain='vscdsh01.northgrum.com'
*.db_file_multiblock_read_count=16
*.DB_NAME='peregrin'
*.db_recovery_file_dest='/ora10/oradata/peregrine'
*.db_recovery_file_dest_size=2147483648
*.DB_UNIQUE_NAME='swesc'
*.dispatchers='(protocol=TCP)'
*.FAL_CLIENT='swesc'
*.FAL_SERVER='peregrine'
*.job_queue_processes=10
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(peregrine,swesc)'
*.LOG_ARCHIVE_DEST_1='LOCATION=/oraarch/swesc/
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=swesc'
*.LOG_ARCHIVE_DEST_2='SERVICE=peregrine LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=peregrine'
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
*.LOG_ARCHIVE_FORMAT='%t_%s_%r.arc'
*.LOG_ARCHIVE_MAX_PROCESSES=30
*.nls_date_format='SYYYY-MM-DD HH24:MI:SS'
*.open_cursors=300
*.pga_aggregate_target=1692401664
*.processes=350
*.REMOTE_LOGIN_PASSWORDFILE='EXCLUSIVE'
*.sessions=390
*.sga_target=5079302144
*.shared_servers=30
*.STANDBY_FILE_MANAGEMENT='AUTO'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/opt/oracle/admin/peregrine/udump'


Did I configure something WRONG here? Seems like I did it right...

Some checks I ran...(primary)

SQL> select * from V$DATAGUARD_CONFIG
2 ;

DB_UNIQUE_NAME
------------------------------
peregrine
swesc

SQL> show parameter db_unique

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string peregrine


Thanks.