| In STB there is always one newer archive file more than in PRI [message #405817] |
Fri, 29 May 2009 12:25  |
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 #405865 is a reply to message #405817] |
Sat, 30 May 2009 11:11  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
