Offline (Cold) backup of database in Oracle 11gRr2
Posted by Mir Sayeed Hassan on February 13th, 2018
Offline (Cold) backup of database in Oracle 11gRr2
Fallow the step by step procedure as shown below:
Shutdown the database
sys@TESTDB>shu immediate Database closed. Database dismounted. ORACLE instance shut down.
Now manually copy all the datafiles, logfiles, controlfiles, parameter file & password file to the backup location
Note: Before shutdown of the database, verify the location of the datafiles,logfiles, controlfiles by using the v$datafile, v$logfile, v$control_files
Example:
sys@TESTDB>select name from V$datafile; NAME -------------------------------------------------------------------------------- /u01/app/oracle/oradata/testdb /system01.dbf /u01/app/oracle/oradata/testdb /sysaux01.dbf
—-
etc
sys@TESTDB>select * from V$logfile; GROUP# STATUS TYPE MEMBER IS_ ------------------------------------------------------------------------------------------------------- 1 ONLINE /u01/app/oracle/oradata/testdb /redo1.log NO
— etc
sys@TESTDB>show parameter control_files NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ control_files string /u01/app/oracle/oradata/testdb /control01.ctl, /u01/app/oracle/ fast_recovery_area/testdb /control02.ctl
Now go to the OS Level & transfer the files to backup location
[oracle@testdb ~]$ cd /u01/app/oracle/oradata/testdb/
[oracle@testdb ~]$ ls redo02.log redo3.log sysaux01.dbf system.dbf undotbs02.dbf users01.dbf control01.ctl redo1.log example01.dbf redo01.log system02.dbf test.dbf undotbs01.dbf
[oracle@testdb ~]$ cp /u01/app/oracle/oradata/testdb/* /backup/offline_db_bkp
[oracle@testdb ~]$ cp /u01/app/oracle/fast_recovery_area/testdb/control02.ctl /backup/offline_db_bkp
[oracle@testdb dbs]$ cp inittestdb.ora spfiletestdb.ora orapwtestdb /backup/offline_db_bkp