About Introduction To Oracle RMAN
RMAN (Recovery Manager)
There are two ways of performing backup and recovery.
- Where user does all the hard work. User takes the backup by manually copying and pasting all the necessary files and directories. For this a user can either use OS commands or use the limited number of SQL commands that come with the Database.
- Another type of backup is where user uses some utility to perform the backup and recovery. In that case this utility or tool does all the work. It is definitely less time consuming and very effective.
The first type of backup where user has to do all the hard work is known as “User Managed Backup-Recovery (UMR)”. Whereas the second type of backup where a specifically designed software performs all the work is known as “Server Managed Backup-Recovery (SMR)”.
1.What is RMAN?
RMAN stands for Recovery Manager. As the name suggests RMAN is a stand-alone utility for managing the backup and recovery of your Oracle Database. It’s a very powerful tool which comes with Oracle Database software.
the core functionality of RMAN is to manage the backup and recovery with minimum user intervention.thus we can say that it’s a “Server-Managed Backup & Recovery” utility for Oracle Database.
RMAN is a command line interpreter. You give some commands to this interpreter, it takes those commands and sends them to the target database by turning those commands as RPCs (Remote Procedure calls). These RPCs get executed at the database.
2.Does RMAN itself needs special privileges?
Yes, to perform all the backup and recovery related tasks Oracle Recovery Manager needs access to internal backup and recovery packages which are built into the Oracle kernel. Since these packages are built into the kernel of the database thus they are available even when the database is closed.
3.How to Install RMAN?
RMAN comes as a feature of your Oracle Database Server. That means it is installed with the installation of your Oracle Database.
4.Can any user of the database use the RMAN?
Since RMAN is a client thus you need some privileges to connect with your database using RMAN.
Before 12c there were only two privileges that you could use to run the RMAN utility. They were –
- SysDBA, The most obvious option and
- SYSOPER
But with Oracle Database 12c Oracle added another privilege which was designed for recovery and backup related tasks. It was –
3. SYSBACKUP
we can say that any database user who has either of these privileges can perform backup and recovery operations using either Oracle Recovery Manager also known as RMAN or SQL*Plus command line utility.
相关文章
- ORA-01592: error converting Version 7 rollback segment (string) to Oracle 8 format ORACLE 报错 故障修复 远程处理
- ORA-28543: Error initializing apply connection to non-Oracle system ORACLE 报错 故障修复 远程处理
- ORA-47957: Oracle Data Pump authorization for Oracle Database Vault to string on object string.string is not found ORACLE 报错 故障修复 远程处理
- 年 报Oracle每天、每周、每年报告(oracle天周)
- Oracle技术:提升多线程性能(oracle多线程)
- Exploring Oracle: A Guide to Oracle Database Learning(oracle英文书籍)
- Oracle数据库文件删除操作指南(oracle数据文件删除)
- 查询Oracle数据库中表空间名(oracle表空间名查询)
- 使用C语言连接Oracle的编程实现(c连接oracle的代码)
- Oracle触发器类型:解析实现机制(oracle触发器类型)
- Oracle大小写规则:注意大小写的规范使用(oracle大小写)
- Oracle如何删除一个表(oracle删除一个表)
- StepbyStep Guide to Oracle Installation: Finding the Right Installation Location(oracle安装地址)
- Exploring the Power of Oracle: A Guide to Understanding Relational Databases(oracle关系型数据库)
- Maximizing Performance: How to Easily Monitor and Optimize Your Oracle SGA.(oracle查看sga)
- StepbyStep Guide to Creating a New Oracle Database for Efficient Data Management(oracle新建数据库)
- Oracle执行计划优化:了解正确的执行顺序(oracle执行计划顺序)
- Oracle全库一键导出点拨语句技巧(oracle全库导出语句)
- 架构成功用Flask打通Oracle数据库连接(flask oracle)
- 恢复配置Oracle RMAN恢复配置的修改指南(oracle修改rman)
- Oracle数据库中的循环函数应用简介(oracle中的循环函数)
- Oracle中Exp命令操作实践(oracle中的exp)
- 瞩目Oracle中国用户大会火热开幕(oracle中国用户大会)
- 深入了解Oracle的两种结构类型(oracle两种类型结构)
- Oracle USN实现无限可能一次改变,永不落后(oracle usn)
- 专业人士尝试将Oracle升级至达梦系统(oracle to达梦)
- 据库高效管理Oracle 25用户数据库(oracle 25用户数)
- 如何解决Oracle 01742错误(oracle 01742)