mobileNavlogo
headerlogo

Oracle Applications Backup

Blog Author

Tekslate

Published Date

22nd September, 2018

Ratings

Views

140

  • Share this blog :

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

   

About Author
Authorlogo
Name

TekSlate

Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .

Related Blogs

Write For Us