---创建数据存储表空间
create tablespace tbs_user_001
datafile 'F:\oracle_data\user_data\user_data001.dbf' size 128m
autoextend off extent management local;
SQL> create tablespace tbs_user_001
2 datafile 'F:\oracle_data\user_data\user_data001.dbf' size 128m
3 autoextend off extent management local;
Tablespace created.
SQL>
---创建恢复目录用户
SQL> create user prman identified by ******** default tablespace tbs_user_001;
User created.
SQL>
---分配 用户权限
SQL> grant connect,resource,recovery_catalog_owner to prman;
Grant succeeded.
SQL>
------恢复目录基础用户
------------------------------------------------------------------------------------------
C:\Users\user>rman catalog=prman/********@catalog_orcl
恢复管理器: Release 11.2.0.1.0 - Production on 星期五 12月 26 15:55:12 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
连接到恢复目录数据库
RMAN> create catalog tablespace tbs_user_001
恢复目录已创建
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-12537: TNS: 连接关闭
RMAN> connect target sys/********@lin_solgle;
连接到目标数据库: solgle (DBID=1369758280)
RMAN> register database;
注册在恢复目录中的数据库
正在启动全部恢复目录的 resync
完成全部 resync
RMAN> exit
恢复管理器完成。
C:\Users\user>
------------------------------------------------------------------------------------------
---- 创建使用虚拟目录的用户
C:\Users\user>sqlplus sys/********@catalog_orcl as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 26 15:23:39 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
SQL> create user vpc_lin_solgle identified by ******** default tablespace tbs_user_001;
User created.
SQL>
SQL> grant resource,connect,recovery_catalog_owner to vpc_lin_solgle;
Grant succeeded.
SQL>
-----分配虚拟恢复目录权限
C:\Users\user>rman catalog=prman/********@catalog_orcl
恢复管理器: Release 11.2.0.1.0 - Production on 星期五 12月 26 15:30:23 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
连接到恢复目录数据库
RMAN> grant register database to vpc_lin_solgle ;
授权成功。
RMAN> grant catalog for database solgle to vpc_lin_solgle ;
授权成功。
RMAN> exit
恢复管理器完成。
-----------------------------------------------------------------------------------------------------------------
C:\Users\user>rman catalog=vpc_lin_solgle/********@catalog_orcl
恢复管理器: Release 11.2.0.1.0 - Production on 星期五 12月 26 16:23:36 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
连接到恢复目录数据库
RMAN> create virtual catalog;
找到 PRMAN 所拥有的符合条件的基础目录
已针对 PRMAN 所拥有的基础目录创建了虚拟目录
RMAN>
------使用虚拟目录管理备份
C:\Users\user>rman target=sys/********@lin_solgle catalog=vpc_lin_solgle/********@ca
talog_orcl
恢复管理器: Release 11.2.0.1.0 - Production on 星期五 12月 26 17:19:13 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
连接到目标数据库: solgle (DBID=1369758280)
连接到恢复目录数据库
RMAN> show all;
db_unique_name 为 solgle 的数据库的 RMAN 配置参数为:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
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 LOA
D TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+data2/solgle/autobackup/sncpsolgle.ora'
;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA2/solgle/autobackup/sncpsolgle.ora'
;
RMAN>