• 博客访问: 3072699
  • 博文数量: 67
  • 用 户 组: 普通用户
  • 注册时间: 1970-01-01 08:00
个人简介

鏆傛棤浠嬬粛

文章分类

全部博文(67)

文章存档

2012年(1)

2011年(6)

2010年(2)

2009年(6)

2008年(25)

2007年(27)

发布时间:2008-03-06 16:21:21

Solution1:source:windows2003 32bit,oracle10g 10.2.0.2target:IBM aix 64bit,oracle10g 10.2.0.3,RAC,ASMSolution2:source:HP UX 64bit,oracle10g 10.2.0.3,RAC,ASMtarget:IBM aix 64bit,oracle10g 10.2.0.3,RAC,ASM[@more@]Solution1:source:windows2003 32bit,oracle10g 10.2.0.2GRANT DBA TO xsb IDENTIFIED BY xsb;CREATE TABLESPACE xsbtest_ts DATAFILE 'D:ORACLEPRODUCT10.2.0ORADATACSLSCxsbtest_ts01.DBF' SIZE 5m;SELECT * FROM v$datafile;CREATE TABLE xsb.t1 TABLESPACE xsbtest_ts AS SELECT * FROM dba_users;SELECT ......【阅读全文】

阅读(2623) | 评论(0) | 转发(0)

发布时间:2008-03-06 16:12:16

HP UX,Oracle10g 10.2.0.3,RAC,ASM[@more@]alter tablespace ro_2006_ts read only;rman target /run {allocate channel c1 type disk;backup as compressed backupset(tablespace RO_2006_TS format "/u01/app/oradata/clct_1_arch2/rman2tape/RO_2006_TS_CLCT.RMAN");release channel c1;}show all;CONFIGURE EXCLUDE FOR TABLESPACE RO_2006_TS;run {sql 'alter system archive log current';allocate channel c1 type disk;backup full as compressed backupset(database format "/u01/app/oradata/clct_1_arch2/rman2......【阅读全文】

阅读(2149) | 评论(0) | 转发(0)
给主人留下些什么吧!~~
留言热议
请登录后留言。

登录 注册