转载自链接 https://blog.csdn.net/u013611461/article/details/53558077
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started. Total System Global Area 776646656 bytes
Fixed Size 2232392 bytes
Variable Size 624955320 bytes
Database Buffers 146800640 bytes
Redo Buffers 2658304 bytes
Database mounted.
SQL> alter database archivelog; Database altered. SQL> alter database open; Database altered. SQL> alter system archive log start; System altered. SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 240
Next log sequence to archive 242
Current log sequence 242
###add at 18-10-30 by nod
把Oracle由归档模式改为非归档模式
开始–>运行命令cmd进入命令行模式
1. 使用命令sqlplus以无日志形式打开如下:
sqlplus /nolog;
2. 连接数据库dev.world其中dev是oracle的SID如下:
SQL> conn system/manager @dev.world as sysdba 3. 关闭数据库如下:
SQL> shutdown immediate 4. 启动了实例,并加载了数据库
SQL> startup mount
5. 归档->非归档
SQL> alter database noarchivelog; (注意末尾带分号)
非归档->归档
SQL> alter database archivelog;(注意末尾带分号)
6. 检查是否成功
SQL> archive log list;(注意末尾带分号)