To change database to archivelog or noarchivelog mode the database has to be in mount stage. If one tries to change the database to archivelog/noarchivelog during mount stage you will receive the following error message. 01:00:04 sys@TESTDB> alter database noarchivelog; alter database noarchivelog * ERROR at line 1: ORA-01507: database not mounted Or if the … Continue reading Change archivelog/noarchivelog
Tag: mode
Database user mode
In SQLServer 2005 one can change the user mode of a database to multi, single or restricted. MULTI_USER - This is the default mode, means multiple user can connect to the database. ALTER DATABASE <DB Name> SET MULTI_USER SINGLE_USER - In single user mode only one connection is allowed at at time to the database. … Continue reading Database user mode
alexlima.com 