×

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

@Calgary

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

  • 现在社区游泳池招救生员巡逻，过一会还要不停的点人头，这工作是否很快就被AI代替了，装一个摄像头后面是AI处理系统，这样只招一个等着救人就行了，人头沉下水一定时间立马强光照射，还可以分析水下人的状况来判断是否溺水等
  • 新冠疫苗引发心肌炎? 最新研究这样看
  • 这道几何题有解吗?
  • SAM 2 Demo
  • 如何在 AWS EC2 实例上构建 WordPress 应用程序?
    • 枫下论坛主坛 /  工作学习 /  学科技术讨论