FAQ
I tried to clone ORACLE database use one week ago RMAN (10Gr2) database backup. Clone database also on same server but different instance name.

Anyone know how to do it?

Thanks.

Search Discussions

  • LS Cheng at Feb 7, 2012 at 3:35 pm
    rman duplicate command?
    regards

    --
    LSC

    On Tue, Feb 7, 2012 at 4:19 PM, dba1 mcc wrote:

    I tried to clone ORACLE database use one week ago RMAN (10Gr2) database
    backup. Clone database also on same server but different instance name.

    Anyone know how to do it?

    Thanks.
    --
    http://www.freelists.org/webpage/oracle-l


    --
    http://www.freelists.org/webpage/oracle-l
  • Surachart Opun at Feb 7, 2012 at 3:51 pm
    Please check this
    http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmdupdb.htm
    DUPLICATE TARGET DATABASE TO <dupdb>
    Surachart Opun
    http://surachartopun.com
    skye: surachart_op



    On Tue, Feb 7, 2012 at 10:19 PM, dba1 mcc wrote:

    I tried to clone ORACLE database use one week ago RMAN (10Gr2) database
    backup. Clone database also on same server but different instance name.

    Anyone know how to do it?

    Thanks.
    --
    http://www.freelists.org/webpage/oracle-l


    --
    http://www.freelists.org/webpage/oracle-l
  • CRISLER, JON A at Feb 7, 2012 at 3:57 pm
    Oracle RAC 11g, AWR reports shoes the metric "rdbms ipc message" as the #1 in Top 5 wait events.

    I have to admit I don't think I have seen this before, and I am not sure where to look-

    11gR2 on Red Hat Linux 5 64 bit, ASM to SAN.

    Any suggestions ?
  • Michael McMullen at Feb 7, 2012 at 4:29 pm
    To me ie (in my environment) that means slow disks. We do a lot of daily
    loads with truncates, whenever we get bad disks or san troubles the
    truncates pile up and that's the wait message or on some boxes it just means
    we've hit a scalability wall with i/o

    -----Original Message-----
    From: oracle-l-bounce@freelists.org
    On Behalf Of CRISLER, JON A
    Sent: Tuesday, February 07, 2012 10:57 AM
    To: oracle-l@freelists.org
    Subject: Wait Event - rdbms ipc message

    Oracle RAC 11g, AWR reports shoes the metric "rdbms ipc message" as the #1
    in Top 5 wait events.

    I have to admit I don't think I have seen this before, and I am not sure
    where to look-

    11gR2 on Red Hat Linux 5 64 bit, ASM to SAN.

    Any suggestions ?
    --
    http://www.freelists.org/webpage/oracle-l



    --
    http://www.freelists.org/webpage/oracle-l
  • Petr Novak at Feb 7, 2012 at 4:50 pm
    Hallo Jon,

    I think the 11G RAC instances communicate more than under 10G. You can try to look in ASH which statements are connected with this wait.

    Best Regards,
    Petr

    ________________________________________
    Von: oracle-l-bounce@freelists.org [oracle-l-bounce@freelists.org]&quot; im Auftrag von &quot;CRISLER, JON A [JC1706@att.com]
    Gesendet: Dienstag, 7. Februar 2012 16:56
    Bis: oracle-l@freelists.org
    Betreff: Wait Event - rdbms ipc message

    Oracle RAC 11g, AWR reports shoes the metric "rdbms ipc message" as the #1 in Top 5 wait events.

    I have to admit I don't think I have seen this before, and I am not sure where to look-

    11gR2 on Red Hat Linux 5 64 bit, ASM to SAN.

    Any suggestions ?
  • Riyaj Shamsudeen at Feb 7, 2012 at 5:25 pm
    Hello Jon
    'rdbms ipc message' simply means exactly that the process is waiting for
    an IPC message. There are many processes which can wait for this event, for
    example, LGWR can wait for this wait event for more work, DBWR can wait
    for this event etc. Usually, this event can be ignored, but not always.
    Question is which process is suffering from this issue? How is it
    affecting the application performance?
    Cheers

    Riyaj Shamsudeen
    Principal DBA,
    Ora!nternals - http://www.orainternals.com - Specialists in Performance,
    RAC and EBS
    Blog: http://orainternals.wordpress.com
    OakTable member http://www.oaktable.com and Oracle ACE Director

    Co-author of the books: Expert Oracle
    Practices<http://tinyurl.com/book-expert-oracle-practices/>,
    Pro Oracle SQL, Expert PL/SQL
    Practices<http://tinyurl.com/book-expert-plsql-practices>


    On Tue, Feb 7, 2012 at 9:56 AM, CRISLER, JON A wrote:

    Oracle RAC 11g, AWR reports shoes the metric "rdbms ipc message" as the #1
    in Top 5 wait events.

    I have to admit I don't think I have seen this before, and I am not sure
    where to look-

    11gR2 on Red Hat Linux 5 64 bit, ASM to SAN.

    Any suggestions ?
    --
    http://www.freelists.org/webpage/oracle-l


    --
    http://www.freelists.org/webpage/oracle-l
  • Lei Zeng at Feb 7, 2012 at 10:37 pm
    Jon:
    Have you checked with ASH report to see which session is/was waiting on this event? Or, whether this wait event is related to specific application user, module, or sql id, object, etc.?
    Wait event is just one dimension when we examine the database’s performance data. From wait event, you can drill down to other dimensions like session, application, sql, sql plan, etc. Usually, if we see one dimension stands out (wait event in this case), we can check other dimensions for either corresponding symptoms, or explanations.
    If you don’t have time to write queries to explore AWR/ASH views, please feel free to try DBspeed http://www.dbspeed.com/product.html
    DBspeed provides lots of the data mining queries for AWR/ASH. You can use it create AWR/ASH report and browse it directly. Very easy to use.
    Lei
    http://www.dbspeed.com/index.html


    ________________________________
    From: "CRISLER, JON A" <JC1706@att.com>
    To: "oracle-l@freelists.org" <oracle-l@freelists.org>
    Sent: Tuesday, February 7, 2012 7:56 AM
    Subject: Wait Event - rdbms ipc message

    Oracle RAC 11g, AWR reports shoes the metric "rdbms ipc message" as the #1 in Top 5 wait events.

    I have to admit I don't think I have seen this before, and I am not sure where to look-

    11gR2 on Red Hat Linux 5 64 bit, ASM to SAN.Â

    Any suggestions ?
  • Steve Wales at Feb 7, 2012 at 3:54 pm
    Try this (at a high level, refer to the documentation for details):

    * Target (Source database) should be up.
    * Login and do: create pfile='/path/to/initclonedb.ora' from spfile;
    * Edit the pfile, change all references from target to clonedb
    - db_name = clonedb
    - instance_name = clonedb
    - setup background_dump_dest, user_dump_dest etc
    - point your control files at the new location
    - setup db_file_name_convert='old','new'
    - setup log_file_name_convert='old','new'
    * Make sure all needed directory structures are created (controlfiles,
    datafiles, log files etc)
    * If windows, make sure services have been created
    * Login to the clonedb, shut it down
    * Start it up again, nomount, with the modified pfile created above
    - startup nomount pfile=/path/to/initclonedb.ora
    * Configure tnsnames.ora and your listener
    * Login to your target and LIST BACKUP SUMMARY to make sure your backups are
    there
    * Set ORACLE_SID to be your clone
    * RMAN TARGET /@target auxiliary /
    * Should show connected to target (open), clonedb (not mounted)
    * Execute:
    Run
    {
    Allocate auxiliary channel aux1 device type disk;
    Set until time "to_date('2012-02-07:06:00:00','YYYY-MM-DD:HH24:MI:SS')";
    Duplicate target database to CLONEDB;
    }

    Then wait for it to finish.

    After it's done, I shut the copy down and set to noarchivelog mode and
    change the password of a couple of accounts so that the passwords are
    different in test then prod etc.

    That should be the gist of it, but check the RMAN documentation for more
    details.

    Steve


    -----Original Message-----
    From: oracle-l-bounce@freelists.org
    On Behalf Of dba1 mcc
    Sent: Tuesday, February 07, 2012 8:20 AM
    To: oracle-db-backup-l@Groups.ITtoolbox.com
    Cc: oracle-l@freelists.org
    Subject: clone database use RMAN backup on same server

    I tried to clone ORACLE database use one week ago RMAN (10Gr2) database
    backup. Clone database also on same server but different instance name.

    Anyone know how to do it?

    Thanks.
    --
    http://www.freelists.org/webpage/oracle-l


    --
    http://www.freelists.org/webpage/oracle-l

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedFeb 7, '12 at 3:20p
activeFeb 7, '12 at 10:37p
posts9
users9
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase