Backing Up the Control File
来源:互联网 发布:ubuntu内核源码目录 编辑:程序博客网 时间:2024/05/29 16:34
Backing Up the Control File
The control file is critical for recovery, as it contains crucial information like database checkpoints and the datafile header checkpoints for the datafiles. A recovery is much harder when you lose allcopies of your control file. You also need to create a new control file when you want to change the name of a database, clone a database in a different location, or increase the maximum number of files you specified when you first created the control file.
You've seen how you can back up a control file using RMAN'sBACKUP CONTROLFILE command. That command will produce a binary copy of the control file. You can also use the SQL statementALTER DATABASE BACKUP CONTROLFILE from the SQL*Plus interface or from within RMAN to back up your control files.
It's a good practice to back up your control file on a regular basis by using theBACKUP CONTROLFILE TO TRACE command, as shown here:
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;Database altered.SQL>
You can use the ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS 'filename' command to achieve the same result as the preceding command. It will produce a text file that has theCREATE CONTROLFILE statement in it.
You should immediately back up your control file after you perform any of the following operations:
Create or drop a tablespace.
Add or rename a datafile.
Add, rename, or drop an online redo log group or member.
- Backing Up the Control File
- Backing Up Control Files
- Backing Up and Restoring the Database
- android-Backing up App Data to the Cloud
- Backing Storage for the File-backed Storage Gadget
- Backing Storage for the File-backed Storage Gadget
- Backing Storage for the File-backed Storage Gadget .
- Maintaining the Control File
- Backing Up & Restoring a Remote SVN Repository
- Chapter 06–Maintaining the Control File
- Fundamental I 06 Maintaining the Control File
- 17.3.1.1 Backing Up a Slave Using mysqldump
- control file
- qemu-img: Could not open old backing file...
- The model backing the 'XXX' context has changed 错误
- Refresh a GridView control on the parent page, from a pop up window
- error:control file or data file 1 is from before the last RESETLOGS
- Setting Up File Sharing
- addEventListener 绑定元素组
- Android新的menu实现——ActionMode
- C++程序设计课程2013级学生名单
- java 面试题02 之 《输入a、b、c 三个整数,按大到小排列》
- C++中的操作符重载
- Backing Up the Control File
- Linux常用的指令汇总
- 关于读取文本文件
- app 代理网址
- c++布尔值的介绍,我觉得挺不错的!
- jhhh
- fatal error C1083: Cannot open precompiled header file: 'Debug/Hello.pch': No such file
- 禅指人心
- Handlebars js模版