Shulou(Shulou.com)05/31 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.