BACKUP ORACLE HOME AND INVENTORY
Oracle Home and Inventory Backup
-----------------------------------------
tar -cvf $ORACLE_HOME $ORACLE_HOME/oraInventory | gzip > Backup_Software_Version.tar.gz
Note:
tar -cvf <destination_location> <source_location>
ORACLE_HOME & ORACLE_CRS_HOME backup’s (for all nodes in RAC)
$ tar -zcvf db_1_bak.tar.gz db_1
$ cd /u01/app/oracle/product/11.2
$ ls -al
total 353532
drwxr-xr-x 3 oracle oinstall 4096 Sep 6 17:32 .
drwxrwxr-x 3 oracle oinstall 4096 Sep 12 2013 ..
drwxr-xr-x 80 oracle oinstall 4096 Jun 11 02:03 db_1
-rw-r--r-- 1 oracle oinstall 361627648 Sep 6 17:34 db_1_bak.tar.gz
Controlfile Backup
---------------------
alter database backup controlfile to trace;
show parameter user_dump_dest
(go to udump dest and make the note of controlfile trace)
Well explained and very clear steps. I was trying to take backup of ORACLE_HOME and oraInventory and it helped me. Thanks for sharing.
ReplyDelete