Description : My database is down and I cannot restore. What now? (forDBA
Last Answer : Recovery without any backup is normally not supported, however, Oracle Consulting can sometimes extract data from an offline database using a utility called DUL (Disk UnLoad). This utility reads data in the ... as an absolute last resort and will most likely cost your company a lot of money!!!
Description : How to implement the multiple control files for an existing database ?
Last Answer : Shutdown the database Copy one of the existing control file to new location Edit Config ora file by adding new control file. name Restart the database.
Description : What are database files, control files and log files. How many of these files should a database have at least? Why?
Last Answer : ∙ Database Files The database files hold the actual data and are typically the largest in size. Depending on their sizes, the tables (and other objects) for all the user accounts can go in one ... or redo log file to the database, the information is recorded in the control files. ∙ Redo Logs
Description : How does one backup a database using the export utility? (for DBA
Last Answer : Oracle exports are "logical" database backups (not physical) as they extract data and logical definitions from the database into a file. Other backup strategies normally back-up the physical data ... exports include more information about the database in the export file than user level exports.
Description : Why and when should I backup my database? (for DBA
Last Answer : Backup and recovery is one of the most important aspects of a DBAs job. If you lose your company's data, you could very well lose your job. Hardware and software can always be ... things that will get you. Most failed recoveries are a result of organizational errors and miscommunications.
Description : Can Full Backup be performed when the database is open ?
Last Answer : No.
Description : My database was terminated while in BACKUP MODE, do I need to recover? (for DBA
Last Answer : If a database was terminated while one of its tablespaces was in BACKUP MODE (ALTER TABLESPACE xyz BEGIN BACKUP;), it will tell you that media recovery is required when you try to restart the ... : ALTER DATABASE END BACKUP; The above commands need to be issued when the database is mounted.
Description : How does one backup a database using RMAN? (for DBA
Last Answer : The biggest advantage of RMAN is that it only backup used space in the database. Rman doesn't put tablespaces in backup mode, saving on redo generation overhead. RMAN will re-read database ... directly to tape. Alternatively one can backup to disk and then manually copy the backups to tape.
Description : Is it possible to backup your database without the use of an RMAN database to store the catalog?
Last Answer : Yes, but the catalog would be stored in the controlfile.
Description : Does Oracle write to data files in begin/hot backup mode? (for DBA
Last Answer : Oracle will stop updating file headers, but will continue to write data to the database files even if a tablespace is in backup mode.In backup mode, Oracle will write out complete changed blocks ... ). Because of this, one should notice increased log activity and archiving during on-line backups.
Description : How does one backup archived log files? (for DBA
Last Answer : One can backup archived log files using RMAN or any operating system backup utility. Remember to delete files after backing them up to prevent the archive log directory from filling up. If the ... oracle/arch_backup/log_t%t_s%s_p%p' 5> (archivelog all delete input); 6> release channel dev1; 7> }
Description : restore backup files from Windows7 to WindowsXP after changing the OS
Last Answer : Did you save the files to an external hard drive or cd?
Description : The purpose of backup is: a) To restore a computer to an operational state following a disaster b) To restore small numbers of files after they have been accidentally deleted c) To restore one among many version of the same file for multiple backup environment d) All of the mentioned
Last Answer : All of the mentioned
Description : 1. The purpose of backup is: a) To restore a computer to an operational state following a disaster b) To restore small numbers of files after they have been accidentally deleted c) To restore one among many version of the same file for multiple backup environment d) All of the mentioned
Description : Name two files used for network connection to a database.
Last Answer : TNSNAMES.ORA and SQLNET.ORA
Description : Name the three major set of files on disk that compose a database in Oracle
Last Answer : There are three major sets of files on disk that compose a database. All the files are binary. These are ∙ Database files ∙ Control files ∙ Redo logs The most important of these ... actual data resides. The control files and the redo logs support the functioning of the architecture itself.
Description : What command would you use to create a backup control file?
Last Answer : Alter database backup control file to trace.
Description : Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?
Last Answer : It is not possible. As triggers are defined for each table, if you use COMMIT of ROLLBACK in a trigger, it affects logical transaction processing.
Description : How do you control number of Datafiles one can have in an Oracle database?
Last Answer : The db_files parameter is a "soft limit " parameter that controls the maximum number of physical OS files that can map to an Oracle instance. The maxdatafiles parameter is a different - "hard limit" ... value is 32. The maximum number of database files can be set with the init parameter db_files.
Description : Table Space,Data Files,Parameter File, Control Files
Last Answer : Table Space :: The table space is useful for storing the data in the database.When a database is created two table spaces are created. a) System Table space :: This data file stores all the tables ... They contain the Db name, name and location of dbs, data files ,redo log files and time stamp.
Description : Explain the difference between a hot backup and a cold backup and the benefits associated with each.
Last Answer : A hot backup is basically taking a backup of the database while it is still up and running and it must be in archive log mode. A cold backup is taking a backup of the database while it is ... and thus there will be a slight performance gain as the database is not cutting archive logs to disk.
Description : What utility is used to create a physical backup?
Last Answer : Either rman or alter tablespace begin backup will do..
Description : What is cold backup? What are the elements of it?
Last Answer : Cold backup is taking backup of all physical files after normal shutdown of database. We need to take. - All Data files. - All Control files. - All on-line redo log files. - The init.ora file (Optional)
Description : What is a logical backup?
Last Answer : Logical backup involves reading a set of database records and writing them into a file. Export utility is used for taking backup and Import utility is used to recover from backup.
Description : What is hot backup and how it can be taken?
Last Answer : Taking backup of archive log files when database is open. For this the ARCHIVELOG mode should be enabled. The following files need to be backed up. All data files. All Archive log, redo log files. All control files.
Description : What is Full Backup ?
Last Answer : 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
Description : What is Partial Backup ?
Last Answer : A Partial Backup is any operating system backup short of a full backup, taken while the database is open or shut down.
Description : What is cold backup and hot backup (in case of Oracle)?
Last Answer : ∙ Cold Backup: It is copying the three sets of files (database files, redo logs, and control file) when the instance is shut down. This is a straight file copy, usually from the disk ... was done. The database is restored to the most consistent state without any loss of committed transactions.
Description : Name two utilities that Oracle provides, which are use for backup and recovery.
Last Answer : Along with the RDBMS software, Oracle provides two utilities that you can use to back up and restore the database. These utilities are Export and Import. The Export utility dumps the definitions and data ... best you can do is recover the database to the time when the export was last performed.
Description : If I back up my iphone on a computer, can it restore backup from another computer that it was authorized on?
Last Answer : I backup mine to “cloud” and can recover from any authorized computer.
Description : Which of the following is false? a) The more important the data, the greater the need for backing it up b) A backup is as useful as its associated restore strategy c) Storing the ... near to its original site is best strategy d) Automated backup and scheduling is preferred over manual operations
Last Answer : Storing the backup copy near to its original site is best strategy
Description : When I restore my Time Machine backup to a new Mac, will my licenses still be legal?
Last Answer : I believe it is YOU who owns the rights, so any machine you own you can use it on. Don’t quote me on that but I think it’s right.
Description : How to solve this problem I have with a restore (backup) file I made in SQL Server 2008?
Last Answer : try to see if you have volume optimization enabled, it prevents certain changes from happening and really gives the user a hell of alot more trouble than it is worth.
Description : If I jailbreak my iPod Touch, but later would like to restore it, is there some way I could restore it from a recent backup instead of a fresh restore?
Last Answer : Just wait until Apple sends out another update.
Description : Is there any way to backup your blog's contents in case of something happening and you want to restore it all?
Last Answer : Yes this is possible, and highly recommended to do every month at least. Is your blog a Wordpress.com blog, or do you have a Wordpress installation on your own server? Here are the instructions for if it' ... very easy - I do regular backups of my blog twice a month and it takes only a few seconds.
Description : Time capsule: i need to format my powerbook harddrive and wonder if i could restore my programms with the time machine backup?
Last Answer : answer:try this first: Did you upgrade the operating system and then CS3 stopped working or did you reinstall it? If the upgrade broke it try reinstalling CS3. If that doesn’t work, use this script and then reinstall. If this works it could save you a lot of time and effort.
Description : What is system restore and backup process ?
Last Answer : System Restore helps to restore the computer's previous settings. Basically it is a kind of Undo process. As a result, new additions to the computer settings are discarded, but personal files such as documents ... . To get rid of such problems, you have to take the help of Films Back up System
Last Answer : You can back up all the data on your phone to your attached mail account if you wish. For this go to settings , from there click on Backup & reset option. Now check the Back up my ... restore options. Now even if there is any loss of the phone, all the data will be restored automatically.
Description : How to create backup or restore Quicken data?
Last Answer : You can do this using Quicken cloud service. With the cloud service, they give you 5GB of data in your Dropbox account. There are 2 different files in Quicken that have the same file name. They will end in the ... do a lot of entries each day it is a good idea to make a daily backup of this file.
Description : Backup & Restore in Windows 7?
Last Answer : Many of us have our work and personal lives tied up in the datathat we store on our computers. A complete loss of data due tosystem failure is unthinkable and unacceptable. Therefore, in orderto ... mostsophisticated needs.In order to set up backup in Windows 7, access Computer in theWindows menu. T
Description : ________ is a windows utility program that locates and eliminates unncessary fragments and rearranges filed and unused disk space to optimize operations a) Backup b) Disk cleanup c) Disk defragmenter d) Restore e) None of these
Last Answer : c) Disk defragmenter
Description : What's the best way to back up my info? Do you back up your entire computer or just certain files, photos, and songs? Online backup versus backup hard drives, and all other options?
Last Answer : answer:I’d go with both online and hard drive. Hard drives don’t do any good if your house gets flooded and both your computer and your backup hard drive get destroyed. You don’t have to back up everything, just documents, music, pictures…
Description : What strategies are available for backing-up an Oracle database? (for DBA
Last Answer : The following methods are valid for backing-up an Oracle database: Export/Import - Exports are "logical" database backups in that they extract logical definitions and data from the database to a file. ... , etc. If your database is in ARCGIVELOG mode, you also need to backup archived log files.
Description : What are the different methods of backing up oracle database ?
Last Answer : Logical Backups - Cold Backups - Hot Backups (Archive log)
Description : How does one manage Oracle database users? (for DBA
Last Answer : Oracle user accounts can be locked, unlocked, forced to choose new passwords, etc. For example, all accounts except SYS and SYSTEM will be locked after creating an Oracle9iDB database using the DB ... locked users account ALTER USER scott PASSWORD EXPIRE; -- Force user to choose a new password
Last Answer : Oracle user accounts can be locked, unlocked, forced to choose new passwords, etc. For example, all accounts except SYS and SYSTEM will be locked after creating an Oracle9iDB database using the ... from SYS.V$BH log buffer spaces Increase LOG_BUFFER parameter or move log files to faster disks
Description : What are the roles and user accounts created automatically with the database?
Last Answer : DBA - role Contains all database system privileges. SYS user account - The DBA role will be assigned to this account. All of the base tables and views for the database's dictionary ... administrative information and internal tables and views used by oracle tools are created using this username.
Description : What are the responsibilities of a Database Administrator ?
Last Answer : Installing and upgrading the Oracle Server and application tools. Allocating system storage and planning future storage requirements for the database system. Managing primary database structures ... tape Backing up and restoring the database. Contacting Oracle Corporation for technical support.
Description : How does one create a standby database? (for DBA)
Last Answer : While your production database is running, take an (image copy) backup and restore it on duplicate hardware. Note that an export will not work!!! On your standby database, issue ... the standby database, stop the recovery process and activate it: ALTER DATABASE ACTIVATE STANDBY DATABASE;