{"id":755,"date":"2015-11-30T16:23:08","date_gmt":"2015-11-30T16:23:08","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=755"},"modified":"2015-11-30T16:23:08","modified_gmt":"2015-11-30T16:23:08","slug":"%ec%95%84%ec%b9%b4%ec%9d%b4%eb%b8%8c%eb%a1%9c%ea%b7%b8-%ec%9e%a5%ec%95%a0full","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=755","title":{"rendered":"\uc544\uce74\uc774\ube0c\ub85c\uadf8 \uc7a5\uc560(FULL)"},"content":{"rendered":"<p><UL style=\"MARGIN-LEFT: 48pt\"><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\ub9ac\ucee4\ubc84\ub9ac \ub370\uc2a4\ud2b8 \uc0ac\uc774\uc988 \ud655\uc778 \ubc0f \uc218\uc815 <\/SPAN><\/DIV><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">oracle@solaris:\/u01\/app\/oracle\/fast_recovery_area\/ORCL1\/archivelog\/2015_01_14$ ss&nbsp;<\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 15 00:04:29 2015&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Copyright (c) 1982, 2013, Oracle. All rights reserved.&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Connected to: <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Oracle Database 11g Release 11.2.0.4.0 &#8211; 64bit Production&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; show parameter db_recovery_file_dest_size&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">NAME TYPE VALUE <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">db_recovery_file_dest_size big integer 4G <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; alter system set db_recovery_file_dest_size=1G scope=both ;&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">System altered.&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; show parameter db_recovery_file_dest_size&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">NAME TYPE VALUE <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">db_recovery_file_dest_size big integer 1G <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; <\/SPAN><\/P><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile25.uf.247F2B4C565C77EA250CA0.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">insert(dml \uc218\ud589) <\/SPAN><\/DIV><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">oracle@solaris:\/u01\/app\/oracle\/fast_recovery_area\/ORCL1\/archivelog\/2015_01_14$ ss&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL*Plus: Release 11.2.0.4.0 Production on Wed Jan 14 23:56:00 2015&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Copyright (c) 1982, 2013, Oracle. All rights reserved.&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Connected to: <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Oracle Database 11g Release 11.2.0.4.0 &#8211; 64bit Production&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; conn scott\/tiger <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Connected. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; insert into emp select * from emp ;&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">14 rows created.&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; \/&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">28 rows created.&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; \/&nbsp;<\/SPAN>&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">56 rows created. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; commit ;&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Commit complete. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; insert into emp select * from emp ;&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">229376 rows created.&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; \/&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">458752 rows created.&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; \/&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">917504 rows created.&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; \/&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">1835008 rows created.&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; commit ;&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Commit complete.&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; insert into emp select * from emp ;&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">3670016 rows created.&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; commit ;&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Commit complete.&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; insert into emp select * from emp ;&nbsp;<\/SPAN>&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">7340032 rows created. <\/SPAN><\/P><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\uc5d0\ub7ec\ubc1c\uc0dd \ubc0f \uc544\uce74\uc774\ube0c full \ud655\uc778 <\/SPAN><\/DIV><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Thu Jan 15 00:04:52 2015 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Errors in file \/u01\/app\/oracle\/diag\/rdbms\/orcl1\/orcl1\/trace\/orcl1_m000_5319.trc: <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">ORA-19815: WARNING: db_recovery_file_dest_size of 1073741824 bytes is 100.00% used, and has 0 remaining bytes available. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">************************************************************************ <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">You have following choices to free up space from recovery area: <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard, <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">then consider changing RMAN ARCHIVELOG DELETION POLICY. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">2. Back up files to tertiary device such as tape using RMAN <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">BACKUP RECOVERY AREA command. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">3. Add disk space and increase db_recovery_file_dest_size parameter to <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">reflect the new space. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">4. Delete unnecessary files using RMAN DELETE command. If an operating <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">system command was used to delete files, then use RMAN CROSSCHECK and <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">DELETE EXPIRED commands. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">************************************************************************ <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Thu Jan 15 00:05:58 2015 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Thread 1 advanced to log sequence 44 (LGWR switch) <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Current log# 2 seq# 44 mem# 0: \/u01\/app\/oracle\/oradata\/orcl1\/redo02.log <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Thu Jan 15 00:05:59 2015 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Errors in file \/u01\/app\/oracle\/diag\/rdbms\/orcl1\/orcl1\/trace\/orcl1_arc2_1811.trc: <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">ORA-19815: WARNING: db_recovery_file_dest_size of 1073741824 bytes is 100.00% used, and has 0 remaining bytes available. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">************************************************************************ <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">You have following choices to free up space from recovery area: <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard, <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">then consider changing RMAN ARCHIVELOG DELETION POLICY. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">2. Back up files to tertiary device such as tape using RMAN <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">BACKUP RECOVERY AREA command. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">3. Add disk space and increase db_recovery_file_dest_size parameter to <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">reflect the new space. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">4. Delete unnecessary files using RMAN DELETE command. If an operating <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">system command was used to delete files, then use RMAN CROSSCHECK and <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">DELETE EXPIRED commands. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">************************************************************************ <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">ARC2: Error 19809 Creating archive log file to &#8216;\/u01\/app\/oracle\/fast_recovery_area\/ORCL1\/archivelog\/2015_01_15\/o1_mf_1_43_%u_.arc&#8217; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">ARCH: Archival stopped, error occurred. Will continue retrying <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">ORACLE Instance orcl1 &#8211; Archival Error <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">ORA-16038: log 1 sequence# 43 cannot be archived <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">ORA-19809: limit exceeded for recovery files <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">ORA-00312: online log 1 thread 1: &#8216;\/u01\/app\/oracle\/oradata\/orcl1\/redo01.log&#8217; <\/SPAN><\/P><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile4.uf.257AE03A565C77EB07D40A.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\ud574\uacb0\ubc29\ubc95 <\/SPAN><\/DIV><br \/>\n<UL><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">recovery size \uc99d\uac00 <\/SPAN><\/DIV><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; show parameter recovery&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">NAME TYPE VALUE <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">db_recovery_file_dest string \/u01\/app\/oracle\/fast_recovery_ <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">area <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">db_recovery_file_dest_size big integer 1G <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">recovery_parallelism integer 0 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; alter system set db_recovery_file_dest_size=5G scope=both ;&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">System altered. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; show parameter db_recovery_file_dest_size&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">NAME TYPE VALUE <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">db_recovery_file_dest_size big integer 5G&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">== <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">************************************************************************ <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">You have following choices to free up space from recovery area: <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Errors in file \/u01\/app\/oracle\/diag\/rdbms\/orcl1\/orcl1\/trace\/orcl1_arc3_1812.trc: <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">ORA-19815: WARNING: db_recovery_file_dest_size of 1073741824 bytes is 100.00% used, and has 0 remaining bytes available. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard, <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">************************************************************************ <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">then consider changing RMAN ARCHIVELOG DELETION POLICY. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">You have following choices to free up space from recovery area: <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">2. Back up files to tertiary device such as tape using RMAN <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard, <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">BACKUP RECOVERY AREA command. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">then consider changing RMAN ARCHIVELOG DELETION POLICY. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">3. Add disk space and increase db_recovery_file_dest_size parameter to <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">2. Back up files to tertiary device such as tape using RMAN <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">reflect the new space. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">BACKUP RECOVERY AREA command. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">4. Delete unnecessary files using RMAN DELETE command. If an operating <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">3. Add disk space and increase db_recovery_file_dest_size parameter to <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">system command was used to delete files, then use RMAN CROSSCHECK and <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">reflect the new space. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">DELETE EXPIRED commands. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">4. Delete unnecessary files using RMAN DELETE command. If an operating <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">************************************************************************ <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">ARC2: Error 19809 Creating archive log file to &#8216;\/u01\/app\/oracle\/fast_recovery_area\/ORCL1\/archivelog\/2015_01_15\/o1_mf_1_43_%u_.arc&#8217; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">system command was used to delete files, then use RMAN CROSSCHECK and <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">DELETE EXPIRED commands. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">************************************************************************ <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">ARC3: Error 19809 Creating archive log file to &#8216;\/u01\/app\/oracle\/fast_recovery_area\/ORCL1\/archivelog\/2015_01_15\/o1_mf_1_44_%u_.arc&#8217; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Thu Jan 15 00:16:39 2015 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">ALTER SYSTEM SET db_recovery_file_dest_size=&#8217;5G&#8217; SCOPE=BOTH; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Thu Jan 15 00:16:44 2015 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Archived Log entry 39 added for thread 1 sequence 43 ID 0x4a516e3d dest 1: <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Archiver process freed from errors. No longer stopped <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Thu Jan 15 00:16:45 2015 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Thread 1 advanced to log sequence 46 (LGWR switch) <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Current log# 1 seq# 46 mem# 0: \/u01\/app\/oracle\/oradata\/orcl1\/redo01.log <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Thu Jan 15 00:16:45 2015 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Archived Log entry 40 added for thread 1 sequence 44 ID 0x4a516e3d dest 1: <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Thu Jan 15 00:16:45 2015 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">db_recovery_file_dest_size of 5120 MB is 26.55% used. This is a <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">user-specified limit on the amount of space that will be used by this <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">database for recovery-related files, and does not reflect the amount of <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">space available in the underlying filesystem or ASM diskgroup. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Thu Jan 15 00:16:47 2015 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Archived Log entry 41 added for thread 1 sequence 45 ID 0x4a516e3d dest 1: <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">os rm <\/SPAN><\/DIV><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; alter system set db_recovery_file_dest_size=1536M scope=both ;&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">System altered.&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">ALTER SYSTEM SET db_recovery_file_dest_size=&#8217;1536M&#8217; SCOPE=BOTH; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Thu Jan 15 01:06:59 2015 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Errors in file \/u01\/app\/oracle\/diag\/rdbms\/orcl1\/orcl1\/trace\/orcl1_m000_5422.trc: <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">ORA-19815: WARNING: db_recovery_file_dest_size of 1610612736 bytes is 89.36% used, and has 171366400 remaining bytes available. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">************************************************************************ <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">You have following choices to free up space from recovery area: <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard, <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">then consider changing RMAN ARCHIVELOG DELETION POLICY. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">2. Back up files to tertiary device such as tape using RMAN <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">BACKUP RECOVERY AREA command. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">3. Add disk space and increase db_recovery_file_dest_size parameter to <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">reflect the new space. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">4. Delete unnecessary files using RMAN DELETE command. If an operating <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">system command was used to delete files, then use RMAN CROSSCHECK and <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">DELETE EXPIRED commands. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">************************************************************************ <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">## insert \uc7ac \uc218\ud589 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; insert into dept select * from dept ;&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">4 rows created.&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; \/&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">8 rows created.&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; \/&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">16 rows created. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; insert into dept select * from dept ;&nbsp;<\/SPAN>&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">4194304 rows created.&nbsp;<\/SPAN>&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; commit ;&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Commit complete.&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">## \uc7a5\uc560 \ubc1c\uc0dd <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Errors in file \/u01\/app\/oracle\/diag\/rdbms\/orcl1\/orcl1\/trace\/orcl1_m000_5422.trc: <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">ORA-19815: WARNING: db_recovery_file_dest_size of 1610612736 bytes is<SPAN style=\"COLOR: red\"> 89.36%<SPAN style=\"COLOR: black\"> used, and has 171366400 remaining bytes available. <\/SPAN><\/SPAN><\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">************************************************************************ <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">You have following choices to free up space from recovery area: <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard, <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">then consider changing RMAN ARCHIVELOG DELETION POLICY. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">2. Back up files to tertiary device such as tape using RMAN <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">BACKUP RECOVERY AREA command. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">3. Add disk space and increase db_recovery_file_dest_size parameter to <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">reflect the new space. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">4. Delete unnecessary files using RMAN DELETE command. If an operating <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">system command was used to delete files, then use RMAN CROSSCHECK and <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">DELETE EXPIRED commands. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">************************************************************************ <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Thu Jan 15 01:11:16 2015 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Thread 1 advanced to log sequence 50 (LGWR switch) <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Current log# 2 seq# 50 mem# 0: \/u01\/app\/oracle\/oradata\/orcl1\/redo02.log <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\/\/\/\/ <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Thu Jan 15 01:35:33 2015 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Errors in file \/u01\/app\/oracle\/diag\/rdbms\/orcl1\/orcl1\/trace\/orcl1_arc2_1811.trc: <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">ORA-19815: WARNING: db_recovery_file_dest_size of 1610612736 bytes is <SPAN style=\"COLOR: red\">100.00%<SPAN style=\"COLOR: black\"> used, and has 0 remaining bytes available. <\/SPAN><\/SPAN><\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">************************************************************************ <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">You have following choices to free up space from recovery area: <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard, <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">then consider changing RMAN ARCHIVELOG DELETION POLICY. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">2. Back up files to tertiary device such as tape using RMAN <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">BACKUP RECOVERY AREA command. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">3. Add disk space and increase db_recovery_file_dest_size parameter to <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">reflect the new space. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">4. Delete unnecessary files using RMAN DELETE command. If an operating <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">system command was used to delete files, then use RMAN CROSSCHECK and <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">DELETE EXPIRED commands. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">************************************************************************ <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">ARC2: Error 19809 Creating archive log file to &#8216;\/u01\/app\/oracle\/fast_recovery_area\/ORCL1\/archivelog\/2015_01_15\/o1_mf_1_57_%u_.arc&#8217; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">ARCH: Archival stopped, error occurred. Will continue retrying <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">ORACLE Instance orcl1 &#8211; Archival Error <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">ORA-16038: log 3 sequence# 57 cannot be archived <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">ORA-19809: limit exceeded for recovery files <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">ORA-00312: online log 3 thread 1: &#8216;\/u01\/app\/oracle\/oradata\/orcl1\/redo03.log&#8217; <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">## \uc0ac\uc774\uc988 \ud655\uc778&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">oracle@solaris:\/u01\/app\/oracle\/fast_recovery_area\/ORCL1\/archivelog$ pwd <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\/u01\/app\/oracle\/fast_recovery_area\/ORCL1\/archivelog <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">oracle@solaris:\/u01\/app\/oracle\/fast_recovery_area\/ORCL1\/archivelog$ ls -la <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">total 30 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">drwxr-x&#8212; 10 oracle dba 10 1\uc6d4 15\uc77c 00:00 . <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">drwxr-x&#8212; 4 oracle dba 4 10\uc6d4 31\uc77c 22:00 .. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">drwxr-x&#8212; 2 oracle dba 3 10\uc6d4 31\uc77c 22:00 2014_10_31 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">drwxr-x&#8212; 2 oracle dba 4 11\uc6d4 1\uc77c 20:00 2014_11_01 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">drwxr-x&#8212; 2 oracle dba 4 11\uc6d4 2\uc77c 16:00 2014_11_02 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">drwxr-x&#8212; 2 oracle dba 4 11\uc6d4 3\uc77c 22:00 2014_11_03 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">drwxr-x&#8212; 2 oracle dba 5 12\uc6d4 2\uc77c 05:00 2014_12_02 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">drwxr-x&#8212; 2 oracle dba 5 1\uc6d4 13\uc77c 20:10 2015_01_13 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">drwxr-x&#8212; 2 oracle dba 16 1\uc6d4 14\uc77c 23:59 2015_01_14 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">drwxr-x&#8212; 2 oracle dba 27 1\uc6d4 15\uc77c 01:35 2015_01_15 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">oracle@solaris:\/u01\/app\/oracle\/fast_recovery_area\/ORCL1\/archivelog$ du -sm <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">1534 .&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">## os \uc544\uce74\uc774\ube0c \uc0ad\uc81c <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">oracle@solaris:\/u01\/app\/oracle\/fast_recovery_area\/ORCL1\/archivelog$ ls -ltr <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">total 24 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">drwxr-x&#8212; 2 oracle dba 3 10\uc6d4 31\uc77c 22:00 2014_10_31 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">drwxr-x&#8212; 2 oracle dba 4 11\uc6d4 1\uc77c 20:00 2014_11_01 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">drwxr-x&#8212; 2 oracle dba 4 11\uc6d4 2\uc77c 16:00 2014_11_02 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">drwxr-x&#8212; 2 oracle dba 4 11\uc6d4 3\uc77c 22:00 2014_11_03 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">drwxr-x&#8212; 2 oracle dba 5 12\uc6d4 2\uc77c 05:00 2014_12_02 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">drwxr-x&#8212; 2 oracle dba 5 1\uc6d4 13\uc77c 20:10 2015_01_13 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">drwxr-x&#8212; 2 oracle dba 16 1\uc6d4 14\uc77c 23:59 2015_01_14 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">drwxr-x&#8212; 2 oracle dba 27 1\uc6d4 15\uc77c 01:35 2015_01_15 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">oracle@solaris:\/u01\/app\/oracle\/fast_recovery_area\/ORCL1\/archivelog$ rm -rf 2014* <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">oracle@solaris:\/u01\/app\/oracle\/fast_recovery_area\/ORCL1\/archivelog$ ls -ltr <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">total 9 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">drwxr-x&#8212; 2 oracle dba 5 1\uc6d4 13\uc77c 20:10 2015_01_13 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">drwxr-x&#8212; 2 oracle dba 16 1\uc6d4 14\uc77c 23:59 2015_01_14 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">drwxr-x&#8212; 2 oracle dba 27 1\uc6d4 15\uc77c 01:35 2015_01_15 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">oracle@solaris:\/u01\/app\/oracle\/fast_recovery_area\/ORCL1\/archivelog$ du -sm <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">1171 . <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">## \uc7a5\uc560 \uc9c0\uc18d <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">************************************************************************ <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">You have following choices to free up space from recovery area: <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard, <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">then consider changing RMAN ARCHIVELOG DELETION POLICY. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">2. Back up files to tertiary device such as tape using RMAN <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">BACKUP RECOVERY AREA command. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">3. Add disk space and increase db_recovery_file_dest_size parameter to <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">reflect the new space. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">4. Delete unnecessary files using RMAN DELETE command. If an operating <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">system command was used to delete files, then use RMAN CROSSCHECK and <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">DELETE EXPIRED commands. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">************************************************************************ <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">ARC0: Error 19809 Creating archive log file to &#8216;\/u01\/app\/oracle\/fast_recovery_area\/ORCL1\/archivelog\/2015_01_15\/o1_mf_1_58_%u_.arc&#8217; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">system command was used to delete files, then use RMAN CROSSCHECK and <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">DELETE EXPIRED commands. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">************************************************************************ <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">ARC3: Error 19809 Creating archive log file to &#8216;\/u01\/app\/oracle\/fast_recovery_area\/ORCL1\/archivelog\/2015_01_15\/o1_mf_1_57_%u_.arc&#8217; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Errors in file \/u01\/app\/oracle\/diag\/rdbms\/orcl1\/orcl1\/trace\/orcl1_arc2_1811.trc: <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">ORA-19815: WARNING: db_recovery_file_dest_size of 1610612736 bytes is 100.00% used, and has 0 remaining bytes available. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">************************************************************************ <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">You have following choices to free up space from recovery area: <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard, <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">then consider changing RMAN ARCHIVELOG DELETION POLICY. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">2. Back up files to tertiary device such as tape using RMAN <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">BACKUP RECOVERY AREA command. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">3. Add disk space and increase db_recovery_file_dest_size parameter to <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">reflect the new space. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">4. Delete unnecessary files using RMAN DELETE command. If an operating <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">system command was used to delete files, then use RMAN CROSSCHECK and <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">DELETE EXPIRED commands. <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">## RMAN \uc791\uc5c5 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">### crosscheck <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">oracle@solaris:\/u01\/app\/oracle\/fast_recovery_area\/ORCL1\/archivelog$ rman target \/&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Recovery Manager: Release 11.2.0.4.0 &#8211; Production on Thu Jan 15 01:39:39 2015&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Copyright (c) 1982, 2011, Oracle and\/or its affiliates. All rights reserved.&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">connected to target database: ORCL1 (DBID=1246882109)&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">RMAN&gt; crosscheck archivelog all ;&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">using target database control file instead of recovery catalog <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">allocated channel: ORA_DISK_1 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">channel ORA_DISK_1: SID=23 device type=DISK <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">validation failed for archived log <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">archived log file name=\/u01\/app\/oracle\/fast_recovery_area\/ORCL1\/archivelog\/2014_10_31\/o1_mf_1_5_b571z17q_.arc RECID=1 STAMP=862437618 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">validation failed for archived log <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">archived log file name=\/u01\/app\/oracle\/fast_recovery_area\/ORCL1\/archivelog\/2014_11_01\/o1_mf_1_6_b58d8ob5_.arc RECID=2 STAMP=862480934 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\/\/\/\/ <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">validation succeeded for archived log <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">archived log file name=\/u01\/app\/oracle\/fast_recovery_area\/ORCL1\/archivelog\/2015_01_15\/o1_mf_1_56_bcf6pf6m_.arc RECID=52 STAMP=869016926 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Crosschecked 52 objects <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">### delete archive <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">RMAN&gt; delete expired archivelog all ;&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">released channel: ORA_DISK_1 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">allocated channel: ORA_DISK_1 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">channel ORA_DISK_1: SID=23 device type=DISK <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">List of Archived Log Copies for database with db_unique_name ORCL1 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">=====================================================================&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Key Thrd Seq S Low Time <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">&#8212;&#8212;- &#8212;- &#8212;&#8212;- &#8211; &#8212;&#8212;&#8212; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">1 1 5 X 31-OCT-14 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Name: \/u01\/app\/oracle\/fast_recovery_area\/ORCL1\/archivelog\/2014_10_31\/o1_mf_1_5_b571z17q_.arc&nbsp;<\/SPAN>&nbsp;&nbsp;&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">2 1 6 X 31-OCT-14 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Name: \/u01\/app\/oracle\/fast_recovery_area\/ORCL1\/archivelog\/2014_11_01\/o1_mf_1_6_b58d8ob5_.arc <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\/\/\/ <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Do you really want to delete the above objects (enter YES or NO)? yes <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">deleted archived log <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">archived log file name=\/u01\/app\/oracle\/fast_recovery_area\/ORCL1\/archivelog\/2014_10_31\/o1_mf_1_5_b571z17q_.arc RECID=1 STAMP=862437618 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">deleted archived log <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">archived log file name=\/u01\/app\/oracle\/fast_recovery_area\/ORCL1\/archivelog\/2014_11_01\/o1_mf_1_6_b58d8ob5_.arc RECID=2 STAMP=862480934 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\/\/\/ <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Deleted 10 EXPIRED objects <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">## \uc7a5\uc560 \ud574\uacb0 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Thu Jan 15 01:40:49 2015 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Archived Log entry 54 added for thread 1 sequence 57 ID 0x4a516e3d dest 1: <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Thu Jan 15 01:41:13 2015 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">db_recovery_file_dest_size of 1536 MB is 82.19% used. This is a <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">user-specified limit on the amount of space that will be used by this <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">database for recovery-related files, and does not reflect the amount of <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">space available in the underlying filesystem or ASM diskgroup. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">?ALTER SYSTEM SET db_recovery_file_dest_size=&#8217;1536M&#8217; SCOPE=BOTH; <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">&nbsp; <\/SPAN>&nbsp;<\/P><\/LI><\/UL><\/LI><\/UL><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ub9ac\ucee4\ubc84\ub9ac \ub370\uc2a4\ud2b8 \uc0ac\uc774\uc988 \ud655\uc778 \ubc0f \uc218\uc815 oracle@solaris:\/u01\/app\/oracle\/fast_recovery_area\/ORCL1\/archivelog\/2015_01_14$ ss&nbsp; SQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 15 00:04:29 2015&nbsp;&nbsp;&nbsp;&nbsp; Copyright (c) 1982, 2013, Oracle. All rights reserved.&nbsp;&nbsp;&nbsp;&nbsp; Connected to: Oracle Database 11g Release 11.2.0.4.0 &#8211; 64bit Production&nbsp;&nbsp;&nbsp;&nbsp; SQL&gt; show parameter db_recovery_file_dest_size&nbsp;&nbsp;&nbsp;&nbsp; NAME TYPE VALUE &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; db_recovery_file_dest_size big integer 4G SQL&gt; alter system set db_recovery_file_dest_size=1G [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":756,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[14],"tags":[436,437,438,439,440],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile4.uf.257AE03A565C77EB07D40A.png?fit=919%2C588","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/755"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=755"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/755\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/756"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=755"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=755"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=755"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}