×

Loading...
Ad by
  • 最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。
Ad by
  • 最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。

@Florida

how to restore a oracle database as new database name?

whygh(studing)
am new to Oracle. From Yesterday, I installed a Oracle 11g Database and took me 3 hours to figure out how to do a full backup. After that, I want to test how to restore it as new db and not overwrite the old db.

is there a GUI tool I can implement it? or How can I do this from RMAN/SQLPLUS?

I have a full backup from EM. It is including datafile , archivelog and control file. names like below.

O1_MF_NNNDF_BACKUP_SAMPLE.MEDI_0_48N74O9Z_.BKP
O1_MF_NCSNF_BACKUP_SAMPLE.MEDI_0_48N78PO7_.BKP
O1_MF_ANNNN_BACKUP_SAMPLE.MEDI_0_48N7923N_.BKP


And another question, I have a new project which will use Oracle. Client will provide us Database and I will restore it to our Oracle Server.
which kind of format for me is easy to install this DB?
1. Directly cold copy.
2. full backup
(#4579278@0)
Last Updated: 2008-7-25
This post has been archived. It cannot be replied.
Report

Replies, comments and Discussions:

  • 工作学习 / 学科技术讨论 / how to restore a oracle database as new database name? -whygh(studing); 2008-7-25 {793} (#4579278@0)
    am new to Oracle. From Yesterday, I installed a Oracle 11g Database and took me 3 hours to figure out how to do a full backup. After that, I want to test how to restore it as new db and not overwrite the old db.

    is there a GUI tool I can implement it? or How can I do this from RMAN/SQLPLUS?

    I have a full backup from EM. It is including datafile , archivelog and control file. names like below.

    O1_MF_NNNDF_BACKUP_SAMPLE.MEDI_0_48N74O9Z_.BKP
    O1_MF_NCSNF_BACKUP_SAMPLE.MEDI_0_48N78PO7_.BKP
    O1_MF_ANNNN_BACKUP_SAMPLE.MEDI_0_48N7923N_.BKP


    And another question, I have a new project which will use Oracle. Client will provide us Database and I will restore it to our Oracle Server.
    which kind of format for me is easy to install this DB?
    1. Directly cold copy.
    2. full backup
    • when you do backup, in command line try to do this, supposed the username=abc(in oracle db name=user name) -thunderbolt(孙悟空); 2008-7-27 {235} (#4581237@0)
      backup:
      exp abc/password@dbname file=mybackup.dmp compress=y

      first create a username: like def, you can use the admin console do that:

      restore:
      imp abc/password@dbname file=mybackup.dmp fromuser=abc touser=def

      hope this help

More Topics

  • 看大家讨论日语，俺也正在认真学习。其实语言问题应该是很快也很容易就解决的，可能比自动驾驶来的还快。TREK里面，全宇宙的人都在大脑里安装了UNIVERSAL TRANSLATOR，外星人之间相互交流无障碍。废话少说，看视频。。。加上个MIC和耳机，不同国家的人就可以无障碍交流。
  • 肉脸真有搞 IT 的？Linux 把俄国中国伊朗踢出去了好像肉脸 IT 没啥感觉似的
  • 请问web developer和software developer技术上有什么区别？
  • Elon Musk 带着川普总统奔向火星了。
  • 扔硬币的实验研究
    • 枫下论坛主坛 /  工作学习 /  学科技术讨论