摘要:
事实上,RMAN备份的时候,如果是使用control file 来作catalog,那么一定要把control file和spfile恢复到另外的机器上面。否则,会出现类似如下的错误:原来的实例:[oracle@localhost ~]$ rman target /Recovery Manager: Release 11.2.0.4.0 - Production on Sun Apr 6 15:54:41 2014Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.connected to ta 阅读全文
摘要:
http://www.onlinedbasupport.com/2010/12/10/block-corruption-in-system-datafile/ 阅读全文
摘要:
SQL> startup mount;ORACLE instance started.Total System Global Area 814227456 bytesFixed Size 2257640 bytesVariable Size 528485656 bytesDatabase Buffers 281018368 bytesRedo Buffers 2465792 bytesDatabase mounted.SQL> alter tablespace system rename to system01;alter tablespace system rename to s 阅读全文
摘要:
SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> startup mount;ORACLE instance started.Total System Global Area 814227456 bytesFixed Size 2257640 bytesVariable Size 528485656 bytesDatabase Buffers 281018368 bytesRedo Buffers 2465792 bytesDatabase mount 阅读全文
摘要:
主要是为了学习oracle的克隆。参考:http://www.dba-oracle.com/oracle_tips_db_copy.htm执行:SQL>alter database backup controlfile to trace;对于oracle11g数据库,到 $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/ 目录下查找,进行查看:[oracle@localhost trace]$ cat orcl_ora_4195.trcTrace file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/ 阅读全文
摘要:
4月2日,首先查看系统状况:SQL> show parameter control NAME TYPE VALUE------------------------------------ ----------- ------------------------------control_file_record_keep_time integer 2control_files string /u01/app/oracle/oradata/orcl/c ontrol01.ctl, /u01/app/oracle/ flash_recovery_area/orcl/contr ol02.ctl 阅读全文
摘要:
参考:http://stackoverflow.com/questions/1043096/how-to-list-active-open-connections-in-oracle以sys身份连接进入,执行如下sql 语句:SQL> select substr(a.spid,1,9) pid, substr(b.sid,1,5) sid, substr(b.serial#,1,5) ser#, substr(b.machine,1,6) box, substr(b.username,1,10) username,-- b.server, substr(b.osuser,1,8) os_ 阅读全文
摘要:
错误分析listener 可以正常启动:[oracle@o_target admin]$ cat listener.ora# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora# Generated by Oracle configuration tools.LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0 阅读全文
摘要:
备忘:http://www.cnblogs.com/xwdreamer/archive/2013/10/11/3363451.html 阅读全文
摘要:
SQL> create table tab01(id integer,val varchar(4));Table created.SQL> insert into tab01 values(1,'0001');1 row created.SQL> insert into tab01 values(2,'0002'); 1 row created.SQL> insert into tab01 values(3,'0003');1 row created.SQL> insert into tab01 values(4,& 阅读全文