Backup oracle home and inventory

How to Backup ORACLE_HOME binaries and Oracle INVENTORY

ORACLE_HOME and INVENTORY need to backup before Database / OS level patching

Table of Contents
______________________________________
Backup ORACLE_HOME and INVENTORY

1. Shutdown Database (Not mandatory but prefer to shutdown)
2. Stop Listener (Not mandatory but prefer to shutdown)
3. Backup Oracle INVENTORY
4. Backup ORACLE_HOME

_______________________________________

1. Shutdown Database (Not mandatory but prefer to shutdown)

[oracle@rac1 ~]$ ps -ef | grep pmon
oracle 13474 1 0 15:29 ? 00:00:00 ora_pmon_DELL
oracle 13583 13414 0 15:30 pts/1 00:00:00 grep pmon
[oracle@rac1 ~]$

SQL> select name,open_mode from v$database;

NAME OPEN_MODE
——— ——————–
DELL READ WRITE

SQL>

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

2. Stop Listener (Not mandatory but prefer to shutdown)

[oracle@rac1 ~]$ lsnrctl stop LISTENER_11G

LSNRCTL for Linux: Version 11.2.0.4.0 – Production on 09-DEC-2018 15:32:36

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1.rajasekhar.com)(PORT=1621)))
The command completed successfully
[oracle@rac1 ~]$
[oracle@rac1 ~]$ ps -ef | grep tns
root 15 2 0 08:32 ? 00:00:00 [netns] oracle 13638 13414 0 15:32 pts/1 00:00:00 grep tns
[oracle@rac1 ~]$

3. Backup Oracle INVENTORY

[oracle@rac1 ~]$ cat /etc/oraInst.loc
inventory_loc=/u01/app/oraInventory
inst_group=dba
[oracle@rac1 app]$ cd /u01/app/
[oracle@rac1 app]$ ls -ltr
total 8
drwxr-xr-x. 10 oracle dba 4096 Nov 7 11:33 oracle
drwxrwx—. 6 oracle dba 4096 Nov 7 20:16 oraInventory
[oracle@rac1 app]$

tar -pcvf /u02/oracle/backup/binary/Backup_OraInv.tar oraInventory

tar -pczvf /u02/oracle/backup/binary/Backup_OraInv.tar oraInventory | gzip >
/u02/oracle/backup/binary/Backup_OraInv.tar.gz

4. Backup ORACLE_HOME

[oracle@rac1 product]$ pwd
/u01/app/oracle/product
[oracle@rac1 product]$ ls -ltr
total 12
drwxr-xr-x. 72 oracle dba 4096 Oct 21 2016 12.1.0.2
drwxr-xr-x. 78 oracle dba 4096 Dec 8 15:47 11.2.0.4 <—
drwxr-xr-x. 74 oracle dba 4096 Dec 8 19:38 12.2.0.1
[oracle@rac1 product]$

cd /u01/app/oracle/product
[oracle@rac1 product]$ nohup tar -pcvf /u02/oracle/backup/binary/oracle_home_bkup.tar 11.2.0.4 &
[1] 8848
[oracle@rac1 product]$ nohup: ignoring input and appending output to `nohup.out’

[oracle@rac1 product]$ jobs -l
[1]+ 8848 Running nohup tar -pcvf /u02/oracle/backup/binary/oracle_home_bkup.tar
11.2.0.4 &

[oracle@rac1 product]$ ls -ltr
total 2312
drwxr-xr-x. 72 oracle dba 4096 Oct 21 2016 12.1.0.2
drwxr-xr-x. 78 oracle dba 4096 Dec 8 15:47 11.2.0.4
drwxr-xr-x. 74 oracle dba 4096 Dec 8 19:38 12.2.0.1
-rw——-. 1 oracle dba 2354978 Dec 11 17:47 nohup.out
[oracle@rac1 product]$

[oracle@rac1 product]$ nohup tar -pczvf /u02/oracle/backup/binary/oracle_home_bkup.tar 11.2.0.4 | gzip
> /u02/oracle/backup/binary/oracle_home_bkup.tar.gz &
[1] 10189

[oracle@rac1 product]$ jobs -l
[1]+ 10188 Running nohup tar -pczvf /u02/oracle/backup/binary/oracle_home_bkup.tar
11.2.0.4
10189 | gzip > /u02/oracle/backup/binary/oracle_home_bkup.tar.gz &

[oracle@rac1 binary]$ ls -ltr /u02/oracle/backup/binary/oracle_home_bkup*
-rw-r–r–. 1 oracle dba 2752787212 Dec 11 18:22 /u02/oracle/backup/binary/oracle_home_bkup.tar
-rw-r–r–. 1 oracle dba 240299 Dec 11 18:22 /u02/oracle/backup/binary/oracle_home_bkup.tar.gz

Soundar Mahendran