Oracle Cold Backup Detailed
--preparatory 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;
-Required backup files include:
/*
Data files, online redo log files, control files, temp files, parameter files, password files, listening 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 above SQL generated Linux command for execution, 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;
--Code execution
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"
Inthe cold standby mode, the concept is easy to understand, it is easy to copy the files that need to be backed up to a safe location, do not need too much intervention easy to recover to a point in time ( just copy the files back ) can be combined with the archiving method, as a database " Recovery of the latest state ".
In the case of a backup, the database must be in a consistent shutdown state can only be provided to a point in time of the recovery of the backup speed is slow, especially the large performance impact of data volume is relatively large Data recovery based on table and user level cannot be implemented.
Oracle Cold Backup detailed "practical case"
