![]() 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 : When using logical backup if we give full=y - that is a full backup.When using RMAN by default it takes full backup and image copy is also full backup since it contains all blocks used and not used ones. But in RMAN terms full backup is part of incremental ... Tags : Backup No. Latest Answer : Of course YESUsing 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 ... 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 : Online redologs name is used since archivelogs are called offline redologs. Online redologs can be in three states current to which lWr is currently writing transaction changes then this current becomes active after it gets filled and logswitch/ckpt ... 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 (8) | Asked by : rakesh banglore
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||