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.
Login to rate this answer.
Murugesh.V.Raja
Answered On : Oct 11th, 2005
When the database in ARCHIVE LOG mode
Login to rate this answer.
Back can be performed. But, it's a hot backup. Database needs to be in Archivemode.
Login to rate this answer.
devesh
Answered On : 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.
Login to rate this answer.
rajat dey
Answered On : 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
Login to rate this answer.
jatinder
Answered On : 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;
Login to rate this answer.
Chiranjeevi Manne
Answered On : Mar 30th, 2007
Yes, it is possible only when the database is in Archivelog Mode.
Login to rate this answer.
Mohammed Abdul Afroze
Answered On : 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.
Login to rate this answer.
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.
Login to rate this answer.
NO, we can't. cuz Full Backup means consistent backup and we can take this backup only when our database is close.
Login to rate this answer.
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
Login to rate this answer.
