ORA
文章平均质量分 73
daimin1983
Contact:Coffey-19830413@hotmail.com
Knowing is not enough; we must apply.
Willing is not enough; we must do;
Doing is not enough,we must think;
Thinking is not enough ,we must test;
展开
-
RMAN备份错误ORA-19502的学习
RMAN备份错误ORA-19502的学习系统平台:Linux AS 3数据库版本:SQL> select * from v$version;BANNER----------------------------------------------------------------Oracle9i Enterprise Edition Release 9.2.0.4.0 - Productio原创 2008-08-24 10:05:00 · 8526 阅读 · 0 评论 -
ORA-00119和ORA-00132错误解决
手动创建数据库时,将/opt/oracle/product/10.2.0/dbs/下的初始文件initGE02.ora中的语句local_listener=LISTENER_GE02释放出来之后,关闭数据库然后重新启动数据库时,出现下面的错误:SQL> startupORA-00119: invalid specification for system parameter LOCAL_LISTE原创 2008-08-31 17:20:00 · 3673 阅读 · 0 评论 -
ORA-19554: error allocating device, device type: SBT_TAPE, device name
执行了下面的语句之后CONFIGURE DEVICE TYPE sbt PARALLELISM 1;CONFIGURE DEFAULT DEVICE TYPE sbt;由于自己的数据库没有配置sbt,所以出现下面的错误:RMAN> CROSSCHECK BACKUP OF DATABASE;RMAN-00571: =========================================原创 2008-10-18 08:44:00 · 12972 阅读 · 1 评论 -
ORA-01251: Unknown File Header Version read for file number 9 错误解决
ORA-01251: Unknown File Header Version read for file number 9 错误解决SQL> startupORACLE instance started.Total System Global Area 608174080 bytesFixed Size 1220820 bytesVariable Si原创 2008-11-05 13:42:00 · 6987 阅读 · 0 评论 -
学习Mechanics of Datafile Restore Operations的注意点
学习Mechanics of Datafile Restore Operations的注意点When you issue a RESTORE command, RMAN directs a server session to restore a suitable backup to either: The default location, overwriting the fi原创 2008-11-02 17:21:00 · 744 阅读 · 0 评论 -
ORA-01152 file 1 was not restored from a sufficiently old backup解决过程
[oracle@localhost ~]$ export ORACLE_SID=ge[oracle@localhost ~]$ sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 29 19:03:33 2008Copyright (c) 1982, 2005, Oracle. All rights reserve原创 2008-12-29 20:43:00 · 19349 阅读 · 0 评论 -
ORA-16038、ORA-19809、ORA-00312问题的学习总结
今天在启动自己windowns下的oracle时,遇到如下的情况:Microsoft Windows XP [版本 5.1.2600](C) 版权所有 1985-2001 Microsoft Corp.D:/Documents and Settings/Administrator>sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production on原创 2008-11-09 21:38:00 · 1035 阅读 · 0 评论 -
RMAN-06585: no copy of datafile 7 found 问题解决
RMAN-06585: no copy of datafile 7 found 问题解决今天在学习backup copy of 命令时出现 RMAN-06585: no copy of datafile 7 found错误,研究了好长时间,才解决,原来是自己看文档不够仔细造成的。This form of backup is used to back up a database back原创 2008-11-22 13:56:00 · 1393 阅读 · 0 评论 -
EXP时发生ORA-00932错误的解决
EXP时发生ORA-00932错误的解决[oracle@localhost ~]$ exp rman/rman@CATA file=/opt/cata.dmp owner=rmanExport: Release 10.2.0.1.0 - Production on Sat Jan 31 21:22:06 2009Copyright (c) 1982, 2005, Oracle. All rig原创 2009-01-31 21:44:00 · 2561 阅读 · 0 评论