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

This article mainly explains "what is the checksum recovery method of DBV cold backup". The explanation in this article is simple and clear and easy to learn and understand. Please follow the editor's train of thought to study and learn "what is the checksum recovery method of DBV cold backup".

Check availability

Dbv is generally used for verification. The specific statements are as follows:

Dbv file=/backup/orcl/system01.dbf blocksize=8192

Batch verification can use the following statement to verify all dbf files under / backup/orcl/

For i in $(find / backup/orcl/-name "* .dbf"); do dbv file=$i blocksize=8192;done

Database recovery

Method 1: need to build a library

Create the same database as before. (database name must be the same as the original)

Stop the database shutdown immediate

Copy admin, oradata, flash_recovery_area overrides in the installation directory, and copy database (PWDfile, pfile) overrides

If the path of the data file changes, you need an alter database rename statement to change it.

Start the database startup

Method 2: no need to build a library (a little bit of trouble)

To install oracle software normally, you only need to install the software and do not need to build an instance.

Data overrides, including data files, parameter files, control files, log files, pwd files, are placed in the same directory as the original system. If the directory changes, you need to modify the alter database rename, modify the pfile.

Create a service (required for windows): use the oradim command cmd to oradim-new-sid gbicc, which means to create a service, and sid is gbicc.

Set up listening: net configuration assintant to build (it is recommended to copy the files under the network of the source system and modify them according to the actual situation).

Open the database startup

Thank you for your reading, the above is the content of "what is the checksum recovery method of DBV cold backup". After the study of this article, I believe you have a deeper understanding of what the checksum recovery method of DBV cold backup is, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.