ORACLE RMAN CLONE

Oracle Zostaw komentarz

how to clone database by RMAN:
it depends on recovering files from previous backup

  1. create PFILE for new database based on PFILE from source database
    init[db_new].ora
    main changes:
    • db_name
    • control_files
    • audit_file_dest
    • background_dump_dest
    • user_dump_dest
    • core_dump_dest
  2. create password file for new database:
    orapwd file=orapw[db_new] password=[pass]
  3. add new database to listener.ora and tnsnames.ora,
  4. create dirs for new database file,
  5. create directories for trace logs as admin with subdirectories: adump, udump, cdump, bdump,
  6. startup new auxiliary database in nomout mode(! then exit from your session because it will be hang on)
  7. start rman with ORACLE_SID = auxiliary database:
  8. at the auxiliary server run command:
    rman auxiliary / target sys/[sys_pass]@[targetdb_tnsalias] catalog rman/[rman_pass]@[catalogdb_tnsalias]
    you should get an output:
    connected to target database: [db_name] (DBID=[db_id])
    connected to recovery catalog database
    connected to auxiliary database: [db_name] (not mounted)
  9. run script:
    run {
    set newname for datafile 4 to ‚/oracle/oradata/[db_new]/users01.dbf’;
    set newname for datafile 3 to ‚/oracle/oradata/[db_new]/sysaux01.dbf’;
    set newname for datafile 2 to ‚/oracle/oradata/[db_new]/undotbs01.dbf’;
    set newname for datafile 1 to ‚/oracle/oradata/[db_new]/system01.dbf’;
    set newname for datafile 5 to ‚/oracle/oradata/[db_new]/example01.dbf’;
    set newname for tempfile 1 to ‚/oracle/oradata/[db_new]/temp.dbf’;
    duplicate target database to [db_new]
    pfile=/oracle/product/10.2.0/db_1/dbs/init[db_new]aux.ora
    logfile
    ‚/oracle/oradata/[db_new]/redo01.log’ size 50m,
    ‚/oracle/oradata/[db_new]/redo02.log’ size 50m,
    ‚/oracle/oradata/[db_new]/redo03.log’ size 50m;}

    to generate script above use sql at source db:
    spool clonescript.rcv
    select ‚set newname for datafile ‚||file_id||’ to ”’||file_name||”’;’ from dba_data_files order by file_id;
    select ‚set newname for tempfile ‚||file_id||’ to ”’||file_name||”’;’ from dba_temp_files order by file_id;
    spool off;
    and next modify output in vim:
    :% s/ora6\/oradata\/DBSRC/u01\/oradata\/DBAUX\/datafile
    or another script:

    run {
    set until time „to_date(‚2010-07-02:01:00′,’yyyy-mm-dd:hh24:mi’)”;
    configure default device type to sbt;
    configure device type sbt parallelism 2;
    configure auxiliary channel 1 device type sbt parms ‚ENV=(NB_ORA_SERV=server_name,NB_ORA_CLIENT=server_target_name)’;
    configure auxiliary channel 2 device type sbt parms ‚ENV=(NB_ORA_SERV=server_name,NB_ORA_CLIENT=server_target_name)’;
    duplicate target database to [db_new]
    DB_FILE_NAME_CONVERT=(‚[target_path1]/’,'[aux_path]’,
    ‚[target_path2]/’,'[aux_path]’)
    pfile=[pfile_aux_path]/[db_new].ora
    logfile
    ‚[logfile_aux_path]/redo01.log’ size 100m,
    ‚[logfile_aux_path]/redo02.log’ size 100m,
    ‚[logfile_aux_path]/redo03.log’ size 100m;
    }

for more read documentation

Share and Enjoy:
  • Print
  • Facebook
  • Twitter
  • Google Bookmarks

Potrzebujesz pomocy w ORACLE RMAN CLONE ? skontaktuj się z administratorem sieci oraz serwerów.
WordPress - Hosting: Twój hosting - Skórka: N.Design Studio - Spolszczenie: Adam Klimowski.
RSS wpisów RSS komentarzy Zaloguj się