Today we are going to have look on Cold Backup. Being DBA we are aware of the importance of Backup in Oracle. Different kind of backup has a different kind of uses.
Let’s have look on Cold Backup. Steps for Cold Backup
SQL> create table cold_back(name varchar(100));
Table created.
SQL> insert into cold_back values('********* DATA INSERTED BEFORE BACKUP ***********');
1 row created.
SQL> commit;
Commit complete.
SQL> select name from v$datafile
union
select name from v$controlfile
union
select member from v$logfile;
NAME
--------------------------------------------------------------
D:\ORACLE\PRODUCT\10.2.0\ORADATA\OracleHelp\CONTROL01.CTL
D:\ORACLE\PRODUCT\10.2.0\ORADATA\OracleHelp\CONTROL02.CTL
D:\ORACLE\PRODUCT\10.2.0\ORADATA\OracleHelp\CONTROL03.CTL
D:\ORACLE\PRODUCT\10.2.0\ORADATA\OracleHelp\REDO01.LOG
D:\ORACLE\PRODUCT\10.2.0\ORADATA\OracleHelp\REDO02.LOG
D:\ORACLE\PRODUCT\10.2.0\ORADATA\OracleHelp\REDO03.LOG
D:\ORACLE\PRODUCT\10.2.0\ORADATA\OracleHelp\SYSAUX01.DBF
D:\ORACLE\PRODUCT\10.2.0\ORADATA\OracleHelp\SYSTEM01.DBF
D:\ORACLE\PRODUCT\10.2.0\ORADATA\OracleHelp\TEST01.DBF
D:\ORACLE\PRODUCT\10.2.0\ORADATA\OracleHelp\UNDOTBS01.DBF
D:\ORACLE\PRODUCT\10.2.0\ORADATA\OracleHelp\USERS01.DBF
11 rows selected.
SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down.
D:\>mkdir D:\cold_back D:\>copy D:\oracle\product\10.2.0\oradata\OracleHelp\* D:\cold_back D:\oracle\product\10.2.0\oradata\OracleHelp\SYSAUX01.DBF D:\oracle\product\10.2.0\oradata\OracleHelp\UNDOTBS01.DBF D:\oracle\product\10.2.0\oradata\OracleHelp\CONTROL01.CTL D:\oracle\product\10.2.0\oradata\OracleHelp\CONTROL02.CTL D:\oracle\product\10.2.0\oradata\OracleHelp\CONTROL03.CTL D:\oracle\product\10.2.0\oradata\OracleHelp\REDO01.LOG D:\oracle\product\10.2.0\oradata\OracleHelp\REDO02.LOG D:\oracle\product\10.2.0\oradata\OracleHelp\REDO03.LOG D:\oracle\product\10.2.0\oradata\OracleHelp\TEMP01.DBF D:\oracle\product\10.2.0\oradata\OracleHelp\SYSTEM01.DBF D:\oracle\product\10.2.0\oradata\OracleHelp\USERS01.DBF D:\oracle\product\10.2.0\oradata\OracleHelp\TEST01.DBF 12 file(s) copied.
SQL> startup;
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1247876 bytes
Variable Size 83887484 bytes
Database Buffers 75497472 bytes
Redo Buffers 7139328 bytes
Database mounted.
Database opened.
SQL> insert into cold_back values('********* DATA INSERTED AFTER BACKUP ***********');
1 row created.
SQL> commit;
Commit complete.
SQL> select * from cold_back;
NAME
--------------------------------------------------------------------------------
********* DATA INSERTED BEFORE BACKUP ***********
********* DATA INSERTED AFTER BACKUP ***********
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
D:\>del D:\oracle\product\10.2.0\oradata\OracleHelp\USERS01.DBF SQL> startup; ORACLE instance started. Total System Global Area 167772160 bytes Fixed Size 1247876 bytes Variable Size 83887484 bytes
Today’s thought…
“The only way to get ahead is to find errors in conventional wisdom.” Larry Ellison
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Telegram Channel: https://t.me/helporacle
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
