In order to backup a database, is there any DBA involvement is involved for oracle 11g? If YES how and if NO how?
You will need a DBA to backup the Oracle database. You may need a system administrator if you wanted the database backup to be on tape or on some other media for archiving purposes.
Your DBA will be able to help you with your backup. The following methods are valid for backing-up an Oracle database:
+ Datapump Export/Import - Exports are "logical" database backups in that they extract logical definitions and data from the database to a file.
+ Cold or Off-line Backups - shut the database down and backup up ALL data, log, and control files.
+ Hot or On-line Backups - If the database is available and in ARCHIVELOG mode, set the tablespaces into backup mode and backup their files. Also remember to backup the control files and archived redo log files.
+ RMAN Backups - while the database is off-line or on-line, use the "rman" utility to backup the database.
It depends on your requirements and needs that will dictate which of the options would work best for your organization. The simplest would be the datapump followed by RMAN. Your DBA would help you with either or.
1. Oracle Documentation: http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmintro.htm#BRADV8001
I hope this helps.