ORACLE11G R2创建回复目录

原创 2015年07月09日 11:03:03

环境为AIX+ORACLE11G R2 RAC

1.用SYSDBA权限连接到数据库,并在RMAN表空间中创建RMAN账号和回复目录:

 

[oracle@sfc3rc1:/]$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Jul 8 16:24:34 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

 

SQL> create tablespace rman;

Tablespace created.

SQL>  select file_name,tablespace_name from  dba_data_files;

FILE_NAME                                                                                                                                                                                                                                                                                                     TABLESPACE_NAME
--------------------------------------------------------------------------------------------------------                      --------------------------------------------------------------------------------------------------------                      ------------------------------------------------- ------------------------------
+DATA/askey/datafile/users.259.865164449                                                                                                                                                                                                                                                                      USERS
+DATA/askey/datafile/undotbs1.258.865164449                                                                                                                                                                                                                                                                   UNDOTBS1
+DATA/askey/datafile/sysaux.257.865164447                                                                                                                                                                                                                                                                     SYSAUX
+DATA/askey/datafile/system.256.865164447                                                                                                                                                                                                                                                                     SYSTEM
+DATA/askey/datafile/undotbs2.261.865164771                                                                                                                                                                                                                                                                   UNDOTBS2
+DATA/askey/datafile/mynew_tablespace.263.884530011                                                                                                                                                                                                                                                           MYNEW_TABLESPACE
+DATA/askey/datafile/rman.264.884537743                                                                                                                                                                                                                                                                       RMAN

7 rows selected.

SQL> grant recovery_catalog_owner to rman identified by oracle;

 

SQL> alter user rman default tablespace rman
  2  quota unlimited on rman;

 

 

2.在数据库中存在一个RMAN用户账号,因此启动RMAN,连接到目录,并使用create catalog命令来初始化存储库:

 

[oracle@sfc3rc1:/]$rman catalog rman/oracle@ASKEY

Recovery Manager: Release 11.2.0.4.0 - Production on Wed Jul 8 17:06:07 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to recovery catalog database

RMAN> create catalog

error creating db
ORACLE error from recovery catalog database: ORA-00955: name is already used by an existing object

ORACLE error from recovery catalog database: ORA-00942: table or view does not exist

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06433: error installing recovery catalog

这里创建catalog的时候出现上面的报错,catalog已经被创建过,清除后重新创建。

 

RMAN> drop catalog

recovery catalog dropped

 

RMAN> create catalog

recovery catalog created

 

3.对于每一个使用RMAN执行备份和回复的数据库,必须在RMAN存储库中对它们进行注册。该操作记录诸如目标数据库模式和数据库的唯一ID(DBID)等信息。只需注册目标数据库一次,随后连接到目标数据库的RMAN会话将自动引用存储库中的正确的元数据。

 

[oracle@sfc3rc1:/]$rman target / catalog rman@ASKEY

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Jul 9 09:32:07 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ASKEY (DBID=3715509859)
recovery catalog database Password:
connected to recovery catalog database

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

 

 

 


 

版权声明:本文为博主原创文章,未经博主允许不得转载。

相关文章推荐

Installing Oracle11g R2 RAC on RedHat Linux AS 5.5

目录 一.主机系统配置及软件规划 .....................................................................................

Centos6.4 x64安装64位oracle11g R2

安装步骤 1.1          安装前的准备工作 1.  从oracle官网上下载oracle11g R2 64位linux版本,我下载的版本是 linux.x64_11gR2_database...
  • wjdd1
  • wjdd1
  • 2013年10月29日 20:22
  • 958

CentOS 6.5 安装Oracle11g R2

分类: Oracle 学习oracle,首先要有个环境,在自己机器上用虚拟机装了个CentOS版的linux,准备装Oracle,发现很多资料都缺点什么,设置内核参数及安装依赖包基本都有,其...

CentOS 6.x 下安装oracle11g R2

oracle11g r2 在centos6.x下利用vnc安装
  • wlzjsj
  • wlzjsj
  • 2016年08月12日 15:36
  • 675

修改linux rac oracle11g r2 7个IP(public vip scan private)

前提说明:有些时候我们可能会将测试机投入到生产中,这就涉及到IP的切换,包括(public private vip scan ) 修改前:                            ...

linux下安装oracle11g R2

查看linux系统位数 file /sbin/init 或者 file /bin/ls [root@localhost proc]# file /sbin/init/sbin/init: ELF 3...

RedHat6.0,Oracle11g-R2,Pro*C配置开发图文详解

RedHat6.0,Oracle11g-R2,Pro*C配置开发详解   背景介绍,有项目功能需求是每分钟在局域网内ping 100个不同ip。每个ip绑定一个设备,ping通认为设备在线。将设备是...

IBM X3400服务器安装Linux操作系统和Oracle11G R2 64位数据库

随着软件技术日益发展,用户对于软件的安全性和准确性、稳定性、响应时间等等要求也越来越高。对于用户的的这种要求,当然这也是我们一直所追求的。软件运行是否稳定、数据是否准确、数据是否安全,这取决于软件本身...

linux64 rh7 下安装oracle11g(r2)

一、 VM10上安装Oracle11g 安装【[远程控制软件].NetSarang.Xmanager.Enterprise.v4.0.0179.Incl.Keymaker-CORE】下的【xme4...
  • FU250
  • FU250
  • 2015年11月12日 21:02
  • 1932

linux下安装oracle11G R2全过程整理

操作系统:CentOS release 6.4(x86_64bit) oracle安装所需包 搭建本地yum oracle 安装报错 can not procol specified exce...
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:ORACLE11G R2创建回复目录
举报原因:
原因补充:

(最多只允许输入30个字)