![]() 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 ... 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. Rolling forward to recover data that has not been recorded in data files, yet has been recorded in the on-line redo log, including the contents of rollback segments. Rolling back Latest Answer : Crash recovery is performed by SMON when database started after an instance crash or after a shutdown abort.
Since during crash current transactions are present in redolog files and not yet been written to corresponding files so the
SCN number of ... 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 ... Read Answers (1) | Asked by : shiva What are the steps to creating a password authentication file? Latest Answer : There are two types of authenticationsOS levelDB levelFor OS level authentication:1. Shutdown the database2. Set OS_AUTHENT_PREFIX=' ' in init.ora file3.$ connect '/ as sysdba'4. > startup5.> create user ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||