暂无图片
暂无图片
4
暂无图片
暂无图片
暂无图片
Oracle RMAN参考手册
3414
37页
411次
2021-05-21
免费下载
RMAN
RMAN
ORACLE ORACLE (
)( )
EXPORTIMPORT RMAN
RMAN
RMAN
退退RMAN
进入RMAN恢复管理器2种方式:
1 rmanrmanconnect
D:/>rman
恢复管理器: Release 10.2.0.2.0 - Production on 星期四 1 4 10:08:52
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN> connect target /
连接到目标数据库: ROME (DBID=252956976)
RMAN>
2targetcatalog( catalog rman)
# example of operating system authentication
D:/>rman TARGET /
# example of Oracle Net authentication
D:/>rman TARGET SYS/oracle@orcl NOCATALOG
D:/>rman TARGET / CATALOG rman/rman@catdb
D:/>rman TARGET SYS/oracle@orcl CATALOG rman/rman@catdb
RMAN> exit
恢复管理器完成。
注:我们将在以后章节讲述带有恢复目录的RMAN操作。
我们可以看一下rman可以连接的数据库的类型如下:
Target da
tabase
RMAN connects you to the target database, which is the database that you are backing up or r
ecovering, with the SYSDBA privilege. If you do not have this privilege, then the connection fai
ls.
Recovery
catalog d
atabase
This database is optional. By default, RMAN runs in NOCATALOG mode.
Auxiliary
database
You can connect to a standby database, duplicate database, or auxiliary instance (standby insta
nce or tablespace point-in-time recovery instance).
Note:
You do not need to specify the SYSDBA option because RMAN uses this option implicitly and automatically.
RMAN
show allrman
RMAN> show all;
使用目标数据库控制文件替代恢复目录
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 ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:/ORACLE/PRODUCT/10.2.0/DB_1/DATABASE/S
NCFROME.ORA'; # default
CONFIGURE... CLEAR
注:大部分配置项的值都是TO后边的内容,个别的除外,例如
CONFIGURE ENCRYPTION FOR DATABASE OFF
RMAN> configure retention policy to redundancy 2;
新的 RMAN 配置参数:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
已成功存储新的 RMAN 配置参数
RMAN> show all;
RMAN 配置参数为:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
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 ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:/ORACLE/PRODUCT/10.2.0/DB_1/DATABASE/S
NCFROME.ORA'; # default
RMAN> configure retention policy clear;
of 37
免费下载
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文档的来源(墨天轮),文档链接,文档作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。
关注
最新上传
暂无内容,敬请期待...
下载排行榜
Top250 周榜 月榜