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

 

 

 


 

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

win2008R2域环境配置用户主目录

目标 在文件服务器上为每个域用户建立一个以用户名命名的文件夹用来存储文件,并限定5GB的大小,限制存入音视频、exe等可执行文件。 1.为服务器添加文件服务器角色 选中文件服务器资源管理...
  • kepa520
  • kepa520
  • 2016年05月23日 22:45
  • 3814

Windows2008 R2上完全卸载Oracle操作步骤

Windows2008 R2上完全卸载Oracle操作步骤1.关闭Oracle所有的服务,按【win+R】运行【services.msc】找到所有Oracle开头的服务,点击停止。 2.使用Oracl...
  • xqf222
  • xqf222
  • 2015年10月23日 15:23
  • 4441

Oracle 11g安装到85%的时候就停止不动了

最近安装Oracle 11g R1时发现一个问题,每次程序安装到85%的时候就停止不动了,几次卸载再安装,结果都一样,安装过程就一直停留在总是在“配置oracle remote Configurati...
  • hj510337194
  • hj510337194
  • 2015年10月13日 15:58
  • 5103

ORACLE11G R2 RAC常用管理命令

1)、检查集群状态:    [grid@rac02 ~]$ crsctl check cluster    CRS-4537: Cluster Ready Services is online  ...
  • beaning_zhang
  • beaning_zhang
  • 2015年07月07日 13:43
  • 442

linux中配置oracle11g R2与tomcat先后启动

linux中配置oracle11g R2、tomcat在系统启动时,oracle先自动启动,tomcat后自动启动。...
  • zxnlmj
  • zxnlmj
  • 2014年04月07日 12:58
  • 1492

oracle11g r2 rac环境添加节点

oracle11g r2 rac环境添加节点 步骤: 1.安装操作系统,操作系统的版本要现在集群节点的版本一致 2.配置网络连接,存储网络连接 要保证网络连接正常设置相应的ip地址(包括设置私...
  • weiwangsisoftstone
  • weiwangsisoftstone
  • 2015年02月03日 15:52
  • 2230

ORACLE11g R2 DG FOR OEL7.1 安装实施

开启归档 shutdown immediate; startup mount; alter database archivelog;   二、开启强制logg...
  • Gjikcheng
  • Gjikcheng
  • 2015年12月10日 22:31
  • 531

使用Xmanager在CentOs5.5 安装oracle11g r2

先决条件:要有图形化界面,如果系统没有图形化界面,则进行安装图形化界面 1、yum grouplist   2、yum groupinstall "X Window System" ...
  • zhaohaifan
  • zhaohaifan
  • 2012年08月28日 08:57
  • 1064

自己动手 CentOS-6.5 安装Oracle11g R2

学习oracle,首先要有个环境,在自己机器上用虚拟机装了个CentOS版的linux,准备装Oracle,发现很多资料都缺点什么,设置内核参数及安装依赖包基本都有,其他的参数设置都不大一样,可能是安...
  • clyao_123456
  • clyao_123456
  • 2015年06月01日 22:10
  • 2583

CentOS6.5下Oracle11G-R2安装、卸载

CentOS6.5下Oracle11G-R2安装、卸载 资源下载地址(包括本人所有安装过程中,系统备份文件):http://download.csdn.net/detail/attagain/770...
  • AttaGain
  • AttaGain
  • 2014年08月01日 09:33
  • 13112
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:ORACLE11G R2创建回复目录
举报原因:
原因补充:

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