Solved
Troubleshooting restore Oracle database on to same server
Our production system is - Window 2008 R2 x64, Oracle 10G, Backup Exec 13
We use Backup Exec to backup out Databases on a regular basis.
We wanted to be familier with the process of restore (and recover) of the database.
So, we created a test environment with the same - Window and Oracle.
And try to run the restore from the Backup Exec.
After some tests that failed, we receive a link to - http://seer.entsupport.symantec.com/docs/303911.htm
we followed the instructions and still it fail.
Followong are some of the log we got...
Microsoft Windows [Version 6.1.7600]
(c) Корпорация Майкрософт (Microsoft Corporation), 2009. Все права защищены.
C:\Users\Администратор>orapwd file=C:\oracle\product\10.2.0\db_1\database\pwdlab
ora.ora password=123
ora.ora password=123
C:\Users\Администратор>rman
Recovery Manager: Release 10.2.0.4.0 - Production on Fri Apr 2 10:09:19 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN> CONNECT TARGET sys/123@labora;
connected to target database: LABORA (DBID=3301204057)
RMAN> SHUTDOWN ABORT;
using target database control file instead of recovery catalog
Oracle instance shut down
Oracle instance shut down
RMAN> CONNECT TARGET sys/123@labora;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
RMAN> CONNECT TARGET sys/123
connected to target database (not started)
RMAN> STARTUP NOMOUNT;
Oracle instance started
Total System Global Area 1258291200 bytes
Fixed Size 2065408 bytes
Variable Size 318770176 bytes
Database Buffers 922746880 bytes
Redo Buffers 14708736 bytes
Variable Size 318770176 bytes
Database Buffers 922746880 bytes
Redo Buffers 14708736 bytes
RMAN> SET DBID 3300599589;
executing command: SET DBID
go to server Symantec Backup Exec and create restore job...
RMAN on server Symantec Backup Exec:
Recovery Manager: Release 10.2.0.4.0 - Production on Fri Apr 2 14:21:45 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
# -----------------------------------------------------------------
# RMAN command section
# -----------------------------------------------------------------
RUN {
ALLOCATE CHANNEL ch0
TYPE 'SBT_TAPE';
SEND 'BSA_SERVICE_HOST=172.17.4.12,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={F4C81D4C-3FF9-4FD1-A100-F086D6A14BFB},NBBSA_DB_DEVICE_NAME=Oracle-Win::\\LAB-ORACLE\LABORA';
RESTORE CONTROLFILE FROM 'BE_11la49e1_1_1';
ALTER DATABASE MOUNT;
RESTORE
DATABASE;
RECOVER
DATABASE;
RELEASE CHANNEL ch0;
alter database open resetlogs;
}
connected to target database: LABORA (not mounted)
using target database control file instead of recovery catalog
allocated channel: ch0
channel ch0: sid=154 devtype=SBT_TAPE
channel ch0: Symantec/BackupExec/1.1.0
sent command to channel: ch0
Starting restore at 02-APR-10
channel ch0: restoring control file
channel ch0: restore complete, elapsed time: 00:00:37
output filename=C:\ORACLE\ORADATA\LABORA\CONTROL01.CTL
output filename=C:\ORACLE\ORADATA\LABORA\CONTROL02.CTL
output filename=C:\ORACLE\ORADATA\LABORA\CONTROL03.CTL
Finished restore at 02-APR-10
database mounted
Starting restore at 02-APR-10
channel ch0: starting datafile backupset restore
channel ch0: specifying datafile(s) to restore from backup set
restoring datafile 00001 to C:\ORACLE\ORADATA\LABORA\SYSTEM01.DBF
restoring datafile 00002 to C:\ORACLE\ORADATA\LABORA\UNDOTBS01.DBF
restoring datafile 00003 to C:\ORACLE\ORADATA\LABORA\SYSAUX01.DBF
restoring datafile 00004 to C:\ORACLE\ORADATA\LABORA\USERS01.DBF
channel ch0: reading from backup piece BE_0ula498l_1_1
channel ch0: restored backup piece 1
piece handle=BE_0ula498l_1_1 tag=TAG20100402T135637
channel ch0: restore complete, elapsed time: 00:04:25
Finished restore at 02-APR-10
Starting recover at 02-APR-10
released channel: ch0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/02/2010 14:26:56
ORA-19698: C:\ORACLE\ORADATA\LABORA\REDO01.LOG is from different database: id=3301204057, db_name=LABORA
Recovery Manager complete.
go to server Oracle and return CMD...
RMAN> Alter database open resetlogs; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of alter db command at 04/02/2010 14:29:18 ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: 'C:\ORACLE\ORADATA\LABORA\SYSTEM01.DBF' RMAN>
How to resolve this issue?
- Check the following document
http://support.veritas.com/docs/294882
1. Bring the database to nomount state.2. Empty the contents of the directory (under the oradata directory) containing the data files and online redo logs of the newly created database.3. Re-try the control file restore operation
