![]() |
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
![]() Related Questions 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. ... Tags : Backup 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 ... Tags : Backup 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 Loss of physical files restore from latest backup aviable.Recovery log apply from redo log files and archive log files. ... Latest Answer : If this is the situation, simple process is :1. Take a trace of control file from clone do the changes in that like database name and datafile name and location.2. Save it as < name >.ora3. Run the file in nomount stage. This will create your control ... Read Answers (3) | Asked by : GAURAV Tags : Backup Latest Answer : Cold backup we can perform using OS commands after shutting down the database.In DB running position we can take hot backup using the following commans;alter database begin backup; ... Read Answers (2) | Asked by : Sameer Tags : Backup Latest Answer : Full backup is offline backup of datafiles, Parameter file, Controlfiles, Redologfiles ... Read Answers (3) | Asked by : manoj Tags : Backup 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 Tags : Backup
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||