Get the App
SLTechnology News&Howtos  ›  Database  › 

What is the recovery method of all the media in the database?

Shulou Source: shulou.com Published: 2022-05-31 14:47:55 11月14日 Update

This article mainly explains "what is the recovery method of all media in the database". The explanation in this article is simple and clear, easy to learn and understand. Please follow the idea of Xiaobian and go deep into it slowly to study and learn "what is the recovery method of all media in the database" together!

1. returning condition

When the database only has control files and spfiles, and has a full database backup, all other data files are lost.

2. recovery steps

(1) Start database to mount state

RMAN> startup mount

(2) Repair data files

RMAN> restore database

(3) Recovery of database

RMAN> recover database

Note: restore database file-level repair refers to using backups to repair data files (media repair)

Recover database Data-level repair (logical repair), further recovery of the database using data files and redo logs (archive files)

Thank you for reading, the above is the "database all media recovery method is what" content, after the study of this article, I believe we have a deeper understanding of the database all media recovery method is what this problem, the specific use of the situation also needs to be verified by practice. Here is, Xiaobian will push more articles related to knowledge points for everyone, welcome to pay attention!

Tags: Data database file media method learning content backup situation that is ideas articles logs more conditions steps status knowledge knowledge points articles Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Huawei Xiaomi OPPO Reno vpn NVidia