本文主要是介绍rman catalog database 使用,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
1、DBCA创建数据库
2、配置监听文件listener.ora(服务器端创建)
3、配置远程连接字符串tnames.ora(客户端创建)
4、在数据库中创建表空间
create tablespace rmanca datafile '/u01/app/oracle/oradata/orclca/rmanca.dbf' size 10M;
5、创建用户并制定用户权限
create user rcuser identified by rcuser default tablespace rmanca temporary tablespace temp;
grant connect,resource,recovery_catalog_owner to rcuser;
6、创建catalog
[oracle@oracle-one admin]$ rman catalog rcuser/rcuser
Recovery Manager: Release 11.2.0.4.0 - Production on Sat Mar 30 18:15:23 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> create catalog tablespace rmanca;
recovery catalog created
7、rman同时连接两个库,注册目标数据库
rman target sys/ziqiyuan catalog rcuser/rcuser@orclca
[oracle@
这篇关于rman catalog database 使用的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!