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

This article mainly explains the "Oracle database cold backup and recovery method", the content of the article is simple and clear, easy to learn and understand, now please follow the editor's train of thought slowly in depth, together to study and learn "Oracle database cold backup and recovery method"!

Operation background

Because there is something wrong with the database of the test environment, expdp/exp/RMAN can not be used, so we need to operate on the objects under sys/system. In order to protect the security of the data, considering that it is too troublesome to back up by table, the cold backup scheme is chosen here.

The Oracle database is composed of Database and Instance. We only need to make a copy of the Database file when we stop Instance, and the backup copy is the cold backup of the database.

Related documents

Cold backup needs to back up the database data files, control files, log files, parameter files, backup files to ensure that all files.

Data file:

SYS@cams > set pages 200nSYSystcams > select name from v$datafile NAME----/u01/app/oracle/oradata/cams/system01.dbf/u01/app/oracle/oradata/cams/sysaux01.dbf/u01/app/oracle/oradata/cams/ Users01.dbf/u01/app/oracle/oradata/cams/example01.dbf... 53 rows selected.

Control file:

SYS@cams > select name from vested control file; NAME----/u01/app/oracle/oradata/cams/control01.ctl/u01/app/oracle/fast_recovery_area/cams/control02.ctl

Log file:

SYS@cams > select member from vault log file; MEMBER----/u01/app/oracle/oradata/cams/redo03.log/u01/app/oracle/oradata/cams/redo02.log/u01/app/oracle/oradata/cams/redo01.log

Parameter file

SYS@cams > show parameter pfile; NAME TYPE VALUE---spfile string / u01/app/oracle/product/11.2.0 / db_1/dbs/spfilecams.oraSYS@cams > create pfile from spfile File created. SYS@cams >! ls / u01/app/oracle/product/11.2.0/db_1/dbs/ | grep cams hc_cams.datinitcams.oraorapwcamsspfilecams.ora

Note: it is recommended to convert spfile to pfile for backup. Spfile is a binary file and pfile is a text file, which can be edited and modified directly.

File transfer

Create coldbackup_130_20181122 files, cams and TBS subdirectories under other server / home/oracle paths

The reference for the transfer command is as follows:

Reconstruction of scp * 182.207.129.181:/home/oracle/coldbackup_130_20181122/cams original library

The objects under the sys/system of the original library are processed, and then the original library is rebuilt in order to verify the recovery process of the cold backup.

(1) use the dbca command, select the Delete a Database option, Next all the way, and wait for the system to finish execution.

(2) use the dbca command, select the Create a Databse option, create the database, and execute it according to the original library standard.

(3) stop the database after installation.

(4) transfer the cold backup files on other servers back to the corresponding path through scp, and overwrite the original library files.

(5) start the original library and check it.

Operation summary

The backup and recovery of the cold backup have been carried out successfully. Here are several key points:

(1) make sure the database is closed before cold backup. You can execute the ps-ef | grep ora command to view

(2) the cold backup documents must be complete, it is easy to say that there is one less control file, and one less tablespace file will be troublesome.

(3) check the disk space of the system before cold backup. If the local disk space is insufficient, you can choose other storage or servers.

(4) the data after cold backup recovery is the "time point" after shutdown before cold backup.

(5) Cold standby can be used as a guarantee for some "destructive" experiments.

Thank you for your reading, the above is the content of "Oracle database cold backup and recovery method". After the study of this article, I believe you have a deeper understanding of the cold backup and recovery method of Oracle database, 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.