How to Auto Backup The Control File
how to enable and disable the auto-backup of the control file in Oracle DB. In case you are not using the Recovery catalog, then enabling the auto backup of Control files of your database is highly recommended.
When does RMAN perform the Auto Backup of The Control files?
RMAN auto backups the control file and server parameter file when
- RMAN has successfully completed the BACKUP or COPY command.
- RMAN has successfully completed the CREATE CATALOG command.
- When there are any changes to the physical structure of the database. And by changes to the physical structure, I mean Adding or deleting a tablespace or data file, Putting tablespace either online or offline, renaming a data file or adding online redo logs. RMAN will process the auto backup of the control file, even if those changes are made through SQL*Plus.
What Process Performs The Auto-Backup?
What process performs the auto backup of the control file in case of structural changes to the database?
Since everything is taking place in RMAN thus we tend to think and answer “The RMAN process” performs the auto backup. But it’s wrong, actually, Oracle Server Process performs the auto backup of the control file and server parameter file when there is any structural change in the database.
How To Enable Auto Backup of The Control File
Step 1: Start the RMAN and connect with your target database
[oracle@oracle-db-19c ~]$
[oracle@oracle-db-19c ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Wed Feb 1 15:40:02 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB1 (DBID=1093429351)
RMAN>
Step 2: Enable the auto backup of the control file
RMAN>
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
using target database control file instead of recovery catalog
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
RMAN>
On successful execution of this command, the auto backup of the control file will be enabled.
How To Disable Auto Backup of The Control File.
There are two ways to disable the auto backup of the control file.
Step 1: Start the RMAN and connect with your target database
[oracle@oracle-db-19c ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Wed Feb 1 15:43:08 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB1 (DBID=1093429351)
RMAN>
Step 2: Disable the auto backup of the control file
RMAN>
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP off;
using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
new RMAN configuration parameters are successfully stored
RMAN>
On successful execution of this command, the auto backup of the control file will be disabled.
That’s the first way to disable the auto backup of the control file.
Reset the “CONTROLFILE AUTOBACKUP” parameter.
(another way to disable the auto backup of the control file)
Step 1: Start the RMAN and connect with your target database
[oracle@oracle-db-19c ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Wed Feb 1 15:46:25 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB1 (DBID=1093429351)
RMAN>
Step 2: Reset the “CONTROLFILE AUTOBACKUP” parameter.
RMAN>
RMAN> configure controlfile autobackup clear;
using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
RMAN configuration parameters are successfully reset to default value
RMAN>
On successful execution, this statement will reset the “CONTROLFILE AUTOBACKUP” parameter to its default state.
相关文章
- QT-找开工程后,最上方提示the code model could not parse an included file, which might lead to incorrect code completion and highlighting, for example.
- 记录一次在生成数据库服务器上出现The timeout period elapsed prior to completion of the operation or the server is not responding.和Exception has been thrown by the target of an invocation的解决办法
- org.springframework.web.multipart.MultipartException: Failed to parse multipart servlet request; nested exception is java.io.IOException: The temporary upload location [/tmp/tomcat.1428942566812653608
- Reporting Service 服务启动时报错The service did not respond to the start or control request in a timely fashion
- [!Typescript] Tips: dynamic specify the type of arguments to function
- [Javascript] Wait for the Fastest JavaScript Promise to Be Fulfilled with Promise.any()
- [Javascript] Write a Generator Function to Generate the Alphabet / Numbers
- [Recompose] Add Local State to a Functional Stateless Component using Recompose
- [Javascrip] Logging Timing Data to the Console
- [AngularJS]16. Using ReviewController to handle the everything, ng-submit
- 解决 Jenkins 中无法展示 HTML 样式的问题,csp问题,Refused to apply inline style because it violates the following Content Security Policy directive: "style-src 'self'".
- unable to copy the file to /etc/oratab
- [NPM] Add comments to your npm scripts
- AndroidStudio3.0 注解报错Annotation processors must be explicitly declared now. The following dependencies on the compile classpath are found to contain annotation processor.
- CM: How to get the complete url of a product attachment
- Unable to read the project file 'client.csproj'. Could not load file or assembly 'Microsoft.Build.En
- 成功解决The following specifications were found to be incompatible with the existing python installation
- 成功解决To fix this you could try to: 1. loosen the range of package versions you‘ve specified
- 成功解决KeyError: “Passing list-likes to .loc or [] with any missing labels is no longer supported. The
- 已解决pyautogui.FailSafeException: PyAutoGUI fail-safe triggered from mouse moving to a corner of the s
- 【已解决】RuntimeError: The following handlers are available to decode the pixel data however they are
- Caused by: org.xml.sax.SAXParseException; systemId: file:/home/hadoop/hive-0.12.0/conf/hive-site.xml; lineNumber: 5; columnNumber: 2; The markup in the document following the root element must be well
- 3GPP TS 29244-h20 中英文对照 | 5.13.5 Reporting of UE MAC addresses to the SMF
- 【问题解决】The connection to the server localhost:8080 was refused
- `Warning: The default method for RunUMAP has changed from calling Python UMAP via reticulate to the
- PAT 1033 To Fill or Not to Fill[dp]
- Kubernetes-kubectl The connection to the server localhost:8080 was refused -did you specify
- (六)Jenkins部署项目报错The username you provided is not allowed to use the text-based Tomcat Manager (error