展开

关键词

Python 连接DBF数据库

安装pip install m3-dbfpy # python 2.7使用from dbfpy import dbf def read(): db = dbf.Dbf(attend.DBF,readOnly

50920

记一次DG数据文件无法创建的问题

往期专题请查看www.zhaibibei.cn这是一个坚持Oracle,Python,MySQL原创内容的公众号这个专题讲一些日常运维的异常处理今天讲一个DG环境中给主库增加数据文件时的报错----1. as:oralogmesftoradatamesft19.dbfRecovery was unable to create the file as:oralogmesftmesftoradata19.dbf u01apporacleadminmesftdgbdumpmesftdg_mrp0_17570.trc:ORA-01274: cannot add datafile oralogmesftoradatamesft19.dbf 在正确位置生成需要的数据文件alter database create datafile u01apporacleproduct9.2.0db_1dbsUNNAMED00031 as mesftoralogmesft19.dbf

25420
  • 广告
    关闭

    90+款云产品免费体验

    提供包括云服务器,云数据库在内的90+款云计算产品。打造一站式的云产品试用服务,助力开发者和企业零门槛上云。

  • 您找到你想要的搜索结果了吗?
    是的
    没有找到

    ORACLE修改数据文件路径(四种方式)--转

    .dbf CJCTBS             u01apporacle11oradatachendbcjctbs01.dbf 6 rows selected.创建测试数据conn cjccjc create  201M Nov 29 21:31 undotbs01.dbf -rw-r----- 1 oracle oinstall 314M Nov 29 21:31 example01.dbf -rw-r--  rename file homeoraclecjctbs02.dbf to u01apporacle11oradatachendbcjctbs02.dbf; alter database rename  file homeoraclecjctbs02.dbf to u01apporacle11oradatachendbcjctbs02.dbf * ERROR at line 1: ORA-01511: .dbf 7 rows selected.

    17840

    Oracle移动数据文件

    .dbf ONLINE 5 oradataorcl11gexample01.dbf ONLINE 6 oradataorcl11gtest01.dbf ONLINE 7 oradataORCL11Gdatafileo1 mv oradataORCL11Gdatafileo1_mf_test_j7jgpq7k_.dbf oradataorcl11gtest02.dbf SQL> ! _mf_test_j7jgpq7k_.dbf to oradataorcl11gtest02.dbf; Database altered. .dbf ONLINE 5 oradataorcl11gexample01.dbf ONLINE 6 oradataorcl11gtest01.dbf ONLINE 7 oradataorcl11gtest02 log sysaux01.dbf system01.dbf temp01.dbf undotbs01.dbf users01.dbf $ mv o1_mf_test_j7jfm30c_.dbf oradataorcl11gtest01

    11420

    数据库文件的迁移

    _1.dbf to oravl01oracleTEMP_1.dbf;alter database tempfile oravl01oracleTEMP_1.dbf online;#### system, _1.dbf to oravl01oracleSYSTEM_1.dbf; ! _1.dbf to oravl01oracleSYSAUX_1.dbf; ! _1.dbf to oravl01oracleUNDOTBS_1.dbf; #### logfiles ####! _m1.dbf to oravl01oracleredo_g1_m1.dbf; !

    51140

    java操作dbf文件

    今天才知道原来java可以直接读取dbf文件,不用附加到数据库了 遇到不少问题 mark一下 1),我是win7系统,提示 驱动程序不支持此功能” 需要把vfpodbc.dll降级版本 , 大小为955K ,版本6.1.8630.1 放到C:WindowsSystem32 下载地址百度一下都有 2)、url的db路径为dbf 文件存放的路径,不要指向dbf文件 select * from xx为该文件的名 java.sql.Statement; ** * 如果提示 驱动程序不支持此功能” * 更新vfpodbc.dll, 大小为955K,版本6.1.8630.1 放到C:WindowsSystem32 * url的db路径为dbf throws SQLException { try { String url = jdbc:odbc:driver={Microsoft Visual FoxPro Driver}; + SourceType=DBF

    24310

    dataguard备库的数据文件的迁移(r8笔记第22天)

    SQL> host mv homeU01apporacleoradatatest04testdata01.dbf homeU01testdata01.dbf 使用rename datafile来移动数据文件 SQL> alter database rename file homeU01apporacleoradatatest04testdata01.dbf to homeU01testdata01.dbf; .dbf homeU01testdata01.dbf homeU01apporacleoradatatest04testidx01.dbf 6 rows selected. .dbf AVAILABLE ONLINE homeU01apporacleoradatatest04system01.dbf AVAILABLE SYSTEM homeU01testdata01.dbf .dbf 1 homeU01testdata01.dbf 5 homeU01apporacleoradatatest04testidx01.dbf 6 6 rows selected.

    61980

    通过历史控制文件恢复Oracle数据库,只需这10步

    .dbf 18502624u01appdbfileenmochang01.dbf 18502624u01appdbfileenmolob_data01.dbf 18502624u01appdbfileenmooggdata.dbf .dbf 18502624u01appdbfileenmochang01.dbf 18502624u01appdbfileenmolob_data01.dbf 18502624u01appdbfileenmooggdata.dbf .dbf 18261588u01appdbfileenmochang01.dbf 18261588u01appdbfileenmolob_data01.dbf 18261588u01appdbfileenmooggdata.dbf .dbf 18504054u01appdbfileenmochang01.dbf 18504054u01appdbfileenmolob_data01.dbf 18504054u01appdbfileenmooggdata.dbf .dbf 18504055u01appdbfileenmochang01.dbf 18504055u01appdbfileenmolob_data01.dbf 18504055u01appdbfileenmooggdata.dbf

    25710

    只需这10步,通过历史控制文件恢复数据库

    .dbf 18502624u01appdbfileenmochang01.dbf 18502624u01appdbfileenmolob_data01.dbf 18502624u01appdbfileenmooggdata.dbf .dbf 18502624u01appdbfileenmochang01.dbf 18502624u01appdbfileenmolob_data01.dbf 18502624u01appdbfileenmooggdata.dbf .dbf 18261588u01appdbfileenmochang01.dbf 18261588u01appdbfileenmolob_data01.dbf 18261588u01appdbfileenmooggdata.dbf .dbf 18504054u01appdbfileenmochang01.dbf 18504054u01appdbfileenmolob_data01.dbf 18504054u01appdbfileenmooggdata.dbf .dbf 18504055u01appdbfileenmochang01.dbf 18504055u01appdbfileenmolob_data01.dbf 18504055u01appdbfileenmooggdata.dbf

    23910

    使用bbed读取数据文件

    5138022402 u01apporacleoradataorclundotbs01.dbf 524288003 u01apporacleoradataorclsysaux01.dbf 2936012804 u01apporacleoradataorclusers01.dbf 52428805 u01apporacleoradataorclexample01.dbf 104857600? .dbf 21474836485 oradatamesassymesassy1.dbf 214748364806 oradatamesassymesassy2.dbf 214748364807 oradatamesassymesassy3 .dbf 214748364808 oradatamesassymesassy4.dbf 214748364809 oradatamesassymesassy6.dbf 2147483648010 oradatamesassymesassy5 .dbf 2147483648011 oradatamesassymesassy7.dbf 214748364802.

    14430

    一步步使用RMAN还原数据库

    _01.dbf; SET NEWNAME FOR DATAFILE 10 to dcprodoradatadcb2b_idx01.dbf; SET NEWNAME FOR DATAFILE 11 to 13 to dcprodoradatadcdm_idx01.dbf; SET NEWNAME FOR DATAFILE 14 to dcprodoradatadclegacy01.dbf; RESTORE .dbf size 20408M ; SQL>alter tablespace temp add tempfile dcprodoradatatemp02.dbf size 20408M ;7. .dbf; alter database rename file oracleNP1mirrlogBlog_g6m2.dbf to qastest2oracleNP1mirrlogBlog_g6m2.dbf ; alter database rename file oracleNP1origlogBlog_g6m1.dbf to qastest2oracleNP1origlogBlog_g6m1.dbf;8

    21920

    RMAN 数据库克隆文件位置转换方法

    u01databasesybo3oradatasysaux01.dbf u02databasesybo3oradataundotbs01.dbf u02databasesybo3oradatausers01 .dbf u02databasesybo3oradataexample01.dbf --auxiliary db path: u01databasesybo5oradatasystem01.dbf u01databasesybo5oradatasysaux01 .dbf u02databasesybo5oradataundotbs01.dbf u02databasesybo5oradatausers01.dbf u02databasesybo5oradataexample01 .dbf; set newname for datafile 5 to u01databasesybo5oradataexample01.dbf; set newname for tempfile 1 .dbf TO u01databasesybo5oradataundotbs01.dbf;CONFIGURE AUXNAME FOR DATAFILE u01databasesybo3oradatausers01

    30310

    Oracle 单实例数据库修改数据文件路径

    .dbf 3 UNDOTBS1 30apporacleoradataJiekeXutestusers01.dbf 4 USERS 6.6784668apporacleoradataJiekeXutestrhzx01 19 21:00 system01.dbf-rw-r----- 1 oracle oinstall 1326456832 Jul 19 17:00 temp01.dbf-rw-r----- 1 oracle .dbf to testdataapporacleoradataJiekeXutestundotbs01.dbf;alter database rename file apporacleoradataJiekeXutestusers01 .dbf to testdataapporacleoradataJiekeXutestusers01.dbf; alter database rename file apporacleoradataJiekeXutestrhzx01 .dbf to testdataapporacleoradataJiekeXutestrhzx01.dbf;--alter database rename file appproduct11.2.0dbdbsD

    26340

    Linux rsync实现断点续传

    =69)DB3.dbf 8380416 100% 5.57MBs 0:00:01 (xfer#3, to-check=59)DB4.dbf 41959424 100% 6.64MBs 0:00:06 ( xfer#4, to-check=49)DB5.dbf 76021760 100% 12.90MBs 0:00:05 (xfer#5, to-check=39)DB6.dbf 80347136 79% 4194304 100% 102.51MBs 0:00:00 (xfer#1, to-check=79)DB2.dbf 41959424 100% 64.44MBs 0:00:00 (xfer#2, to-check=69)DB3.dbf 8380416 100% 11.38MBs 0:00:00 (xfer#3, to-check=59)DB4.dbf 41959424 100% 37.40MBs 0:00:01 (xfer#4, to-check=49)DB5.dbf 76021760 100% 47.14MBs 0:00:01 (xfer#5, to-check=39)DB6.dbf 100597760

    1.4K20

    Oracle 冷备份

    .dbf EXAMPLE AVAILABLE ONLINE u01apporacleoradataorcltbs1_1.dbf TBS1 AVAILABLE ONLINE u01apporacleoradataorcltbs1 .dbf u01apporacleoradataorclsysaux01.dbf u01apporacleoradataorclusers01.dbf u01apporacleoradataorclexample01 .dbf u01apporacleoradataorcltbs1_1.dbf u01apporacleoradataorcltbs1_2.dbf --查看临时文件 SQL> select name from users01.dbf control02.ctl redo1a.rdo redo3a.rdo tbs1_1.dbf example01.dbf redo1b.rdo redo3b.rdo tbs1_ 2.dbf initorcl.ora redo2a.rdo sysaux01.dbf undotbs01.dbf四、总结 优点 冷备模式下概念易于理解,即将需要备份的文件复制到安全的位置 操作比较简单,

    28520

    SYSAUX表空间管理及恢复

    users01.dbf control02.ctl redo1a.rdo redo3a.rdo tbs1_1.dbf example01.dbf redo1b.rdo redo3b.rdo tbs1_ 2.dbf initorcl.ora redo2a.rdo sysaux01.dbf undotbs01.dbf SQL> ho rm u01apporaclecoolbak* --将冷备路径下先前的备份文件删除 .dbf EXAMPLE u01apporacleoradataorclexample01.dbf TBS1 u01apporacleoradataorcltbs1_1.dbf TBS1 u01apporacleoradataorcltbs1 --sysaux01.dbf在系统中不存在,即丢失 ls: u01apporacleoradataorclsysaux01.dbf: No such file or directory SQL> ho --还原sysaux01.dbf SQL> ho cp $ORACLE_BASEhotbaksysaux01.dbf $ORACLE_BASEoradataorcl --恢复sysaux01.dbf并将数据库置于

    32120

    追本溯源:Oracle 只读表空间的探索实践

    AVAILABLE SYSTEMoracleoradatatestsysaux01.dbf AVAILABLE ONLINEoracleoradatatestundotbs01.dbf AVAILABLE AVAILABLE SYSTEMoracleoradatatestsysaux01.dbf AVAILABLE ONLINEoracleoradatatestundotbs01.dbf AVAILABLE ,oracleoradatatestsysaux01.dbf,oracleoradatatestundotbs01.dbf,oracleoradatatestusers01.dbfCHARACTER SET ,14 oracleoradatatestsysaux01.dbf,15 oracleoradatatestundotbs01.dbf,16 oracleoradatatestusers01.dbf17 .dbf AVAILABLESYSTEMoracleoradatatesthzh01.dbf AVAILABLE ONLINEoracleoradatatesthzh02.dbf AVAILABLE ONLINE

    23230

    实验Oracle数据文件被误删除的场景恢复

    2 u03oradataPROD2sysaux01.dbf 3 u03oradataPROD2undotbs01.dbf 4 u03oradataPROD2users01.dbf 5 u03oradataPROD2example01 .dbf SQL> ! .dbf SQL> ! rm u03oradataPROD2example01.dbf SQL> ! (deleted)$ cp 261 u03oradataPROD2example01.dbf恢复之后,数据库没有发现有异常报错,继续进行操作或重启库都没有问题。

    21230

    Oralce OMF 功能详解

    u01apporacleoradataorclundotbs01.dbf u01apporacleoradataorclsysaux01.dbf u01apporacleoradataorclusers01 .dbf u01apporacleoradataorclexample01.dbf u01apporacleoradataorclTest.dbf u01apporacleoradataorclORCLdatafileo1 u01apporacleoradataorclundotbs01.dbf u01apporacleoradataorclsysaux01.dbf u01apporacleoradataorclusers01 u01apporacleoradataorclundotbs01.dbf u01apporacleoradataorclsysaux01.dbf u01apporacleoradataorclusers01 u01apporacleoradataorclundotbs01.dbf u01apporacleoradataorclsysaux01.dbf u01apporacleoradataorclusers01

    39520

    【DB宝27】在Oracle 19c中创建容器数据库(4)--Duplicating a CDB(从18c开始)

    .dbf; set newname for datafile 5 to optoracleoradataCDB2pdbseedsystem01.dbf; set newname for datafile .dbf; set newname for datafile 8 to optoracleoradataCDB2pdbseedundotbs01.dbf; set newname for datafile .dbf; set newname for datafile 11 to optoracleoradataCDB2ORCLPDB1undotbs01.dbf; set newname for datafile .dbf, optoracleoradataCDB2pdbseedsysaux01.dbf, optoracleoradataCDB2users01.dbf, optoracleoradataCDB2pdbseedundotbs01 .dbf, optoracleoradataCDB2ORCLPDB1sysaux01.dbf, optoracleoradataCDB2ORCLPDB1undotbs01.dbf, optoracleoradataCDB2ORCLPDB1users01

    20530

    相关产品

    • 消息队列 TDMQ

      消息队列 TDMQ

      消息队列 TDMQ 是基于 Apache 顶级开源项目Pulsar自研的金融级分布式消息中间件,是一款具备跨城高一致、高可靠、高并发的分布式消息队列,拥有原生Java 、 C++、Python、GO 多种API, 支持 HTTP 协议方式接入,可为分布式应用系统提供异步解耦和削峰填谷的能力,同时也具备互联网应用所需的海量消息堆积、高吞吐、可靠重试等特性。

    相关资讯

    热门标签

    活动推荐

      运营活动

      活动名称
      广告关闭

      扫码关注云+社区

      领取腾讯云代金券