On the Friday to a customer to do database inspection, is the window 2008 system on the 10g of a set of NC system library, has been configured DG, but the inspection found that the database error:
Tue Nov 10:13:57 2014lns:standby redo logfile selected for thread 1 sequence 3945 for destination Log_archive_dest_2tu E Nov 10:14:29 2014Errors in file d:\oracle\product\10.2.0\admin\nc\bdump\nc_arc0_177356.trc:Ora-16401:archivelog rejected by RFS
Fal[server, ARC0]: FAL archive failed, see trace file. Sun Nov 04:05:12 2014Errors in file d:\oracle\product\10.2.0\admin\nc\bdump\nc_arc0_177356.trc:Ora-16055:fal request rejected
Arch:fal Archive failed. Archiver Continuingsun Nov 04:05:15 2014Errors in file d:\oracle\product\10.2.0\admin\nc\bdump\nc_arc0_177356.trc:Ora-00270:error Creating archive log
Prompt archive log rejected by RFS process, FAL process request rejected, unable to create archive log
2014-11-11 10:14:29.806tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x2) Tkcrrpa: (WARN) Failed initial A Ttempt to send ARCH message (message:0x2)Error 16401 Creating standby archive log file at host ' NCDG 'Ora-16401:archivelog rejected by RFS2014-11-11 10:15:29.900tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x2) Tkcrrpa: (WARN) Failed initial A Ttempt to send ARCH message (message:0x2)Error 16401 Creating standby archive log file at host ' NCDG 'Ora-16401:archivelog rejected by RFS2014-11-11 10:16:29.962tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x2) Tkcrrpa: (WARN) Failed initial A Ttempt to send ARCH message (message:0x2)Error 16401 Creating standby archive log file at host ' NCDG 'Ora-16401:archivelog rejected by RFS2014-11-11 10:17:30.025tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x2) Tkcrrpa: (WARN) Failed initial A Ttempt to send ARCH message (message:0x2)Error 16401 Creating standby archive log file at host ' NCDG 'Ora-16401:archivelog rejected by RFS2014-11-11 10:18:30.088tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x2) Tkcrrpa: (WARN) Failed initial A Ttempt to send ARCH message (message:0x2)Error 16401 Creating standby archive log file at host ' NCDG 'Ora-16401:archivelog rejected by RFS
View trace file Nc_arc0_177356.trc learned that from November 11 10:14 A.M. Error, is similar to the prompt, and then the target host can not create an archive log file, an average of 1 minutes to report errors, in the Standby library view, It turns out that the disk space is exhausted because there is no regular cleanup of archived logs passed by the main library.
70G space all ran out, because the customer's disk is relatively small, some of which are also used to store data files, itself will occupy 47G.
The last archived log is generated on November 11, 7:25, there is no, this and the trace file error is also consistent, because this time exhausted the last space of the disk, resulting in the main library alarm log in the failure to create a remote archive error, since the problem has been found, So it's easy to deal with it, remove the archive that was applied to the repository, and free up disk space.
Because of the gap in the repository archive, and these gaps are not in the archive of the main library, the main library does not retain a very many archives, and the archive log does not have a separate backup set, so only the reconfiguration of the DG configuration.
Today, the client over there, the DG reconfigured a bit. Step is actually very simple, because it has been configured once, this time as long as the synchronization of the line, do not need to modify parameters, copy parameter files, password files, Tnsnames.ora, Listener.ora and so on, just need to create a repository control file in the main library, and then the main library Rman backup set to the repository to recover it. The specific process here does not write, after the deployment of DG, check both sides of the archive path status, to determine that no error after opening redo apply, the repository and the main library data synchronization.
Because the free disk space is still relatively small, so this time specifically to the customer configured to automatically delete the Repository archive log script, the main use of 3 files, roughly the following:
--delete_dg_archivelogCD d:\archivelogdeld:sqlplus/as sysdba @delete_archive. SQL Echo Rman Target/cmdfile=rman_checkcross.rman>>dele Te_archivelog.bat delete_archivelog.bat >>delete_dg_archivelog_%date:~0,4%%date:~5,2%%date:~8,2% ". Log exit
--delete_archive.sqlSet lines col name for a150 set pagesize 0 feedback off verify off heading off echo off spool Delete_archivelog.batselect ' Del ' | | Name from V$archived_log where applied= ' YES ' and NAME are not NULL and dest_id=1;Spool off exit;
--rman_checkcross.rmanCrosscheck Archivelog All; Delete noprompt expired archivelog all; Exit
Here is a description of the script, where the first bat script to call the Delte_archive.sql and Rman_checkcross.rman 2 command files, the main thing is Delete_ Archive.sql the execution of this script, use the SQL stitching to find the archived files that have been applied, then generate the del command, delete them at the OS level, and finally call the Rman command cross-check, and finally delete the expired archive log (OS-level Delete, also notify the control file these archives no longer exist , need to be deleted), if the log is not yet in the repository application, then the previous SELECT statement will not query travel records.
Today when the first time to do delete_archivelog.sql in the SELECT statement with the dest_id=1 time, incredibly did not find the data row, with the dest_id=2 have the result, and later encountered with dest_id=2 did not result, and then change back to dest_id =1 is fine. In factThe main thing is to pay attention to the SQL script to run out of the results, otherwise the previous commands are equal to not work, no results, OS commands will not go to del these files, and if the OS level does not del out of these files, then Rman can not check out is expired, Therefore, the related records of these archives are not deleted from the control files.
finally add this script to the Windows Task Scheduler to run regularly, as the customer's log switching frequency is not high, so it is tentatively scheduled to be archived weekly.
DG Standby disk space is full, resulting in an archive cannot be created
