双语网站建设费用,手机软件怎么做出来的,福州建设网站效果,网站搭建百家号Oracle非归档模式MediaRecovery错误之--ORA-26040系统环境#xff1a;操作系统#xff1a;LinuxRH55Oracle#xff1a;Oracle11gR2模拟案例#xff1a;1、查看数据库模式18:12:36SYSprodarchiveloglisOracle非归档模式Media Recovery错误之--ORA-26040系统环境#xff1a;…Oracle非归档模式MediaRecovery错误之--ORA-26040系统环境操作系统LinuxRH55OracleOracle11gR2模拟案例1、查看数据库模式18:12:36SYSprodarchiveloglisOracle非归档模式Media Recovery错误之--ORA-26040系统环境操作系统Linux RH55Oracle Oracle 11gR2模拟案例1、查看数据库模式18:12:36 SYS prodarchive log list;Database log mode No Archive ModeAutomatic archival DisabledArchive destination /dsk4/arch1Oldest online log sequence 1Current log sequence 32、创建新的Tablespace18:13:19 SYS prodcreate tablespace tbs218:13:30 2 datafile /u01/app/oracle/oradata/prod/tbs2.dbf size 10m;Tablespace created.3、对数据库进行冷备[oraclerh6 ~]$ rman target /Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jul 24 18:14:30 2014Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.connected to target database: PROD (DBID239333010)RMAN run {2 shutdown immediate;3 startup mount;4 backup database format /dsk3/bak/%s_%d.bak;5 alter database open;6 }4、备份完成在新的Tablesapce上创建Object18:19:40 SYS prodconn scott/tigerConnected.18:30:13 SCOTT prodcreate table t1 tablespace tbs2 as select * from emp;Table created.Elapsed: 00:00:01.0018:30:45 SCOTT prodselect count(*) from t1;COUNT(*)----------14Elapsed: 00:00:00.0218:30:56 SCOTT prodinsert into t1 select * from t1 where rownum1;1 row created.Elapsed: 00:00:00.0218:31:16 SCOTT prodcommit;Commit complete.Elapsed: 00:00:00.0418:31:18 SCOTT prodinsert into t1 select * from t1 where rownum1;1 row created.Elapsed: 00:00:00.0118:31:23 SCOTT prodselect count(*) from t1;COUNT(*)----------165、查看Redo Log信息18:32:14 SYS prodselect group#,sequence# ,status from v$log;GROUP# SEQUENCE# STATUS---------- ---------- ----------------1 4 CURRENT2 2 INACTIVE3 3 INACTIVEElapsed: 00:00:00.056、模拟数据文件被破坏[oraclerh6 ~]$ rm /u01/app/oracle/oradata/prod/tbs2.dbf18:32:28 SYS prodshutdown abortORACLE instance shut down.重新启动Instance到mount查看redo log日志没有发生switch18:33:06 SYS prodstartup mount;ORACLE instance started.Total System Global Area 835104768 bytesFixed Size 2217952 bytesVariable Size 775948320 bytesDatabase Buffers 54525952 bytesRedo Buffers 2412544 bytesDatabase mounted.18:33:42 SYS prodselect group#,sequence# ,status from v$log;GROUP# SEQUENCE# STATUS---------- ---------- ----------------1 4 CURRENT3 3 INACTIVE2 2 INACTIVEOpen database出现数据文件丢失错误18:34:17 SYS prodalter database open;alter database open*ERROR at line 1:ORA-01157: cannot identify/lock data file 9 - see DBWR trace fileORA-01110: data file 9: /u01/app/oracle/oradata/prod/tbs2.dbf本文原创发布php中文网转载请注明出处感谢您的尊重