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.
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: Answer: Media recovery is done,in response to recover a command issued by the DBA.It is also used to make current and to restore changes that were lost when a current datafile went offline with out checkpoint. ...
Latest Answer: Disk migration is noting but, migration of data from one OS dependent database to another Dependent database. The steps involved in this are- first go to your target database and export all your data into flat files-next in the destination database during ...
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 ...
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. ...
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. ...
View page << Previous 1 2 [3] 4 Next >>
Go Top
