Hi All,
I need to re build physical standby database now. Yesterday switchover activity got failed and need to bring standby db in read write mode. So at this moment we have 2 primary database.
My db version is Oracle 10.2.0.1.0 in windows 2003 64bit.
I have daily RMAN backup running in production db. I already copied the backup & want to restore in standby db but getting below errors.
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:\Documents and Settings\kumarim>set oracle_sid=eamdr
C:\Documents and Settings\kumarim>rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Fri May 30 12:24:20 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database (not started)
RMAN> startup nomount;
Oracle instance started
Total System Global Area 4294967296 bytes
Fixed Size 2009792 bytes
Variable Size 2852128064 bytes
Database Buffers 1426063360 bytes
Redo Buffers 14766080 bytes
RMAN> restore standby controlfile from 'D:\Controlfile_bak\O1_MF_NCNNF_TAG201405
30T122011_9RJ1QWF0_.BKP';
Starting restore at 30-MAY-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:05
output filename=D:\MAXIMODATA\ORADATA\MAXPROD\CONTROL01.CTL
output filename=D:\MAXIMODATA\ORADATA\MAXPROD\CONTROL02.CTL
output filename=D:\MAXIMODATA\ORADATA\MAXPROD\CONTROL03.CTL
Finished restore at 30-MAY-14
sql statement: alter database mount standby database
released channel: ORA_DISK_1
RMAN> run
2> {
3> ALLOCATE CHANNEL c1 DEVICE TYPE DISK ;
4> restore database;
5> }
allocated channel: c1
channel c1: sid=123 devtype=DISK
Starting restore at 30-MAY-14
Starting implicit crosscheck backup at 30-MAY-14
Crosschecked 10 objects
Finished implicit crosscheck backup at 30-MAY-14
Starting implicit crosscheck copy at 30-MAY-14
Crosschecked 5 objects
Finished implicit crosscheck copy at 30-MAY-14
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: D:\MAXIMODATA\FLASH_RECOVERY_AREA\EAMDR\2014_01_22\O1_MF_NCNNF_TAG201
40122T121230_9FYK9HDD_.BKP
File Name: D:\MAXIMODATA\FLASH_RECOVERY_AREA\EAMDR\O1_MF_NCNNF_TAG20140122T12123
0_9FYK9HDD_.BKP
creating datafile fno=1 name=D:\MAXIMODATA\ORADATA\MAXPROD\SYSTEM01.DBF
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/30/2014 12:29:51
ORA-01180: can not create datafile 1
ORA-01110: data file 1: 'D:\MAXIMODATA\ORADATA\MAXPROD\SYSTEM01.DBF'
RMAN>
1.Do I need to delete existing data files or it will overwrite?
2.After restoration , do I need to create standby logfiles?
3.can you please share me steps how to rebuild physical standby using RMAN backup?
Can anyone advice me on this issue?
Thanks,
Meena