ORACL19C 为RMAN 创建 CATALOG DB

最新推荐文章于 2025-03-26 14:39:14 发布

liuxinglei13

最新推荐文章于 2025-03-26 14:39:14 发布

阅读量670

点赞数

文章标签： oracle 数据库 sql

本文链接：https://blog.youkuaiyun.com/liuxinglei13/article/details/125779471

版权

该文详述了如何创建RMAN恢复目录数据库，包括创建带有归档模式的CADB数据库、配置tnsnames.ora文件、创建恢复目录用户及表空间、赋予RECOVERY_CATALOG_OWNER角色、启用VPD模型以及使用RMAN注册目标数据库并验证过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

RMAN TARGET database name:dgurad , rman catalog DB name capdb1

capdb1 is a new pluggable database without anything setting,just new database created by CDBA or SQL command.

followings are Steps for create catalog for RMAN

1. Using CBDA, create a new DB cadb with pluggable database capdb1,database should be created with archive log mode, of course, you also can change it from no archivelog mode to archive mode later.catalog will be saved in the capdb1.

2. Adding tns acess string in the rman target db server and catalog db server

[oracle@dguard2 admin]$ pwd
/u01/app/oracle/product/19.3.0/dbhome_1/network/admin
[oracle@dguard2 admin]$ vi tnsnames.ora

cadb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.43.182)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cadb)
)
)
capdb1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.43.182)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = capdb1)
)
)

DGUARD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.43.92)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dguard)
)
)

3. On The Catalog db server, create Catalog user's tablespace and Catalog user

[oracle@dguard2 admin]$ sqlplus sys/password@capdb1 as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jul 14 11:19:49 2022
Version 19.3.0.0.0

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> desc dba_data_files;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_NAME VARCHAR2(513)
FILE_ID NUMBER
TABLESPACE_NAME VARCHAR2(30)
BYTES NUMBER
BLOCKS NUMBER
STATUS VARCHAR2(9)
RELATIVE_FNO NUMBER
AUTOEXTENSIBLE VARCHAR2(3)
MAXBYTES NUMBER
MAXBLOCKS NUMBER
INCREMENT_BY NUMBER
USER_BYTES NUMBER
USER_BLOCKS NUMBER
ONLINE_STATUS VARCHAR2(7)
LOST_WRITE_PROTECT VARCHAR2(7)

SQL> select file_name from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
/u01/app/oradata/CADB/E3BC1899CDDC1777E053B62BA8C0BD98/datafile/o1_mf_system_kdz
1oh9c_.dbf

/u01/app/oradata/CADB/E3BC1899CDDC1777E053B62BA8C0BD98/datafile/o1_mf_sysaux_kdz
1ohhh_.dbf

/u01/app/oradata/CADB/E3BC1899CDDC1777E053B62BA8C0BD98/datafile/o1_mf_undotbs1_k
dz1ohhn_.dbf

/u01/app/oradata/CADB/E3BC1899CDDC1777E053B62BA8C0BD98/datafile/o1_mf_users_kdz1
rzqh_.dbf

FILE_NAME
--------------------------------------------------------------------------------

SQL> create tablespace tools datafile '/u01/app/oradata/CADB/E3BC1899CDDC1777E053B62BA8C0BD98/datafile/tools01.dbf' size 200m autoextend on;

Tablespace created.

SQL> CREATE USER rco IDENTIFIED BY Ntrvl#123
TEMPORARY TABLESPACE temp
DEFAULT TABLESPACE tools
QUOTA UNLIMITED ON tools; 2 3 4

User created.

SQL>

4. Grant the RECOVERY_CATALOG_OWNER role to the schema owner,this example is rco

SQL> GRANT RECOVERY_CATALOG_OWNER TO rco;

Grant succeeded.

5.(Optional) Enable the VPD model for the recovery catalog

SQL> @/$ORACLE_HOME/rdbms/admin/dbmsrmanvpc.sql -vpd rco;

Checking the operating user... Passed

Granting VPD privileges to the owner of the base catalog schema RCO

========================================
No eligible RMAN catalogs have been found!

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

6. Create catalog in the catalog DB by using RMAN and verify it do works

[oracle@dguard2 admin]$ rman catalog rco/password@capdb1

Recovery Manager: Release 19.0.0.0.0 - Production on Thu Jul 14 11:33:05 2022
Version 19.3.0.0.0

connected to recovery catalog database

RMAN> CREATE CATALOG;

recovery catalog created

RMAN> exit

Recovery Manager complete.

[oracle@dguard2 admin]$ sqlplus rco/password@capdb1

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jul 14 11:36:31 2022
Version 19.3.0.0.0

Last Successful login time: Thu Jul 14 2022 11:36:21 +08:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> SELECT TABLE_NAME FROM USER_TABLES;

TABLE_NAME
--------------------------------------------------------------------------------
CONFIG
RASCHEMAVER
CFS
RCVER
DB
NODE

.......................

58 rows selected.

7. Register target database in the catalog database. and verify whether it works well.

[oracle@dguard ~]$ rman target / catalog rco/password@capdb1

Recovery Manager: Release 19.0.0.0.0 - Production on Thu Jul 14 11:57:20 2022
Version 19.3.0.0.0

connected to target database: DGUARD (DBID=3590491223)
connected to recovery catalog database

RMAN> REGISTER DATABASE;

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

RMAN>

RMAN> REPORT SCHEMA;--verify whether the catalog works now.

Report of database schema for database with db_unique_name DGUARD

List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 910 SYSTEM YES /u01/app/oradata/DGUARD/system01.dbf
3 590 SYSAUX NO /u01/app/oradata/DGUARD/sysaux01.dbf
4 295 UNDOTBS1 YES /u01/app/oradata/DGUARD/undotbs01.dbf
5 270 PDB$SEED:SYSTEM NO /u01/app/oradata/DGUARD/pdbseed/system01.dbf
6 330 PDB$SEED:SYSAUX NO /u01/app/oradata/DGUARD/pdbseed/sysaux01.dbf
7 5 USERS NO /u01/app/oradata/DGUARD/users01.dbf
8 100 PDB$SEED:UNDOTBS1 NO /u01/app/oradata/DGUARD/pdbseed/undotbs01.dbf
9 270 PDB1:SYSTEM NO /u01/app/oradata/DGUARD/pdb1/system01.dbf
10 340 PDB1:SYSAUX NO /u01/app/oradata/DGUARD/pdb1/sysaux01.dbf
11 100 PDB1:UNDOTBS1 NO /u01/app/oradata/DGUARD/pdb1/undotbs01.dbf
12 5 PDB1:USERS NO /u01/app/oradata/DGUARD/pdb1/users01.dbf
13 270 PDB2:SYSTEM NO /u01/app/oradata/DGUARD/pdb2/system01.dbf
14 340 PDB2:SYSAUX NO /u01/app/oradata/DGUARD/pdb2/sysaux01.dbf
15 100 PDB2:UNDOTBS1 NO /u01/app/oradata/DGUARD/pdb2/undotbs01.dbf
16 5 PDB2:USERS NO /u01/app/oradata/DGUARD/pdb2/users01.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 128 TEMP 32767 /u01/app/oradata/DGUARD/temp01.dbf
2 36 PDB$SEED:TEMP 32767 /u01/app/oradata/DGUARD/pdbseed/temp012022-07-05_14-13-22-854-PM.dbf
3 36 PDB1:TEMP 32767 /u01/app/oradata/DGUARD/pdb1/temp01.dbf
4 36 PDB2:TEMP 32767 /u01/app/oradata/DGUARD/pdb2/temp01.dbf