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 ...
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 ...
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 ...
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 ...
A mirrored on-line redo log consists of copies of on-line redo log files physically located on separate disks, changes made to one member of the group are made to all members.
Latest Answer: mirrored redologfile is the same copy of redologfile,when lgwr writes in the redologfile the same will be in the mirrored redofile.it is useful when original redo is corrupt database can recover from mirrored redologfile. ...
Archived Redo Log consists of Redo Log files that have archived before being reused.
Latest Answer: Answer: The archived redo log consists of archived redo logfile copies that have archived before being reused. ...
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.
View page << Previous 1 2 3 [4] 5 Next >>
Go Top
