recovery catalog

最新推荐文章于 2024-07-27 15:45:10 发布

weixin_34351321

最新推荐文章于 2024-07-27 15:45:10 发布

阅读量98

点赞数

文章标签：数据库网络 python

原文链接：https://my.oschina.net/u/1013648/blog/272287

版权

2019独角兽企业重金招聘Python工程师标准>>>

恢复编录

以下是在恢复编录数据库上做的

首先创建表空间

create tablespace rc_tbs datafile ‘/u01/Identify/database/oradata/rc_data.dbf’
size 200m autoextend on next 10m;

再创建用户

create user rcowner identified by oracle
temporary tablespace temp default tablespace rc_tbs quota unlimited on rc_tbs;

给用户权限

grant recovery_catalog_owner to rcowner;

找到你的tnsname.ora文件位置

我在这列出我的位置/u01/app/oracle/product/11.2.0/db_1/network/admin

more tnsmane.ora

这是我的tnsname.ora文件中内容

BUSDEV =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = BUS-DB-scan)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = busdev)

)

)

cat /etc/hosts ##查看hosts文件中内容

#public IP

10.8.234.35 YKT-DB-SRV3

10.8.234.36 YKT-DB-SRV4

#VIP

10.8.234.37 YKT-DB-SRV3-vip

10.8.234.38 YKT-DB-SRV4-vip

#private IP

1.1.1.3 YKT-DB-SRV3-pvt

1.1.1.4 YKT-DB-SRV4-pvt

10.8.234.40 BUS-DB-scan

以下是在目的数据库上做的

接下来配置tnsname.ora

将上面的内容加入到目的数据库上的tnsname.ora文件中

注意：将(ADDRESS = (PROTOCOL = TCP)(HOST =
BUS-DB-scan)(PORT = 1521))这一行中的(HOST = BUS-DB-scan)中的BUS-DB-scan改为恢复数据库/etc/hosts文件中对应的IP地址
我的tnsname.ora修改之后是这样的
YKTDEV =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =
HSYKT_TEST_DEV_APP_03)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = yktdev)
    )
  )
BUSDEV =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.234.40)(PORT
= 1521))
    (CONNECT_DATA =
     (SERVER = DEDICATED)