|
| 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 Start an instance, Mount the Database and Open the Database. Latest Answer : Steps involved in database startup are as follows
Startup nomount - Instance starts, SGA allocated, Background processes
started
Used during database creation
Startup mount - Control file read, datafiles & online redolog files are
allocated
Used ... Close the Database, Dismount the Database and Shutdown the Instance. Latest Answer : There are the following steps of shutting down the database and it's associated instance:1)Close the database.2) Unmount the database.3)Shut down the instance.1) Close a database:When we close the database, oracle writes all the data and recovery ... An instance can be started in (or later altered to be in) restricted mode so that when the database is open connections are limited only to those whose user Latest Answer : RESTRICT is one of an important option used with an open database.It performs a database startup with the database in the restricted user mode. User must having the privileges of RESTRICT, usually it is used by DBA's only.It is used for ... Exclusive Mode If the first instance that mounts a database does so in exclusive mode, only that Instance can mount the database. Parallel Mode Latest Answer : shared mode and exclusive mode ... Tags : Parallel Server 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 The On-line Redo Log is a set of tow or more on-line redo files that record all committed changes made to the database. Whenever a transaction is committed, the Latest Answer : Redo logs records all the changes to the database whether commited or uncommited. How does it know whether you are committing or rolling back till you commit it. Oracle always thinks positively that everything is going to be commited and writes to the ... 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. What are the different tools available for hot backups. Is it preferable to take it manually all the What are the different tools available for hot backups. Is it preferable to take it manually all the time or it depends on the size of the database. Read Answers (7) | Asked by : rakesh banglore
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
