Detailed explanation of Oracle cold backup [actual combat case]
Detailed explanation of Oracle cold backup
-- preparation work
Select * from v$database
Select file_name from dba_data_files
Create tablespace inv datafile'/ oradata/ocm/inv01.dbf' size 2048m
Create user inv identified by inv default tablespace inv temporary tablespace temp
Grant dba,resource to inv
Alter user scott account unlock
SQL > conn scott/tiger
Select * from tab
Select 'create table' | | tname | |'as select * from scott.' | | tname | |'; 'from tab
Create table BONUS as select * from scott.BONUS
Create table DEPT as select * from scott.DEPT
Create table EMP as select * from scott.EMP
Create table SALGRADE as select * from scott.SALGRADE
Create table te_objects as select * from dba_objects
-- oracle cold backup
Select instance_name,version,status,archiver,database_status from v$instance
Select dbid,name,log_mode from v$database
-- the files that need to be backed up include:
/ *
Data files, online redo log files, control files, temporary files, parameter files, password files, monitoring files, tnsnames files, sqlnet files
, /
-- execute statement preparation
Select'cp'| | name | |'/ ggs/backup/cold_back' from v$datafile
Union all
Select'cp'| | name | |'/ ggs/backup/cold_back' from v$tempfile
Union all
Select'cp'| | member | |'/ ggs/backup/cold_back' from v$logfile
Union all
Select'cp'| | name | |'/ ggs/backup/cold_back' from v$controlfile
-- Note: use the Linux command generated by the above SQL to execute, as follows:
Cp / oradata/ocm/system01.dbf / ggs/backup/cold_back
Cp / oradata/ocm/sysaux01.dbf / ggs/backup/cold_back
Cp / oradata/ocm/undotbs01.dbf / ggs/backup/cold_back
Cp / oradata/ocm/users01.dbf / ggs/backup/cold_back
Cp / oradata/ocm/ogg.dbf / ggs/backup/cold_back
Cp / oradata/ocm/inv01.dbf / ggs/backup/cold_back
Cp / oradata/ocm/temp01.dbf / ggs/backup/cold_back
Cp / oradata/ocm/redo04a.rdo / ggs/backup/cold_back
Cp / oradata/ocm/redo04b.rdo / ggs/backup/cold_back
Cp / oradata/ocm/redo03a.rdo / ggs/backup/cold_back
Cp / oradata/ocm/redo03b.rdo / ggs/backup/cold_back
Cp / oradata/ocm/redo02a.rdo / ggs/backup/cold_back
Cp / oradata/ocm/redo02b.rdo / ggs/backup/cold_back
Cp / oradata/ocm/redo01a.rdo / ggs/backup/cold_back
Cp / oradata/ocm/redo01b.rdo / ggs/backup/cold_back
Cp / oradata/ocm/control01.ctl / ggs/backup/cold_back
Cp / oradata/ocm/control02.ctl / ggs/backup/cold_back
Cp / oradata/ocm/control03.ctl / ggs/backup/cold_back
Create pfile='/ggs/backup/cold_back/dbs/initocm.ora' from spfile
Cp $ORACLE_HOME/dbs/orapwocm / ggs/backup/cold_back/dbs/
Cp $ORACLE_HOME/network/admin/ / ggs/backup/cold_back/admin/
-- close the database
Alter system archive log all
Shutdown immediate
-- execute code
Cp / oradata/ocm/system01.dbf / ggs/backup/cold_back
Cp / oradata/ocm/sysaux01.dbf / ggs/backup/cold_back
Cp / oradata/ocm/undotbs01.dbf / ggs/backup/cold_back
Cp / oradata/ocm/users01.dbf / ggs/backup/cold_back
Cp / oradata/ocm/ogg.dbf / ggs/backup/cold_back
Cp / oradata/ocm/inv01.dbf / ggs/backup/cold_back
Cp / oradata/ocm/temp01.dbf / ggs/backup/cold_back
Cp / oradata/ocm/redo04a.rdo / ggs/backup/cold_back
Cp / oradata/ocm/redo04b.rdo / ggs/backup/cold_back
Cp / oradata/ocm/redo03a.rdo / ggs/backup/cold_back
Cp / oradata/ocm/redo03b.rdo / ggs/backup/cold_back
Cp / oradata/ocm/redo02a.rdo / ggs/backup/cold_back
Cp / oradata/ocm/redo02b.rdo / ggs/backup/cold_back
Cp / oradata/ocm/redo01a.rdo / ggs/backup/cold_back
Cp / oradata/ocm/redo01b.rdo / ggs/backup/cold_back
Cp / oradata/ocm/control01.ctl / ggs/backup/cold_back
Cp / oradata/ocm/control02.ctl / ggs/backup/cold_back
Cp / oradata/ocm/control03.ctl / ggs/backup/cold_back
Cp $ORACLE_HOME/dbs/orapwocm / ggs/backup/cold_back/dbs/
Cp-r $ORACLE_HOME/network/admin/ / ggs/backup/cold_back/
-- start the database
Sqlplus / as sysdba
Startup
[advantages and disadvantages of cold backup]
01. The concept of cold backup mode is easy to understand, and it is relatively simple to copy the files that need to be backed up to a safe location. Without too much intervention, it is easy to recover to a certain point in time (just copy the file back). It can be combined with the archiving method to restore the "latest state" of the database.
02, defect backup, the database must be in a consistent closed state can only provide a certain point in time to restore backup speed is relatively slow, especially the large amount of data performance impact is relatively large can not achieve table-based and user-level data recovery.
