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.

Total System Global Area 581506668 bytesFixed Size 452204 bytesVariable Size 402653184 bytes

Database Buffers 167772160 bytes

Redo Buffers 10629120 bytes

Database mounted.

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;

RMAN configuration parameters are:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultCONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DI

CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO

RMAN configuration has no stored or default parameters

RMAN configuration has no stored or default parameters

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/ visdb/9.2.0/dbs/ snapcf_vis.f'; # default

RMAN configuration has no stored or default parameters

RMAN configuration has no stored or default parameters

 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;

RMAN configuration parameters are:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultCONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/home/oracle/backup/df0_%d_%s_%t';

RMAN configuration has no stored or default parameters

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/ visdb/9.2.0/dbs/ snapcf_vis.f'; # default

RMAN configuration has no stored or default parameters

RMAN configuration has no stored or default parameters

 2.5. Start full backup,

RMAN> backup database;

Starting backup at 02-SEP-06allocated channel: ORA_DISK_1channel ORA_DISK_1: sid= 51 devtype= DISK

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

including current controlfile in backupset