RMAN CATALOG和Nocatalog

原创

wx62e28ac222a20 2022-07-29 17:05:28 ©著作权

文章标签 数据库 linux python java mysql 文章分类 数据库

©著作权归作者所有：来自51CTO博客作者wx62e28ac222a20的原创作品，请联系作者获取转载授权，否则将追究法律责任

1.nocatalog方式 Nocatalog方式就是用control file作为catalog，每一次备份都要往控制文件里面写好多备份信息，控制文件里面会有越来越多的备份信息。因此，当使用rman nocatalog方式备份时，备份controlfile是非常重要的。

sys@CXMTDB 16:45:33> select name,value,issys_modifiable from v$parameter where name='control_file_record_keep_time';

NAME                   VALUE            ISSYS_MOD
------------------------------ -------------------- ---------
control_file_record_keep_time  7            IMMEDIATE

Elapsed: 00:00:00.01
sys@CXMTDB 16:45:34> alter system set control_file_record_keep_time=14 scope=both;

System altered.

Elapsed: 00:00:00.02
sys@CXMTDB 17:21:23> select name,value,issys_modifiable from v$parameter where name='control_file_record_keep_time';

NAME                   VALUE            ISSYS_MOD
------------------------------ -------------------- ---------
control_file_record_keep_time  14            IMMEDIATE

Elapsed: 00:00:00.00
sys@CXMTDB 17:21:32> show parameter control

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time         integer     14
control_files                 string     /oradata/CXMTDB/control01.ctl,
                          /oradata/CXMTDB/control02.ctl
control_management_pack_access         string     DIAGNOSTIC+TUNING

2.catalog方式
Catalog 则必须要首先要创建目录备份数据库，建立恢复目录。

sys@CXMTDB 17:26:37> select file_name,tablespace_name from dba_data_files;

FILE_NAME                       TABLESPACE_NAME
-------------------------------------------------- ------------------------------
/oradata/CXMTDB/system01.dbf               SYSTEM
/oradata/CXMTDB/sysaux01.dbf               SYSAUX
/oradata/CXMTDB/undotbs01.dbf               UNDOTBS1
/oradata/CXMTDB/users01.dbf               USERS
/oradata/CXMTDB/ogg_tbs.dbf               OGG_TBS

1.创建Catalog所需表空间

sys@CXMTDB 17:30:32> create tablespace rman_ts  datafile '/oradata/CXMTDB/rmants.dbf'  size 1024M;

Tablespace created.

2.创建RMAN用户并授权

sys@CXMTDB 17:30:39> create user rman identified by wwwwww default tablespace rman_ts quota unlimited on rman_ts;

User created.

sys@CXMTDB 17:30:52> grant recovery_catalog_owner to rman;

Grant succeeded.

3.创建恢复目录

[oracle@node02:/home/oracle]$ rman catalog rman/wwwwww

Recovery Manager: Release 19.0.0.0.0 - Production on Wed Sep 29 17:32:54 2021
Version 19.3.0.0.0

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

connected to recovery catalog database

RMAN> create catalog tablespace rman_ts;

recovery catalog created

RMAN> connect target /;

connected to target database: CXMTDB (DBID=2538411202)

RMAN> register database;

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

4.catalog方式连接
(第一斜杠表示target数据库，catalog表示catalog目录 rman/wwwwww表示catalog用户名和密码)

[oracle@node02:/home/oracle]$ rman target / catalog rman/wwwwww

Recovery Manager: Release 19.0.0.0.0 - Production on Wed Sep 29 17:37:46 2021
Version 19.3.0.0.0

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

connected to target database: CXMTDB (DBID=2538411202)
connected to recovery catalog database

oracle,linux