ORACLE 11G Êý¾Ý¿âÒì»ú»Ö¸´µ½ÁíÍâµÄĿ¼

֣ȫ

±ÈÈçÉú²ú¿âλÖÃÔÚ :/u01/app/oracle/oradata/emr/
       »Ö¸´¿âµÄÎļþλÖãº/oradata/emr/

²½Ö裺
1.»Ö¸´¿ØÖÆÎļþ
    rman target /
    rman>restore controlfile from '/bak/dbbak/ctl.bak';

2.Æô¶¯µ½mount
    rman>alter database mount;

3.»Ö¸´Êý¾ÝÎļþ
    Êý¾ÝÎļþ¿ÉÒÔÒ»¸ö¸öÈ¥Ö´ÐÐλÖã¬Èç¹ûÎļþÌ«¶à£¬Ö¸¶¨Ì«Âé·³£¬¿ÉÒÔʹÓÃset newname for database to '/oradata/emr/%b' ·½Ê½½â¾ö
     rman>
    run{
    allocate channel c1 device type disk;
    allocate channel c2 device type disk;
    allocate channel c3 device type disk;
    allocate channel c4 device type disk;
    set newname for database to '/oradata/emr/%b';
    restore database;
    switch datafile all;
    switch tempfile all;
    recover database;
    }

4.µ÷ÕûÁª»úÎļþ
    sql>
alter database rename file '/u01/app/oracle/oradata/emr/redo01.log' to '/oradata/emr/redo01.log';
alter database rename file '/u01/app/oracle/oradata/emr/redo02.log' to '/oradata/emr/redo02.log';
alter database rename file '/u01/app/oracle/oradata/emr/redo03.log' to '/oradata/emr/redo03.log';
alter database rename file '/u01/app/oracle/oradata/emr/redo04.log' to '/oradata/emr/redo04.log';

alter database clear logfile group 1;
alter database clear logfile group 2;
alter database clear logfile group 3;
alter database clear logfile group 4;

5.´ò¿ªÊý¾Ý¿â
  sql>alter database open resetlogs;