\u64cd\u4f5c\u7cfb\u7edf\u4fe1\u606f<\/p>\n
\r\n[oracle@rhl6 lib]$ uname -a\r\nLinux rhl6.0x64 2.6.32-71.el6.x86_64 #1 SMP Wed Sep 1 01:33:01 EDT 2010 x86_64 x86_64 x86_64 GNU\/Linux\r\n<\/pre>\n\u6570\u636e\u5e93\u7248\u672c<\/p>\n
\r\nSQL> set line 400 \r\nSQL> select * from gv$version;\r\n\r\n INST_ID BANNER\r\n---------- --------------------------------------------------------------------------------\r\n 1 Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\n 1 PL\/SQL Release 11.2.0.3.0 - Production\r\n 1 CORE 11.2.0.3.0 Production\r\n 1 TNS for Linux: Version 11.2.0.3.0 - Production\r\n 1 NLSRTL Version 11.2.0.3.0 - Production\r\n<\/pre>\n\u6d4b\u8bd5\u6570\u636e<\/p>\n
\r\nSQL> archive log list;\r\nDatabase log mode Archive Mode\r\nAutomatic archival Enabled\r\nArchive destination USE_DB_RECOVERY_FILE_DEST\r\nOldest online log sequence 66\r\nNext log sequence to archive 68\r\nCurrent log sequence 68\r\nSQL> show parameter DB_RECOVERY_FILE_DEST\r\n\r\nNAME TYPE VALUE\r\n------------------------------------ ----------- ------------------------------\r\ndb_recovery_file_dest string \/u01\/app\/oracle\/fast_recovery_\r\n area\r\ndb_recovery_file_dest_size big integer 4977M\r\nSQL> conn yallonking\/yallonking\r\nConnected.\r\nSQL> alter session set nls_date_format='yyyy\/mm\/dd hh24:mi:ss';\r\n\r\nSession altered.\r\n\r\nSQL> select rowid,t.* from yallonking t;\r\n\r\nROWID ID NAME MY_DATE\r\n------------------ ---------- -------------------- -------------------\r\nAAARciAAFAAAACHAAA 1 yallonking 2013\/07\/22 09:44:53\r\nAAARciAAFAAAACHAAB 2 oraking 2013\/07\/22 09:45:07\r\nAAARciAAFAAAACHAAC 3 xiaolong 2013\/07\/22 09:50:09\r\n<\/pre>\n\u5907\u4efd\u6570\u636e\u5e93<\/p>\n
\r\nRMAN> backup database;\r\n\r\nStarting backup at 24-JUL-13\r\nusing target database control file instead of recovery catalog\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=30 device type=DISK\r\nchannel ORA_DISK_1: starting full datafile backup set\r\nchannel ORA_DISK_1: specifying datafile(s) in backup set\r\ninput datafile file number=00001 name=\/u01\/app\/oracle\/oradata\/ora11gr2\/system01.dbf\r\ninput datafile file number=00002 name=\/u01\/app\/oracle\/oradata\/ora11gr2\/sysaux01.dbf\r\ninput datafile file number=00003 name=\/u01\/app\/oracle\/oradata\/ora11gr2\/undotbs01.dbf\r\ninput datafile file number=00004 name=\/u01\/app\/oracle\/oradata\/ora11gr2\/users01.dbf\r\ninput datafile file number=00005 name=\/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf\r\nchannel ORA_DISK_1: starting piece 1 at 24-JUL-13\r\nchannel ORA_DISK_1: finished piece 1 at 24-JUL-13\r\npiece handle=\/u01\/app\/oracle\/fast_recovery_area\/ORA11GR2\/backupset\/2013_07_24\/o1_mf_nnndf_TAG20130724T112657_8yyld1x7_.bkp tag=TAG20130724T112657 comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:03:56\r\nchannel ORA_DISK_1: starting full datafile backup set\r\nchannel ORA_DISK_1: specifying datafile(s) in backup set\r\nincluding current control file in backup set\r\nincluding current SPFILE in backup set\r\nchannel ORA_DISK_1: starting piece 1 at 24-JUL-13\r\nchannel ORA_DISK_1: finished piece 1 at 24-JUL-13\r\npiece handle=\/u01\/app\/oracle\/fast_recovery_area\/ORA11GR2\/backupset\/2013_07_24\/o1_mf_ncsnf_TAG20130724T112657_8yylmk9m_.bkp tag=TAG20130724T112657 comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\r\nFinished backup at 24-JUL-13\r\n\r\nRMAN> exit\r\n\r\n\r\nRecovery Manager complete.\r\n<\/pre>\n\u4e0b\u8fb9\u63d2\u51653\u6761\u65b0\u8bb0\u5f55\u5e76\u8ba9\u5176\u7f6e\u4e8e3\u4e2a\u4e0d\u540c\u7684\u5f52\u6863\u65e5\u5fd7\u4e2d<\/p>\n
\r\nSQL> insert into yallonking values(4,'archive_test1',sysdate);\r\n\r\n1 row created.\r\n\r\nSQL> commit;\r\n\r\nCommit complete.\r\n\r\nSQL> alter system archive log current;\r\n\r\nSystem altered.\r\n\r\nSQL> insert into yallonking values(5,'archive_test2',sysdate);\r\n\r\n1 row created.\r\n\r\nSQL> commit;\r\n\r\nCommit complete.\r\n\r\nSQL> alter system archive log current;\r\n\r\nSystem altered.\r\n\r\nSQL> insert into yallonking values(6,'archive_test3',sysdate);\r\n\r\n1 row created.\r\n\r\nSQL> commit;\r\n\r\nCommit complete.\r\n\r\nSQL> alter system archive log current;\r\n\r\nSystem altered.\r\n\r\nSQL> select rowid,t.* from yallonking t;\r\n\r\nROWID ID NAME MY_DATE\r\n------------------ ---------- -------------------- -------------------\r\nAAARciAAFAAAACHAAA 1 yallonking 2013\/07\/22 09:44:53\r\nAAARciAAFAAAACHAAB 2 oraking 2013\/07\/22 09:45:07\r\nAAARciAAFAAAACHAAC 3 xiaolong 2013\/07\/22 09:50:09\r\nAAARciAAFAAAACHAAD 4 archive_test1 2013\/07\/24 11:31:48\r\nAAARciAAFAAAACHAAE 5 archive_test2 2013\/07\/24 11:32:36\r\nAAARciAAFAAAACHAAF 6 archive_test3 2013\/07\/24 11:32:51\r\n\r\n6 rows selected.\r\n<\/pre>\n\u6e05\u7a7aredo\u8bb0\u5f55\uff0c\u907f\u514d\u8bb0\u5f55\u5728redo\u4e2d\u7684\u5b58\u5728\u5f71\u54cd\u6d4b\u8bd5<\/p>\n
\r\nSQL> select a.GROUP#,MEMBER,a.STATUS from v$log a,v$logfile b where a.GROUP#=b.GROUP#;\r\n\r\n GROUP# MEMBER STATUS\r\n---------- --------------------------------------------- ----------------\r\n 1 \/u01\/app\/oracle\/oradata\/ora11gr2\/redo01.log ACTIVE\r\n 2 \/u01\/app\/oracle\/oradata\/ora11gr2\/redo02.log CURRENT\r\n 3 \/u01\/app\/oracle\/oradata\/ora11gr2\/redo03.log ACTIVE\r\n\r\nSQL> alter database clear unarchived logfile '\/u01\/app\/oracle\/oradata\/ora11gr2\/redo01.log';\r\n\r\nDatabase altered.\r\n\r\nSQL> alter database clear unarchived logfile '\/u01\/app\/oracle\/oradata\/ora11gr2\/redo02.log';\r\nalter database clear unarchived logfile '\/u01\/app\/oracle\/oradata\/ora11gr2\/redo02.log'\r\n*\r\nERROR at line 1:\r\nORA-01624: log 2 needed for crash recovery of instance ora11gr2 (thread 1)\r\nORA-00312: online log 2 thread 1: '\/u01\/app\/oracle\/oradata\/ora11gr2\/redo02.log'\r\n\r\n\r\nSQL> alter database clear unarchived logfile '\/u01\/app\/oracle\/oradata\/ora11gr2\/redo03.log';\r\n\r\nDatabase altered.\r\n\r\nSQL> alter system switch logfile;\r\n\r\nSystem altered.\r\n\r\nSQL> alter database clear unarchived logfile '\/u01\/app\/oracle\/oradata\/ora11gr2\/redo02.log';\r\n\r\nDatabase altered.\r\n<\/pre>\n\u4e0b\u8fb9\u786e\u8ba4\uff0c\u6bcf\u4e2a\u8bb0\u5f55\u90fd\u53ea\u5728\u5bf9\u5e94\u7684\u5f52\u6863\u65e5\u5fd7\u4e2d\u5b58\u5728<\/p>\n
\r\n[root@rhl6 ~]# cd \/u01\/app\/oracle\/fast_recovery_area\/ORA11GR2\/archivelog\/2013_07_24\r\n[root@rhl6 2013_07_24]# ls -ltr\r\ntotal 15528\r\n-rw-r-----. 1 oracle oinstall 13705216 Jul 24 11:31 o1_mf_1_68_8yyloh5b_.arc\r\n-rw-r-----. 1 oracle oinstall 3072 Jul 24 11:32 o1_mf_1_69_8yylps9r_.arc\r\n-rw-r-----. 1 oracle oinstall 3584 Jul 24 11:32 o1_mf_1_70_8yylq9on_.arc\r\n-rw-r-----. 1 oracle oinstall 2186240 Jul 24 11:41 o1_mf_1_71_8yym6j68_.arc\r\n[root@rhl6 2013_07_24]# string * | grep 'archive_test1'\r\n-bash: string: command not found\r\n[root@rhl6 2013_07_24]# \r\n[root@rhl6 2013_07_24]# \r\n[root@rhl6 2013_07_24]# strings * | grep 'archive_test1'\r\narchive_test1\r\n[root@rhl6 2013_07_24]# strings * | grep 'archive_test2'\r\narchive_test2\r\n[root@rhl6 2013_07_24]# strings * | grep 'archive_test3'\r\narchive_test3\r\n[root@rhl6 2013_07_24]# strings o1_mf_1_68_8yyloh5b_.arc | grep 'archive_test1'\r\narchive_test1\r\n[root@rhl6 2013_07_24]# strings o1_mf_1_69_8yylps9r_.arc | grep 'archive_test2'\r\narchive_test2\r\n[root@rhl6 2013_07_24]# strings o1_mf_1_70_8yylq9on_.arc | grep 'archive_test3'\r\narchive_test3\r\n[root@rhl6 2013_07_24]# strings o1_mf_1_71_8yym6j68_.arc | grep 'archive_tes'\r\n[root@rhl6 ora11gr2]# cd \/u01\/app\/oracle\/oradata\/ora11gr2\/\r\n[root@rhl6 ora11gr2]# strings *.log | grep 'archive_tes'\r\n<\/pre>\n\u4eba\u4e3a\u5220\u9664\u6570\u636e\u5e93\u6570\u636e\u6587\u4ef6\u548c\u90e8\u5206\u4e2d\u95f4\u7684\u5f52\u6863\u65e5\u5fd7\uff0c\u5e76\u8fdb\u884c\u4ece\u5907\u4efd\u6062\u590d\u6570\u636e\u5e93<\/p>\n
\r\n[root@rhl6 2013_07_24]# rm -rf o1_mf_1_69_8yylps9r_.arc\r\nSQL> select name from v$datafile;\r\n\r\nNAME\r\n--------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/oradata\/ora11gr2\/system01.dbf\r\n\/u01\/app\/oracle\/oradata\/ora11gr2\/sysaux01.dbf\r\n\/u01\/app\/oracle\/oradata\/ora11gr2\/undotbs01.dbf\r\n\/u01\/app\/oracle\/oradata\/ora11gr2\/users01.dbf\r\n\/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf\r\n\r\nSQL> !mv \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf \/tmp\/yallonking01.dbf_bak\r\n\r\nSQL> shutdown immediate;\r\nORA-01116: error in opening database file 5\r\nORA-01110: data file 5: '\/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf'\r\nORA-27041: unable to open file\r\nLinux-x86_64 Error: 2: No such file or directory\r\nAdditional information: 3\r\nSQL> shutdown abort\r\nORACLE instance shut down.\r\nSQL> startup\r\nORACLE instance started.\r\n\r\nTotal System Global Area 939495424 bytes\r\nFixed Size 2233960 bytes\r\nVariable Size 545261976 bytes\r\nDatabase Buffers 385875968 bytes\r\nRedo Buffers 6123520 bytes\r\nDatabase mounted.\r\nORA-01157: cannot identify\/lock data file 5 - see DBWR trace file\r\nORA-01110: data file 5: '\/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf'\r\n\r\nRMAN> restore datafile 5;\r\n\r\nStarting restore at 24-JUL-13\r\nusing target database control file instead of recovery catalog\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=21 device type=DISK\r\n\r\nchannel ORA_DISK_1: starting datafile backup set restore\r\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set\r\nchannel ORA_DISK_1: restoring datafile 00005 to \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf\r\nchannel ORA_DISK_1: reading from backup piece \/u01\/app\/oracle\/fast_recovery_area\/ORA11GR2\/backupset\/2013_07_24\/o1_mf_nnndf_TAG20130724T112657_8yyld1x7_.bkp\r\nchannel ORA_DISK_1: piece handle=\/u01\/app\/oracle\/fast_recovery_area\/ORA11GR2\/backupset\/2013_07_24\/o1_mf_nnndf_TAG20130724T112657_8yyld1x7_.bkp tag=TAG20130724T112657\r\nchannel ORA_DISK_1: restored backup piece 1\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:01\r\nFinished restore at 24-JUL-13\r\n\r\nSQL> recover datafile 5;\r\nORA-00279: change 761058 generated at 07\/24\/2013 11:26:57 needed for thread 1\r\nORA-00289: suggestion :\r\n\/u01\/app\/oracle\/fast_recovery_area\/ORA11GR2\/archivelog\/2013_07_24\/o1_mf_1_68_8yy\r\nloh5b_.arc\r\nORA-00280: change 761058 for thread 1 is in sequence #68\r\n\r\n\r\nSpecify log: {<RET>=suggested | filename | AUTO | CANCEL}\r\n\r\nORA-00279: change 761181 generated at 07\/24\/2013 11:31:59 needed for thread 1\r\nORA-00289: suggestion :\r\n\/u01\/app\/oracle\/fast_recovery_area\/ORA11GR2\/archivelog\/2013_07_24\/o1_mf_1_69_8yy\r\nlps9r_.arc\r\nORA-00280: change 761181 for thread 1 is in sequence #69\r\n\r\n\r\nSpecify log: {<RET>=suggested | filename | AUTO | CANCEL}\r\n\r\nORA-00308: cannot open archived log\r\n'\/u01\/app\/oracle\/fast_recovery_area\/ORA11GR2\/archivelog\/2013_07_24\/o1_mf_1_69_8y\r\nylps9r_.arc'\r\nORA-27037: unable to obtain file status\r\nLinux-x86_64 Error: 2: No such file or directory\r\nAdditional information: 3\r\n<\/pre>\n\u6ce8\uff1a\u6b64\u5904\u53d1\u73b0\u7f3a\u5931\u7684\u6b63\u662f\u6211\u4eec\u4e4b\u524d\u5220\u9664\u7684\u90a3\u4e2a\u4e2d\u95f4\u5f52\u6863\u65e5\u5fd769<\/p>\n
\u67e5\u770b\u6570\u636e\u5e93\u4e00\u81f4\u6027<\/p>\n
\r\nSQL> select checkpoint_change# from v$database;\r\n\r\nCHECKPOINT_CHANGE#\r\n------------------\r\n 761498\r\n\r\nSQL> select file#,checkpoint_change#,status from v$datafile;\r\n\r\n FILE# CHECKPOINT_CHANGE# STATUS\r\n---------- ------------------ -------\r\n 1 761498 SYSTEM\r\n 2 761498 ONLINE\r\n 3 761498 ONLINE\r\n 4 761498 ONLINE\r\n 5 761498 ONLINE\r\n\r\nSQL> select file#,change# from v$recover_file;\r\n\r\n FILE# CHANGE#\r\n---------- ----------\r\n 5 761181\r\n<\/pre>\n\u4e0b\u8fb9\u4f7f\u7528BBED\u8fdb\u884c\u5904\u7406<\/p>\n
\r\nBBED> d \/v dba 1,1 offset 484 count 4\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/system01.dbf (1)\r\n Block: 1 Offsets: 484 to 487 Dba:0x00400001\r\n-------------------------------------------------------\r\n 9a9e0b00 l ....\r\n\r\n <16 bytes per line>\r\n\r\nBBED> d \/v dba 5,1 offset 484 count 4\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 1 Offsets: 484 to 487 Dba:0x01400001\r\n-------------------------------------------------------\r\n 5d9d0b00 l ]...\r\n\r\n <16 bytes per line> \r\n<\/pre>\n\u6ce8\uff1a\u6b64\u5904\u660e\u663e\u56e0\u4e3a5\u53f7\u6587\u4ef6\u4ece\u5907\u4efd\u6062\u590d\u800c\u6765\uff0c\u6545\u5176scn\u6ede\u540e\u4e8e\u6587\u4ef61<\/p>\n
\u51e1\u662f\u4fee\u6539\u6587\u4ef65\u7684scn\u548c1\u53f7\u6587\u4ef6\u4e00\u81f4\uff0c\u90a3\u4e48\u5c06\u4f1a\u5931\u53bb\u4e22\u5931\u5f52\u6863\u4e4b\u540e\u7684\u6240\u6709\u5f52\u6863\u6570\u636e
\n\u4e0b\u8fb9\u6211\u4eec\u53ea\u4fee\u6539 kcrbaseq \u4e3a\u4e0b\u4e00\u4e2a\u65e5\u5fd7\u5e8f\u5217\uff0c\u8df3\u8fc7\u7f3a\u5931\u7684\u65e5\u5fd7<\/p>\n\r\nBBED> d \/v dba 1,1 offset 484 count 4\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/system01.dbf (1)\r\n Block: 1 Offsets: 484 to 487 Dba:0x00400001\r\n-------------------------------------------------------\r\n 9a9e0b00 l ....\r\n\r\n <16 bytes per line>\r\n\r\nBBED> d \/v dba 5,1 offset 484 count 4\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 1 Offsets: 484 to 487 Dba:0x01400001\r\n-------------------------------------------------------\r\n 5d9d0b00 l ]...\r\n\r\n <16 bytes per line>\r\n\r\nBBED> d \/v dba 5,1 offset 500 count 4\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 1 Offsets: 500 to 503 Dba:0x01400001\r\n-------------------------------------------------------\r\n 45000000 l E...\r\n\r\n <16 bytes per line>\r\n<\/pre>\n\u67e5\u770b\u53d1\u73b0\u5f53\u524d\u7684\u65e5\u5fd7\u5e8f\u5217\u662f 0x45\u4e5f\u5c31\u662f69\u53f7\uff0c\u6211\u4eec\u5c06\u5176\u6539\u62100x46\u4e5f\u5c31\u662f70\u53f7\u65e5\u5fd7\u6587\u4ef6<\/p>\n
\r\nBBED> m \/x 46 dba 5,1 offset 500\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 1 Offsets: 500 to 503 Dba:0x01400001\r\n------------------------------------------------------------------------\r\n 46000000 \r\n\r\n <32 bytes per line>\r\n\r\nBBED> sum apply;\r\nCheck value for File 5, Block 1:\r\ncurrent = 0xcd85, required = 0xcd85\r\n\r\n<\/pre>\n\u518d\u6b21\u6062\u590d\t\t <\/p>\n
\r\nSQL> recover datafile 5;\r\nORA-00279: change 761181 generated at 07\/24\/2013 11:31:59 needed for thread 1\r\nORA-00289: suggestion :\r\n\/u01\/app\/oracle\/fast_recovery_area\/ORA11GR2\/archivelog\/2013_07_24\/o1_mf_1_70_8yy\r\nlq9on_.arc\r\nORA-00280: change 761181 for thread 1 is in sequence #70\r\n\r\n\r\nSpecify log: {<RET>=suggested | filename | AUTO | CANCEL}\r\n\r\nORA-00326: log begins at change 761200, need earlier change 761181 <<\u4e5f\u5c31\u662f\u5f53\u524d\u7684scn 000b9d5d\r\nORA-00334: archived log:\r\n'\/u01\/app\/oracle\/fast_recovery_area\/ORA11GR2\/archivelog\/2013_07_24\/o1_mf_1_70_8y\r\nylq9on_.arc'\t \r\n<\/pre>\n\u6ce8\uff1a\u6b64\u5904\u53d1\u73b0\u8be5\u6587\u4ef6\u7684scn\u592a\u4e45<\/p>\n
\u6211\u4eec\u7ee7\u7eed\u4fee\u65395\u53f7\u6587\u4ef6\u7684scn\u4e3a 761200 \u4e5f\u5c31\u662f\u5341\u516d\u8fdb\u5236\u7684 000b9d70,\u5982\u4e0b\u8ba1\u7b97<\/p>\n
\r\nSQL> select to_char('761200','xxxxxxxx') from dual;\r\n\r\nTO_CHAR('\r\n---------\r\n b9d70\r\n\r\nSQL> select to_number('000b9d70','xxxxxxxx') from dual;\r\n\r\nTO_NUMBER('00B9D70','XXXXXXXX')\r\n-------------------------------\r\n 761200\r\n\t\t\t\t\t\t \r\nBBED> d \/v dba 1,1 offset 484 count 4\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/system01.dbf (1)\r\n Block: 1 Offsets: 484 to 487 Dba:0x00400001\r\n-------------------------------------------------------\r\n 9a9e0b00 l ....\r\n\r\n <16 bytes per line>\r\n\r\nBBED> d \/v dba 5,1 offset 484 count 4\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 1 Offsets: 484 to 487 Dba:0x01400001\r\n-------------------------------------------------------\r\n 5d9d0b00 l ]...\r\n\r\n <16 bytes per line>\r\n\r\nBBED> m \/x 709d0b00 dba 5,1 offset 484\t\t<<\u6ce8\u610f\u5b57\u8282\u5e8f\u7684\u53cd\u8f6c\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 1 Offsets: 484 to 487 Dba:0x01400001\r\n------------------------------------------------------------------------\r\n 709d0b00 \r\n\r\n <32 bytes per line>\r\n\r\nBBED> sum apply;\r\nCheck value for File 5, Block 1:\r\ncurrent = 0xd326, required = 0xd326\r\n<\/pre>\n\u4e0b\u8fb9\u7ee7\u7eed\u5c1d\u8bd5\u6062\u590d\u6570\u636e\u6587\u4ef6<\/p>\n
\r\nSQL> recover datafile 5;\r\nORA-00279: change 761200 generated at 07\/24\/2013 11:31:59 needed for thread 1\r\nORA-00289: suggestion :\r\n\/u01\/app\/oracle\/fast_recovery_area\/ORA11GR2\/archivelog\/2013_07_24\/o1_mf_1_70_8yy\r\nlq9on_.arc\r\nORA-00280: change 761200 for thread 1 is in sequence #70\r\n\r\n\r\nSpecify log: {<RET>=suggested | filename | AUTO | CANCEL}\r\n\r\nORA-00279: change 761212 generated at 07\/24\/2013 11:32:57 needed for thread 1\r\nORA-00289: suggestion :\r\n\/u01\/app\/oracle\/fast_recovery_area\/ORA11GR2\/archivelog\/2013_07_24\/o1_mf_1_71_8yy\r\nm6j68_.arc\r\nORA-00280: change 761212 for thread 1 is in sequence #71\r\n\r\n\r\nSpecify log: {<RET>=suggested | filename | AUTO | CANCEL}\r\n\r\nLog applied.\r\nMedia recovery complete.\r\n<\/pre>\n\u6ce8\uff1a\u6b64\u5904\u5df2\u7ecf\u8df3\u8fc7\u7f3a\u5931\u7684\u5f52\u6863\u65e5\u5fd7\uff0c\u5e76\u6210\u529f\u7684\u5e94\u7528\u4e86\u4e4b\u540e\u7684\u5f52\u6863\u8fdb\u884c\u4e86\u6570\u636e\u6587\u4ef6\u7684\u6062\u590d<\/p>\n
\u68c0\u67e5\u6d4b\u8bd5\u6570\u636e<\/p>\n
\r\nSQL> alter database open;\r\n\r\nDatabase altered.\r\n\r\nSQL> alter session set nls_date_format='yyyy\/mm\/dd hh24:mi:ss';\r\n\r\nSession altered.\r\n\r\nSQL> select * from yallonking.yallonking;\r\n\r\n ID NAME MY_DATE\r\n---------- -------------------- -------------------\r\n 1 yallonking 2013\/07\/22 09:44:53\r\n 2 oraking 2013\/07\/22 09:45:07\r\n 3 xiaolong 2013\/07\/22 09:50:09\r\n 4 archive_test1 2013\/07\/24 11:31:48\r\n 6 archive_test3 2013\/07\/24 11:32:51\r\n<\/pre>\n\u6ce8\uff1a\u6b64\u5904\u679c\u771f\u4e22\u5931\u4e865\u53f7\u8bb0\u5f55\u3002<\/p>\n
\u5c0f\u7ed3\uff1a
\n\u53ea\u8981\u6587\u4ef6\u7684scn\u548c\u63a7\u5236\u6587\u4ef6\u4e2d\u7684scn\u4e00\u81f4\uff0c\u5219\u5e93\u4fbf\u53ef\u4ee5\u5b8c\u6210\u4e00\u81f4\u6027\u68c0\u67e5\u6253\u5f00\uff0c\u5982\u679c\u6587\u4ef6\u7684scn\u6ede\u540e\uff0c\u90a3\u4e48\u5c31\u9700\u8981\u4ece\u8be5scn\u5e94\u7528\u4e4b\u540e\u7684\u65e5\u5fd7\uff08\u5f52\u6863\u65e5\u5fd7\uff09\u8ffd\u5e73scn\u3002
\n\u5728\u6b64\u4f8b\u4e2d\uff0c\u6211\u4eec\u8981\u8df3\u8fc7\u7f3a\u5931\u7684\u5f52\u6863\u65e5\u5fd7\uff0c\u6211\u4eec\u9700\u8981\u8bbe\u7f6e\u8be5\u6587\u4ef6\u7684scn\u4e3a\u63a5\u4e0b\u6765\u5f52\u6863\u5f00\u59cb\u7684scn\uff0c\u4ee5\u53ca\u8bbe\u7f6e\u65e5\u5fd7\u5e8f\u5217\u53f7\u4e3a\u63a5\u4e0b\u6765\u7684\u5f52\u6863\u65e5\u5fd7\u5e8f\u5217\u53f7\uff0c\u8fd9\u6837\u624d\u53ef\u8df3\u8fc7\u786e\u5b9e\u7684\u5f52\u6863\u65e5\u5fd7\u8fdb\u884c\u6062\u590d\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"\u64cd\u4f5c\u7cfb\u7edf\u4fe1\u606f [oracle@rhl6 lib]$ uname -a Linux rhl6.0x64 2.6. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[40],"tags":[222,102,236,235],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1032"}],"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=1032"}],"version-history":[{"count":3,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1032\/revisions"}],"predecessor-version":[{"id":1094,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1032\/revisions\/1094"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1032"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1032"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1032"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}