A full backup is an operating system backup of all data files, on-line redo log files and control file that constitute ORACLE database and the parameter.
Latest Answer : Full backup means it having datafiles, controlfile and parameter file. ...
No.
Latest Answer : NO, we can't. cuz Full Backup means consistent backup and we can take this backup only when our database is close. ...
A Partial Backup is any operating system backup short of a full backup, taken while the database is open or shut down.
Latest Answer : A partial backup is an operating system backup of part of a database. The backup of an individual tablespace's datafiles or the backup of a control file are examples of partial backups. Partial backups are useful only when the database is in ARCHIVELOG ...
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?
Complete database recovery from disk failure is possible only in ARCHIVELOG mode.Online database backup is possible only in ARCHIVELOG mode.
Latest Answer : The basic diff between the media and crash recovery is that , media recovery is performed by the user or dba with the helps of backups while the crash recovery is performed by the oracle itself by using his sman background process. ...
Latest Answer : Restore means that you are copying either datafiles(or)controlfile from one database to another database. It is possible only through RMAN. While connecting through RMAN this stage require only at nomount.Recover means that you are trying the recover ...
Latest Answer : if we don;t have any backup of Controlfile...then we have to use create controlfile command.. ...
Latest Answer : We can perform cold backup in unix by shutting down the database in proper mode so the control file will in consistent state and after that u can perform backing up all database files.I hot back we can perform by the stmt >alter tablespace begin backup;Then ...
Latest Answer : use CATALOG command ...
You can take a coldbackup from solaris and use it on windows NT?A) YesB) Yes, if RMAN backup performed from NT serverC) Yes, after running RMAN convertD) No