SQL>create tablespace kingodb_rman datafile 'e:/rmanbackup/kingodb_rman.dbf' size 100m autoextend on next 50m maxsize unlimited;
2.在恢复目录数据库中创建RMAN用户并授权。
SQL>create user rman_user identified by oracle default tablespace kingodb_rman quota unlimited on kingodb_rman;
SQL>grant connect,resource,recovery_catalog_owner to rman_user;
3.连接到RMAN恢复目录数据库。
C:\Users\Administrator>rman catalog rman_user/oracle
恢复管理器: Release 11.2.0.4.0 - Production on 星期二 8月 18 18:33:46 2020
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
连接到恢复目录数据库
RMAN> register database;
注册在恢复目录中的数据库
正在启动恢复目录的全部重新同步
完成全部重新同步
RMAN> list incarnation;
正在启动恢复目录的全部重新同步
完成全部重新同步
数据库原型列表
DB 关键字 Inc 关键字 DB 名 DB ID STATUS 重置 SCN 重置时间
------- ------- -------- --------------- -------- ---------- ----------
1 17 KINGODB 2411285002 PARENT 1 09-10月-13
1 2 KINGODB 2411285002 CURRENT 897124 15-8月 -20
3.显示已经配置过的有默认值的参数,其中包括通道参数:
RMAN> show all;
db_unique_name 为 KINGODB 的数据库的 RMAN 配置参数为:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFKINGODB.ORA'; # default
#1.创建恢复目录:用来存储RMAN资料库的。SQL>create tablespace kingodb_rman datafile 'e:/rmanbackup/kingodb_rman.dbf' size 100m autoextend on next 50m maxsize unlimited;#2.在恢复目录数据库中创建RMAN用户并授权。SQL>create user rman_user identified by oracle default tablespace kingo