• rman catalog

    参考文档：Recovery catalog for RMAN backup (Doc ID 452529.1)
    catalog库 ： bak，将其他库的备份信息存放在catalog库上

    -- 在cagalog库上创建用户

    1. create tablespace cat_tbs datafile '/oradata/bak/cat_tbs01.dbf' size 200M autoextend on;
    2. CREATE USER catuser IDENTIFIED BY oracle DEFAULT TABLESPACE cat_tbs TEMPORARY TABLESPACE temp  QUOTA UNLIMITED ON cat_tbs; 
    3. GRANT CONNECT, RECOVERY_CATALOG_OWNER TO catuser;
    4.  
    5. SYS@bak SQL> create tablespace cat_tbs datafile '/oradata/bak/cat_tbs01.dbf' size 200M autoextend on;
    6.  
    7. Tablespace created.
    8.  
    9. SYS@bak SQL> CREATE USER catuser IDENTIFIED BY oracle DEFAULT TABLESPACE cat_tbs TEMPORARY TABLESPACE temp  QUOTA UNLIMITED ON cat_tbs;
    10.  
    11. User created.
    12.  
    13. SYS@bak SQL> GRANT CONNECT, RECOVERY_CATALOG_OWNER TO catuser;
    14.  
    15. Grant succeeded.
    16.  
    17. SYS@bak SQL>

    -- 创建catalog 

    1. % rman catalog <catalog username>/<password> @<catalog db connect string>
    2.  
    3. rman catalog catuser/oracle@bak 
    4. create catalog;
    5.  
    6. [oracle@19ctest ~]$ rman catalog catuser/oracle@bak
    7.  
    8. Recovery Manager: Release 19.0.0.0.0 - Production on Fri Nov 17 14:17:07 2023
    9. Version 19.21.0.0.0
    10.  
    11. Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
    12.  
    13. connected to recovery catalog database
    14.  
    15. RMAN> create catalog;
    16.  
    17. recovery catalog created
    18.  
    19. RMAN>

    -- 注册database，分别在bak，test，orcl库上执行

    1. % rman TARGET / CATALOG <catalog username>/<password> @<catalog db connect string>
    2.  
    3. rman target / catalog catuser/oracle@bak 
    4. register database;
    5.  
    6. [oracle@19ctest ~]$ rman target / catalog catuser/oracle@bak
    7.  
    8. Recovery Manager: Release 19.0.0.0.0 - Production on Fri Nov 17 14:18:29 2023
    9. Version 19.21.0.0.0
    10.  
    11. Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
    12.  
    13. connected to target database: BAK (DBID=1552936560)
    14. connected to recovery catalog database
    15.  
    16. RMAN> register database;
    17.  
    18. database registered in recovery catalog
    19. starting full resync of recovery catalog
    20. full resync complete
    21.  
    22. RMAN>
    23.  
    24. [oracle@19ctest ~]$ rman target / catalog catuser/oracle@bak
    25.  
    26. Recovery Manager: Release 19.0.0.0.0 - Production on Fri Nov 17 14:19:10 2023
    27. Version 19.21.0.0.0
    28.  
    29. Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
    30.  
    31. connected to target database: TEST (DBID=2318641842)
    32. connected to recovery catalog database
    33.  
    34. RMAN> register database;
    35.  
    36. database registered in recovery catalog
    37. starting full resync of recovery catalog
    38. full resync complete
    39.  
    40. RMAN>
    41.  
    42.  
    43. [oracle@19ctest ~]$ rman target / catalog catuser/oracle@bak
    44.  
    45. Recovery Manager: Release 19.0.0.0.0 - Production on Fri Nov 17 14:19:53 2023
    46. Version 19.21.0.0.0
    47.  
    48. Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
    49.  
    50. connected to target database: ORCL (DBID=1628558668)
    51. connected to recovery catalog database
    52.  
    53. RMAN> register database;
    54.  
    55. database registered in recovery catalog
    56. starting full resync of recovery catalog
    57. full resync complete
    58.  
    59. RMAN>

    -- 升级catalog
    RMAN>UPGRADE CATALOG;
     
    --remove catalog 
    RMAN> DROP CATALOG; 

    -- unregister database 
    RMAN> UNREGISTER DATABASE ;   <<<< 10g之前的方式

    % sqlplus / @     <<<< 10g及之后的方式
    SQL > DBMS_RCVCAT.UNREGISTERDATABASE(db_key, db_id);

    -- 查看catalog版本

    1. % sqlplus <catalog username>/<password> @<catalog db connect string>
    2.  
    3. SQL > SELECT * FROM rcver; 
    4.  
    5. sqlplus catuser/oracle@bak
    6. SELECT * FROM rcver; 
    7.  
    8. [oracle@19ctest ~]$ sqlplus catuser/oracle@bak
    9.  
    10. SQL*Plus: Release 19.0.0.0.0 - Production on Fri Nov 17 14:20:55 2023
    11. Version 19.21.0.0.0
    12.  
    13. Copyright (c) 1982, 2022, Oracle.  All rights reserved.
    14.  
    15. Last Successful login time: Fri Nov 17 2023 14:19:54 +08:00
    16.  
    17. Connected to:
    18. Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    19. Version 19.21.0.0.0
    20.  
    21.  
    22. Session altered.
    23.  
    24. CATUSER@bak SQL> SELECT * FROM rcver;
    25.  
    26. VERSION
    27. ---------------
    28. 19.21.00.00.00
    29.  
    30. CATUSER@bak SQL>

    -- 查看在catalog中的库

    1. SYS@bak SQL> select * from catuser.node;
    2.  
    3. DB_UNIQUE_     DB_KEY INST_STARTUP_STAMP DATABAS   SITE_KEY DB_TIMEZONE                                                      T
    4. ---------- ---------- ------------------ ------- ---------- ---------------------------------------------------------------- -
    5. BAK                 1         1153144098 PRIMARY          3 +08:00                                                           R
    6. TEST              105         1153142785 PRIMARY        107 +08:00                                                           R
    7. ORCL              263         1153142862 PRIMARY        265 +08:00                                                           R
    8.  
    9. SYS@bak SQL>

    END 

  • 相关阅读:
    使用一段时候，oracle服务在启动时报1053：服务没有及时响应启动或控制请求
    redis应用于微服务缓存的探讨
    JavaScript速成课--面向对象程序设计
    为什么选择clickhouse?
    机器人操作系统ROS2学习—控制小海龟运动
    算法day39|62，63
    万卷书 - 欧洲的门户 [The Gates of Europe]
    git 版本管理
    5个最好的乐高设计软件
    前端生成海报图：html2canvas 生成海报图
  • 原文地址：https://blog.csdn.net/xxzhaobb/article/details/134464819