Oracle Archivelog mode and non-archivelog mode conversion

The recent integration environment when the archive log is full, the database is unable to log in, ask the DBA to find out, privately according to the DBA's search scheme, take the development environment to do a database mode switch, in order to do the synchronization monitoring analysis problem, this gives the data path

First Use DBA login, link to database after use

Sqlplus/as Sysdba;

Archive Log list

View the current database archive mode after it is indeed archived or non-archived.
Use

Shutdwon Immediate

Close the database,
Then use

Startup Mount

command to open the data in the Mount State
use

alter  database  archivelog
2   or
3  alter  database  noarchivelog

Keep the database in archive or non-archival mode
Again through

1 Archive log list

Confirm Archive Mode again
You might also want to use

1 Archive log start

Turn on automatic archiving
Finally don't forget

1 ALTER DATABASE open

Open Database

This article is from the "Summary of problems encountered" blog, please be sure to keep this source http://4184212.blog.51cto.com/4174212/1672117

Oracle Archivelog mode and non-archivelog mode conversion