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

This article mainly explains "what is the manual backup and recovery method of Oracle". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn "what is the manual backup and recovery method of Oracle"?

What is manually managed backup and recovery?

Although in Oracle, there is already backup and recovery of RMAN. But as a way of Oracle backup and recovery, we will show you how to use manual methods to complete Oracle backup and recovery through an example in this article. The essence of the manual method is done through the cp command of the operating system, but during backup and recovery, the data block needs to be set to the correct state.

There are also some shortcomings in manual mode, for example, backup content needs to be managed manually, which is easy to lose and is not conducive to management.

II. The first manually managed backup and recovery

Here we take the backup and recovery of a table space as an example.

Prepare test data

Create tablespace mytbs datafile'/ home/oracle/mytbs01.dbf' size 50m alter user scott quota unlimited on mytbs;create table scott.test1 tablespace mytbs as select ename,sal from scott.emp;create table scott.test2 tablespace mytbs as select * from scott.dept

Perform a manual backup

Alter tablespace mytbs begin backup;host cp / home/oracle/mytbs01.dbf / home/oracle/backup/demo1/mytbs01.dbfalter tablespace mytbs end backup

Perform destructive actions

Delete data file and simulate data loss rm-rf / home/oracle/mytbs01.dbf Open Database: startup encountered the following error: ORA-01157: cannot identify/lock data file 5-see DBWR trace fileORA-01110: data file 5: / home/oracle/mytbs01.dbf' query error message: SQL > select FILE#,ERROR from V$RECOVER_FILE FILE# ERROR- 5 FILE NOT FOUND to view the status of the current database: SQL > select OPEN_MODE from vested databases

Perform manual recovery

Dump data file: copy the backup back to its original location cp / home/oracle/backup/demo1/mytbs01.dbf / home/oracle/mytbs01.dbf restore: recover datafile 8; open database: alter database open

Check whether the database is restored

At this point, I believe you have a deeper understanding of "what is the manual backup and recovery method of Oracle". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.