RMAN\u6570\u636e\u5e93\u8fc1\u79fb\uff08\u8de8\u5e73\u53f0\u8de8\u64cd\u4f5c\u7cfb\u7edf\u4f4d\u6570\uff09
\n\u573a\u666f\u8bf4\u660e\uff1a\u5c06oracle10gr2\u7684\u6570\u636e\u5e93\u4ecewin\u5e73\u53f032\u4f4d\uff08\u8fd0\u884c\u4e2d\uff09\u4f7f\u7528rman\u8fc1\u79fb\uff08\u4f7f\u7528rman\u7684\u5168\u5e93\u5907\u4efd\uff09\u5230redhat linux6.0 64\u4f4d\u7684\u5e73\u53f0\u4e0b\u3002
\n\u76f8\u5173\u535a\u6587\uff1a\u6570\u636e\u5e93\u9ad8\u7248\u672c\u5230\u4f4e\u7248\u672c\u8de8\u64cd\u4f5c\u7cfb\u7edf\u4f4d\u6570\u8de8\u7528\u6237\u7684\u6570\u636e\u5bfc\u5165\u5bfc\u51fa
\nhttp:\/\/www.yallonking.com\/database\/623.html
\n\u67e5\u770b\u6e90\u7aef\u6570\u636e\u5e93\u4fe1\u606f<\/p>\n
\r\nSQL> select * from gv$version;\r\n\r\n INST_ID BANNER\r\n---------- ----------------------------------------------------------------\r\n 1 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod\r\n 1 PL\/SQL Release 10.2.0.1.0 - Production\r\n 1 CORE 10.2.0.1.0 Production\r\n 1 TNS for 32-bit Windows: Version 10.2.0.1.0 - Production\r\n 1 NLSRTL Version 10.2.0.1.0 - Production\r\nSQL> ALTER SESSION SET NLS_DATE_FORMAT='YYYY\/MM\/DD HH24:MI:SS';\r\n\r\n\u4f1a\u8bdd\u5df2\u66f4\u6539\u3002\r\n\r\nSQL> select * from test;\r\n\r\n ID NAME MYTIME\r\n---------- -------------------- -------------------\r\n 1 yallonking 2013\/01\/22 22:00:35\r\n\r\n<\/pre>\n\u63d2\u5165\u6d4b\u8bd5\u6570\u636e<\/p>\n
\r\nSQL> INSERT INTO TEST VALUES(2,'YALLONKING',SYSDATE);\r\n\r\n\u5df2\u521b\u5efa 1 \u884c\u3002\r\n\r\nSQL> COMMIT;\r\n\r\n\u63d0\u4ea4\u5b8c\u6210\u3002\r\n\r\nSQL> select * from test;\r\n\r\n ID NAME MYTIME\r\n---------- -------------------- -------------------\r\n 1 yallonking 2013\/01\/22 22:00:35\r\n 2 YALLONKING 2013\/01\/25 14:10:10\r\n\r\nSQL> ALTER SYSTEM SWITCH LOGFILE;\r\n\r\n\u7cfb\u7edf\u5df2\u66f4\u6539\u3002\r\n\r\nSQL> ALTER SYSTEM CHECKPOINT;\r\n\r\n\u7cfb\u7edf\u5df2\u66f4\u6539\u3002\r\n\r\nSQL> ALTER SYSTEM ARCHIVE LOG CURRENT;\r\n\r\n\u7cfb\u7edf\u5df2\u66f4\u6539\u3002\r\n\r\nSQL> archive log list;\r\n\u6570\u636e\u5e93\u65e5\u5fd7\u6a21\u5f0f \u5b58\u6863\u6a21\u5f0f\r\n\u81ea\u52a8\u5b58\u6863 \u542f\u7528\r\n\u5b58\u6863\u7ec8\u70b9 C:\\oracle\\product\\10.2.0\\backup\\\r\n\u6700\u65e9\u7684\u8054\u673a\u65e5\u5fd7\u5e8f\u5217 7\r\n\u4e0b\u4e00\u4e2a\u5b58\u6863\u65e5\u5fd7\u5e8f\u5217 9\r\n\u5f53\u524d\u65e5\u5fd7\u5e8f\u5217 9\r\n<\/pre>\n\u67e5\u770b\u5404\u5e73\u53f0\u5b57\u8282\u5e8f<\/p>\n
\r\nSQL> set pagesize 20\r\nSQL> col platform_name for a35\r\nSQL> select * from v$transportable_platform order by platform_id;\r\n\r\nPLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT\r\n----------- ----------------------------------- --------------\r\n 1 Solaris[tm] OE (32-bit) Big\r\n 2 Solaris[tm] OE (64-bit) Big\r\n 3 HP-UX (64-bit) Big\r\n 4 HP-UX IA (64-bit) Big\r\n 5 HP Tru64 UNIX Little\r\n 6 AIX-Based Systems (64-bit) Big\r\n 7 Microsoft Windows IA (32-bit) Little\r\n 8 Microsoft Windows IA (64-bit) Little\r\n 9 IBM zSeries Based Linux Big\r\n 10 Linux IA (32-bit) Little\r\n 11 Linux IA (64-bit) Little\r\n 12 Microsoft Windows 64-bit for AMD Little\r\n 13 Linux 64-bit for AMD Little\r\n 15 HP Open VMS Little\r\n 16 Apple Mac OS Big\r\n 17 Solaris Operating System (x86) Little\r\n 18 IBM Power Based Linux Big\r\n\r\n\u5df2\u9009\u62e917\u884c\u3002\r\n\r\n\u786e\u8ba4\u6e90\u5e93\u6570\u636e\u5e93\u5b57\u8282\u5e8f\r\nSQL> select tp.platform_id,substr(d.platform_name,1,30),endian_format from v$transportable_platform tp,v$database d where tp.platform_name=d.platform_name;\r\n\r\nPLATFORM_ID SUBSTR(D.PLATFORM_NAME,1,30) ENDIAN_\r\nFORMAT\r\n----------- ------------------------------------------------------------ -------\r\n-------\r\n 7 Microsoft Windows IA (32-bit) Little\r\n<\/pre>\n\u4f7f\u7528\u4ee5\u4e0b\u811a\u672c\u5907\u4efd\u6e90\u7aef\u6570\u636e\u5e93
\nC:\\Documents and Settings\\Administrator>rman target \/ log='C:\\oracle\\product\\10.2.0\\backup\\rman_full.log'
\nrun{
\nallocate channel dev1 type disk;
\nallocate channel dev2 type disk;
\nbackup full database tag 'full_backup' format 'C:\\oracle\\product\\10.2.0\\backup\\full_db_backup_%d_%T_%U.bak';
\nsql 'alter system archive log current';
\nbackup filesperset 5 format 'C:\\oracle\\product\\10.2.0\\backup\\arch_%u_%s_%p.arch' archivelog all delete input;
\nbackup current controlfile format 'C:\\oracle\\product\\10.2.0\\backup\\db_ctl_%T_%t_%s_%p.bak';
\nbackup spfile format 'C:\\oracle\\product\\10.2.0\\backup\\db_spfile_%T_%t_%s_%p.bak';
\nrelease channel dev1;
\nrelease channel dev2;
\n}<\/p>\n\u5c06\u5907\u4efd\u4f20\u9001\u5230\u76ee\u6807\u7aef\uff0c\u5e76\u4fee\u6539\u6743\u9650<\/p>\n
\r\n[oracle@rhl6 ora10gr2]$ ls -l backup\/\r\ntotal 548452\r\n-rw-r--r--. 1 oracle oinstall 17408 Jan 25 21:22 ARCH_0FO0AB8A_15_1.ARCH\r\n-rw-r--r--. 1 oracle oinstall 2560 Jan 25 21:22 ARCH_0GO0AB8A_16_1.ARCH\r\n-rw-r--r--. 1 oracle oinstall 7110656 Jan 25 21:22 DB_CTL_20130125_805645580_17_1.BAK\r\n-rw-r--r--. 1 oracle oinstall 98304 Jan 25 21:22 DB_SPFILE_20130125_805645585_18_1.BAK\r\n-rw-r--r--. 1 oracle oinstall 367763456 Jan 25 21:25 FULL_DB_BACKUP_ORA10GR2_20130125_0BO0AB5M_1_1.BAK\r\n-rw-r--r--. 1 oracle oinstall 179404800 Jan 25 21:24 FULL_DB_BACKUP_ORA10GR2_20130125_0CO0AB5M_1_1.BAK\r\n-rw-r--r--. 1 oracle oinstall 7110656 Jan 25 21:24 FULL_DB_BACKUP_ORA10GR2_20130125_0DO0AB7Q_1_1.BAK\r\n-rw-r--r--. 1 oracle oinstall 98304 Jan 25 21:24 FULL_DB_BACKUP_ORA10GR2_20130125_0EO0AB86_1_1.BAK\r\n-rw-r--r--. 1 oracle oinstall 3951 Jan 25 21:24 rman_full.log\r\n<\/pre>\n\u76ee\u6807\u7aef\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n
\r\n[oracle@rhl6 ~]$ file $ORACLE_HOME\/bin\/oracle\r\n\/opt\/ora10g\/product\/database\/bin\/oracle: setuid setgid ELF 64-bit LSB executable, x86-64, version 1 (GNU\/Linux), dynamically linked (uses shared libs), for GNU\/Linux 2.6.18, not stripped\r\n<\/pre>\nRMAN\u5f00\u59cb\u6062\u590d
\n\u53c2\u6570\u6587\u4ef6\u7684\u6062\u590d\u53ef\u4ee5\u4ece\u5907\u4efd\u6062\u590dspfile\uff0c\u4e5f\u53ef\u4ece\u6e90\u5e93\u521b\u5efa\u3002\u6b64\u5904\u9009\u62e9\u540e\u8005
\n\u81f3\u4e8e\u524d\u8005\uff0c\u89c1\u672c\u4eba\u53e6\u4e00\u7bc7\u535a\u6587\uff0c\u5f53\u4e2d\u6709\u63d0\u5230\uff1a
\n\u6570\u636e\u5e93\u9ad8\u7248\u672c\u5230\u4f4e\u7248\u672c\u8de8\u64cd\u4f5c\u7cfb\u7edf\u4f4d\u6570\u8de8\u7528\u6237\u7684\u6570\u636e\u5bfc\u5165\u5bfc\u51fa
\nhttp:\/\/www.yallonking.com\/database\/623.html
\n\u6b64\u5904\u62ff\u5230\u6e90\u5e93\u7684pfile\u5e76\u4fee\u6539\u91cc\u8fb9\u7684dump\u76f8\u5173\u76ee\u5f55\uff0c\u63a7\u5236\u6587\u4ef6\u76ee\u5f55\u7b49\uff0c\u4ee5\u53ca\u5728\u65b0\u5730\u5740\u521b\u5efa\u76f8\u5173\u76ee\u5f55\u3002<\/p>\n\r\n[oracle@rhl6 ora10gr2]$ pwd\r\n\/opt\/ora10g\/product\/ora10gr2\r\n[oracle@rhl6 ora10gr2]$ mkdir adump\r\n[oracle@rhl6 ora10gr2]$ mkdir bdump\r\n[oracle@rhl6 ora10gr2]$ mkdir cdump\r\n[oracle@rhl6 ora10gr2]$ mkdir archivelog\r\n[oracle@rhl6 ora10gr2]$ mkdir udump\r\n[oracle@rhl6 ora10gr2]$ cat pfile.txt\r\nora10gr2.__db_cache_size=432013312\r\nora10gr2.__java_pool_size=4194304\r\nora10gr2.__large_pool_size=4194304\r\nora10gr2.__shared_pool_size=167772160\r\nora10gr2.__streams_pool_size=0\r\n*.audit_file_dest='\/opt\/ora10g\/product\/ora10gr2\/adump'\r\n*.background_dump_dest='\/opt\/ora10g\/product\/ora10gr2\/bdump'\r\n*.compatible='10.2.0.1.0'\r\n*.control_files='\/opt\/ora10g\/product\/ora10gr2\/control01.ctl','\/opt\/ora10g\/product\/ora10gr2\/control02.ctl','\/opt\/ora10g\/product\/ora10gr2\/control03.ctl'\r\n*.core_dump_dest='\/opt\/ora10g\/product\/ora10gr2\/cdump'\r\n*.db_block_size=8192\r\n*.db_domain=''\r\n*.db_file_multiblock_read_count=16\r\n*.db_name='ora10gr2'\r\n*.dispatchers='(PROTOCOL=TCP) (SERVICE=ora10gr2XDB)'\r\n*.job_queue_processes=10\r\n*.log_archive_dest='\/opt\/ora10g\/product\/ora10gr2\/archivelog'\r\n*.nls_language='SIMPLIFIED CHINESE'\r\n*.nls_territory='CHINA'\r\n*.open_cursors=300\r\n*.pga_aggregate_target=203423744\r\n*.processes=150\r\n*.remote_login_passwordfile='EXCLUSIVE'\r\n*.sga_target=612368384\r\n*.undo_management='AUTO'\r\n*.undo_tablespace='UNDOTBS1'\r\n*.user_dump_dest='\/opt\/ora10g\/product\/ora10gr2\/udump'\r\n<\/pre>\n\u4f7f\u7528\u65b0\u6784\u9020\u7684pfile\u5c06\u5e93nomount<\/p>\n
\r\n[oracle@rhl6 ora10gr2]$ export ORACLE_SID=ora10gr2\r\n[oracle@rhl6 ora10gr2]$ sqlplus "\/as sysdba"\r\n\r\nSQL*Plus: Release 10.2.0.1.0 - Production on Fri Jan 25 21:28:04 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 nomount pfile='\/opt\/ora10g\/product\/ora10gr2\/pfile.txt';\r\nORA-27125: unable to create shared memory segment\r\nLinux-x86_64 Error: 1: Operation not permitted\r\nSQL> exit\r\n[root@rhl6 ~]# echo 501 > \/proc\/sys\/vm\/hugetlb_shm_group\r\n[oracle@rhl6 ora10gr2]$ export ORACLE_SID=ora10gr2\r\n[oracle@rhl6 ora10gr2]$ sqlplus "\/as sysdba"\r\n\r\nSQL*Plus: Release 10.2.0.1.0 - Production on Fri Jan 25 21:30:31 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 nomount pfile='\/opt\/ora10g\/product\/ora10gr2\/pfile.txt';\r\nORACLE instance started.\r\n\r\nTotal System Global Area 612368384 bytes\r\nFixed Size 2022728 bytes\r\nVariable Size 176161464 bytes\r\nDatabase Buffers 432013312 bytes\r\nRedo Buffers 2170880 bytes\r\nSQL> \r\n\r\n<\/pre>\n\u4ece\u5907\u4efd\u6062\u590d\u63a7\u5236\u6587\u4ef6
\n[oracle@rhl6 ora10g]$ export ORACLE_SID=ora10gr2<\/p>\n\r\n[oracle@rhl6 ora10g]$ rman target \/\r\n\r\nRecovery Manager: Release 10.2.0.1.0 - Production on Fri Jan 25 21:31:58 2013\r\n\r\nCopyright (c) 1982, 2005, Oracle. All rights reserved.\r\n\r\nconnected to target database: ora10gr2 (not mounted)\r\n\r\nRMAN> restore controlfile to '\/opt\/ora10g\/product\/ora10gr2\/control01.ctl' from '\/opt\/ora10g\/product\/ora10gr2\/backup\/DB_CTL_20130125_805645580_17_1.BAK';\r\n\r\nStarting restore at 25-JAN-13\r\nusing target database control file instead of recovery catalog\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: sid=155 devtype=DISK\r\n\r\nchannel ORA_DISK_1: restoring control file\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:03\r\nFinished restore at 25-JAN-13\r\n\r\nRMAN> \r\n\r\n<\/pre>\n\u5728\u65b0\u5730\u5740\u590d\u7528\u63a7\u5236\u6587\u4ef6<\/p>\n
\r\n[oracle@rhl6 ~]$ cd \/opt\/ora10g\/product\/ora10gr2\/\r\n[oracle@rhl6 ora10gr2]$ ls -l\r\ntotal 6924\r\ndrwxr-xr-x. 2 oracle oinstall 4096 Jan 25 21:32 adump\r\ndrwxr-xr-x. 2 oracle oinstall 4096 Jan 25 21:23 archivelog\r\ndrwxr-xr-x. 2 oracle oinstall 4096 Jan 25 21:24 backup\r\ndrwxr-xr-x. 2 oracle oinstall 4096 Jan 25 21:28 bdump\r\ndrwxr-xr-x. 2 oracle oinstall 4096 Jan 25 21:22 cdump\r\n-rw-r-----. 1 oracle oinstall 7061504 Jan 25 21:33 control01.ctl\r\n-rw-r--r--. 1 oracle oinstall 1049 Jan 25 21:26 pfile.txt\r\ndrwxr-xr-x. 2 oracle oinstall 4096 Jan 25 21:30 udump\r\n[oracle@rhl6 ora10gr2]$ cp control01.ctl control02.ctl \r\n[oracle@rhl6 ora10gr2]$ cp control01.ctl control03.ctl \r\n<\/pre>\n\u4f7f\u7528\u65b0\u7684pfile\u521b\u5efaspfile\u5c06\u6570\u636e\u5e93\u542f\u52a8\u81f3mount\u4e0b<\/p>\n
\r\nSQL> create spfile from pfile='\/opt\/ora10g\/product\/ora10gr2\/pfile.txt';\r\n\r\nFile created.\r\n\r\nSQL> shutdown immediate;\r\nORA-01507: database not mounted\r\n\r\n\r\nORACLE instance shut down.\r\nSQL> startup mount\r\nORACLE instance started.\r\n\r\nTotal System Global Area 612368384 bytes\r\nFixed Size 2022728 bytes\r\nVariable Size 176161464 bytes\r\nDatabase Buffers 432013312 bytes\r\nRedo Buffers 2170880 bytes\r\nDatabase mounted.\r\nSQL> \r\n\r\n<\/pre>\n\u5728rman\u7684run\u5757\u4e2d\u66f4\u65b0\u63a7\u5236\u6587\u4ef6\u4e2d\u5907\u4efd\u6240\u5728\u5730\u7684\u4fe1\u606f\u6307\u5411\u65b0\u7684\u5907\u4efd\u6240\u5728\u5730<\/p>\n
\r\n[oracle@rhl6 ora10g]$ export ORACLE_SID=ora10gr2\r\n[oracle@rhl6 ora10g]$ rman target \/\r\n\r\nRecovery Manager: Release 10.2.0.1.0 - Production on Fri Jan 25 21:36:33 2013\r\n\r\nCopyright (c) 1982, 2005, Oracle. All rights reserved.\r\n\r\nconnected to target database: ORA10GR2 (DBID=4105654577, not open)\r\n\r\nRMAN> catalog start with '\/opt\/ora10g\/product\/ora10gr2\/backup\/';\r\n\r\nusing target database control file instead of recovery catalog\r\nsearching for all files that match the pattern \/opt\/ora10g\/product\/ora10gr2\/backup\/\r\n\r\nList of Files Unknown to the Database\r\n=====================================\r\nFile Name: \/opt\/ora10g\/product\/ora10gr2\/backup\/ARCH_0GO0AB8A_16_1.ARCH\r\nFile Name: \/opt\/ora10g\/product\/ora10gr2\/backup\/DB_SPFILE_20130125_805645585_18_1.BAK\r\nFile Name: \/opt\/ora10g\/product\/ora10gr2\/backup\/FULL_DB_BACKUP_ORA10GR2_20130125_0DO0AB7Q_1_1.BAK\r\nFile Name: \/opt\/ora10g\/product\/ora10gr2\/backup\/FULL_DB_BACKUP_ORA10GR2_20130125_0EO0AB86_1_1.BAK\r\nFile Name: \/opt\/ora10g\/product\/ora10gr2\/backup\/FULL_DB_BACKUP_ORA10GR2_20130125_0CO0AB5M_1_1.BAK\r\nFile Name: \/opt\/ora10g\/product\/ora10gr2\/backup\/rman_full.log\r\nFile Name: \/opt\/ora10g\/product\/ora10gr2\/backup\/FULL_DB_BACKUP_ORA10GR2_20130125_0BO0AB5M_1_1.BAK\r\nFile Name: \/opt\/ora10g\/product\/ora10gr2\/backup\/DB_CTL_20130125_805645580_17_1.BAK\r\nFile Name: \/opt\/ora10g\/product\/ora10gr2\/backup\/ARCH_0FO0AB8A_15_1.ARCH\r\n\r\nDo you really want to catalog the above files (enter YES or NO)? yes\r\ncataloging files...\r\ncataloging done\r\n\r\nList of Cataloged Files\r\n=======================\r\nFile Name: \/opt\/ora10g\/product\/ora10gr2\/backup\/ARCH_0GO0AB8A_16_1.ARCH\r\nFile Name: \/opt\/ora10g\/product\/ora10gr2\/backup\/DB_SPFILE_20130125_805645585_18_1.BAK\r\nFile Name: \/opt\/ora10g\/product\/ora10gr2\/backup\/FULL_DB_BACKUP_ORA10GR2_20130125_0DO0AB7Q_1_1.BAK\r\nFile Name: \/opt\/ora10g\/product\/ora10gr2\/backup\/FULL_DB_BACKUP_ORA10GR2_20130125_0EO0AB86_1_1.BAK\r\nFile Name: \/opt\/ora10g\/product\/ora10gr2\/backup\/FULL_DB_BACKUP_ORA10GR2_20130125_0CO0AB5M_1_1.BAK\r\nFile Name: \/opt\/ora10g\/product\/ora10gr2\/backup\/FULL_DB_BACKUP_ORA10GR2_20130125_0BO0AB5M_1_1.BAK\r\nFile Name: \/opt\/ora10g\/product\/ora10gr2\/backup\/DB_CTL_20130125_805645580_17_1.BAK\r\nFile Name: \/opt\/ora10g\/product\/ora10gr2\/backup\/ARCH_0FO0AB8A_15_1.ARCH\r\n\r\nList of Files Which Where Not Cataloged\r\n=======================================\r\nFile Name: \/opt\/ora10g\/product\/ora10gr2\/backup\/rman_full.log\r\n RMAN-07517: Reason: The file header is corrupted\r\n<\/pre>\n\u6b64\u5904\u662frman\u5907\u4efd\u7684log\u65e5\u5fd7\u4e0d\u53ef\u7528\u6765\u505a\u5907\u4efd\u7247\uff0c\u6240\u4ee5\u62a5\u9519\u3002<\/p>\n
\u5c06\u6570\u636e\u5e93restore\u5e76\u505arecover<\/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 '\/opt\/ora10g\/product\/ora10gr2\/SYSTEM01.DBF';\r\n5> set newname for datafile 4 to '\/opt\/ora10g\/product\/ora10gr2\/USERS01.DBF';\r\n6> set newname for datafile 3 to '\/opt\/ora10g\/product\/ora10gr2\/SYSAUX01.DBF';\r\n7> set newname for datafile 2 to '\/opt\/ora10g\/product\/ora10gr2\/UNDOTBS01.DBF';\r\n8> restore database;\r\n9> switch datafile all;\r\n10> recover database;\r\n11> release channel dev1;\r\n12> release channel dev2;\r\n13> }\r\n\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\nStarting restore at 25-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 00002 to \/opt\/ora10g\/product\/ora10gr2\/UNDOTBS01.DBF\r\nrestoring datafile 00003 to \/opt\/ora10g\/product\/ora10gr2\/SYSAUX01.DBF\r\nchannel dev1: reading from backup piece C:\\ORACLE\\PRODUCT\\10.2.0\\BACKUP\\FULL_DB_BACKUP_ORA10GR2_20130125_0CO0AB5M_1_1.BAK\r\nchannel dev2: starting datafile backupset restore\r\nchannel dev2: specifying datafile(s) to restore from backup set\r\nrestoring datafile 00001 to \/opt\/ora10g\/product\/ora10gr2\/SYSTEM01.DBF\r\nrestoring datafile 00004 to \/opt\/ora10g\/product\/ora10gr2\/USERS01.DBF\r\nchannel dev2: reading from backup piece C:\\ORACLE\\PRODUCT\\10.2.0\\BACKUP\\FULL_DB_BACKUP_ORA10GR2_20130125_0BO0AB5M_1_1.BAK\r\nchannel dev1: restored backup piece 1\r\nfailover to piece handle=\/opt\/ora10g\/product\/ora10gr2\/backup\/FULL_DB_BACKUP_ORA10GR2_20130125_0CO0AB5M_1_1.BAK tag=FULL_BACKUP\r\nchannel dev1: restore complete, elapsed time: 00:01:11\r\nchannel dev2: restored backup piece 1\r\nfailover to piece handle=\/opt\/ora10g\/product\/ora10gr2\/backup\/FULL_DB_BACKUP_ORA10GR2_20130125_0BO0AB5M_1_1.BAK tag=FULL_BACKUP\r\nchannel dev2: restore complete, elapsed time: 00:01:28\r\nFinished restore at 25-JAN-13\r\n\r\ndatafile 1 switched to datafile copy\r\ninput datafile copy recid=5 stamp=805671684 filename=\/opt\/ora10g\/product\/ora10gr2\/SYSTEM01.DBF\r\ndatafile 4 switched to datafile copy\r\ninput datafile copy recid=6 stamp=805671684 filename=\/opt\/ora10g\/product\/ora10gr2\/USERS01.DBF\r\ndatafile 3 switched to datafile copy\r\ninput datafile copy recid=7 stamp=805671685 filename=\/opt\/ora10g\/product\/ora10gr2\/SYSAUX01.DBF\r\ndatafile 2 switched to datafile copy\r\ninput datafile copy recid=8 stamp=805671685 filename=\/opt\/ora10g\/product\/ora10gr2\/UNDOTBS01.DBF\r\n\r\nStarting recover at 25-JAN-13\r\n\r\nstarting media recovery\r\n\r\nchannel dev1: starting archive log restore to default destination\r\nchannel dev1: restoring archive log\r\narchive log thread=1 sequence=9\r\nchannel dev1: reading from backup piece C:\\ORACLE\\PRODUCT\\10.2.0\\BACKUP\\ARCH_0FO0AB8A_15_1.ARCH\r\nchannel dev2: starting archive log restore to default destination\r\nchannel dev2: restoring archive log\r\narchive log thread=1 sequence=10\r\nchannel dev2: reading from backup piece C:\\ORACLE\\PRODUCT\\10.2.0\\BACKUP\\ARCH_0GO0AB8A_16_1.ARCH\r\nchannel dev1: restored backup piece 1\r\nfailover to piece handle=\/opt\/ora10g\/product\/ora10gr2\/backup\/ARCH_0FO0AB8A_15_1.ARCH tag=TAG20130125T142617\r\nchannel dev1: restore complete, elapsed time: 00:00:01\r\narchive log filename=\/opt\/ora10g\/product\/ora10gr2\/archivelog\/1_9_803427765.dbf thread=1 sequence=9\r\nchannel dev2: restored backup piece 1\r\nfailover to piece handle=\/opt\/ora10g\/product\/ora10gr2\/backup\/ARCH_0GO0AB8A_16_1.ARCH tag=TAG20130125T142617\r\nchannel dev2: restore complete, elapsed time: 00:00:01\r\narchive log filename=\/opt\/ora10g\/product\/ora10gr2\/archivelog\/1_10_803427765.dbf thread=1 sequence=10\r\nunable to find archive log\r\narchive log thread=1 sequence=11\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\/25\/2013 21:41:30\r\nRMAN-06054: media recovery requesting unknown log: thread 1 seq 11 lowscn 577972\r\n<\/pre>\n\u6b64\u5904\u53d1\u73b0recover\u7684\u65f6\u5019\u7f3a\u5c11\u65e5\u5fd7\uff0c\u5982\u679c\u6211\u4eec\u628a\u6e90\u5e93\u7684\u6240\u6709\u81ea\u4ecefull backup\u4e00\u6765\u7684\u5f52\u6863\u548c\u8054\u673a\u65e5\u5fd7\u5168\u90e8\u62f7\u5230\u76ee\u6807\u5e93\uff0c\u8fd9\u6837\u5c31\u80fd\u591f\u548c\u6e90\u5e93\u4fdd\u6301\u4e00\u81f4\u4e86\uff0c\u4f46\u662f\u7531\u4e8e\u6e90\u5e93\u59cb\u7ec8\u662f\u5728\u8fd0\u884c\u7684\uff0c\u6240\u6709\u76ee\u6807\u5e93\u80af\u5b9a\u65e0\u6cd5\u548c\u6e90\u5e93\u4fdd\u6301\u4e00\u81f4\uff0c\u5e76\u5b8c\u6210\u5b8c\u5168\u6062\u590d\u3002\u6240\u4ee5\uff0c\u8fd9\u91cc\u53ea\u80fd\u8fdb\u884c\u4e0d\u5b8c\u5168\u6062\u590d\u3002<\/p>\n
\r\nSQL> recover database using backup controlfile until cancel;\r\nORA-00279: change 577972 generated at 01\/25\/2013 14:26:16 needed for thread 1\r\nORA-00289: suggestion :\r\n\/opt\/ora10g\/product\/ora10gr2\/archivelog\/1_11_803427765.dbf\r\nORA-00280: change 577972 for thread 1 is in sequence #11\r\n\r\n\r\nSpecify log: {<RET>=suggested | filename | AUTO | CANCEL}\r\n\r\nORA-00308: cannot open archived log\r\n'\/opt\/ora10g\/product\/ora10gr2\/archivelog\/1_11_803427765.dbf'\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\r\n\r\nSQL> alter database open resetlogs;\r\n\r\nDatabase altered.\r\n\r\n<\/pre>\n\u68c0\u67e5\u6d4b\u8bd5\u6570\u636e<\/p>\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 test;\r\n\r\n ID NAME MYTIME\r\n---------- -------------------- -------------------\r\n 1 yallonking 2013\/01\/22 22:00:35\r\n 2 YALLONKING 2013\/01\/25 14:10:10\r\n<\/pre>\n\u6ce8\u610f\uff1a\u6b64\u5904\u76842\u6761\u6570\u636e\u90fd\u5728\uff0c\u8bf4\u660e\u4e4b\u524d\u867d\u7136\u662f\u4e0d\u5b8c\u5168\u6062\u590d\uff0c\u4f46\u662f\u7531\u4e8e\u6e90\u5e93\u4e0d\u662f\u5f88\u7e41\u5fd9\uff0c\u4e14\u8fc1\u79fb\u4e4b\u524d\u505a\u4e86\u65e5\u5fd7\u5207\u6362\u4ee5\u53ca\u89e6\u53d1\u68c0\u67e5\u70b9\u548c\u5f52\u6863\u4e86\u672a\u5f52\u6863\u7684\u65e5\u5fd7\uff0c\u6240\u4ee5\uff0c\u5373\u4f7f\u662f\u540e\u6765\u6dfb\u52a0\u4e0a\u53bb\u7684\u7b2c\u4e8c\u6761\u8bb0\u5f55\u5728\u8fc1\u79fb\u4e4b\u524d\u5df2\u7ecf\u5199\u5165\u5230\u5f52\u6863\u65e5\u5fd7\u6216\u8005\u6570\u636e\u6587\u4ef6\u4e2d\u4e86\uff0c\u800c\u4e0d\u662f\u5728\u8054\u673a\u65e5\u5fd7\u4e2d\u4f7f\u5176\u5728\u8fc1\u79fb\u8fc7\u7a0b\u4e2d\u4e22\u5931\u3002<\/p>\n
\u5c0f\u7ed3\uff1a\u8fd9\u4e2a\u6848\u4f8b\u8bf4\u660e\uff0c\u4ee5\u540e\u4e5f\u53ef\u8fd9\u6837\u8fdb\u884c\u8de8\u5e73\u53f0\u8de8\u64cd\u4f5c\u7cfb\u7edf\u4f4d\u6570\u7684\u6570\u636e\u5e93\u8fc1\u79fb\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
RMAN\u6570\u636e\u5e93\u8fc1\u79fb\uff08\u8de8\u5e73\u53f0\u8de8\u64cd\u4f5c\u7cfb\u7edf\u4f4d\u6570\uff09 \u573a\u666f\u8bf4\u660e\uff1a\u5c06oracle10gr2\u7684\u6570\u636e\u5e93\u4ecewin\u5e73\u53f032\u4f4d\uff08\u8fd0\u884c […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[40],"tags":[95,96,100,93,102,103,104,98,94,99,71,83,84,101,97],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/676"}],"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=676"}],"version-history":[{"count":2,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/676\/revisions"}],"predecessor-version":[{"id":689,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/676\/revisions\/689"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=676"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=676"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=676"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}