Pular para o conteúdo

Fóruns Banco de dados Oracle restore em outro servidor restore em outro servidor

#96465
paulakioro
Participante

    Executei os seguintes procedimentos

    1-passo
    set ORACLE_SID=NEWBANCO

    rman target /
    startup nomount;
    restore controlfile from ‘C:backup_Ca01pCONTROL_CA01P_20100923.CTL’;
    alter database mount;

    2-Passo
    catalog backuppiece ‘C:backup_Ca01pBACKUP_CA01P_XE_SET95_PIECE1_20100923_2VLOIRRL_1_1.BAK’;
    catalog backuppiece ‘C:backup_Ca01pBACKUP_CA01P_XE_SET96_PIECE1_20100923_30LOIRUB_1_1.BAK’;
    catalog backuppiece ‘C:backup_Ca01pBACKUP_CA01P_XE_SET97_PIECE1_20100923_31LOIRUF_1_1.ARC’;

    3- Passo
    alter database rename file ‘E:ORACLEORADATAXEREDO02A.ORA’ to ‘C:oraclexeoradataXEREDO02A.ORA’;
    alter database rename file ‘E:ORACLEORADATAXEREDO01A.ORA’ to ‘C:oraclexeoradataXEREDO01A.ORA’;
    alter database rename file ‘E:ORACLEORADATAXEREDO03A.ORA’ to ‘C:oraclexeoradataXEREDO03A.ORA’;
    alter database rename file ‘E:ORACLEORADATAXEREDO03B.ORA’ to ‘C:oraclexeoradataXEREDO03B.ORA’;
    alter database rename file ‘E:ORACLEORADATAXEREDO01B.ORA’ to ‘C:oraclexeoradataXEREDO01B.ORA’;
    alter database rename file ‘E:ORACLEORADATAXEREDO02B.ORA’ to ‘C:oraclexeoradataXEREDO02B.ORA’;

    4-Passo
    run
    {
    set until sequence 151;
    set newname for datafile 1 to ‘C:oraclexeoradataXESYSTEM.DBF’;
    set newname for datafile 2 to ‘C:oraclexeoradataXEUNDO.DBF’;
    set newname for datafile 3 to ‘C:oraclexeoradataXESYSAUX.DBFF’;
    set newname for datafile 4 to ‘C:oraclexeoradataXEUSERS.DBF’;
    set newname for datafile 5 to ‘C:oraclexeoradataXEDAT_ONX.DBF’;
    restore database;
    switch datafile all;
    recover database;
    alter database open resetlogs;
    }

    So q esta dando o erro:

    executing command: SET until clause
    using target database control file instead of recovery catalog

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    Starting restore at 14-OCT-10
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: sid=38 devtype=DISK

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of restore command at 10/14/2010 21:23:07
    RMAN-06026: some targets not found – aborting restore
    RMAN-06023: no backup or copy of datafile 4 found to restore
    RMAN-06023: no backup or copy of datafile 3 found to restore
    RMAN-06023: no backup or copy of datafile 2 found to restore
    RMAN-06023: no backup or copy of datafile 1 found to restore

    Nao sei mais o q fazer