No question at this time
DBA Top 10
1 M. Cadot 22100
2 A. Kavsek 15500
3 M. Hidayathullah ... 11000
4 B. Vroman 7900
5 P. Wisse 6000
6 T. Boles 5400
7 J. Schnackenberg 3300
8 G. Lambregts 2200
8 P. Knibbs 2200
8 K. Pagadala 2200
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48016
Total active users1849
Act. users last 24h10
Act. users last hour0
Registered user hits last week306
Registered user hits last month1339
Go up

duplcate for standby from active database
Next thread: knowledge gain
Prev thread: migrate apex and ords from vm machine to phsyical server

Message Score Author Date
Hi all, ODA X5-2, 2 appliance box on 2 differe...... Pekka Koppanen May 15, 2017, 17:02
Dear, Please check following mos notes and link...... Mirza Hidayathullah Baig May 16, 2017, 05:45
Dear, In addition to above mos notes, please re...... Mirza Hidayathullah Baig May 16, 2017, 06:03

Follow up by mail Click here


Subject: duplcate for standby from active database
Author: Pekka Koppanen, Sweden
Date: May 15, 2017, 17:02, 93 days ago
Os info: red hat
Oracle info: 11.2.0.3
Message: Hi all,

ODA X5-2, 2 appliance box on 2 different datacenter
Running data guard on the appliance box. primary on one datacaenter and standby on the other datacaenter

the error during duplicate

Errors in file /u01/app/oracle/diag/rdbms/xxxxx_se02/xxxxx/trace/xxxxx_lgwr_98134.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: ‘/u01/app/oracle/oradata/datastore/xxxxxxonlinelog/o1_mf_3_dhrvft0s_.log’
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory

Same for all redologs, the duplicate create controlfiles and datafiles.

If I run the statement select member from v$logfile; on the standby the files are there but not on the filesystem.

I have run the same duplicate on this enviroment about 10 times without any problem


I Hope you understand
/P
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: duplcate for standby from active database
Author: Mirza Hidayathullah Baig, United Kingdom
Date: May 16, 2017, 05:45, 92 days ago
Message: Dear,

Please check following mos notes and links.

ORA-313 ORA-312 ORA-349 Mounting a Standby Database (Doc ID 2031961.1)

Open Resetlogs Reports Errors ORA-00313 and ORA-00312 to Alert (Doc ID 1366482.1)

https://support.oracle.com/epmos/faces/CommunityDisplay?resultUrl=https%3A%2F%2Fcommunity.oracle.com%2Fthread%2F2897214&_afrLoop=244977301526302&resultTitle=Create+new+db+from+backup+of+standby+db&commId=2897214&displayIndex=2&_afrWindowMode=0&_adf.ctrl-state=r1gkddwcl_175

Regards
Mirza
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: duplcate for standby from active database
Author: Mirza Hidayathullah Baig, United Kingdom
Date: May 16, 2017, 06:03, 92 days ago
Message: Dear,

In addition to above mos notes, please refer following mos note as well for step by step creating standby using rman duplication.


Step by Step Guide on Creating Physical Standby Using RMAN DUPLICATE...FROM ACTIVE DATABASE (Doc ID 1075908.1)

Regards
Mirza
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here