Oracle Applications Backup

Prerequisite of RMAN is that database must be in archivelog mode. I f the database on which you are going to use RMAN is not in archivelog mode then first enable archivelog mode. 1. Enabling Archive log Mode 2. RMAN Settings   1. Enabling Archivelog Mode 1.1. Login as oracle user 1.2. Set environment variables by executing VIS_vision.env as following, $ cd /u01/oracle/ visdb/9.2.0/ $ . ./VIS_vision.env $ VIS-/u01/oracle/ visdb/9.2.0> sqlplus SQL* Plus: Release 9.2.0.6.0 - Production on Sat Sep 2 13:16:42 2006 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Enter user-name: sys as sysdba Enter password: Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.6.0 - Production 1.3. To check if database is in which status as if already in archivelog mode then we will skip the next steps. SQL> select Log_Mode from Sys.v$database; LOG_MODE ------------ NOARCHIVELOG 1.4. SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. 1.5. SQL> startup mount; ORACLE instance started.

1.6. SQL> alter database archivelog; Database altered. 1.7. SQL> alter database open; Database altered. 1.8. SQL> exit     <<<<<<<<<<---------------------*************----------------------->>>>>>>>>>>>>   2. RMAN Settings 2.1. $ rman target= sys/password nocatalog Recovery Manager: Release 9.2.0.6.0 - Production Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved. connected to target database: VIS (DBID= 1772376983) using target database controlfile instead of recovery catalog Note: Just change the word password with your sys user password. 2.2. To check the RMAN settings execute show all command, RMAN> show all;

 2.3. To configure backup path use the configure command but first check the available space on the target path. RMAN> configure channel device type disk format = '/backup/df0_%d_%s_%t'; RMAN configuration parameters are successfully stored  Note: Make sure that you have a folder named backup on root where files will be copied by rman or create with mkdir command. 2.4. Verify your settings, RMAN> show all;

 2.5. Start full backup, RMAN> backup database;