{"id":230,"date":"2014-11-09T14:27:45","date_gmt":"2014-11-09T06:27:45","guid":{"rendered":"http:\/\/blog.cyszys.com\/?p=230"},"modified":"2024-06-05T10:21:31","modified_gmt":"2024-06-05T02:21:31","slug":"catalog%e5%92%8cnocatalog%e4%b8%a4%e7%a7%8d%e5%a4%87%e4%bb%bd%e6%96%b9%e6%a1%88%e7%9a%84%e5%8c%ba%e5%88%ab","status":"publish","type":"post","link":"http:\/\/blog.cyszys.com\/?p=230","title":{"rendered":"\u5bf9\u6bd4catalog\u548cnocatalog\u4e24\u79cdOracle\u5907\u4efd\u65b9\u6848\u7684\u533a\u522b"},"content":{"rendered":"

\u4e00\uff0e<\/b><\/span>\nNocatalog<\/b><\/span><\/p>\n

N<\/span>ocatalog<\/span>\u65b9\u5f0f\u00a0<\/span>\u5c31\u662f\u7528control\u00a0file<\/span>\u4f5c\u4e3acatalog<\/span>\uff0c\u6bcf\u4e00\u6b21\u5907\u4efd\u90fd\u8981\u5f80\u63a7\u5236\u6587\u4ef6\u91cc\u9762\u5199\u597d\u591a\u5907\u4efd\u4fe1\u606f\uff0c\u63a7\u5236\u6587\u4ef6\u91cc\u9762\u4f1a\u6709\u8d8a\u6765\u8d8a\u591a\u7684\u5907\u4efd\u4fe1\u606f\u3002\u56e0\u6b64\uff0c\u5f53\u4f7f\u7528rman\u00a0nocatalog<\/span>\u65b9\u5f0f\u5907\u4efd\u65f6\uff0c\u5907\u4efdcontrolfile<\/span>\u662f\u975e\u5e38\u91cd\u8981\u7684\u3002<\/p>\n

\u7531\u4e8e<\/span>nocatalog\u65f6\u5229\u7528<\/span>controlfile\u5b58\u653e\u5907\u4efd\u4fe1\u606f\uff0c\u5efa\u8bae\u5c06<\/span>Oracle\u53c2\u6570\u6587\u4ef6\u4e2d\u7684<\/span>CONTROL_FILE_RECORD_KEEP_TIME\u503c\u52a0\u5927\uff08\u7f3a\u7701\u4e3a<\/span>7\u5929\uff09<\/span>,\u00a0\u53c2\u6570\u5728<\/span>$ORACLE_HOME\/dbs\/initSID.ora\u4e2d\uff0c\u8be5\u53c2\u6570<\/span>control_file__record_keep_time\u8bbe\u7f6e\u5907\u4efd\u4fe1\u606f\u4fdd\u5b58\u65f6\u95f4\uff0c\u5230\u89c4\u5b9a\u65f6\u95f4\u5c31\u81ea\u52a8\u6e05\u9664\u4ee5\u524d\u7684\u5907\u4efd\u4fe1\u606f\u3002<\/span><\/p>\n

SQL>\u00a0show\u00a0parameter\u00a0control\nNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VALUE\n------------------------------------\u00a0-----------\u00a0------------------------------\ncontrol_file_record_keep_time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0integer\u00a0\u00a0\u00a0\u00a0\u00a07\ncontrol_files\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0string\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0D:\/APP\/ADMINISTRATOR\/ORADATA\/O\ncontrol_management_pack_access\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0string\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0DIAGNOSTIC+TUNING\nSQL>\u00a0alter\u00a0system\u00a0set\u00a0control_file_record_keep_time=14\u00a0scope=both;\n\u7cfb\u7edf\u5df2\u66f4\u6539\u3002\nSQL>\u00a0select\u00a0name,value,issys_modifiable\u00a0from\u00a0v$parameter\u00a0where\u00a0name='control_file_record_keep_time';\nNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VALUE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0ISSYS_MOD\n---------------\u00a0----------\u00a0---------\ncontrol_file_re\u00a0\u00a0\u00a014\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0IMMEDIATE<\/pre>\n
\u4e8c\uff0e<\/span>Catalog<\/strong><\/span><\/p>\n
Catalog<\/span>\u00a0<\/span>\u5219\u5fc5\u987b\u8981\u9996\u5148\u8981\u521b\u5efa\u76ee\u5f55\u5907\u4efd\u6570\u636e\u5e93\uff0c\u5efa\u7acb\u6062\u590d\u76ee\u5f55\u3002\u793a\u4f8b\u5982\u4e0b\uff1a<\/p>\n
1.\u521b\u5efa<\/span>Catalog\u6240\u9700\u8981\u7684\u8868\u7a7a\u95f4<\/span><\/p>\n
SQL>create\u00a0tablespace\u00a0rman_ts \u00a0datafile\u00a0'\/u01\/oracle\/oradata\/ora10g\/rmants.dbf'\u00a0\u00a0size 20M;<\/p>\n
2.<\/span>\u521b\u5efaRMAN<\/span>\u7528\u6237\u5e76\u6388\u6743<\/p>\n
SQL>create\u00a0user\u00a0rman\u00a0identified\u00a0by\u00a0rman\u00a0default\u00a0tablespace\u00a0rman_ts\u00a0quota\u00a0unlimited\u00a0on\u00a0rman_ts;<\/p>\n
SQL>grant\u00a0recovery_catalog_owner\u00a0to\u00a0rman;(grant\u00a0connect\u00a0to\u00a0rman)<\/p>\n
\u67e5\u770b\u89d2\u8272\u6240\u62e5\u6709\u7684\u6743\u9650<\/span>:\u00a0select\u00a0*\u00a0from\u00a0dba_sys_privs\u00a0where\u00a0grantee='RECOVERY_CATALOG_OWNER';<\/p>\n
(RECOVER_CATALOG_OWNER,CONNECT,RESOURCE)<\/p>\n
3.<\/span>\u521b\u5efa\u6062\u590d\u76ee\u5f55<\/p>\n
oracle>rman\u00a0catalog\u00a0rman\/rman<\/p>\n
RMAN>create\u00a0catalog\u00a0tablespace\u00a0rman_ts;<\/p>\n
RMAN>register\u00a0database;(database\u662f<\/span>target\u00a0database)<\/p>\n
database\u00a0registered\u00a0in\u00a0recovery\u00a0catalog<\/p>\n
starting\u00a0full\u00a0resync\u00a0of\u00a0recovery\u00a0catalog<\/p>\n
full\u00a0resync\u00a0complete<\/p>\n
RMAN>\u00a0connect\u00a0target\u00a0\/;<\/p>\n
\u4ee5\u540e\u8981\u4f7f\u7528\u5907\u4efd\u548c\u6062\u590d\uff0c\u9700\u8981\u8fde\u63a5\u5230\u4e24\u4e2a\u6570\u636e\u5e93\u4e2d,<\/span>\u547d\u4ee4:<\/span><\/p>\n
oracle>rman\u00a0target\u00a0\/\u00a0catalog\u00a0rman\/rman\u00a0(\u7b2c\u4e00\u659c\u6760\u8868\u793a<\/span>target\u6570\u636e\u5e93\uff0c<\/span>catalog\u8868\u793a<\/span>catalog\u76ee\u5f55<\/span>\u00a0<\/span>rman\/rman\u8868\u793a<\/span>catalog\u7528\u6237\u540d\u548c\u5bc6\u7801<\/span>)<\/p>\n
\u547d\u4ee4\u6267\u884c\u540e\u663e\u793a\uff1a<\/p>\n
Recovery\u00a0Manager:\u00a0Release\u00a010.2.0.1.0\u00a0-\u00a0Production\u00a0on\u00a0Wed\u00a0Dec\u00a010\u00a015:00:42\u00a02008<\/p>\n
Copyright\u00a0(c)\u00a01982,\u00a02005,\u00a0Oracle.\u00a0\u00a0All\u00a0rights\u00a0reserved.<\/p>\n
connected\u00a0to\u00a0target\u00a0database:\u00a0ORA10G\u00a0(DBID=3988862108)<\/p>\n
connected\u00a0to\u00a0recovery\u00a0catalog\u00a0database<\/p>\n
\u547d\u4ee4\u89e3\u91ca:<\/span><\/p>\n
Report\u00a0schema\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Report\u00a0shema\u662f\u6307\u5728\u6570\u636e\u5e93\u4e2d\u9700\u627e<\/span>schema<\/p>\n
List\u00a0backup\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u4ece<\/span>control\u8bfb\u53d6\u4fe1\u606f<\/span><\/p>\n
Crosscheck\u00a0backup\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u770b\u4e00\u4e0b<\/span>backup\u7684\u6587\u4ef6\uff0c\u68c0\u67e5<\/span>controlfile\u4e2d\u7684\u76ee\u5f55\u6216\u6587\u4ef6\u662f\u5426\u771f\u6b63\u5728\u78c1\u76d8\u4e0a<\/span><\/p>\n
Delete\u00a0backupset\u00a024\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a024\u4ee3\u8868<\/span>backupset\u00a0\u7684\u7f16\u53f7<\/span>,\u00a0\u65e2<\/span>delete\u76ee\u5f55\uff0c\u4e5f<\/span>delete\u4f60\u7684\u6587\u4ef6\u3002<\/span><\/p>\n
 <\/p>\n
\u4e0b\u9762\u5bf9\u6bd4\u4e00\u4e0brman nocatalog\u548crman catalog\u7684\u6062\u590d\u65f6\u7684\u6b65\u9aa4\uff0c\u4ee5\u4fbf\u5efa\u7acb\u6b63\u786e\u7684\u5907\u4efd\u7b56\u7565\uff08\u4ee5\u4e0b\u7684\u6062\u590d\u90fd\u662f\u5728online\u72b6\u6001\u4e0b\u7684\u5907\u4efd\uff09\uff1a<\/p>\n
 <\/p>\n
rman nocatalog\u6062\u590d\uff1a<\/span><\/p>\n
1) \u5efa\u7acboracle\u8fd0\u884c\u73af\u5883\uff08\u5305\u62ecinit\u6216sp\u6587\u4ef6\uff09<\/p>\n
2) \u6587\u4ef6\u65b9\u5f0f\u6062\u590dcontrolfile\u5230init\u6587\u4ef6\u6307\u5b9a\u7684\u4f4d\u7f6e<\/p>\n
3) startup mount<\/p>\n
4) rman\uff0c\u6062\u590ddatafile<\/p>\n
5) alter database open resetlogs<\/p>\n
 <\/p>\n
