› Fóruns › Banco de dados Oracle › restore em outro servidor › restore em outro servidor
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