北京网站建设 公司,北太平庄网站建设,html5教程 pdf,wordpress 示例原创作品#xff0c;允许转载#xff0c;转载时请务必以超链接形式标明文章 原始出处 、作者信息和本声明。否则将追究法律责任。http://407882.blog.51cto.com/397882/212142 我想建立一个RMAN备份机制#xff0c;本机为目标数据库#xff0c;sid为orcl10的数据库为恢复目… 原创作品允许转载转载时请务必以超链接形式标明文章 原始出处 、作者信息和本声明。否则将追究法律责任。http://407882.blog.51cto.com/397882/212142 我想建立一个RMAN备份机制本机为目标数据库sid为orcl10的数据库为恢复目录来做备份但总不成功以下是我的执行步骤 SQL conn sys/e2000jlorcl10 as sysdbaConnected.SQL create user rman2 identified by rman123; User created. SQL grant dba to rman; Grant succeeded. C:\Documents and Settings\zouyangrman target sys/system catalog rman/rman123orcl10 Recovery Manager: Release 10.1.0.2.0 - Production Copyright (c) 1995, 2004, Oracle. All rights reserved. connected to target database: ORCL (DBID1227672490)connected to recovery catalog databaserecovery catalog is not installed RMAN show channel for device type disk; recovery catalog is not installedrecovery catalog is not installedRMAN-00571: RMAN-00569: ERROR MESSAGE STACK FOLLOWS RMAN-00571: RMAN-03002: failure of show command at 10/14/2009 09:30:02RMAN-06429: RCVCAT database is not compatible with this version of RMAN RMAN 可以连接上恢复目录数据库但是无法使用这个恢复目录Oracle报错“recovery catalog is not installed”。 在网上搜了下重新建立步骤如下 第一步Create Recovery Catalog First create a user to hold the recovery catalog: -- Create tablepsace to hold repository SQL create tablespace rman_tools2 datafile 3 D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL10\rman01.dbf 4 size 100m; Tablespace created -- Create rman schema owner SQL create user rman2 identified by rman1233 default tablespace rman_tools4 quota unlimited on rman_tools; User created C:\Documents and Settings\zouyangrman catalog rman/rman123orcl10 Recovery Manager: Release 10.1.0.2.0 - Production Copyright (c) 1995, 2004, Oracle. All rights reserved. RMAN-00571: RMAN-00569: ERROR MESSAGE STACK FOLLOWS RMAN-00571: RMAN-00554: initialization of internal recovery manager package failedRMAN-04004: error from recovery catalog database: ORA-01045: user RMAN lacks CREATE SESSION privilege; logon denied -- 报错要给rman用户分配一定的权限 SQL grant connect,resource,create session,recovery_catalog_owner2 to rman; Grant succeeded C:\Documents and Settings\zouyangrman catalog rman/rman123orcl10 Recovery Manager: Release 10.1.0.2.0 - Production Copyright (c) 1995, 2004, Oracle. All rights reserved. connected to recovery catalog databaserecovery catalog is not installed RMAN create catalog tablespace rman_tools; recovery catalog created ——很好建立了 可是当我重新连接显示RMAN设置信息时又报错了 C:\Documents and Settings\zouyangrman target sys/system catalog rman/rman123orcl10 Recovery Manager: Release 10.1.0.2.0 - Production Copyright (c) 1995, 2004, Oracle. All rights reserved. connected to target database: ORCL (DBID1227672490)connected to recovery catalog database RMAN show channel for device type disk; RMAN configuration parameters are:RMAN-00571: RMAN-00569: ERROR MESSAGE STACK FOLLOWS RMAN-00571: RMAN-03002: failure of show command at 10/14/2009 10:32:36RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog RMAN 又在网上查找原因原来还需要注册数据库 第二步Register Database Each database to be backed up by RMAN must be registeredRMAN register database; database registered in recovery catalogstarting full resync of recovery catalogfull resync complete RMAN show channel for device type disk; RMAN configuration parameters are:CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT D:\BACKUP\RMAN\%d_%s.bak; RMAN 成功啦 转载于:https://www.cnblogs.com/weixun/archive/2013/06/13/3134731.html
