{"id":880,"date":"2013-05-22T12:23:22","date_gmt":"2013-05-22T04:23:22","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=880"},"modified":"2013-05-22T12:59:05","modified_gmt":"2013-05-22T04:59:05","slug":"%e5%a2%9e%e9%87%8f%e5%a4%87%e4%bb%bd%e6%81%a2%e5%a4%8d%e7%9a%84%e4%b8%80%e4%b8%aa%e5%b0%8f%e4%be%8b%e5%ad%90","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=880","title":{"rendered":"\u589e\u91cf\u5907\u4efd\u6062\u590d\u7684\u4e00\u4e2a\u5c0f\u4f8b\u5b50"},"content":{"rendered":"<p>\u80cc\u666f\uff1a\u4e00\u4e2a\u9879\u76ee\u9700\u8981\u6062\u590d\u4e00\u4e2a\u5e93\u505a\u6d4b\u8bd5\uff0c\u4e4b\u524d\u6709\u6e90\u5e93\u7684\u589e\u91cf\u5907\u4efd\uff080+1+2\u7ea7\uff09\uff0c\u65f6\u95f4\u7a97\u53e3\u53ea\u67095H\uff0c\u6d4b\u8bd5\u7684\u65f6\u5019\u53d1\u73b0\u6062\u590d\u4e00\u4e2a0\u7ea7\u5168\u5907\u9700\u89813H\uff0c\u518d\u52a0\u4e00\u4e9b\u5176\u4ed6\u64cd\u4f5c\uff0c\u65f6\u95f4\u7a97\u53e3\u5185\u5b8c\u6210\u6d4b\u8bd5\u8f83\u4e3a\u7d27\u5f20\u3002\u4e00\u4e2a\u540c\u4e8b\u63d0\u51fa\u8bf4\u5728\u8fdb\u884c2\u7ea7\u589e\u91cf\u6062\u590d\u7684\u65f6\u5019\uff0c\u6570\u636e\u5e93\u4f1a\u4ece\u4e4b\u524d\u6240\u6709\u53ef\u7528\u76840\u7ea7+2\u7ea7+1\u7ea7\u5168\u90e8\u4ece\u5934\u6765\u4e00\u904d\uff0c\u8fd9\u6837\u5c31\u4f1a\u82b1\u8d39\u4e00\u4e2a0\u7ea7\u6062\u590d\u7684\u65f6\u95f4\uff0c\u7406\u8bba\u4e0a\u589e\u91cf\u5907\u4efd\u6062\u590d\u5e94\u8be5\u662f\u5f88\u667a\u80fd\u7684\uff0c\u6ca1\u6709\u8fd9\u4e48\u7b28\uff0c\u9042\u6709\u4e0b\u8fb9\u7684\u8fd9\u4e2a\u5c0f\u6d4b\u8bd5\uff0c\u5c31\u662f\u4e8b\u5148\u5c060\u7ea7restore\uff0c\u7b49\u5230\u65f6\u95f4\u7a97\u53e3\u65f6\u518drecover 2\u7ea7\uff0c\u8fd9\u6837\u65f6\u95f4\u5c31\u4f1a\u817e\u51fa\u6765\u3002<\/p>\n<p>\u589e\u91cf\u5907\u4efd\u6062\u590d\u6d4b\u8bd5<br \/>\n\u987a\u5e8f\t\u589e\u91cf\u7ea7\u522b\t\u6570\u636e\u65f6\u95f4\u70b9<br \/>\n1\t0\t2013\/05\/21 18:38:54<br \/>\n2\t2\t2013\/05\/21 18:45:15<br \/>\n3\t1\t2013\/05\/21 18:51:15<br \/>\n4\t2\t2013\/05\/21 18:57:55<\/p>\n<p>\u6062\u590d\u987a\u5e8f<br \/>\n1\u3001\u6062\u590d0\u7ea7\u589e\u91cf\u5907\u4efd\uff08restore+recover\uff09<br \/>\n2\u3001\u6062\u590d\u7b2c\u4e00\u4e2a2\u7ea7\uff08\u5373\u987a\u5e8f\u53f7\u4e3a2\uff09\u7684\u63a7\u5236\u6587\u4ef6\uff0c\u6062\u590d\u6570\u636e\u5e93\uff08recover\uff09<\/p>\n<p>\u9a8c\u8bc1\u7684\u7ed3\u679c\uff1a<br \/>\n\u5728\u8fdb\u884c2\u7ea7recover\u7684\u65f6\u5019\uff0c\u53ea\u5e94\u75282\u7ea7\u7684\u589e\u91cf\u5907\u4efd\u7684\u6587\u4ef6\uff0c\u4e0d\u4f1a\u518d\u6b21\u5e94\u7528\u4e4b\u524d\u76840\u7ea7\u5907\u4efd\u6587\u4ef6\u3002<\/p>\n<p>**************************************************\u4ee5\u4e0b\u4e3a\u6d4b\u8bd5\u8fc7\u7a0b**************************************************<\/p>\n<p><strong>\u6570\u636e\u5e93\u7248\u672c<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; select * from v$version;\r\n\r\nBANNER\r\n----------------------------------------------------------------\r\nOracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod\r\nPL\/SQL Release 10.2.0.1.0 - Production\r\nCORE    10.2.0.1.0      Production\r\nTNS for Linux: Version 10.2.0.1.0 - Production\r\nNLSRTL Version 10.2.0.1.0 - Production\r\n<\/pre>\n<p><strong>\u5efa\u6d4b\u8bd5\u6570\u636e<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; create tablespace yallonking datafile &#039;\/u01\/app\/oracle\/oradata\/ora10gr2\/yallonking01.dbf&#039; size 1m;\r\n\r\nTablespace created.\r\n\r\nSQL&gt; create user yallonking identified by yallonking default tablespace yallonking quota unlimited on yallonking;\r\n\r\nUser created.\r\n\r\nSQL&gt; grant dba to yallonking\r\n  2  ;\r\n\r\nGrant succeeded.\r\n\r\nSQL&gt; conn yallonking\/yallonking\r\nConnected.\r\nSQL&gt; create table yallonking (id number,name varchar2(20),my_date date);\r\n\r\nTable created.\r\n\r\nSQL&gt; insert into yallonking values (1,&#039;0&#039;,sysdate);\r\n\r\n1 row created.\r\n\r\nSQL&gt; commit;   \r\n\r\nCommit complete.\r\n\r\nSQL&gt; alter session set nls_date_format=&#039;yyyy\/mm\/dd hh24:mi:ss&#039;;\r\n\r\nSession altered.\r\n\r\nSQL&gt; select * from yallonking;\r\n\r\n        ID NAME                 MY_DATE\r\n---------- -------------------- -------------------\r\n         1 0                    2013\/05\/21 18:38:54\t\t \r\n<\/pre>\n<p><strong>\u8fdb\u884c0\u7ea7\u589e\u91cf\u5907\u4efd<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@ora10gr2 ~]$ rman target \/ \r\n\r\nRecovery Manager: Release 10.2.0.1.0 - Production on Tue May 21 18:42:31 2013\r\n\r\nCopyright (c) 1982, 2005, Oracle.  All rights reserved.\r\n\r\nconnected to target database: ORA10GR2 (DBID=4093928674)\r\n\r\nRMAN&gt; run {\r\n2&gt; allocate channel c1 type disk;\r\n3&gt; allocate channel c2 type disk;\r\n4&gt; backup \r\n5&gt;   incremental level 0\r\n6&gt;      skip inaccessible filesperset 5 \r\n7&gt;        Database format=&#039;\/tmp\/orcl_lev0_%U_%T&#039; tag=&#039;orcl_lev0&#039; ;\r\n8&gt; sql &#039;alter system archive log current&#039;;\r\n9&gt; backup format &#039;\/tmp\/arch_%s_%p_%t.bak&#039;\r\n10&gt;   filesperset 5\r\n11&gt;     archivelog all delete input skip inaccessible;\r\n12&gt; backup current controlfile tag=&#039;bak_ctlfile&#039; format=&#039;\/tmp\/ctl_file_%U_%T&#039;;\r\n13&gt; backup spfile tag=&#039;spfile&#039; format=&#039;\/tmp\/ORCL_spfile_%U_%T&#039;;\r\n14&gt; release channel c1;\r\n15&gt; release channel c2;\r\n16&gt; }\r\n\r\nusing target database control file instead of recovery catalog\r\nallocated channel: c1\r\nchannel c1: sid=145 devtype=DISK\r\n... ...\r\nchannel c1: backup set complete, elapsed time: 00:00:01\r\nFinished backup at 21-MAY-13\r\n\r\nreleased channel: c1\r\n\r\nreleased channel: c2\r\n\r\nRMAN&gt; exit\r\n\r\n\r\nRecovery Manager complete.\r\n\r\n<\/pre>\n<p><strong>\u63d2\u51652\u7ea7\u589e\u91cf\u7684\u6d4b\u8bd5\u6570\u636e<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; insert into yallonking values (2,&#039;2&#039;,sysdate);\r\n\r\n1 row created.\r\n\r\nSQL&gt; commit;\r\n\r\nCommit complete.\r\n\r\nSQL&gt; alter system archive log current;\r\n\r\nSystem altered.\r\n\r\nSQL&gt; \/     \r\n\r\nSystem altered.\r\n\r\nSQL&gt; alter system switch logfile;\r\n\r\nSystem altered.\r\n\r\nSQL&gt; \/\r\n\r\nSystem altered.\r\n\r\nSQL&gt; \/\r\n\r\nSystem altered.\r\n\r\nSQL&gt; alter system archive log current;\r\n\r\nSystem altered.\r\n\r\nSQL&gt; select * from yallonking;\r\n\r\n        ID NAME                 MY_DATE\r\n---------- -------------------- -------------------\r\n         1 0                    2013\/05\/21 18:38:54\r\n         2 2                    2013\/05\/21 18:45:15\r\n\r\n<\/pre>\n<p><strong>\u8fdb\u884c2\u7ea7\u589e\u91cf\u5907\u4efd<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@ora10gr2 ~]$ rman target \/ \r\n\r\nRecovery Manager: Release 10.2.0.1.0 - Production on Tue May 21 18:45:44 2013\r\n\r\nCopyright (c) 1982, 2005, Oracle.  All rights reserved.\r\n\r\nconnected to target database: ORA10GR2 (DBID=4093928674)\r\n\r\nRMAN&gt; run {\r\n2&gt; allocate channel c1 type disk;\r\n3&gt; allocate channel c2 type disk;\r\n4&gt; backup \r\n5&gt;   incremental level 2\r\n6&gt;      skip inaccessible filesperset 5 \r\n7&gt;        Database format=&#039;\/tmp\/orcl_lev2_%U_%T&#039; tag=&#039;orcl_lev2&#039; ;\r\n8&gt; sql &#039;alter system archive log current&#039;;\r\n9&gt; backup format &#039;\/tmp\/arch_%s_%p_%t.bak&#039;\r\n10&gt;   filesperset 5\r\n11&gt;     archivelog all delete input skip inaccessible;\r\n12&gt; backup current controlfile tag=&#039;bak_ctlfile&#039; format=&#039;\/tmp\/ctl_file_%U_%T_level2&#039;;\r\n13&gt; backup spfile tag=&#039;spfile&#039; format=&#039;\/tmp\/ORCL_spfile_%U_%T&#039;;\r\n14&gt; release channel c1;\r\n15&gt; release channel c2;\r\n16&gt; }\r\n\r\nusing target database control file instead of recovery catalog\r\nallocated channel: c1\r\nchannel c1: sid=141 devtype=DISK\r\n... ...\r\nreleased channel: c1\r\n\r\nreleased channel: c2\r\n\r\nRMAN&gt; exit\r\n\r\n\r\nRecovery Manager complete.\r\n<\/pre>\n<p><strong>\u63d2\u51651\u7ea7\u589e\u91cf\u7684\u6d4b\u8bd5\u6570\u636e<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; insert into yallonking values (3,&#039;1&#039;,sysdate);\r\n\r\n1 row created.\r\n\r\nSQL&gt; commit;\r\n\r\nCommit complete.\r\n\r\nSQL&gt; alter system archive log current;\r\n\r\nSystem altered.\r\n\r\nSQL&gt; \/\r\n\r\nSystem altered.\r\n\r\nSQL&gt; alter system switch logfile;\r\n\r\nSystem altered.\r\n\r\nSQL&gt; \/\r\n\r\nSystem altered.\r\n\r\nSQL&gt; \/\r\n\r\nSystem altered.\r\n\r\nSQL&gt; alter system archive log current;\r\n\r\nSystem altered.\r\n\r\nSQL&gt; \/\r\n\r\nSystem altered.\r\n\r\nSQL&gt; alter system switch logfile;\r\n\r\nSystem altered.\r\n\r\nSQL&gt; \/\r\n\r\nSystem altered.\r\n\r\nSQL&gt; select * from yallonking;\r\n\r\n        ID NAME                 MY_DATE\r\n---------- -------------------- -------------------\r\n         1 0                    2013\/05\/21 18:38:54\r\n         2 2                    2013\/05\/21 18:45:15\r\n         3 1                    2013\/05\/21 18:51:15\r\n\r\n<\/pre>\n<p><strong>\u5907\u4efd1\u7ea7\u589e\u91cf\u6570\u636e\u5e93\t<\/strong>\t <\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nRMAN&gt; run {\r\n2&gt; allocate channel c1 type disk;\r\n3&gt; allocate channel c2 type disk;\r\n4&gt; backup \r\n5&gt;   incremental level 1\r\n6&gt;      skip inaccessible filesperset 5 \r\n7&gt;        Database format=&#039;\/tmp\/orcl_lev1_%U_%T&#039; tag=&#039;orcl_lev1&#039; ;\r\n8&gt; sql &#039;alter system archive log current&#039;;\r\n9&gt; backup format &#039;\/tmp\/arch_%s_%p_%t.bak&#039;\r\n10&gt;   filesperset 5\r\n11&gt;     archivelog all delete input skip inaccessible;\r\n12&gt; backup current controlfile tag=&#039;bak_ctlfile&#039; format=&#039;\/tmp\/ctl_file_%U_%T_level1&#039;;\r\n13&gt; backup spfile tag=&#039;spfile&#039; format=&#039;\/tmp\/ORCL_spfile_%U_%T&#039;;\r\n14&gt; release channel c1;\r\n15&gt; release channel c2;\r\n16&gt; }\r\n\r\nreleased channel: ORA_DISK_1\r\nallocated channel: c1\r\nchannel c1: sid=148 devtype=DISK\r\n... ...\r\nFinished backup at 21-MAY-13\r\n\r\nreleased channel: c1\r\n\r\nreleased channel: c2\r\n\r\nRMAN&gt; exit\r\n\r\n\r\nRecovery Manager complete.\r\n\r\n<\/pre>\n<p><strong>\u518d\u6b21\u63d2\u51652\u7ea7\u589e\u91cf\u7684\u6d4b\u8bd5\u6570\u636e<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; insert into yallonking values (4,&#039;2&#039;,sysdate);\r\n\r\n1 row created.\r\n\r\nSQL&gt; commit;\r\n\r\nCommit complete.\r\n\r\nSQL&gt; alter system archive log current;\r\n\r\nSystem altered.\r\n\r\nSQL&gt; alter system switch logfile;\r\n\r\nSystem altered.\r\n\r\nSQL&gt; \/\r\n\r\nSystem altered.\r\n\r\nSQL&gt; \/\r\n\r\nSystem altered.\r\n\r\nSQL&gt; alter system archive log current;\r\n\r\nSystem altered.\r\n\r\nSQL&gt; alter system switch logfile;\r\n\r\nSystem altered.\r\n\r\nSQL&gt; \/\r\n\r\nSystem altered.\r\n\r\nSQL&gt; alter system archive log current;\r\n\r\nSystem altered.\r\n\r\nSQL&gt; select * from yallonking;\r\n\r\n        ID NAME                 MY_DATE\r\n---------- -------------------- -------------------\r\n         1 0                    2013\/05\/21 18:38:54\r\n         2 2                    2013\/05\/21 18:45:15\r\n         3 1                    2013\/05\/21 18:51:15\r\n         4 2                    2013\/05\/21 18:57:55\r\n\r\n<\/pre>\n<p><strong>\u5907\u4efd2\u7ea7\u589e\u91cf\u6570\u636e\u5e93<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@ora10gr2 ~]$ rman target \/ \r\n\r\nRecovery Manager: Release 10.2.0.1.0 - Production on Tue May 21 19:01:01 2013\r\n\r\nCopyright (c) 1982, 2005, Oracle.  All rights reserved.\r\n\r\nconnected to target database: ORA10GR2 (DBID=4093928674)\r\n\r\nRMAN&gt; run {\r\n2&gt; allocate channel c1 type disk;\r\n3&gt; allocate channel c2 type disk;\r\n4&gt; backup \r\n5&gt;   incremental level 2\r\n6&gt;      skip inaccessible filesperset 5 \r\n7&gt;        Database format=&#039;\/tmp\/orcl_lev2_%U_%T&#039; tag=&#039;orcl_lev2&#039; ;\r\n8&gt; sql &#039;alter system archive log current&#039;;\r\n9&gt; backup format &#039;\/tmp\/arch_%s_%p_%t.bak&#039;\r\n10&gt;   filesperset 5\r\n11&gt;     archivelog all delete input skip inaccessible;\r\n12&gt; backup current controlfile tag=&#039;bak_ctlfile&#039; format=&#039;\/tmp\/ctl_file_%U_%T_level2&#039;;\r\n13&gt; backup spfile tag=&#039;spfile&#039; format=&#039;\/tmp\/ORCL_spfile_%U_%T&#039;;\r\n14&gt; release channel c1;\r\n15&gt; release channel c2;\r\n16&gt; }\r\n\r\nusing target database control file instead of recovery catalog\r\nallocated channel: c1\r\nchannel c1: sid=154 devtype=DISK\r\n... ...\r\nFinished backup at 21-MAY-13\r\n\r\nreleased channel: c1\r\n\r\nreleased channel: c2\r\n\r\nRMAN&gt; exit\r\n\r\n\r\nRecovery Manager complete.\r\n<\/pre>\n<p><strong>\u4ee5\u4e0b\u5f00\u59cb\u6062\u590d\u6d4b\u8bd5<br \/>\n\u5220\u9664\u6240\u6709\u6570\u636e\u6587\u4ef6<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; select name from v$datafile;\r\n\r\nNAME\r\n--------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/oradata\/ora10gr2\/system01.dbf\r\n\/u01\/app\/oracle\/oradata\/ora10gr2\/undotbs01.dbf\r\n\/u01\/app\/oracle\/oradata\/ora10gr2\/sysaux01.dbf\r\n\/u01\/app\/oracle\/oradata\/ora10gr2\/users01.dbf\r\n\/u01\/app\/oracle\/oradata\/ora10gr2\/test01.dbf\r\n\/u01\/app\/oracle\/oradata\/ora10gr2\/ogg01.dbf\r\n\/u01\/app\/oracle\/oradata\/ora10gr2\/yallonking01.dbf\r\n\r\n7 rows selected.\r\n\r\n[oracle@ora10gr2 ~]$ cd \/u01\/app\/oracle\/oradata\/ora10gr2\/\r\n[oracle@ora10gr2 ora10gr2]$ rm -rf *\r\n<\/pre>\n<p><strong>\u5f00\u59cb\u6062\u590d\u5728\u65f6\u95f42013\/05\/21 18:38:54\u76840\u7ea7\u589e\u91cf\u5907\u4efd<br \/>\n\u518d\u6062\u590d\u7b2c\u4e00\u4e2a2\u7ea7\u5907\u4efd\uff08\u53732013\/05\/21 18:45:15\u65f6\u95f4\u70b9\u7684\u6570\u636e\uff09<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@ora10gr2 ora10gr2]$ ps -ef | grep pmon| grep -v grep\r\noracle    9422     1  0 20:25 ?        00:00:00 ora_pmon_ora10gr2\r\n[oracle@ora10gr2 ora10gr2]$ kill -9 9422\r\n[oracle@ora10gr2 ora10gr2]$ rman target \/\r\n\r\nRecovery Manager: Release 10.2.0.1.0 - Production on Tue May 21 20:23:08 2013\r\n\r\nCopyright (c) 1982, 2005, Oracle.  All rights reserved.\r\n\r\nconnected to target database (not started)\r\n\r\nRMAN&gt; set DBID=4093928674\r\n\r\nexecuting command: SET DBID\r\n\r\nRMAN&gt; startup nomount;\r\n\r\nOracle instance started\r\n\r\nTotal System Global Area     608174080 bytes\r\n\r\nFixed Size                     1220844 bytes\r\nVariable Size                205524756 bytes\r\nDatabase Buffers             398458880 bytes\r\nRedo Buffers                   2969600 bytes\r\n\r\nRMAN&gt; restore controlfile from &#039;\/tmp\/ctl_file_0coa77bl_1_1_20130521&#039;;\t--\u6b64\u5904\u662f0\u7ea7\u7684\u63a7\u5236\u6587\u4ef6\u7684\u5907\u4efd\r\n\r\nStarting restore at 21-MAY-13\r\nusing target database control file instead of recovery catalog\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: sid=156 devtype=DISK\r\n\r\nchannel ORA_DISK_1: restoring control file\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:01\r\noutput filename=\/u01\/app\/oracle\/oradata\/ora10gr2\/control01.ctl\r\noutput filename=\/u01\/app\/oracle\/oradata\/ora10gr2\/control02.ctl\r\noutput filename=\/u01\/app\/oracle\/oradata\/ora10gr2\/control03.ctl\r\nFinished restore at 21-MAY-13\r\n\r\nRMAN&gt; startup mount;\r\n\r\ndatabase is already started\r\ndatabase mounted\r\nreleased channel: ORA_DISK_1\r\n\r\nRMAN&gt; restore database;\r\n\r\nStarting restore at 21-MAY-13\r\nStarting implicit crosscheck backup at 21-MAY-13\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: sid=156 devtype=DISK\r\nCrosschecked 11 objects\r\nFinished implicit crosscheck backup at 21-MAY-13\r\n\r\nStarting implicit crosscheck copy at 21-MAY-13\r\nusing channel ORA_DISK_1\r\nFinished implicit crosscheck copy at 21-MAY-13\r\n\r\nsearching for all files in the recovery area\r\ncataloging files...\r\nno files cataloged\r\n\r\nusing channel ORA_DISK_1\r\n\r\nchannel ORA_DISK_1: starting datafile backupset restore\r\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set\r\nrestoring datafile 00001 to \/u01\/app\/oracle\/oradata\/ora10gr2\/system01.dbf\r\nrestoring datafile 00004 to \/u01\/app\/oracle\/oradata\/ora10gr2\/users01.dbf\r\nrestoring datafile 00007 to \/u01\/app\/oracle\/oradata\/ora10gr2\/yallonking01.dbf\r\nchannel ORA_DISK_1: reading from backup piece \/tmp\/orcl_lev0_01oa7792_1_1_20130521\r\nchannel ORA_DISK_1: restored backup piece 1\r\npiece handle=\/tmp\/orcl_lev0_01oa7792_1_1_20130521 tag=ORCL_LEV0\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:25\r\nchannel ORA_DISK_1: starting datafile backupset restore\r\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set\r\nrestoring datafile 00002 to \/u01\/app\/oracle\/oradata\/ora10gr2\/undotbs01.dbf\r\nrestoring datafile 00003 to \/u01\/app\/oracle\/oradata\/ora10gr2\/sysaux01.dbf\r\nrestoring datafile 00005 to \/u01\/app\/oracle\/oradata\/ora10gr2\/test01.dbf\r\nrestoring datafile 00006 to \/u01\/app\/oracle\/oradata\/ora10gr2\/ogg01.dbf\r\nchannel ORA_DISK_1: reading from backup piece \/tmp\/orcl_lev0_02oa7792_1_1_20130521\r\nchannel ORA_DISK_1: restored backup piece 1\r\npiece handle=\/tmp\/orcl_lev0_02oa7792_1_1_20130521 tag=ORCL_LEV0\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:15\r\nFinished restore at 21-MAY-13\r\n\r\nRMAN&gt; recover database;\r\n\r\nStarting recover at 21-MAY-13\r\nusing channel ORA_DISK_1\r\n\r\nstarting media recovery\r\n\r\nchannel ORA_DISK_1: starting archive log restore to default destination\r\nchannel ORA_DISK_1: restoring archive log\r\narchive log thread=1 sequence=29\r\nchannel ORA_DISK_1: restoring archive log\r\narchive log thread=1 sequence=30\r\nchannel ORA_DISK_1: reading from backup piece \/tmp\/arch_7_1_816029040.bak\r\nchannel ORA_DISK_1: restored backup piece 1\r\npiece handle=\/tmp\/arch_7_1_816029040.bak tag=TAG20130521T184350\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:03\r\narchive log filename=\/u01\/app\/oracle\/flash_recovery_area\/ORA10GR2\/archivelog\/2013_05_21\/o1_mf_1_29_8srgo72y_.arc thread=1 sequence=29\r\nchannel default: deleting archive log(s)\r\narchive log filename=\/u01\/app\/oracle\/flash_recovery_area\/ORA10GR2\/archivelog\/2013_05_21\/o1_mf_1_29_8srgo72y_.arc recid=60 stamp=816035128\r\narchive log filename=\/u01\/app\/oracle\/flash_recovery_area\/ORA10GR2\/archivelog\/2013_05_21\/o1_mf_1_30_8srgo76j_.arc thread=1 sequence=30\r\nchannel default: deleting archive log(s)\r\narchive log filename=\/u01\/app\/oracle\/flash_recovery_area\/ORA10GR2\/archivelog\/2013_05_21\/o1_mf_1_30_8srgo76j_.arc recid=59 stamp=816035127\r\nunable to find archive log\r\narchive log thread=1 sequence=31\r\nRMAN-00571: ===========================================================\r\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\r\nRMAN-00571: ===========================================================\r\nRMAN-03002: failure of recover command at 05\/21\/2013 20:25:32\r\nRMAN-06054: media recovery requesting unknown log: thread 1 seq 31 lowscn 500800\r\n\r\nRMAN&gt; shutdown immediate\r\n\r\ndatabase dismounted\r\nOracle instance shut down\r\n\r\nRMAN&gt; startup nomount;\r\n\r\nconnected to target database (not started)\r\nOracle instance started\r\n\r\nTotal System Global Area     608174080 bytes\r\n\r\nFixed Size                     1220844 bytes\r\nVariable Size                205524756 bytes\r\nDatabase Buffers             398458880 bytes\r\nRedo Buffers                   2969600 bytes\r\n\r\nRMAN&gt; restore controlfile from &#039;\/tmp\/ctl_file_0toa77kj_1_1_20130521_level2&#039;;\t--\u6b64\u5904\u662f\u7b2c\u4e00\u4e2a2\u7ea7\u589e\u91cf\u5907\u4efd\u7684\u63a7\u5236\u6587\u4ef6\r\n\r\nStarting restore at 21-MAY-13\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: sid=156 devtype=DISK\r\n\r\nchannel ORA_DISK_1: restoring control file\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:02\r\noutput filename=\/u01\/app\/oracle\/oradata\/ora10gr2\/control01.ctl\r\noutput filename=\/u01\/app\/oracle\/oradata\/ora10gr2\/control02.ctl\r\noutput filename=\/u01\/app\/oracle\/oradata\/ora10gr2\/control03.ctl\r\nFinished restore at 21-MAY-13\r\n\r\nRMAN&gt; startup mount;\r\n\r\ndatabase is already started\r\ndatabase mounted\r\nreleased channel: ORA_DISK_1\r\n\r\nRMAN&gt; recover database;\r\n\r\nStarting recover at 21-MAY-13\r\nStarting implicit crosscheck backup at 21-MAY-13\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: sid=156 devtype=DISK\r\nCrosschecked 28 objects\r\nFinished implicit crosscheck backup at 21-MAY-13\r\n\r\nStarting implicit crosscheck copy at 21-MAY-13\r\nusing channel ORA_DISK_1\r\nFinished implicit crosscheck copy at 21-MAY-13\r\n\r\nsearching for all files in the recovery area\r\ncataloging files...\r\nno files cataloged\r\n\r\nusing channel ORA_DISK_1\r\nchannel ORA_DISK_1: starting incremental datafile backupset restore\r\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00002: \/u01\/app\/oracle\/oradata\/ora10gr2\/undotbs01.dbf\r\ndestination for restore of datafile 00003: \/u01\/app\/oracle\/oradata\/ora10gr2\/sysaux01.dbf\r\ndestination for restore of datafile 00005: \/u01\/app\/oracle\/oradata\/ora10gr2\/test01.dbf\r\ndestination for restore of datafile 00006: \/u01\/app\/oracle\/oradata\/ora10gr2\/ogg01.dbf\r\nchannel ORA_DISK_1: reading from backup piece \/tmp\/orcl_lev2_0foa77jv_1_1_20130521\r\nchannel ORA_DISK_1: restored backup piece 1\r\npiece handle=\/tmp\/orcl_lev2_0foa77jv_1_1_20130521 tag=ORCL_LEV2\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:03\r\nchannel ORA_DISK_1: starting incremental datafile backupset restore\r\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00001: \/u01\/app\/oracle\/oradata\/ora10gr2\/system01.dbf\r\ndestination for restore of datafile 00004: \/u01\/app\/oracle\/oradata\/ora10gr2\/users01.dbf\r\ndestination for restore of datafile 00007: \/u01\/app\/oracle\/oradata\/ora10gr2\/yallonking01.dbf\r\nchannel ORA_DISK_1: reading from backup piece \/tmp\/orcl_lev2_0eoa77jv_1_1_20130521\r\nchannel ORA_DISK_1: restored backup piece 1\r\npiece handle=\/tmp\/orcl_lev2_0eoa77jv_1_1_20130521 tag=ORCL_LEV2\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:01\r\n\r\nstarting media recovery\r\n\r\nchannel ORA_DISK_1: starting archive log restore to default destination\r\nchannel ORA_DISK_1: restoring archive log\r\narchive log thread=1 sequence=45\r\nchannel ORA_DISK_1: restoring archive log\r\narchive log thread=1 sequence=46\r\nchannel ORA_DISK_1: reading from backup piece \/tmp\/arch_28_1_816029328.bak\r\nchannel ORA_DISK_1: restored backup piece 1\r\npiece handle=\/tmp\/arch_28_1_816029328.bak tag=TAG20130521T184836\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:01\r\narchive log filename=\/u01\/app\/oracle\/flash_recovery_area\/ORA10GR2\/archivelog\/2013_05_21\/o1_mf_1_45_8srh41qv_.arc thread=1 sequence=45\r\nchannel default: deleting archive log(s)\r\narchive log filename=\/u01\/app\/oracle\/flash_recovery_area\/ORA10GR2\/archivelog\/2013_05_21\/o1_mf_1_45_8srh41qv_.arc recid=91 stamp=816035601\r\narchive log filename=\/u01\/app\/oracle\/flash_recovery_area\/ORA10GR2\/archivelog\/2013_05_21\/o1_mf_1_46_8srh41rd_.arc thread=1 sequence=46\r\nchannel default: deleting archive log(s)\r\narchive log filename=\/u01\/app\/oracle\/flash_recovery_area\/ORA10GR2\/archivelog\/2013_05_21\/o1_mf_1_46_8srh41rd_.arc recid=92 stamp=816035601\r\nunable to find archive log\r\narchive log thread=1 sequence=47\r\nRMAN-00571: ===========================================================\r\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\r\nRMAN-00571: ===========================================================\r\nRMAN-03002: failure of recover command at 05\/21\/2013 20:33:24\r\nRMAN-06054: media recovery requesting unknown log: thread 1 seq 47 lowscn 501062\r\n\r\nRMAN&gt; alter database open resetlogs;\r\n\r\ndatabase opened\r\n\r\nRMAN&gt; exit\r\n\r\n\r\nRecovery Manager complete.\r\n<\/pre>\n<p><strong><br \/>\n\u4ee5\u4e0a\u662f\u5b8c\u6574\u7684\u8f93\u51fa\uff0c\u53ef\u4ee5\u770b\u5230\u5728\u6062\u590d2\u7ea7\u7684\u65f6\u5019\u53ea\u5e94\u7528\u4e862\u7ea7\u7684\u589e\u91cf\u5907\u4efd\u7684\u5907\u4efd\u7247\u3002<\/strong><\/p>\n<p><strong>\u9a8c\u8bc1\u6062\u590d\u7ed3\u679c<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@ora10gr2 ora10gr2]$ sqlplus &quot;\/as sysdba&quot;\r\n\r\nSQL*Plus: Release 10.2.0.1.0 - Production on Tue May 21 20:34:13 2013\r\n\r\nCopyright (c) 1982, 2005, Oracle.  All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production\r\nWith the Partitioning, OLAP and Data Mining options\r\n\r\nSQL&gt; alter session set nls_date_format=&#039;yyyy\/mm\/dd hh24:mi:ss&#039;;\r\n\r\nSession altered.\r\n\r\nSQL&gt; select * from yallonking.yallonking;\r\n\r\n        ID NAME                 MY_DATE\r\n---------- -------------------- -------------------\r\n         1 0                    2013\/05\/21 18:38:54\r\n         2 2                    2013\/05\/21 18:45:15\r\n\r\n<\/pre>\n<p>*************************\u4e0b\u8fb9\u7ee7\u7eed\u5c1d\u8bd5\u5728resetlogs\u6253\u5f00\u5e93\u5e76\u8fdb\u884c\u4e86\u4e8b\u7269\u540e\uff0c\u80fd\u5426\u518d\u7ee7\u7eed\u6062\u590d*************************<br \/>\n<strong>\u6b63\u5e38\u8fdb\u884c\u4e8b\u7269<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; insert into yallonking.yallonking values(10,&#039;after_resetlogs_open&#039;,sysdate);\r\n\r\n1 row created.\r\n\r\nSQL&gt; commit;\r\n\r\nCommit complete.\r\n\r\nSQL&gt; alter session set nls_date_format=&#039;yyyy\/mm\/dd hh24:mi:ss&#039;;\r\n\r\nSession altered.\r\n\r\nSQL&gt; select * from yallonking.yallonking;\r\n\r\n        ID NAME                 MY_DATE\r\n---------- -------------------- -------------------\r\n         1 0                    2013\/05\/21 18:38:54\r\n         2 2                    2013\/05\/21 18:45:15\r\n        10 after_resetlogs_open 2013\/05\/21 21:49:43\r\n<\/pre>\n<p><strong>\u4e0b\u8fb9\u7ee7\u7eed\u8fdb\u884c\u4e4b\u524d\u7684\u589e\u91cf\u7684\u6062\u590d<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; shutdown immediate;\r\nDatabase closed.\r\nDatabase dismounted.\r\nORACLE instance shut down.\r\n\r\n[oracle@ora10gr2 ora10gr2]$ rman target \/\r\n\r\nRecovery Manager: Release 10.2.0.1.0 - Production on Tue May 21 21:51:51 2013\r\n\r\nCopyright (c) 1982, 2005, Oracle.  All rights reserved.\r\n\r\nconnected to target database (not started)\r\n\r\nRMAN&gt; startup nomount;\r\n\r\nOracle instance started\r\n\r\nTotal System Global Area     608174080 bytes\r\n\r\nFixed Size                     1220844 bytes\r\nVariable Size                213913364 bytes\r\nDatabase Buffers             390070272 bytes\r\nRedo Buffers                   2969600 bytes\r\n\r\nRMAN&gt; restore controlfile from &#039;\/tmp\/ctl_file_1soa78bo_1_1_20130521_level2&#039;; --\u6b64\u5904\u662f\u6700\u65b0\u7684\u63a7\u5236\u53ca\u6587\u4ef6\u7684\u5907\u4efd\r\n\r\nStarting restore at 21-MAY-13\r\nusing target database control file instead of recovery catalog\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: sid=156 devtype=DISK\r\n\r\nchannel ORA_DISK_1: restoring control file\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:01\r\noutput filename=\/u01\/app\/oracle\/oradata\/ora10gr2\/control01.ctl\r\noutput filename=\/u01\/app\/oracle\/oradata\/ora10gr2\/control02.ctl\r\noutput filename=\/u01\/app\/oracle\/oradata\/ora10gr2\/control03.ctl\r\nFinished restore at 21-MAY-13\r\n\r\nRMAN&gt; startup mount;\r\n\r\ndatabase is already started\r\ndatabase mounted\r\nreleased channel: ORA_DISK_1\r\n\r\nRMAN&gt; recover database;\r\n\r\nStarting recover at 21-MAY-13\r\nStarting implicit crosscheck backup at 21-MAY-13\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: sid=156 devtype=DISK\r\nCrosschecked 59 objects\r\nFinished implicit crosscheck backup at 21-MAY-13\r\n\r\nStarting implicit crosscheck copy at 21-MAY-13\r\nusing channel ORA_DISK_1\r\nFinished implicit crosscheck copy at 21-MAY-13\r\n\r\nsearching for all files in the recovery area\r\ncataloging files...\r\nno files cataloged\r\n\r\nusing channel ORA_DISK_1\r\n\r\nstarting media recovery\r\nmedia recovery failed\r\nRMAN-00571: ===========================================================\r\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\r\nRMAN-00571: ===========================================================\r\nRMAN-03002: failure of recover command at 05\/21\/2013 21:52:39\r\nORA-00283: recovery session canceled due to errors\r\nRMAN-11003: failure during parse\/execution of SQL statement: alter database recover if needed\r\n start until cancel using backup controlfile\r\nORA-00283: recovery session canceled due to errors\r\nORA-19909: datafile 1 belongs to an orphan incarnation\r\nORA-01110: data file 1: &#039;\/u01\/app\/oracle\/oradata\/ora10gr2\/system01.dbf&#039;\r\n\r\nRMAN&gt; restore database;\r\n\r\nStarting restore at 21-MAY-13\r\nusing channel ORA_DISK_1\r\n\r\nchannel ORA_DISK_1: starting datafile backupset restore\r\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set\r\nrestoring datafile 00001 to \/u01\/app\/oracle\/oradata\/ora10gr2\/system01.dbf\r\nrestoring datafile 00004 to \/u01\/app\/oracle\/oradata\/ora10gr2\/users01.dbf\r\nrestoring datafile 00007 to \/u01\/app\/oracle\/oradata\/ora10gr2\/yallonking01.dbf\r\nchannel ORA_DISK_1: reading from backup piece \/tmp\/orcl_lev0_01oa7792_1_1_20130521\r\nchannel ORA_DISK_1: restored backup piece 1\r\npiece handle=\/tmp\/orcl_lev0_01oa7792_1_1_20130521 tag=ORCL_LEV0\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:25\r\nchannel ORA_DISK_1: starting datafile backupset restore\r\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set\r\nrestoring datafile 00002 to \/u01\/app\/oracle\/oradata\/ora10gr2\/undotbs01.dbf\r\nrestoring datafile 00003 to \/u01\/app\/oracle\/oradata\/ora10gr2\/sysaux01.dbf\r\nrestoring datafile 00005 to \/u01\/app\/oracle\/oradata\/ora10gr2\/test01.dbf\r\nrestoring datafile 00006 to \/u01\/app\/oracle\/oradata\/ora10gr2\/ogg01.dbf\r\nchannel ORA_DISK_1: reading from backup piece \/tmp\/orcl_lev0_02oa7792_1_1_20130521\r\nchannel ORA_DISK_1: restored backup piece 1\r\npiece handle=\/tmp\/orcl_lev0_02oa7792_1_1_20130521 tag=ORCL_LEV0\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:15\r\nFinished restore at 21-MAY-13\r\n\r\nRMAN&gt; recover database;\r\n\r\nStarting recover at 21-MAY-13\r\nusing channel ORA_DISK_1\r\nchannel ORA_DISK_1: starting incremental datafile backupset restore\r\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00001: \/u01\/app\/oracle\/oradata\/ora10gr2\/system01.dbf\r\ndestination for restore of datafile 00007: \/u01\/app\/oracle\/oradata\/ora10gr2\/yallonking01.dbf\r\nchannel ORA_DISK_1: reading from backup piece \/tmp\/orcl_lev1_0voa77v2_1_1_20130521\r\nchannel ORA_DISK_1: restored backup piece 1\r\npiece handle=\/tmp\/orcl_lev1_0voa77v2_1_1_20130521 tag=ORCL_LEV1\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:02\r\nchannel ORA_DISK_1: starting incremental datafile backupset restore\r\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00002: \/u01\/app\/oracle\/oradata\/ora10gr2\/undotbs01.dbf\r\ndestination for restore of datafile 00003: \/u01\/app\/oracle\/oradata\/ora10gr2\/sysaux01.dbf\r\ndestination for restore of datafile 00004: \/u01\/app\/oracle\/oradata\/ora10gr2\/users01.dbf\r\ndestination for restore of datafile 00005: \/u01\/app\/oracle\/oradata\/ora10gr2\/test01.dbf\r\ndestination for restore of datafile 00006: \/u01\/app\/oracle\/oradata\/ora10gr2\/ogg01.dbf\r\nchannel ORA_DISK_1: reading from backup piece \/tmp\/orcl_lev1_10oa77v3_1_1_20130521\r\nchannel ORA_DISK_1: restored backup piece 1\r\npiece handle=\/tmp\/orcl_lev1_10oa77v3_1_1_20130521 tag=ORCL_LEV1\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:03\r\nchannel ORA_DISK_1: starting incremental datafile backupset restore\r\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00001: \/u01\/app\/oracle\/oradata\/ora10gr2\/system01.dbf\r\ndestination for restore of datafile 00004: \/u01\/app\/oracle\/oradata\/ora10gr2\/users01.dbf\r\ndestination for restore of datafile 00007: \/u01\/app\/oracle\/oradata\/ora10gr2\/yallonking01.dbf\r\nchannel ORA_DISK_1: reading from backup piece \/tmp\/orcl_lev1_1boa780s_1_1_20130521\r\nchannel ORA_DISK_1: restored backup piece 1\r\npiece handle=\/tmp\/orcl_lev1_1boa780s_1_1_20130521 tag=ORCL_LEV1\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:01\r\nchannel ORA_DISK_1: starting incremental datafile backupset restore\r\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00002: \/u01\/app\/oracle\/oradata\/ora10gr2\/undotbs01.dbf\r\ndestination for restore of datafile 00003: \/u01\/app\/oracle\/oradata\/ora10gr2\/sysaux01.dbf\r\ndestination for restore of datafile 00005: \/u01\/app\/oracle\/oradata\/ora10gr2\/test01.dbf\r\ndestination for restore of datafile 00006: \/u01\/app\/oracle\/oradata\/ora10gr2\/ogg01.dbf\r\nchannel ORA_DISK_1: reading from backup piece \/tmp\/orcl_lev1_1coa780s_1_1_20130521\r\nchannel ORA_DISK_1: restored backup piece 1\r\npiece handle=\/tmp\/orcl_lev1_1coa780s_1_1_20130521 tag=ORCL_LEV1\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:01\r\nchannel ORA_DISK_1: starting incremental datafile backupset restore\r\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00001: \/u01\/app\/oracle\/oradata\/ora10gr2\/system01.dbf\r\ndestination for restore of datafile 00004: \/u01\/app\/oracle\/oradata\/ora10gr2\/users01.dbf\r\ndestination for restore of datafile 00007: \/u01\/app\/oracle\/oradata\/ora10gr2\/yallonking01.dbf\r\nchannel ORA_DISK_1: reading from backup piece \/tmp\/orcl_lev2_1koa78bf_1_1_20130521\r\nchannel ORA_DISK_1: restored backup piece 1\r\npiece handle=\/tmp\/orcl_lev2_1koa78bf_1_1_20130521 tag=ORCL_LEV2\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:01\r\nchannel ORA_DISK_1: starting incremental datafile backupset restore\r\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00002: \/u01\/app\/oracle\/oradata\/ora10gr2\/undotbs01.dbf\r\ndestination for restore of datafile 00003: \/u01\/app\/oracle\/oradata\/ora10gr2\/sysaux01.dbf\r\ndestination for restore of datafile 00005: \/u01\/app\/oracle\/oradata\/ora10gr2\/test01.dbf\r\ndestination for restore of datafile 00006: \/u01\/app\/oracle\/oradata\/ora10gr2\/ogg01.dbf\r\nchannel ORA_DISK_1: reading from backup piece \/tmp\/orcl_lev2_1loa78bf_1_1_20130521\r\nchannel ORA_DISK_1: restored backup piece 1\r\npiece handle=\/tmp\/orcl_lev2_1loa78bf_1_1_20130521 tag=ORCL_LEV2\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:01\r\n\r\nstarting media recovery\r\n\r\narchive log thread 1 sequence 68 is already on disk as file \/u01\/app\/oracle\/oradata\/arch\/1_68_791701862.dbf\r\narchive log thread 1 sequence 69 is already on disk as file \/u01\/app\/oracle\/oradata\/arch\/1_69_791701862.dbf\r\narchive log filename=\/u01\/app\/oracle\/oradata\/arch\/1_68_791701862.dbf thread=1 sequence=68\r\narchive log filename=\/u01\/app\/oracle\/oradata\/arch\/1_69_791701862.dbf thread=1 sequence=69\r\nunable to find archive log\r\narchive log thread=1 sequence=70\r\nRMAN-00571: ===========================================================\r\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\r\nRMAN-00571: ===========================================================\r\nRMAN-03002: failure of recover command at 05\/21\/2013 21:53:53\r\nRMAN-06054: media recovery requesting unknown log: thread 1 seq 70 lowscn 502078\r\n\r\nRMAN&gt; alter database open resetlogs;\r\n\r\ndatabase opened\r\n\r\nRMAN&gt; exit\r\n\r\n\r\nRecovery Manager complete.\r\n[oracle@ora10gr2 ora10gr2]$ sqlplus &quot;\/as sysdba&quot;\r\n\r\nSQL*Plus: Release 10.2.0.1.0 - Production on Tue May 21 21:54:35 2013\r\n\r\nCopyright (c) 1982, 2005, Oracle.  All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production\r\nWith the Partitioning, OLAP and Data Mining options\r\n\r\nSQL&gt; alter session set nls_date_format=&#039;yyyy\/mm\/dd hh24:mi:ss&#039;;\r\n\r\nSession altered.\r\n\r\nSQL&gt; select * from yallonking.yallonking;\r\n\r\n        ID NAME                 MY_DATE\r\n---------- -------------------- -------------------\r\n         1 0                    2013\/05\/21 18:38:54\r\n         2 2                    2013\/05\/21 18:45:15\r\n         3 1                    2013\/05\/21 18:51:15\r\n         4 2                    2013\/05\/21 18:57:55\r\n<\/pre>\n<p>\u6b64\u5904\u53d1\u73b0\uff0c\u5728resetlogs\u6253\u5f00\u5e93\u5e76\u8fdb\u884c\u4e8b\u7269\u540e\uff0c\u8fd9\u6837\u7684\u6062\u590d\u4f1a\u5148\u6062\u590d0\u7ea7\u518d\u6062\u590d\u540e\u8fb91\u7ea7\u518d\u6062\u590d\u6700\u8fd1\u76842\u7ea7\u3002\u4e5f\u8bf4\u660e\u4e86\uff0c\u5728resetlogs\u6253\u5f00\u5e93\u540e\uff0c\u4e4b\u524d\u7684\u5907\u4efd\u8fd8\u662f\u53ef\u4ee5\u7528\u7684\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u80cc\u666f\uff1a\u4e00\u4e2a\u9879\u76ee\u9700\u8981\u6062\u590d\u4e00\u4e2a\u5e93\u505a\u6d4b\u8bd5\uff0c\u4e4b\u524d\u6709\u6e90\u5e93\u7684\u589e\u91cf\u5907\u4efd\uff080+1+2\u7ea7\uff09\uff0c\u65f6\u95f4\u7a97\u53e3\u53ea\u67095H\uff0c\u6d4b\u8bd5\u7684\u65f6\u5019\u53d1\u73b0\u6062\u590d [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[40],"tags":[202],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/880"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=880"}],"version-history":[{"count":5,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/880\/revisions"}],"predecessor-version":[{"id":882,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/880\/revisions\/882"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=880"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=880"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=880"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}