• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

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

 

 

Summary
Review Date
Reviewed Item
Oracle Applications Backup
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Oracle Applications Backup"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.