rman catalog\u6062\u590d\uff1a<\/span><\/p>\n
1) \u5efa\u7acboracle\u8fd0\u884c\u73af\u5883\uff08\u5305\u62ecinit\u6216sp\u6587\u4ef6\uff09<\/p>\n
2) rman \uff0crestore controfile<\/p>\n
3) alter database mount<\/p>\n
4) rman, restore datafile<\/p>\n
5) alter database open resetlogs<\/p>\n
\u53ef\u4ee5\u770b\u51fa\uff0crman nocatalog\u5907\u4efd\u65f6\uff0c\u5fc5\u987b\u7528\u6587\u4ef6\u65b9\u5f0f\u5907\u4efdcontrolfile\u3002<\/p>\n
\u53e6\u5916\uff0c\u7531\u4e8enocatalog\u65f6\u5229\u7528controlfile\u5b58\u653e\u5907\u4efd\u4fe1\u606f\uff0c\u5efa\u8bae\u5c06Oracle\u53c2\u6570\u6587\u4ef6\u4e2d\u7684CONTROL_FILE_RECORD_KEEP_TIME\u503c\u52a0\u5927\uff08\u7f3a\u7701\u4e3a7\u5929\uff09, \u8be5\u53c2\u6570\u5728$ORACLE_HOME\/dbs\/initSID.ora\u4e2d\uff089i\u540e\u4e5f\u53ef\u80fd\u5728spfile\u4e2d\uff0c\u53ea\u80fd\u901a\u8fc7Oracle\u8bed\u53e5\u66f4\u6539\uff09\u3002<\/p>","protected":false},"excerpt":{"rendered":"
\u4e00\uff0e Nocatalog Nocatalog\u65b9\u5f0f\u00a0\u5c31\u662f\u7528control\u00a0file\u4f5c\u4e3acatalog\uff0c\u6bcf\u4e00\u6b21\u5907\u4efd […]<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=\/wp\/v2\/posts\/230"}],"collection":[{"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=230"}],"version-history":[{"count":6,"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=\/wp\/v2\/posts\/230\/revisions"}],"predecessor-version":[{"id":507,"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=\/wp\/v2\/posts\/230\/revisions\/507"}],"wp:attachment":[{"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=230"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=230"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=230"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}