10g启动归档模式及报ORA-00265错处理
来源:互联网 发布:wp软件怎么打开 编辑:程序博客网 时间:2024/06/05 01:05
1)问题原因及现象简单说明:3)mount数据库,再alter为archivel模式则恢复正常4)查看归档信息5)修改归档位置6)修改最大log_archive个数7)修改log_archive格式
因虚拟机非正常关机(数据库也非正常关机),再次启动startup mount,修改为archivel模式的时候提示2)正常启动数据库,然后再正常关闭
SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
SQL> alter database open;
Database altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
Database altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> alter database archivelog;
Database altered.
SQL> select log_mode from v$database;
LOG_MODE
------------------------
ARCHIVELOG
SQL>
Database altered.
SQL> select log_mode from v$database;
LOG_MODE
------------------------
ARCHIVELOG
SQL>
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 4
Next log sequence to archive 6
Current log sequence 6
SQL>
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 4
Next log sequence to archive 6
Current log sequence 6
SQL>
SQL> alter system set log_archive_dest_1='location=/opt/oracle/archive_log/archive_log';
System altered.
SQL>show parameter log_archive_dest_1
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
log_archive_dest_1 string location=/opt/oracle/archive_l
og/archive_log
log_archive_dest_10 string
SQL>
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /opt/oracle/archive_log/archive_log
Oldest online log sequence 4
Next log sequence to archive 6
Current log sequence 6
SQL>
System altered.
SQL>show parameter log_archive_dest_1
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
log_archive_dest_1 string location=/opt/oracle/archive_l
og/archive_log
log_archive_dest_10 string
SQL>
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /opt/oracle/archive_log/archive_log
Oldest online log sequence 4
Next log sequence to archive 6
Current log sequence 6
SQL>
SQL> alter system set log_archive_max_processes = 5;
System altered.
SQL>
System altered.
SQL>
SQL> show parameter log_archive_format
NAME TYPE VALUE
------------------------------------ ---------- ------------------------------
log_archive_format string %t_%s_%r.dbf
SQL> alter system set log_archive_format = "archive_%t_%s_%r.log" scope=spfile;
System altered.
SQL> show parameter log_archive_format
NAME TYPE VALUE
------------------------------------ ---------- ------------------------------
log_archive_format string %t_%s_%r.log
SQL>
NAME TYPE VALUE
------------------------------------ ---------- ------------------------------
log_archive_format string %t_%s_%r.dbf
SQL> alter system set log_archive_format = "archive_%t_%s_%r.log" scope=spfile;
System altered.
SQL> show parameter log_archive_format
NAME TYPE VALUE
------------------------------------ ---------- ------------------------------
log_archive_format string %t_%s_%r.log
SQL>
本文出自 “Focus on Oracle” 博客,请务必保留此出处http://alexy.blog.51cto.com/6115453/1072670
- 10g启动归档模式及报ORA-00265错处理
- xtrabackup启动报错处理
- zabbix_agentd 启动报错处理
- ORA-00257报错处理过程
- ORA-600[6122]报错处理
- ORA-00600: [kcratr1_lastbwr] 报错处理办法
- ora-28002报错处理步骤
- 在Oracle 10g里启动自动归档模式
- Oracle 10g里启动自动归档模式
- 启动Eclipse workspace 报错处理
- centos6.5启动报错处理
- @Override 的作用及报错处理
- crontab格式示例及报错处理
- oracle 11g开启归档模式及修改归档目录
- oracle数据库impdp报错处理ORA-39083、ORA-00959、ORA-39171、ORA-01653
- ORA-00979: not a GROUP BY expression报错处理
- ORACLE11G ORA-32004 报错处理方法(总结)
- 用expdp导出时遇到ORA-12170报错处理
- 10g管理EM控制台
- 10g的exp出数据出现“Export terminated successfully with warnings”
- 10g的sqlplus区分大小写问题
- 10g直接删除数据文件后的启动
- 10g配置isqlplus
- 10g启动归档模式及报ORA-00265错处理
- solaris10出现crontab无法正常编辑问题
- 10g安装出现oraInventory目录问题
- solaris10下shell常用
- c与c#数据类型对应关系
- solaris10中wuftp配置小实验
- solaris10限制用户访问其他目录
- 11g数据导入10g数据库方法实现
- 10g数据导入9i数据库方法实现