[Experiment-Video process] Simple and useful backup-oracle physical cold backup operation

[Experiment-Video process] Simple and useful backup-oracle physical cold backup operation

Mainly to the database to use the important files for targeted backup, data files, control files, online log files, archive log files, parameter files, password files, etc.

Cold backup requires an offline backup, that is, to shut down the database, more suitable for the business scenario can be shut down, such as supermarket stores server, 12 o'clock to 5 in the morning to shut down the database, then can be in this time period to do database cold backup.

The main is the following three steps

1 shut down the database normally
2 Back up all important files to the backup directory (data files, control files, redo log files, etc.)
3 Start the database after completing the backup

When recovering with a cold backup, you can start the database by simply restoring all the files to the original location.

1 Entering the database

[oracle@el48 xuejiayue]$ "/as sysdba"

2 Querying the directory where the data file DataFile is located:

SQL>SELECTFROM v$datafile;     查询控制文件controlfile的所在目录：SQL>SELECTFROM v$controlfile;     查询重做日志文件的所在目录：SQL>SELECTFROM v$logfile;

3 Closing the database

 SQL>shutdown immediate;

4 Backing up files to a backup directory

/u01/app/oracle/oradata/orcl/*.dbf  /home/backup/xuejiayue//u01/app/oracle/oradata/orcl/*.ctl  /home/backup/xuejiayue//u01/app/oracle/oradata/orcl/*.log  /home/backup/xuejiayue/

5 then start the database

 [oracle@el48 xuejiayue]$ "/as sysdba"

   SQL>startup

The video is as follows:

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced. If there is a need to reprint please contact [email protected]

[Experiment-Video process] Simple and useful backup-oracle physical cold backup operation