Home » Server Options » Data Guard » In STB there is always one newer archive file more than in PRI (9i, Win2003)
In STB there is always one newer archive file more than in PRI [message #405817] Fri, 29 May 2009 12:25 Go to next message
2884
Messages: 12
Registered: May 2009
Junior Member
After created DataGuard between 2 sites, I add more 2 standby redo logs (there are already 3 redo logs as in Primary site)

alter database add standby logfile GROUP 4 ('.......redo4.stb') size 10m;
alter database add standby logfile GROUP 5 ('.......redo5.stb') size 10m;


Then I use "recover managed standby database disconnect;", Standby DB is OK, it synchronizes with Primary.

However, I see a stranger: in Standby site, there is always more one the newest archive file than in Primary, with file size equals size of Redo log file.
Example, in PRI there are archive files: arc10, arc11, arc12 then in STB there are arc10, arc11, arc12, arc13 and arc13's size = RedoXX.log file size
in PRI there are archive files: arc10, arc11, arc12, arc13 then in STB there are arc10, arc11, arc12, arc13, arc14 and arc14's size = RedoXX.log file size

Event I don't use any log_archive_dest_XX in STB

So what's cause of issue? Thanks
Re: In STB there is always one newer archive file more than in PRI [message #405836 is a reply to message #405817] Fri, 29 May 2009 19:04 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>So what's cause of issue?
Who knows?
You make claims & provide no proof.

CUT & PASTE whole session so we can actually see what you see.
Re: In STB there is always one newer archive file more than in PRI [message #405865 is a reply to message #405817] Sat, 30 May 2009 11:11 Go to previous message
2884
Messages: 12
Registered: May 2009
Junior Member
OK, let I show shortly what I do
1) in PRI DB:
- Setup initial parameters:
log_archive_dest_1= 'LOCATION=C:\Oracle\oradata\ORCL\archive'
log_archive_dest_2= 'service=ORCL_STB OPTIONAL LGWR ASYNC=20480 REOPEN=15 MAX_FAILURE=10 NET_TIMEOUT=30'
...
- Add connections in tnsnames.ora
ORCL_PRI = (DESCRIPTION= ...
ORCL_STB = (DESCRIPTION= ...
2) in STB DB:
- create new ORCL DB by ORADIM
- Setup initial parameters:
standby_archive_dest = 'LOCATION=C:\Oracle\oradata\ORCL\archive'
fal_client = ORCL_STB
fal_server = ORCL_PRI
standby_file_management = AUTO
3) in PRI DB:
- Create standby controlfile by "alter database create standby controlfile as ..."
- Stop DB, copy new control files and all datafiles except TEMP to Standby
4) in STB:
startup nomount pfile=%ORACLE_HOME%\database\initORCL.ora;

alter database mount standby database;

alter database add standby logfile GROUP 4 ('C:\Oracle\oradata\ORCL\redo04.stb') size 10m;
alter database add standby logfile GROUP 5 ('C:\Oracle\oradata\ORCL\redo05.stb') size 10m;

recover managed standby database disconnect;

Add TEMP
recover managed standby database cancel;
alter database open read only;
alter tablespace temp add tempfile 'C:\ORACLE\ORADATA\ORCL\TEMP01.DBF' size 200M;
recover managed standby database disconnect;
create spfile from pfile

That's all

Previous Topic: DROP DATAFILES and CONTENTS
Next Topic: Trying to add a physical standby using Grid failed with ORA-16000
Goto Forum:
  


Current Time: Thu Mar 28 05:54:03 CDT 2024