|
|||||
|
我们知道跨平台表空间传输是在Oracle10g以后实现的，用RMAN命令可以完成。 那么在Oracle9i数据库中到底跨平台表空间传输能不能够实现呢？Oracle官方文档中提到： The source and target database must be on the same hardware platform. For example, you can transport tablespaces between Sun Solaris Oracle databases, or you can transport tablespaces between Windows NT Oracle databases. However, you cannot transport a tablespace from a Sun Solaris Oracle database to an Windows NT Oracle database. . . . → Read More: Transporting Oracle9i Tablespaces from Solaris to HP-UX 今天在客户处测试Oracle 9.2.0.8 on HP-UX IA64的RAC Failover功能，遇到ORA-01034错误。 表现为： 当关闭RAC环境的某一个实例之后（无论是shutdown abort还是shutdown immediate），再用远程客户端通过tns连接RAC Service都会间歇性报ORA-01034错误。 $ sqlplus system/oracle@prod SQL*Plus: Release 9.2.0.8.0 – Production ON Tue Nov 17 20:52:09 2009 Copyright (c) 1982, 2002, Oracle Corporation. ALL rights reserved. ERROR: ORA-01034: ORACLE NOT available ORA-27101: shared memory realm does NOT exist HPUX-ia64 Error: 2: No such . . . → Read More: How to resolve ORA-01034 when RAC failover 操作系统版本：Solaris 5.8 Sparc 64bit 数据库版本：Oracle 9.2.0.1 一直以为”alter database recover”和”recover database”这两个命令除了前者是SQL命令后者是SQL*PLUS命令之外，其它都是相同的，实际上却有所出入。 在所有需要的归档日志都存在的相同前提下。alter database recover命令无法继续。 SQL> ALTER DATABASE recover USING backup controlfile until cancel; ALTER DATABASE recover USING backup controlfile until cancel * ERROR at line 1: ORA-00279: CHANGE 10402260063 generated at 10/31/2009 01:30:52 needed FOR thread 1 ORA-00289: suggestion : /xf_arch1/log9565_1.arc ORA-00280: CHANGE 10402260063 FOR . . . → Read More: “Alter Database Recover” Vs “Recover Database” |
|||||
|
Copyright © 2010 Chanel [K] - All Rights Reserved |
|||||
