Hi Exports,Exports ;)
I am getting the following Error Under the Application event log in the server manager windows. As i am the only DBA in this company i have the solve the server issue also.Do you have configured more than one destination? Or remote destinations(Data Guard) ?
*"archive process. error oracle instance prod. archival error. archiver continuing"*
My database is running in Windows O/S.
I checked the archive location as there is only 4 GB space free
Thu Jan 17 10:58:57 2013You have standby database(s) also.
Error 12170 received logging on to the standby
set lines 100 col name format a60 select name , floor(space_limit / 1024 / 1024) "Size MB" , ceil(space_used / 1024 / 1024) "Used MB" from v$recovery_file_dest order by name /
SQL> show parameter dest_2provide all the requested information next time. Thanks.
SQL> archive log list
966523 wrote:Sure, if you don't need this standby anymore just execute 'alter system set log_archive_dest_state_2=defer' (this is the dynamic parameter) and errors 12170 in your alert log will disappear.
Can i use LOG_ARCHIVE_DEST_STATE_n=defer...