Exactly what I needed
Rich Stucke, July 03, 2002 - 1:33 pm UTC
This answer is exactly what I needed to know. If I understand correctly: If my Primary database is Oracle 9.2 EE on a SUN Sparc Solaris 4500, I can have my standby database as Oracle 9.2 EE on a Linux box ??
July 03, 2002 - 2:29 pm UTC
with a logical standby -- yes.
that is a new 9iR2 feature -- we turn the binary redo stream into logical change records which are turned into SQL and applied to the logical standby (you can still do a physical standby of course)
Correct
Akthar A.J., July 04, 2002 - 5:17 am UTC
If you guys have solaris platform ,'Data Guard' can be used to configure standby DB. Available right from 8i. Have any folks tried it..It is really fantastic and Real point in time.
Tom , any comment on Data Guard..
July 04, 2002 - 11:14 am UTC
Data guard is cool, better then standby. More features, more options.
Doesn't require solaris -- just any two homogenous platforms that Oracle is on. and in 9iR2 -- can be heterogenous as well (Solaris to Nt, Nt to HP/UX etc)
Sagi, July 04, 2002 - 9:52 am UTC
What is Logical and Physical Standby.
Would appreciate if you could explain in short.
Thanx in advance.
Regards,
July 04, 2002 - 11:21 am UTC
</code>
http://docs.oracle.com/docs/cd/B10501_01/server.920/a96653/standbycon.htm#1005573 <code>
<quote from there>
* Physical standby databases
A physical standby database is physically identical to the primary database, with on-disk database structures that are identical to the primary database on a block-for-block basis. The physical standby database is updated by performing recovery. It can either be recovering data or open for read-only reporting.
* Logical standby databases
A logical standby database is logically identical to the primary database. The logical standby database is updated using SQL statements. The tables in a logical standby database can be used simultaneously for recovery and for other tasks such as reporting, summations, and queries.
</quote>
A reader, August 21, 2002 - 4:24 pm UTC
Hi Tom,
I am little confuse ,
1- you said:
<quote>
Data guard is cool, better then standby. More features, more options.
Doesn't require solaris -- just any two homogenous platforms that Oracle is on.
and in 9iR2 -- can be heterogenous as well (Solaris to Nt, Nt to HP/UX etc)
<quote>
But when I read the operation requirements in the Oracle documentation about Data Guard for the release 9i2, they said
<quote>
The hardware and operating system architecture on the primary and standby locations must be the same. For example, this means a Data Guard configuration with a primary database on a 32-bit Sun system must have a standby database that is configured on a 32-bit Sun system. Similarly, a primary database on a 64-bit HP-UX system must be configured with a standby database on a 64-bit HP-UX system, a primary database on a 32-bit Linux on Intel system must be configured with a standby database on a 32-bit Linux on Intel system, and so forth.
<qoute>
Taking into account this, Can I use two differents severs with differents OS but the same ORacle release?
2-You said <qoute> Data guard is cool, better then standby. More features, more options. <quote>
Why did you say better then standby? Isn't data guard an Oracle tool (like entreprise manager for example) in order to manage better the standby databases? Don't you need to have a standby database in order to use data guard?
Thanks for your help
August 21, 2002 - 7:55 pm UTC
1) I "mispoke" a little there. The underlying technology here is "streams" and with streams it can be heterogenous. A little more involved then out of the box logical standby (which wants you to start with a hot/cold backup of the original which won't work in a heterogenous situation). So yes, you are correct -- it would not be a true "logical standby", it would be a one way stream (see the streams concepts guide)
2) standby is the version 8i and before name (in my mind) -- data guard is a more comprehensive solution giving you switch over, switch back; 4 levels from which to choose (as far as apply goes) and so on. The standby database is just a tiny component of that now.
Data Guard gives you a standby database.
A standby database doesn't necessarily have all of the features of data guard.
A reader, August 22, 2002 - 12:10 pm UTC
Thanks for the answer.
1-Logical standby database is available in 9i standard edition?
2-Do you know if data guard is available in 9i standard edition?
regards
August 22, 2002 - 10:32 pm UTC
Why primary and standby on same box?
A reader, August 23, 2002 - 9:01 am UTC
Tom,
Can you please explain in what situation and why we put primary and standby databases on the same box? I thought the standby is for disaster recovery. If both on the same box, how?
Thank you very much.
August 23, 2002 - 2:05 pm UTC
they are on different computers.
What is the difference between Data Guard's logical Standby and Replication?
Alin Cretu, February 05, 2003 - 9:40 am UTC
I want to have a better comprehention of these options. A highlighted list of differences and resemblances between Data Guard's logical Standby and Advance Replication would help.
February 05, 2003 - 11:53 am UTC
Well that is easy.
One is an apple.
The other is a toaster oven.
In as much as you can compare them, go for it.
You see -- data guard is for DR, disaster recovery. plain and simple.
Replication -- that is a technology that does lots of things, you build applications with it in mind.
Using data guard for replication -- no, not really.
Using replication for DR -- wouldn't suggest it, it is not a DR tool, never has been.
So, if you are building an application that needs replication -- you use replication.
If you are building a system that needs DR -- data guard is what you want and if you want to use the DR site as a reporting instance just as a bonus and can live within the bounds of the logical standby -- it is an OK thing to do.
But -- one is not to be used for the other (although everyone keeps trying to use replication as DR, it just is the most utterly painful way to try and do it. if you *need* replication, thats fine. If you want DR, replication isn't the way to go)
Is 9.2.0.2 compatable with 9.2.0.1 for physical standby
Baqir Hussain, March 03, 2003 - 5:01 pm UTC
Tom,
In the test environment for the physical standby,
Primary database is 9.2.0.2 on sun solaris 2.8, ULTRA 5.
Standby databse is 9.2.0.1 on e250 solris 2.8.
The standby database was set successfully into the managed recover mode as well as the transfer of the archivelog from the PRIMARY to the STANDBY.
Now I tried to open the standby database in read-only mode as follows:
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
and then
SQL> ALTER DATABASE OPEN READ ONLY;
the database shutdown with the following message:
ORA-01092: ORACLE instance terminated. Disconnection forced
and there is an error message in the alert log:
Mon Mar 3 13:13:43 2003
ALTER DATABASE OPEN READ ONLY
Mon Mar 3 13:13:43 2003
SMON: enabling cache recovery
Mon Mar 3 13:13:44 2003
Database Characterset is WE8ISO8859P1
Updating 9.2.0.2.0 NLS parameters in sys.props$
-- adding 9.2.0.1.0 NLS parameters.
An error occurred while updating sys.props$ !
Failure when inserting the new parameters.
It is inadvisable to use the new 9.2.0.1.0 NLS parameters
until this problem is resolved.
1. Is there is any kind of bug that conversion of 9.2.0.2 of NLS parameters could not update into 9.2.0.1? As per oracle only base of the database should be the same (EE 9.2)??
2. OR it is due to the hradware or both?
Please advise. thanks
2.
March 04, 2003 - 6:47 am UTC
physical standbys -- by definition -- must be at the same release.
they are not in your case.
contact support.
upgrading database and standby
Rich Stucke, March 04, 2003 - 8:36 am UTC
How can I install patches to a standby database. I can upgrade the engine, but I can't run the catalog and catproc scripts without opening the database can I ?? And if that is true, then I suspect that you only upgrade the production database and then create a new standby. Or because I've installed the patches in the standby engine, the application of the archive logs during synchronization will effectively do the catalog and catproc, etc. scripts for me ??
March 04, 2003 - 6:22 pm UTC
think about what catalog and catproc do.....
they update tables -- which are logged -- which propagate... just like if you create or replace a view in your own schema -- they move over via redo.
Data Guard for Windows 2000
Riaz Shahid, March 05, 2003 - 12:41 pm UTC
Hi Tom !
Is data guard available for Oracle 8.1.7 running on Windows 2000 Advanced Server ? I vistied technet.oracle.com > Download but couldn't find one for Windows 2000.
Thankx
March 05, 2003 - 2:32 pm UTC
data guard is a 9i new feature
SOME of the bits were available for 8i like the data guard manager command line interface but the architectural changes are 9i and up.
standby upgrades
Rich Stucke, March 05, 2003 - 12:48 pm UTC
OK if I understand correctly, I can do DDL processes on my production database and they also will propagate to my standby ?? Is there anything that might be added to my production database that would warrant having to create a new standby ??
March 05, 2003 - 2:34 pm UTC
stream
test, May 16, 2003 - 8:53 pm UTC
I have release 9ir2(9.2.0.2.1) on sun solaris. I am trying to configure oracle stream on a single table object between two database through OEM. OEM generates three scripts 1. Setup script 2. EXp/im script 3. Run script.
When the first scripts(setup script) run it fails at giving the permission of ENQUE ANY using DBMS_AQ package. Giveing an error End of file on communication channel. When I try to look into alert log file it generates ORA-600 internal error. I tried to check on metalink for any patch related to this. But none was there.
Has anyone faced this problem?
Thanks for the help.
May 17, 2003 - 10:04 am UTC
open a tar with support -- you have metalink access so apparently you can. all ora-600's should lead to a tar.
Setting up of DR on different Palteform
Manish Garg, August 08, 2003 - 2:41 am UTC
Hi Actualy i have Oracle 8.1.7 running on AIX Plateform ,i wanted to setup a HOT DR Server on Solaris Box .i am looking for online replication sort of thing .so this article help me in finding answer of my query
Regards
Manish Garg
Standby Cold backup
Haratsaris,Alexandre, September 18, 2003 - 3:03 pm UTC
Hi Tom,
My question is quite strange, but here it goes anyway...
I've created a standby database on a new Customer ( I work as Oracle Consultant) that I supose it would be for Disaster Recovery issues, but then they sad that they are planning to use only Standby database files for cold backups rather than have to stop Production Env (24X7 new APPS) , as it "would" be at same point-in-time as Prod . You know : No RMAN, No HOTBACKUPS, ONLY WEEKLY SO COLD backups for years...terrible.
Well, as it is not easy to change their minds, what more arguments can I use than explain problems with gap of sequence logs , nologging indexes replication, create datafiles replication and so on ?
Thanks!
September 18, 2003 - 3:33 pm UTC
i would tell them "i can cut your hardware costs in half and never shutdown your production database"
in order to do standby, they MUST be in archivelog mode.
if they are in archivelog mode, it is *trivial* to hot backup.
restoring a cold or hot backup is no more or less difficult.
taking a cold or hot backup is just as easy as well.
they *could* do what they are doing but they need 2x the disk, 2x the computers, 2x the software. Maybe you can be their hero and cut their costs in half by giving them a simple hot backup script.
A reader, November 10, 2003 - 6:35 pm UTC
Tom,
We are using dgmgrl which is pretty cool. Consider this
P1 is production and S1 is standby.
I gracefully switched over to S1, so now S1 is my production. Now i wanna switchback to P1 so it becomes my production (back again).
Do i need to create a new controlfile from S1 and copy it to P1 or just issuing the command "switchover ..." should work like before.
Thanks.
November 10, 2003 - 7:42 pm UTC
the switchover reverses the roles -- standby becomes prod, prod becomes standby. to re-reverse them, putting them back, is just another switchover.
A reader, November 10, 2003 - 8:51 pm UTC
Thanks..
A reader, November 12, 2003 - 4:36 pm UTC
Tom,
We have similar kind of situation, instead of switchover we are testing failover using dataguard(dgmgrl).
As per my understanding after performing failover we cannot use former primary as standby. We have to configure it again.
Example:- From Prod1 i failover to Standby1.
So now Standby1 is Production, now I have to configure Prod1 to be my new Standby.
Do i have to copy all the datafiles and standby controlfiles from primary (former standby) to be standby (former primary), or i can just create a standby controlfile and copy & follow the process as suggested in Oracle docs.
Thanks.
November 13, 2003 - 6:30 am UTC
if you did a non-graceful "failover" (as opposed to switchover), you reinstantiate the standby from this new production (just like you were setting up from scratch) and then do a graceful switchover.
if no data was lost during the non-graceful "failover", there is an opportunity to "fail back" -- but in reality, it would not really happen. You failed over because the production machines blew up, they don't exist anymore.
Standby for SE
Olaf, December 03, 2003 - 11:04 am UTC
Tom,
what the possibilities I have to make a standby database for our prod DB SE.
In "Oracle 9i Feature and Option Availability" I saw that DATA GUARD as well as Standby database GUI are not available for SE.
December 03, 2003 - 11:19 am UTC
managed standby (data guard) is a feature of Enterprise Edition.
so the redo shipping, etc etc etc -- it not available with SE.
with SE, you have to "roll your own" - shipping logs, applying, etc. no FAL server, no managed standby
Standby DB
A reader, December 03, 2003 - 11:12 am UTC
Is it enough to buy a Standard Edition One license for the prod database with SE license? HW for standby always has one CPU.
A reader, December 03, 2003 - 12:00 pm UTC
Tom,
In 9i dataguard is there some command for reinstantiating.
Thanks.
December 03, 2003 - 4:49 pm UTC
reinstantiating?
db_file_name_convert and log_file_name_convert
reader, February 21, 2004 - 4:00 pm UTC
Are these parameters used in logical standby database parameter file? I was reading the document and it is suggesting to rename all of the data files using ALTER DATABSE RENAME command as one of the steps in creating logical standby. Is there any reason why these parameters cannot be used in logical standby? Thanks.
Following is a copy and paste from data guard concept guide (pdf doc).
4.2.11 Rename the Datafiles on the Logical Standby Database
On the logical standby database, rename all of the datafiles that were identified in Section 4.2.1 and copied from the primary database. For example:
SQL> ALTER DATABASE RENAME FILE Â’/disk1/oracle/oradata/payroll/system01.dbfÂ’
2> TO Â’/disk1/oracle/oradata/payroll/standby/system01.dbfÂ’;
February 21, 2004 - 4:32 pm UTC
db_file_name_convert .....
reader, February 22, 2004 - 10:33 am UTC
Thanks.
(1)I looked at the above link, it says the parameter is applicable for physical standby only. That means if I had to rename a file in primary database, do I have to manually do the same in the logical standby?
(2) If I set the protection mode in 9i R2 to one of these maximum protection or availability or performance for the standby database, is it possible to dynamicall change this mode or do I have to shutdown both primary and standby before I change the protection mode? Thanks.
(3) If for some reason my standby is down and assume that it was set in maximum performance. When I bring the standby up would it automatically detect the archive gap and applies them? Thanks for your time. Hope you don't mind asking these questions in this thread.
Thanks.
February 22, 2004 - 12:35 pm UTC
1) just search the data guard concepts/admin guide for that and you'll see things like:
...
You must rename primary database datafiles in the standby database control file. You can either manually rename the datafiles (see Section B.4) or set up the DB_FILE_NAME_ CONVERT initialization parameter on the standby database to automatically rename the datafiles (see Section 6.3.4).
......
it is for the standby.
2) quote from sql ref:
...
SET STANDBY [DATABASE] Clause Use this clause to specify the level of protection for the data in your database environment. You specify this clause from the primary database, which must be mounted but not open.
......
it is an "offline" operation. database must be mounted but not open.
3) see
</code>
http://docs.oracle.com/docs/cd/B10501_01/server.920/a96653/log_apply.htm#1017313 <code>
Synch vs Aynch
reader, February 23, 2004 - 8:34 pm UTC
I understand synch as LGWR writes redo info to standby redolog at the same time it writes to primary redo log. What does asynch mean? Does it mean LGWR writes to standby redo log after some time? Thanks.
February 24, 2004 - 6:30 am UTC
async means "not syncronous"
lgwr can write to the standby in one of three ways:
a) syncronous -- write to the standby and wait for a confirmation that write succeeded.
b) asyncronous -- write to the standby but do not wait for confirmation (fire and forget).
c) really long asyncronous, actually let ARCH move the redo over to standby after redo log fills up
Is ARCH process sync or async?
David, February 25, 2004 - 6:40 pm UTC
Tom, can ARCH process ASYNC? Thanks.
February 25, 2004 - 7:33 pm UTC
can arch process async what?
Oracle Standby on diffrent Linux releases
Asif Anwar, September 04, 2004 - 7:04 am UTC
Hi,
With my production system running on Oracle 8.1.7.4 and RedHat Linux 6.2 (filesystem type ext2), can I configure an Oracle Standby Server with Oracle 8.1.7.4 and RedHat Enterprise Linux AS 2.1 on filesystem type ext3 ?
Regards and thanks,
September 04, 2004 - 11:13 am UTC
While it would "probably work by accident" (the OS's are certainly close enough to probably work) it would sort of go against the very tenet of disaster recovery -- when you fail over, something really utterly bad has happened. Do you really want to pour salt into that gaping wound and rub it in by imposing and OS upgrade/downgrade at the same time you fail over.
Think about it -- your production data center just blew up. Some of your best friends are gone or in the hospital, your mission critical applications have to get up and running, but "something is not working" -- why? because you've totally changed the operating environments.
At least it is not as bad as the people who ask "can I use my windows print server as a failover site for my 32 cpu sparc?"
Migrate Oracle 8.1.7.4 from RedHat 6.2 to RedHat Enterprise with a hot backup.
Asif Anwar, September 05, 2004 - 4:04 am UTC
Ok!
Thanks for the usefull suggestions.
What is the best and easiest way to migrate my oracle 8.1.7.4 from RedHat 6.2 (ext2) to RedHat Enterprise Linux AS 2.1 (ext3)? Can I simply restore my hot backup to the new box and then apply the online redologs to make it synchronized. I have to ensure a minimum downtime for the migration.
Regards,
September 05, 2004 - 10:33 am UTC
yes. just restore and upgrade it.
ORA-01092
Nishant Choudhary, March 01, 2005 - 2:23 pm UTC
Sir,
I am creating logical on test environment .. same os same hardware. oracle 9i rel2
first time it created sucessfully but after that i m continously getting error:
ORA-01092: ORACLE instance terminated. Disconnection forced
====================alert.log================
ALTER DATABASE GUARD ALL
Wed Mar 02 00:34:06 2005
Completed: ALTER DATABASE GUARD ALL
Wed Mar 02 00:34:14 2005
ALTER DATABASE OPEN RESETLOGS
RESETLOGS after incomplete recovery UNTIL CHANGE 203075
Resetting resetlogs activation ID 4243928368 (0xfcf53530)
Online log 2 of thread 1 was previously cleared
Wed Mar 02 00:34:20 2005
LGWR: Primary database is in CLUSTER CONSISTENT mode
Assigning activation ID 4243911553 (0xfcf4f381)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: D:\STDBY\REDO01.LOG
Successful open of redo thread 1.
Wed Mar 02 00:34:20 2005
SMON: enabling cache recovery
Wed Mar 02 00:34:22 2005
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Dictionary check beginning
Dictionary check complete
Wed Mar 02 00:34:22 2005
SMON: enabling tx recovery
Wed Mar 02 00:34:22 2005
Database Characterset is WE8MSWIN1252
Wed Mar 02 00:34:23 2005
Errors in file d:\stdby\udump\stdby_ora_1236.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-25153: Temporary Tablespace is Empty
Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Instance terminated by USER, pid = 1236
ORA-1092 signalled during: ALTER DATABASE OPEN RESETLOGS...
==============stdby_ora_1236.trc =================
Dump file d:\stdby\udump\stdby_ora_1236.trc
Wed Mar 02 00:34:15 2005
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: stdby
Redo thread mounted by this instance: 1
Oracle process number: 15
Windows thread id: 1236, image: ORACLE.EXE
*** SESSION ID:(11.3) 2005-03-02 00:34:15.000
*** 2005-03-02 00:34:15.000
ORA-00604: error occurred at recursive SQL level 1
ORA-25153: Temporary Tablespace is Empty
===========================================================
is this due to non existence of temp file ... how should i go ahead ..
thanx in advance
March 01, 2005 - 3:23 pm UTC
support would be the best path for these things. I see a metalink Note 273413.1
they suggest setting sufficiently high sort_area_size (workarea_policy set to manual for this) and starting (avoiding the recursive sql attempt to write to temp)
then you can add the tempfile.
ORA-25153
Totu, April 07, 2005 - 12:28 am UTC
Dear Tom.
I was importing spatial data to Oracle using another tool. During that process ORA-25153: temp. tabslespace is empty occured.
I read Oracle docs and google search: Solution is that add temp file to tablespace. But original file exists physically. OEM doesn't show it. What caused Oracle to go on this way?..
Thanks in advance.
April 07, 2005 - 9:07 am UTC
no idea on that one. sorry.
little confused
avi, May 12, 2005 - 11:44 am UTC
Hi Tom,
You said:
* Physical standby databases
A physical standby database is physically identical to the primary database, with on-disk database structures that are identical to the primary database on a block-for-block basis. The physical standby database is updated by
performing recovery. It can either be recovering data or open for read-only reporting.
* Logical standby databases
A logical standby database is logically identical to the primary database. The logical standby database is updated using SQL statements. The tables in a logical standby database can be used simultaneously for recovery and for other tasks such as reporting, summations, and queries.
So where is the diffrence in betwwen? In every case it'll apply archive logs which contains SQL statements. What I mean to say is in Physical it uses SQL statements from archive log to recover database and in Logical it uses SQL statements for updating. Please clarify as I'm confused.
Lots of thanks in advance.
May 12, 2005 - 1:26 pm UTC
physical standby applies redo like recovery does
logical standby READS redo and turns it into sql and does inserts/updates/deletes.
physical does NOT use sql at all, it uses bits and bytes to recover datafiles.
Difference between Physical and Logical standby
mohan, June 29, 2005 - 10:41 pm UTC
Hi Tom,
I had configured physical standby using Oracle 8i. The disadvantage is that for each recovery the standby DB has to be shutdown and apply archive logs.
I want to configure logical standby. How difficult it is from a physical standby.
June 30, 2005 - 9:26 am UTC
you won't be doing that in 8i, it was a new 9i feature.
It is documented in the data guard documentation, freely available on OTN, you can read it and see what is different from your perspective.
but you won't be doing it until you get on software written this century....
Need help in estimating Bandwidth usage / considerations for Standby
Anand G, July 27, 2006 - 3:31 am UTC
Hi Tom,
Thanks a lot for the wonderful answers given here.
When setting up a standby environment how can be estimate the bandwidth requirements?
- If you can give some guidance/ links that would be a a great help.
Is there a way from Oracle to compress and send archivelogs? I guess only way to use external utilities and manual transfer..
July 27, 2006 - 11:50 am UTC
how much redo do you generate in a given period of time.
That will be your basic requirement - to get that much redo from system A to system B in that same amount of time.
FAL CONCEPTS
Star Nirav, October 19, 2006 - 2:34 pm UTC
Hi TK,
can you tell us that do we need to configure FAL server and client at DR end or both (PDC and DR)...?
My senior told me that we dont need to configure FAL at any end in oracle 9i and if it is required then configure at PDC side only.
What if I am having connectivity from PDC to DR and still I am having archive_gap ?
What I understood from the concepts and articles published by you is that in such cases, we need to manually register those archives.. correct ?
Pls. tell me if i am manually download and register files then do my FAL will do automatically applying future archives...... ?
Pls. help me as My PDC and DR are not in sync.
Thanks in advance...
Star nirav
October 19, 2006 - 2:53 pm UTC
guess you haven't figured out that TK isn't here.
we'll wait for him/her.
TK means technically King ;)
Star Nirav, October 19, 2006 - 4:47 pm UTC
Hey Tk,
I hope that you would like this nickname.
Anyways coming to the point that, I would surely like to have your expert advice on the above said issue.
Pls. let me know....
October 20, 2006 - 4:00 am UTC
man, you don't get it.
I will tell you the solution....
STAR NIRAV, October 20, 2006 - 4:58 pm UTC
In the above said case, need to follow the instructions.
1. see the gap of sequence in standby site.
2. download the said archives to standby site from PDC.
3. SQL > Shu immediate;
4. SQL > STARTUP NOMOUNT;
5. SQL > ALTER DATABASE MOUNT STANDBY DATABASE;
6. REGISTER THOSE FILES MANUALLY
7. SQL > ALTER DATABASE RECOVER AUTOMATIC STANDBY DATABASE
8. SQL > SELECT * FROM V$ARCHIVE_GAP; (STANDBY SIDE)
9. IF THERE IS ANY RECORDS THEN RE-RUN THE STEPS AGAIN.
10. THEN CANCEL THE RECOVERY AND MANUALLY LOGSWITCH IN PDC TO VERIFY THAT PDC AND DR IN SYNC MODE.
CORRECT MR. TK ???
REGARDS,
STAR NIRAV
October 20, 2006 - 5:47 pm UTC
When Mr. TK comes by - I'll be sure and ask him. Ok?
Ok... Tom, one clarification please
Star Nirav, October 23, 2006 - 4:42 pm UTC
In the above said case, need to follow the instructions.
1. see the gap of sequence in standby site.
2. download the said archives to standby site from PDC.
3. SQL > Shu immediate;
4. SQL > STARTUP NOMOUNT;
5. SQL > ALTER DATABASE MOUNT STANDBY DATABASE;
6. REGISTER THOSE FILES MANUALLY
7. SQL > ALTER DATABASE RECOVER AUTOMATIC STANDBY DATABASE
8. SQL > SELECT * FROM V$ARCHIVE_GAP; (STANDBY SIDE)
9. IF THERE IS ANY RECORDS THEN RE-RUN THE STEPS AGAIN.
10. THEN CANCEL THE RECOVERY AND MANUALLY LOGSWITCH IN PDC TO VERIFY THAT PDC
AND DR IN SYNC MODE.
CORRECT Tom ???
One confusion here is that in a given situation, we are supposed to move some big tables to another tablespace and hence we need to rebuilding indexes. So it is confirm that this activity will generate more archives and will try to ship all to DR (Standby) site, Now tom, i would like to have your feedback on this that how to come out from this situation when we are supposed to do this activity...?
Is there any hidden parameters which will constantly check and ship the archives from Prmary site to DR site ?
REGARDS,
STAR NIRAV
How to keep continue log-shipping ? respond please
Star Nirav, October 24, 2006 - 6:29 pm UTC
One confusion here is that in a given situation, we are supposed to move some
big tables to another tablespace and hence we need to rebuilding indexes. So it is confirms that this activity will generate more archives and will try to ship
all to DR (Standby) site, Now tom, i would like to have your feedback on this
that how to come out from this situation when we are supposed to do this
activity...?
Is there any hidden parameters which will constantly check and ship the archives from Prmary site to DR site ?
REGARDS,
STAR NIRAV
October 25, 2006 - 9:32 am UTC
please utilize support for setup/configuration of data guard.
Dataguard Linux 4 -> Linux 5
Daniel, September 13, 2007 - 2:28 am UTC
I understand that similar questions have been asked before but given the current ( much later than those discussed above) versions of Oracle and OS I feel I am still not exactly sure if :
1.Data guard ( PHYSICAL standby ) would work with
Primary DB on RH Linux rel 4 , Oracle 10.2.0.2 and
Standby DB on RH Linux rel 5 , Oracle 10.2.0.3
( both systems 64 bit Intel )
2. Same question for LOGICAL standby .
Oracle documentation is not entirely clear on the subject , although the phrasing in the DataGuard Conceps and Admin guide suggests that both configurations should work ...
My apologies for a repetitive question.
September 15, 2007 - 7:17 pm UTC
1) no, physical says "everything is the same"
2) same with logical
a failover is to be IDENTICAL operationally to the production machine, it can be smaller (less hardware), but everything else is the same.
One more doubt on Standby
tkl, November 21, 2007 - 2:29 am UTC
Can I run primary on one server,
stand by on a second server and
data guard on third one?
November 21, 2007 - 2:25 pm UTC
data guard is the infrastructure you use to implement a standby - not sure what you mean by "run data guard on a third one"
A reader, November 22, 2007 - 10:42 pm UTC
Tom,
Referring to the above post can we setup dataguard - physical between Sun OS 5.8 Oracle 9208 and Sun OS 5.10 Oracle 9208 both are 64 bit the only difference is OS version.
Thanks.
Oracle standby / dataguard
tkl, November 23, 2007 - 12:42 am UTC
Can I run primary on one server,
stand by on a second server and
data guard on third one?
Followup November 21, 2007 - 2pm US/Eastern:
data guard is the infrastructure you use to implement a standby - not sure what you mean by "run data guard on a third one"
What I meant is that I want to run standby database without data guard in one site and with data guard in yet another site simultaneously. Sorry for mix up
standby database
A reader, October 20, 2008 - 2:19 pm UTC
Tom,
Can I create standby DB on the different Disk group in ASM?
Primary uses DG as DB_DATA in ASM. Can I create standby DB in DG DEV_DATA in asm?
Thanks,
Kevin
October 21, 2008 - 3:39 pm UTC
you would typically use a different disk group as you would typically have the data guard site physically way away from production.
Not sure what sense it would make to have data guard running in the same ASM set of disks though, all of the disks would be in the same room. Data guard is used to protect you from losing the room - if the room burns up in a fire for example.
Can you expand on what you mean here?
oracle software requirement for standby
A reader, July 26, 2011 - 4:07 am UTC
Dear Tom,
I have to provide a estimation to my client for data guard. I am using below oracle software config (10.2.0.4 E.Ed.64 bit) for Primary database upgraded through patch:
Oracle Interim Patch Installer version 10.2.0.4.2
Copyright (c) 2007, Oracle Corporation. All rights reserved.
Oracle Home : /data/app/oracle/product/10204/db
Central Inventory : /data/app/oracle/product/10204/db/oraInventory
from : /var/opt/oracle/oraInst.loc
OPatch version : 10.2.0.4.2
OUI version : 10.2.0.4.0
OUI location : /data/app/oracle/product/10204/db/oui
Log file location : /data/app/oracle/product/10204/db/cfgtoollogs/opatch/opatch2011-07-26_14-45-04PM.log
Lsinventory Output file location : /data/app/oracle/product/10204/db/cfgtoollogs/opatch/lsinv/lsinventory2011-07-26_14-45-04PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (4):
Java 2 SDK 1.4.2.0.8
Java Runtime Environment 1.4.2.14.0
Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0
There are 4 products installed in this Oracle Home.
Therefore if I use only oracle 10.2.0.4 E.Ed. 64bit directly (without any upgradtion) for standby database will it be any problem?
July 28, 2011 - 6:23 pm UTC
the standby has to be at the same version in the production instance. any data dictionary changes would be there in the physical standby - the SOFTWARE that runs that database should be at the same release level.
Think about this - if you are running production 10.2.0.4.2 - you have to be running that for your failover site - otherwise, your failover site isn't CAPABLE of running your applications (you patched to 10.2.0.4.2 for a reason right? why wouldn't you have that SAME reason on your failover site when it becomes production?)
oracle software requirement for standby
A reader, July 29, 2011 - 9:06 am UTC
Dear Tom,
Therefore what do you suggest? Will I have to go as the sameway it was done in primary or we can straightway implement a standby database as:
Oracle Home : /data/app/oracle/product/10204/db
Central Inventory : n/a
from :
OPatch version : 10.2.0.4.2
OUI version : 10.2.0.4.0
OUI location : /data/app/oracle/product/10204/db/oui
Log file location : n/a
August 01, 2011 - 11:35 am UTC
i would suggest you patch up your standby so it is as the same release as the production site?
Error ORA-25153 while opening database
Ashish kumar, March 16, 2012 - 12:17 am UTC
Hi Tom,
I am trying to open my standby database in read only mode but i am getting below error:
ORA-00604: error occurred at recursive SQL level 1
ORA-25153: Temporary Tablespace is Empty
Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Instance terminated by USER, pid = 6729
ORA-1092 signalled during: alter database open read only
db version-8.1.7.0
os- sun 5.9
Any help will be appreciated.
Thanks,
Ashish
March 16, 2012 - 8:23 am UTC
[tkyte@localhost ~]$ oerr ora 25153
25153, 00000, "Temporary Tablespace is Empty"
// *Cause: An attempt was made to use space in a temporary tablespace with
// no files.
// *Action: Add files to the tablespace using ADD TEMPFILE command.
Setting up of DR on different Palteform
Amarnath, May 08, 2012 - 8:36 pm UTC
Hi Tom,
Thanks a ton for the responses on the multiple queries that we as DBAs have. I am working for a client where in the customer was looking of moving from AIX to Solaris the database version being 8.1.7. Though I knew exp/imp was the best option, when I went followed the discussion in here, there was a question in the middle of the entire discussion on "Setting up of DR on different Platform" - setting up of 8.1.7 Hot DR from AIX to Solaris. I googled this and looked it up on metalink as well. However, I could not find an answer. Is there any way to setup a DR like this?
Thanks & Regards,
Amarnath N
May 10, 2012 - 2:54 am UTC
data guard only works on homogeneous hardware/OS setups. There is (thankfully) no 'DR' (disaster recovery) between two totally different OS's. Imagine your failover was completely different from production - the day you need things to go smoothly - won't be that way.