\u573a\u666f\u8bf4\u660e\uff1a\u6a21\u62df\u6570\u636e\u5e93\u6240\u5728\u78c1\u76d8\u53d1\u751f\u6545\u969c\u5bfc\u81f4\u6240\u6709\u6587\u4ef6\u4e22\u5931\uff0c\u5305\u62ec\u53c2\u6570\u6587\u4ef6\uff0c\u63a7\u5236\u6587\u4ef6\uff0c\u6570\u636e\u6587\u4ef6\uff0c\u4f46\u662f\u6709\u5b8c\u6574\u6570\u636e\u5e93\u5168\u5e93\u5907\u4efd\uff08\u542b\u53c2\u6570\u6587\u4ef6\u53ca\u63a7\u5236\u6587\u4ef6\u7684\u5907\u4efd\uff09\uff0c\u4ee5\u53ca\u5b8c\u6574\u7684\u5f52\u6863\u65e5\u5fd7\uff0conline redo\u5907\u4efd\u3002<\/p>\n
RMAN\u5f02\u5730\u6062\u590d\uff08\u540c\u5e73\u53f0\u540c\u64cd\u4f5c\u7cfb\u7edf\uff09
\n\u573a\u666f\u8bf4\u660e\uff1a\u6a21\u62df\u6570\u636e\u5e93\u6240\u5728\u78c1\u76d8\u53d1\u751f\u6545\u969c\u5bfc\u81f4\u6240\u6709\u6587\u4ef6\u4e22\u5931\uff0c\u5305\u62ec\u53c2\u6570\u6587\u4ef6\uff0c\u63a7\u5236\u6587\u4ef6\uff0c\u6240\u6709redo\u6587\u4ef6\uff0c\u6570\u636e\u6587\u4ef6\uff0c\u4f46\u662f\u6709\u5b8c\u6574\u6570\u636e\u5e93\u5168\u5e93\u5907\u4efd\uff08\u542b\u53c2\u6570\u6587\u4ef6\u53ca\u63a7\u5236\u6587\u4ef6\u7684\u5907\u4efd\uff09\uff0c\u4ee5\u53ca\u5b8c\u6574\u7684\u5f52\u6863\u65e5\u5fd7\u5907\u4efd\u3002<\/p>\n
\u9996\u5148\u8bbe\u7f6erman\u63a7\u5236\u6587\u4ef6\u81ea\u52a8\u5907\u4efd<\/p>\n
\r\nRMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;\r\n\r\nnew RMAN configuration parameters:\r\nCONFIGURE CONTROLFILE AUTOBACKUP ON;\r\nnew RMAN configuration parameters are successfully stored\r\n<\/pre>\n\u67e5\u770b\u6570\u636e\u5e93\u662f\u5426\u5f52\u6863\u6a21\u5f0f<\/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 27\r\nNext log sequence to archive 29\r\nCurrent log sequence 29\r\n<\/pre>\n\u6ce8\u610f\uff1a\u6b64\u5904\u6570\u636e\u5e93\u662f\u51fa\u4e8e\u5f52\u6863\u6a21\u5f0f\u7684\uff0c\u81f3\u4e8e\u5982\u4f55\u8bbe\u5b9a\u5f52\u6863\u6a21\u5f0f\uff0c\u6b64\u5904\u4e0d\u518d\u8d58\u8ff0\u3002<\/p>\n
\u67e5\u770b\u6d4b\u8bd5\u6570\u636e<\/p>\n
\r\nSQL> select * from test.test;\r\n\r\n ID NAME\r\n---------- --------------------\r\n 1 yallonking\r\n<\/pre>\n\u4f7f\u7528RMAN\u5907\u4efd\u6570\u636e\u5e93<\/p>\n
\r\n[oracle@ora10gr2 ~]$ rman target \/ log='\/u01\/app\/oracle\/backups\/full_db_rman_backups.log'\r\nRMAN> run {\r\n2> allocate channel dev1 type disk;\r\n3> allocate channel dev2 type disk;\r\n4> backup full database tag 'full_db_backup' format '\/u01\/app\/oracle\/backups\/%d_%T_%U_full.dbf';\r\n5> sql 'alter system archive log current';\r\n6> backup filesperset 5 format '\/u01\/app\/oracle\/backups\/arch_%u_%s_%p' archivelog all delete input;\r\n7> backup current controlfile format '\/u01\/app\/oracle\/backups\/db_ctl_%T_%t_%s_%p.bak';\r\n8> release channel dev1;\r\n9> release channel dev2;\r\n10> }\r\nRMAN> \r\n<\/pre>\n\u4e0b\u8fb9\u6a21\u62df\u5220\u9664\u6240\u6709\u6570\u636e\u5e93\u6587\u4ef6
\n\u6ce8\u610f\uff1a\u5982\u679c\u5220\u9664\u6240\u6709redo\u65e5\u5fd7\uff0c\u90a3\u4e48\u5982\u679c\u5173\u95ed\u65f6\u6ca1\u6709\u5e72\u51c0\u5173\u95ed\u5e93\u7684\u8bdd\uff0c\u53ef\u80fd\u4f1a\u5728\u4e0b\u6b21\u6062\u590d\u65f6\u8fdb\u884c\u4e0d\u5b8c\u5168\u6062\u590d\u3002<\/p>\n\r\n[oracle@ora10gr2 ora10gr2]$ ls -l\r\ntotal 1006384\r\n-rw-r----- 1 oracle oinstall 7356416 Jan 21 20:12 control01.ctl\r\n-rw-r----- 1 oracle oinstall 7356416 Jan 21 20:12 control02.ctl\r\n-rw-r----- 1 oracle oinstall 7356416 Jan 21 20:12 control03.ctl\r\n-rw-r----- 1 oracle oinstall 52436992 Jan 21 19:31 ogg01.dbf\r\n-rw-r----- 1 oracle oinstall 52429312 Jan 21 19:25 redo01.log\r\n-rw-r----- 1 oracle oinstall 52429312 Jan 21 20:12 redo02.log\r\n-rw-r----- 1 oracle oinstall 52429312 Jan 21 19:25 redo03.log\r\n-rw-r----- 1 oracle oinstall 251666432 Jan 21 20:09 sysaux01.dbf\r\n-rw-r----- 1 oracle oinstall 503324672 Jan 21 20:11 system01.dbf\r\n-rw-r----- 1 oracle oinstall 20979712 Jan 1 23:51 temp01.dbf\r\n-rw-r----- 1 oracle oinstall 10493952 Jan 21 19:31 test01.dbf\r\n-rw-r----- 1 oracle oinstall 26222592 Jan 21 20:11 undotbs01.dbf\r\n-rw-r----- 1 oracle oinstall 5251072 Jan 21 19:31 users01.dbf\r\n[oracle@ora10gr2 ora10gr2]$ mv * ..\/\r\n[oracle@ora10gr2 ora10gr2]$ ls -l\r\ntotal 0\r\n\r\n<\/pre>\n\u5220\u9664\u53c2\u6570\u6587\u4ef6<\/p>\n
\r\nSQL> show parameter spfile\r\n\r\nNAME TYPE VALUE\r\n------------------------------------ ----------- ------------------------------\r\nspfile string \/u01\/app\/oracle\/product\/10.2.0\r\n \/db_1\/dbs\/spfileora10gr2.ora\r\n[oracle@ora10gr2 dbs]$ ls\r\nalert_ora10gr2.log hc_ora10gr2.dat initdw.ora init.ora lkORA10GR2 orapwora10gr2 snapcf_ora10gr2.f spfileora10gr2.ora\r\n[oracle@ora10gr2 dbs]$ mv spfileora10gr2.ora ..\/\r\n\r\n<\/pre>\n\u6a21\u62df\u4e3b\u673a\u65ad\u7535\uff08\u6b64\u5904\u4e0d\u662f\u4e00\u81f4\u6027\u5173\u95ed\u5e93\uff09<\/p>\n
\r\nSQL> shutdown abort\r\nORACLE instance shut down.\r\n<\/pre>\nRMAN\u5f00\u59cb\u6062\u590d
\n\u4eceRMAN\u65e5\u5fd7\u4e2d\u627e\u5230\u6570\u636e\u5e93\u7684DBID<\/p>\n\r\n[oracle@ora10gr2 ~]$ cat \/u01\/app\/oracle\/backups\/full_db_rman_backups.log | grep DBID\r\nconnected to target database: ORA10GR2 (DBID=4093928674)\r\n[oracle@ora10gr2 ~]$ rman target \/ \r\n\r\nRecovery Manager: Release 10.2.0.1.0 - Production on Mon Jan 21 20:21:05 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> set dbid=4093928674\r\n\r\nexecuting command: SET DBID\r\n\r\nRMAN> 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 201330452 bytes\r\nDatabase Buffers 402653184 bytes\r\nRedo Buffers 2969600 bytes\r\n\r\nRMAN> \r\n<\/pre>\n\u67e5\u770b\u53c2\u6570\u6587\u4ef6\u5907\u4efd\u7247\uff0c\u5e76\u4ece\u5907\u4efd\u6062\u590d\u53c2\u6570\u6587\u4ef6\u5230\u5176\u4ed6\u76ee\u5f55<\/p>\n
\r\n[oracle@ora10gr2 ~]$ cat \/u01\/app\/oracle\/backups\/full_db_rman_backups.log| grep -A 2 SPFILE\r\nStarting Control File and SPFILE Autobackup at 21-JAN-13\r\npiece handle=\/u01\/app\/oracle\/flash_recovery_area\/ORA10GR2\/autobackup\/2013_01_21\/o1_mf_s_805333346_8hwjq5pd_.bkp comment=NONE\r\nFinished Control File and SPFILE Autobackup at 21-JAN-13\r\n\r\nsql statement: alter system archive log current\r\n--\r\nStarting Control File and SPFILE Autobackup at 21-JAN-13\r\npiece handle=\/u01\/app\/oracle\/flash_recovery_area\/ORA10GR2\/autobackup\/2013_01_21\/o1_mf_s_805333417_8hwjsbhc_.bkp comment=NONE\r\nFinished Control File and SPFILE Autobackup at 21-JAN-13\r\n\r\nreleased channel: dev1\r\n[oracle@ora10gr2 ~]$\r\nRMAN> restore spfile to '\/u01\/app\/spfile_temp' from '\/u01\/app\/oracle\/flash_recovery_area\/ORA10GR2\/autobackup\/2013_01_21\/o1_mf_s_805333417_8hwjsbhc_.bkp';\r\n\r\nStarting restore at 21-JAN-13\r\nusing target database control file instead of recovery catalog\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: sid=36 devtype=DISK\r\n\r\nchannel ORA_DISK_1: autobackup found: \/u01\/app\/oracle\/flash_recovery_area\/ORA10GR2\/autobackup\/2013_01_21\/o1_mf_s_805333417_8hwjsbhc_.bkp\r\nchannel ORA_DISK_1: SPFILE restore from autobackup complete\r\nFinished restore at 21-JAN-13\r\n\r\n[oracle@ora10gr2 ~]$ sqlplus "\/as sysdba"\r\n\r\nSQL*Plus: Release 10.2.0.1.0 - Production on Mon Jan 21 20:45:27 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> create pfile='\/u01\/app\/pfile.txt' from spfile='\/u01\/app\/spfile_temp';\r\n\r\nFile created.\r\n<\/pre>\n\u67e5\u770b\u63a7\u5236\u6587\u4ef6\u6240\u5728\u5907\u4efd\u7247\uff0c\u5e76\u4ece\u5907\u4efd\u6062\u590d\u63a7\u5236\u6587\u4ef6<\/p>\n
\r\n[oracle@ora10gr2 ~]$ cat \/u01\/app\/oracle\/backups\/full_db_rman_backups.log| grep -A 2 Control\r\nStarting Control File and SPFILE Autobackup at 21-JAN-13\r\npiece handle=\/u01\/app\/oracle\/flash_recovery_area\/ORA10GR2\/autobackup\/2013_01_21\/o1_mf_s_805333346_8hwjq5pd_.bkp comment=NONE\r\nFinished Control File and SPFILE Autobackup at 21-JAN-13\r\n\r\nsql statement: alter system archive log current\r\n--\r\nStarting Control File and SPFILE Autobackup at 21-JAN-13\r\npiece handle=\/u01\/app\/oracle\/flash_recovery_area\/ORA10GR2\/autobackup\/2013_01_21\/o1_mf_s_805333417_8hwjsbhc_.bkp comment=NONE\r\nFinished Control File and SPFILE Autobackup at 21-JAN-13\r\n\r\nreleased channel: dev1\r\n\r\nRMAN> restore controlfile to '\/u01\/app\/controlfile01.ctl' from '\/u01\/app\/oracle\/flash_recovery_area\/ORA10GR2\/autobackup\/2013_01_21\/o1_mf_s_805333417_8hwjsbhc_.bkp';\r\n\r\nStarting restore at 21-JAN-13\r\nusing channel ORA_DISK_1\r\n\r\nchannel ORA_DISK_1: restoring control file\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:04\r\nFinished restore at 21-JAN-13\r\n\r\n<\/pre>\n\u5728\u65b0\u5730\u5740\u590d\u7528\u63a7\u5236\u6587\u4ef6<\/p>\n
\r\n[oracle@ora10gr2 app]$ pwd\r\n\/u01\/app\r\n[oracle@ora10gr2 app]$ ls -l\r\ntotal 7220\r\n-rw-r----- 1 oracle oinstall 7356416 Jan 21 20:51 controlfile01.ctl\r\ndrwxrwxr-x 4 grid oinstall 4096 Aug 19 04:06 grid\r\ndrwxr-xr-x 3 oracle oinstall 4096 Jan 1 21:53 ogg\r\ndrwxrwxr-x 7 oracle oinstall 4096 Jan 21 20:40 oracle\r\ndrwxrwx--- 6 grid oinstall 4096 Aug 19 05:03 oraInventory\r\n-rw-r--r-- 1 oracle oinstall 1119 Jan 21 20:46 pfile.txt\r\n-rw-r----- 1 oracle oinstall 3584 Jan 21 20:42 spfile_temp\r\n[oracle@ora10gr2 app]$ cp controlfile01.ctl controlfile02.ctl\r\n[oracle@ora10gr2 app]$ cp controlfile01.ctl controlfile03.ctl\r\n\r\n<\/pre>\n\u4fee\u6539\u53c2\u6570\u6587\u4ef6\u4e2dcontrol_files\u53c2\u6570\u7684\u503c\u6307\u5411\u65b0\u7684\u5730\u5740<\/p>\n
\r\n[oracle@ora10gr2 app]$ cat pfile.txt | grep control_files\r\n*.control_files='\/u01\/app\/controlfile01.ctl','\/u01\/app\/controlfile02.ctl','\/u01\/app\/controlfile03.ctl'\r\n<\/pre>\n\u4f7f\u7528\u65b0\u7684pfile\u4ee5\u53ca\u65b0\u7684\u63a7\u5236\u6587\u4ef6\u5728mount\u4e0b\u6062\u590d\u6570\u636e\u5e93\u5230\u65b0\u7684\u5730\u5740<\/p>\n
\r\nRMAN> shutdown abort\r\n\r\nOracle instance shut down\r\n[oracle@ora10gr2 ~]$ sqlplus "\/as sysdba"\r\n\r\nSQL*Plus: Release 10.2.0.1.0 - Production on Mon Jan 21 21:00:52 2013\r\n\r\nCopyright (c) 1982, 2005, Oracle. All rights reserved.\r\n\r\nConnected to an idle instance.\r\n\r\nSQL> startup mount pfile='\/u01\/app\/pfile.txt';\r\nORACLE instance started.\r\n\r\nTotal System Global Area 608174080 bytes\r\nFixed Size 1220844 bytes\r\nVariable Size 201330452 bytes\r\nDatabase Buffers 402653184 bytes\r\nRedo Buffers 2969600 bytes\r\nDatabase mounted.\r\n\r\n<\/pre>\n\u5728rman\u4e2d\u627e\u5230\u4ee5\u524d\u6570\u636e\u5e93\u6570\u636e\u6587\u4ef6\u7684\u8def\u5f84<\/p>\n
\r\n[oracle@ora10gr2 ~]$ rman target \/ \r\n\r\nRecovery Manager: Release 10.2.0.1.0 - Production on Tue Jan 22 00:02:41 2013\r\n\r\nCopyright (c) 1982, 2005, Oracle. All rights reserved.\r\n\r\nconnected to target database: ORA10GR2 (DBID=4093928674, not open)\r\n\r\nRMAN> list backupset;\r\n\r\nusing target database control file instead of recovery catalog\r\n\r\nList of Backup Sets\r\n===================\r\n\r\nBS Key Type LV Size Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ ---------------\r\n1 Full 359.09M DISK 00:02:06 21-JAN-13 \r\n BP Key: 1 Status: AVAILABLE Compressed: NO Tag: FULL_DB_BACKUP\r\n Piece Name: \/u01\/app\/oracle\/backups\/ORA10GR2_20130121_01o00q6k_1_1_full.dbf\r\n List of Datafiles in backup set 1\r\n File LV Type Ckp SCN Ckp Time Name\r\n ---- -- ---- ---------- --------- ----\r\n 1 Full 501257 21-JAN-13 \/u01\/app\/oracle\/oradata\/ora10gr2\/system01.dbf\r\n 4 Full 501257 21-JAN-13 \/u01\/app\/oracle\/oradata\/ora10gr2\/users01.dbf\r\n 5 Full 501257 21-JAN-13 \/u01\/app\/oracle\/oradata\/ora10gr2\/test01.dbf\r\n\r\nBS Key Type LV Size Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ ---------------\r\n2 Full 172.80M DISK 00:02:18 21-JAN-13 \r\n BP Key: 2 Status: AVAILABLE Compressed: NO Tag: FULL_DB_BACKUP\r\n Piece Name: \/u01\/app\/oracle\/backups\/ORA10GR2_20130121_02o00q6k_1_1_full.dbf\r\n List of Datafiles in backup set 2\r\n File LV Type Ckp SCN Ckp Time Name\r\n ---- -- ---- ---------- --------- ----\r\n 2 Full 501258 21-JAN-13 \/u01\/app\/oracle\/oradata\/ora10gr2\/undotbs01.dbf\r\n 3 Full 501258 21-JAN-13 \/u01\/app\/oracle\/oradata\/ora10gr2\/sysaux01.dbf\r\n 6 Full 501258 21-JAN-13 \/u01\/app\/oracle\/oradata\/ora10gr2\/ogg01.dbf\r\n\u6b64\u5904\u7701\u7565\u5176\u4ed6\u8f93\u51fa...\r\n<\/pre>\n\u6839\u636e\u4ee5\u4e0a\u8f93\u51fa\u5728rman\u7684run\u5757\u4e2d\u5c06\u6570\u636e\u5e93\u6587\u4ef6\u91cd\u65b0\u6307\u5411\u65b0\u7684\u5730\u5740\uff0c\u5e76\u4f5crestore\u548crecover<\/p>\n
\r\nRMAN> run {\r\n2> allocate channel dev1 type disk;\r\n3> allocate channel dev2 type disk;\r\n4> set newname for datafile 1 to '\/u01\/app\/system01.dbf';\r\n5> set newname for datafile 4 to '\/u01\/app\/users01.dbf';\r\n6> set newname for datafile 5 to '\/u01\/app\/test01.dbf';\r\n7> set newname for datafile 2 to '\/u01\/app\/undotbs01.dbf';\r\n8> set newname for datafile 3 to '\/u01\/app\/sysaux01.dbf';\r\n9> set newname for datafile 6 to '\/u01\/app\/ogg01.dbf';\r\n10> restore database;\r\n11> switch datafile all;\r\n12> recover database;\r\n13> release channel dev1;\r\n14> release channel dev2;\r\n15> }\r\n\r\nreleased channel: ORA_DISK_1\r\nallocated channel: dev1\r\nchannel dev1: sid=155 devtype=DISK\r\n\r\nallocated channel: dev2\r\nchannel dev2: sid=154 devtype=DISK\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nStarting restore at 22-JAN-13\r\n\r\nchannel dev1: starting datafile backupset restore\r\nchannel dev1: specifying datafile(s) to restore from backup set\r\nrestoring datafile 00001 to \/u01\/app\/system01.dbf\r\nrestoring datafile 00004 to \/u01\/app\/users01.dbf\r\nrestoring datafile 00005 to \/u01\/app\/test01.dbf\r\nchannel dev1: reading from backup piece \/u01\/app\/oracle\/backups\/ORA10GR2_20130121_01o00q6k_1_1_full.dbf\r\nchannel dev2: starting datafile backupset restore\r\nchannel dev2: specifying datafile(s) to restore from backup set\r\nrestoring datafile 00002 to \/u01\/app\/undotbs01.dbf\r\nrestoring datafile 00003 to \/u01\/app\/sysaux01.dbf\r\nrestoring datafile 00006 to \/u01\/app\/ogg01.dbf\r\nchannel dev2: reading from backup piece \/u01\/app\/oracle\/backups\/ORA10GR2_20130121_02o00q6k_1_1_full.dbf\r\nchannel dev1: restored backup piece 1\r\npiece handle=\/u01\/app\/oracle\/backups\/ORA10GR2_20130121_01o00q6k_1_1_full.dbf tag=FULL_DB_BACKUP\r\nchannel dev1: restore complete, elapsed time: 00:01:07\r\nchannel dev2: restored backup piece 1\r\npiece handle=\/u01\/app\/oracle\/backups\/ORA10GR2_20130121_02o00q6k_1_1_full.dbf tag=FULL_DB_BACKUP\r\nchannel dev2: restore complete, elapsed time: 00:01:07\r\nFinished restore at 22-JAN-13\r\n\r\ndatafile 1 switched to datafile copy\r\ninput datafile copy recid=13 stamp=805339465 filename=\/u01\/app\/system01.dbf\r\ndatafile 4 switched to datafile copy\r\ninput datafile copy recid=14 stamp=805339465 filename=\/u01\/app\/users01.dbf\r\ndatafile 5 switched to datafile copy\r\ninput datafile copy recid=15 stamp=805339465 filename=\/u01\/app\/test01.dbf\r\ndatafile 2 switched to datafile copy\r\ninput datafile copy recid=16 stamp=805339465 filename=\/u01\/app\/undotbs01.dbf\r\ndatafile 3 switched to datafile copy\r\ninput datafile copy recid=17 stamp=805339465 filename=\/u01\/app\/sysaux01.dbf\r\ndatafile 6 switched to datafile copy\r\ninput datafile copy recid=18 stamp=805339465 filename=\/u01\/app\/ogg01.dbf\r\n\r\nStarting recover at 22-JAN-13\r\n\r\nstarting media recovery\r\n\r\narchive log thread 1 sequence 29 is already on disk as file \/u01\/app\/oracle\/oradata\/arch\/1_29_791701862.dbf\r\narchive log thread 1 sequence 30 is already on disk as file \/u01\/app\/oracle\/oradata\/arch\/1_30_791701862.dbf\r\narchive log filename=\/u01\/app\/oracle\/oradata\/arch\/1_29_791701862.dbf thread=1 sequence=29\r\narchive log filename=\/u01\/app\/oracle\/oradata\/arch\/1_30_791701862.dbf thread=1 sequence=30\r\nunable to find archive log\r\narchive log thread=1 sequence=31\r\nreleased channel: dev1\r\nreleased channel: dev2\r\nRMAN-00571: ===========================================================\r\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\r\nRMAN-00571: ===========================================================\r\nRMAN-03002: failure of recover command at 01\/22\/2013 01:24:33\r\nRMAN-06054: media recovery requesting unknown log: thread 1 seq 31 lowscn 501317\r\n<\/pre>\n\u6b64\u5904\u53d1\u73b0\u5728recover\u65f6\u7f3a\u5c11\u65e5\u5fd7\uff0c\u8fd9\u4e2a\u4e5f\u548c\u4e4b\u524d\u5c06\u6240\u6709redo\u79fb\u8d70\u6709\u5173\uff08\u5e76\u4e14\u5728shutdown abort\u4e4b\u524d\u6ca1\u6709\u8fdb\u884c\u5207\u6362\u65e5\u5fd7\u5c06\u65e5\u5fd7\u4fe1\u606f\u53ca\u65f6\u5199\u8fdb\u5f52\u6863\u65e5\u5fd7\uff09\uff0c\u5982\u679credo\u771f\u7684\u4e22\u5931\uff0c\u90a3\u4e48\u5c31\u53ea\u80fd\u8fdb\u884c\u4e0d\u5b8c\u5168\u6062\u590d\uff0c\u6b64\u5904\u6211\u4eec\u5c06\u4e4b\u524d\u7684redo\uff08\u5047\u5b9a\u662fonline redo\u7684\u4e00\u4e2a\u955c\u50cf\u5907\u4efd\u8fd8\u5b58\u5728\uff09\u79fb\u52a8\u5230\u65b0\u7684\u4f4d\u7f6e\uff08\u65b0\u4f4d\u7f6e\u6a21\u62df\u5f02\u5730\u6062\u590d\uff09\uff0c\u5e76\u518d\u6b21recover\uff0c\u8fd9\u91cc\u53ef\u4ee5\u4eceseq\u53f7\u5728alert.log\u4e2d\u67e5\u5230\u5177\u4f53\u7684redo\u7ec4\uff0c\u8fd9\u91cc\u5c06\u6240\u6709redo\u79fb\u8fc7\u53bb\uff0c\u6328\u4e2a\u5c1d\u8bd5\u3002<\/p>\n
\r\n[oracle@ora10gr2 oradata]$ ls\r\narch control02.ctl ogg01.dbf redo01.log redo03.log system01.dbf test01.dbf users01.dbf\r\ncontrol01.ctl control03.ctl ora10gr2 redo02.log sysaux01.dbf temp01.dbf undotbs01.dbf\r\n[oracle@ora10gr2 oradata]$ mv *.log \/u01\/app\r\nRMAN> recover database from "\/u01\/app\/redo01.log";\r\n\r\nRMAN-00571: ===========================================================\r\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\r\nRMAN-00571: ===========================================================\r\nRMAN-00558: error encountered while parsing input commands\r\nRMAN-01009: syntax error: found "double-quoted-string": expecting one of: "tag"\r\nRMAN-01007: at line 1 column 23 file: standard input\r\n\r\n<\/pre>\n\u7531\u4e8erecover database\u65f6\u65e0\u6cd5\u6307\u5b9afrom\u5b50\u53e5\uff0c\u6b64\u5904\u901a\u8fc7\u5efa\u7acb\u8f6f\u8fde\u63a5\u8fdb\u884c\u6062\u590d<\/p>\n
\r\n[oracle@ora10gr2 ~]$ ln -s \/u01\/app\/redo01.log \/u01\/app\/oracle\/oradata\/ora10gr2\/redo01.log\r\n[oracle@ora10gr2 ~]$ ln -s \/u01\/app\/redo02.log \/u01\/app\/oracle\/oradata\/ora10gr2\/redo02.log\r\n[oracle@ora10gr2 ~]$ ln -s \/u01\/app\/redo03.log \/u01\/app\/oracle\/oradata\/ora10gr2\/redo03.log\r\n[oracle@ora10gr2 ~]$ cd \/u01\/app\/oracle\/oradata\/ora10gr2\/;ls -l\r\ntotal 0\r\nlrwxrwxrwx 1 oracle oinstall 19 Jan 22 01:41 redo01.log -> \/u01\/app\/redo01.log\r\nlrwxrwxrwx 1 oracle oinstall 19 Jan 22 01:42 redo02.log -> \/u01\/app\/redo02.log\r\nlrwxrwxrwx 1 oracle oinstall 19 Jan 22 01:43 redo03.log -> \/u01\/app\/redo03.log\r\nRMAN> recover database;\r\n\r\nStarting recover at 22-JAN-13\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: sid=155 devtype=DISK\r\n\r\nstarting media recovery\r\n\r\narchive log thread 1 sequence 31 is already on disk as file \/u01\/app\/oracle\/oradata\/ora10gr2\/redo03.log\r\narchive log filename=\/u01\/app\/oracle\/oradata\/ora10gr2\/redo03.log thread=1 sequence=31\r\nmedia recovery complete, elapsed time: 00:00:16\r\nFinished recover at 22-JAN-13\r\n\r\n<\/pre>\n\u6700\u540e\u4ee5resetlogs\u6253\u5f00\u5e93\u3002<\/p>\n
\r\nSQL> alter database open;\r\nalter database open\r\n*\r\nERROR at line 1:\r\nORA-01589: must use RESETLOGS or NORESETLOGS option for database open\r\n\r\n\r\nSQL> alter database open RESETLOGS;\r\n\r\nDatabase altered.\r\n<\/pre>\n\u6ce8\u610f\uff1a\u6b64\u65f6\u6570\u636e\u5e93\u662f\u4ee5RESETLOGS\u6253\u5f00\u7684\uff0coracle\u5efa\u8bae\u7acb\u5373\u5bf9\u8be5\u5e93\u8fdb\u884c\u5168\u5b8c\u5907\u4efd\u3002\uff08\u4f46\u662f\u672c\u4eba\u572810g\u7684\u5e93\u91cc\u8fb9\u5728\u4ee5resetlogs\u6253\u5f00\u5e93\u4e4b\u540e\uff0c\u4e4b\u524d\u7684\u5907\u4efd\u6709\u65f6\u5019\u8fd8\u662f\u53ef\u4ee5\u7528\u7684\u3002\uff09<\/p>\n
\u5269\u4e0b\u7684\u5c31\u662f\u7528pfile\u521b\u5efaspfile\uff0c\u5e76\u4ee5spfile\u6253\u5f00\u5e93\u5373\u53ef\u3002<\/p>\n
\r\nSQL> show parameter spfile\r\n\r\nNAME TYPE VALUE\r\n------------------------------------ ----------- ------------------------------\r\nspfile string\r\nSQL> create spfile='\/u01\/app\/spfileora10gr2.ora' from pfile='\/u01\/app\/pfile.txt';\r\n\r\nFile created.\r\n\r\nSQL> shutdown immediate \r\nDatabase closed.\r\nDatabase dismounted.\r\nORACLE instance shut down.\r\nSQL> startup\r\nORA-01078: failure in processing system parameters\r\nLRM-00109: could not open parameter file '\/u01\/app\/oracle\/product\/10.2.0\/db_1\/dbs\/initora10gr2.ora'\r\n<\/pre>\n\u6b64\u5904\u662f\u56e0\u4e3aoracle\u901a\u8fc7\u73af\u5883\u53d8\u91cfORACLE_HOME\u548cSID\u627e\u4ee5\u524d\u8def\u5f84\u7684\u4e0b\u7684\u53c2\u6570\u6587\u4ef6\uff0c\u6211\u4eec\u53ef\u4ee5\u4fee\u6539\u73af\u5883\u53d8\u91cf\u6216\u8005\u901a\u8fc7\u8f6f\u8fde\u63a5\u7684\u65b9\u5f0f\u89e3\u51b3\u3002\u6b64\u5904\u901a\u8fc7\u8f6f\u8fde\u63a5\u3002<\/p>\n
\r\n[oracle@ora10gr2 dbs]$ ln -s \/u01\/app\/spfileora10gr2.ora \/u01\/app\/oracle\/product\/10.2.0\/db_1\/dbs\/spfileora10gr2.ora\r\n[oracle@ora10gr2 dbs]$ ls -l \/u01\/app\/oracle\/product\/10.2.0\/db_1\/dbs\/spfileora10gr2.ora\r\nlrwxrwxrwx 1 oracle oinstall 27 Jan 22 02:07 \/u01\/app\/oracle\/product\/10.2.0\/db_1\/dbs\/spfileora10gr2.ora -> \/u01\/app\/spfileora10gr2.ora\r\n[oracle@ora10gr2 ~]$ sqlplus "\/as sysdba"\r\n\r\nSQL*Plus: Release 10.2.0.1.0 - Production on Tue Jan 22 02:08:56 2013\r\n\r\nCopyright (c) 1982, 2005, Oracle. All rights reserved.\r\n\r\nConnected to an idle instance.\r\n\r\nSQL> startup\r\nORACLE instance started.\r\n\r\nTotal System Global Area 608174080 bytes\r\nFixed Size 1220844 bytes\r\nVariable Size 201330452 bytes\r\nDatabase Buffers 402653184 bytes\r\nRedo Buffers 2969600 bytes\r\nDatabase mounted.\r\nDatabase opened.\r\nSQL> select * from test.test;\r\n\r\n ID NAME\r\n---------- --------------------\r\n 1 yallonking\r\nSQL> show parameter spfile;\r\n\r\nNAME TYPE VALUE\r\n------------------------------------ ----------- ------------------------------\r\nspfile string \/u01\/app\/oracle\/product\/10.2.0\r\n \/db_1\/dbs\/spfileora10gr2.ora\r\n<\/pre>\n\u81f3\u6b64\uff0c\u5168\u90e8OK\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u573a\u666f\u8bf4\u660e\uff1a\u6a21\u62df\u6570\u636e\u5e93\u6240\u5728\u78c1\u76d8\u53d1\u751f\u6545\u969c\u5bfc\u81f4\u6240\u6709\u6587\u4ef6\u4e22\u5931\uff0c\u5305\u62ec\u53c2\u6570\u6587\u4ef6\uff0c\u63a7\u5236\u6587\u4ef6\uff0c\u6570\u636e\u6587\u4ef6\uff0c\u4f46\u662f\u6709\u5b8c\u6574\u6570\u636e\u5e93\u5168\u5e93\u5907 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[40,32],"tags":[85,79,78,80,71,81,82,83,84,86,76,77,75],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/623"}],"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=623"}],"version-history":[{"count":8,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/623\/revisions"}],"predecessor-version":[{"id":626,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/623\/revisions\/626"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=623"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=623"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=623"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}