todearmurali

 Profile Answers by todearmurali 

• Sep 27th, 2005

 

full backup can be taken with the interaction of oracle where we keep the tablespaces in begin backup mode and the respective datafiles are taken at os.finallt controlfile is taken backup .After that logfile switch should be force for recovery purpose.

Murugesh.V.Raja

• Oct 11th, 2005

 

When the database in ARCHIVE LOG mode

Srinivas_vemali

 Profile Answers by Srinivas_vemali 

• Nov 20th, 2005

 

Back can be performed. But, it's a hot backup. Database needs to be in Archivemode.

devesh

• Jan 20th, 2006

 

Yes, by using the Rman you have to take full backup when database is opened. But it is not a synchronized backup because its a hot backup.

I have recomended to you go for cold backup.

rajat dey

• Feb 21st, 2006

 

Yes , we can take full backup but this is not advisable it will degrade your performace if your database transaction is more .But using RMAN utility of oracle you can take which is more flexible than traditional full backup (it nothing but online backup ). regrdsrajat dey

jatinder

• Jun 6th, 2006

 

ues we can tabke full backup while database is open. By using hot backup. Tabe backup of all tablespaces using hotback. and take backup on control file useing alter database backup controlfile to trace;and then take backup of pfile using: create pfile from spfile;In this way Full backup can be performed when the database is open;

Chiranjeevi Manne

• Mar 30th, 2007

 

Yes, it is possible only when the database is in Archivelog Mode.

Mohammed Abdul Afroze

• Sep 20th, 2007

 

If the database is in Noarchivelog mode, then it is not possible to take the close backup.

If the database is in Archivelog mode, then it can be taken as Open Backup.

satyam_2007

 Profile Answers by satyam_2007 

• Oct 27th, 2007

 

Online backup can be whole and partial, be full and incremental, and be carried out with RMAN or with the operating system commands. But they can only be done if the database is in archivelog mode.

A datafile that is backed up online will not be synchronized with any particlular SCN, nor it is synchronized with the other datafiles or the control files. It is backed up while it is in use: being read from by server processes, and written by DBWn.

sanjayoracle

 Profile Answers by sanjayoracle 

• Apr 24th, 2008

 

NO, we can't. cuz Full Backup means consistent backup and we can take this backup only when our database is close.

Kamran Agayev A.

 Profile Answers by Kamran Agayev A. 

• Sep 8th, 2009

 

Of course YES

Using RMAN you can take full backup of database while it's open. But don't forget to archive current redo log file and backup it also, because it keeps all changes made to database while it was backed up

For more information, please refer to documentation:
download.oracle.com/docs/cd/B28359_01/backup.111/b28270/rcmbckba.htm#i1006297