Get the App
SLTechnology News&Howtos  ›  Database  › 

Steps for RMAN to recover a file

Shulou Source: shulou.com Published: 2022-05-31 18:32:59 09月30日 Update

This article mainly explains the "steps of RMAN file recovery", the content of the article is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "RMAN file recovery steps" bar!

1. Recovery condition

In order to protect the control file, the control file itself is redundant by default (two by default), and the contents of the two control files are exactly the same. Without a control file, the database can only be started to the nomount state.

two。 Recovery steps

Case 1: RMAN is configured to control automatic backup of files.

(1) Boot to nomount status

RMAN > startup nomount

(2) restore control files from backup

RMAN > restore controlfile from autobackup

Case 2: there is a backup set of control files in RMAN

(1) Boot to nomount status

RMAN > startup nomount

(2) specify a backup set for repair

RMAN > restore controlfile from'/ backup/ctl-3284582354-20180506'

Thank you for your reading, the above is the content of the "RMAN recovery file steps", after the study of this article, I believe you have a deeper understanding of the RMAN recovery file steps, the specific use of the need for you to practice and verify. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Tags: Files controls steps backups situations content status learning consistency redundancy that is ideas data databases articles more conditions knowledge knowledge points articles Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Docker MariaDB OPPO Reno Microsoft Apple