1. Actions in the original system:
    1. Win + R – Call “Run”;
    2. “Cmd” <Enter> – Start the console;
    3. “Set (with no parameters)” – Check the set variables ORACLE_HOME, ORACLE_SID. In their absence, exhibit, for example, as follows:
      set ORACLE_SID = db
    4. connect to the database:
      sqlplus "/ as sysdba"
    5. tablespace’ov select our names and files belonging to them to be transferred to the target system:
      col file_name format a70;
      select tablespace_name, file_name from dba_data_files;

      Those files that appear in the query result, it is necessary to carry

    6. create a file that contains the required set to re-create the control files (control files):
      alter database backup controlfile to trace as '/path/to/trace.file';
    7. stop the source database:
      shutdown immediate;
    8. exit from sqlplus:
      exit
    9. to /path/to/find the file trace.file. (As it necessary to re-create a set of control files (control files)). We transfer it to the target system.
  2. Actions in the target system:
    1. Install Oracle to the creation of the database. Name-based give the same – db;
    2. Copy trace-file ( ‘trace.file’) to another, for example, db.sql
    3. Adjust the db.sql so that left something like:
      STARTUP NOMOUNT;
      CREATE CONTROLFILE REUSE DATABASE "DB" RESETLOGS NOARCHIVELOG
        MAXLOGFILES 16
        MAXLOGMEMBERS 3
        MAXDATAFILES 100
        MAXINSTANCES 8
        MAXLOGHISTORY 4544
      LOGFILE
      GROUP 1 'D: \ ORACLE \ PRODUCT \ 10.1.0 \ ORADATA \ DB \ REDO01.LOG' SIZE 10M,
      GROUP 2 'D: \ ORACLE \ PRODUCT \ 10.1.0 \ ORADATA \ DB \ REDO02.LOG' SIZE 10M,
      GROUP 3 'D: \ ORACLE \ PRODUCT \ 10.1.0 \ ORADATA \ DB \ REDO03.LOG' SIZE 10M
      DATAFILE
            'D: \ ORACLE \ PRODUCT \ 10.1.0 \ ORADATA \ DB \ SYSTEM01.DBF',
            'D: \ ORACLE \ PRODUCT \ 10.1.0 \ ORADATA \ DB \ UNDOTBS01.DBF',
            'D: \ ORACLE \ PRODUCT \ 10.1.0 \ ORADATA \ DB \ SYSAUX01.DBF',
            'D: \ ORACLE \ PRODUCT \ 10.1.0 \ ORADATA \ DB \ MYDB.DBF',
            'D: \ ORACLE \ PRODUCT \ 10.1.0 \ ORADATA \ DB \ USERS01.DBF'
      CHARACTER SET CL8MSWIN1251;
    4. Win + R – Call “Run”;
    5. “Cmd” <Enter> – Start the console;
    6. “set” – Check the set variables ORACLE_HOME, ORACLE_SID. In their absence, exhibit, for example, as:
      “the set ORACLE_SID = the db”
    7. connect to the database:
      sqlplus "/ as sysdba"
    8. stop the target database:
      shutdown immediate;
    9. delete all the files in the% ORACLE_HOME% \ .. \ ORADATA \ DB \
    10. transferred from the% ORACLE_HOME% \ .. \ ORADATA \ DB \ source database datafiles all, the resulting query in para. 1.5., in% ORACLE_HOME% \ .. \ ORADATA \ DB \ target database
    11. to execute sqlplus window:
      @ \ Path \ to \ db.sql;
      alter database open resetlogs;
(Visited 23 times, 1 visits today)
adminOracleTips
Actions in the original system: Win + R - Call 'Run'; 'Cmd' <Enter> - Start the console; 'Set (with no parameters)' - Check the set variables ORACLE_HOME, ORACLE_SID. In their absence, exhibit, for example, as follows: set ORACLE_SID = db connect to the database: sqlplus '/ as sysdba' tablespace'ov select our names and files belonging to...

Do you want to be notified about new DBA updates, releases, jobs and free tips? Join our email newsletter. It's fast and easy. You will be among the first to know about hot new DBA updates and stuff, it will help you enhance your DBA skills.
We take your privacy very seriously