Oracle 非归档--归档操作流程

时间:2021-10-02 15:10:40

转载自链接  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;(注意末尾带分号)