Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is this replication?
Kenny
What you're describing is standby database. The only problem with this approach is your QA database will be mounted in recovery mode. You can open it in query only mode in 8.1, then put it back to mounted mode later if you want to (note that this is an 8.1 feature that was not available in earlier releases). Any archivelogs that have been generated while the database is open will simply queue up ready to be applied when you go back to recovery mode.
Another alternative might be export / import, but if the database is really growing that rapidly becomes unwieldy due to timeslot concerns (how long you have available to do the import).
HTH. Pete
Kenny wrote:
> Hey Everyone,
>
> Oracle Version 8.1.5
> Sun Solaris 2.6
> Production DB size 2GIG and growing rapidly
>
> I have been asked to replicate our production database every night into our QA
> database. I wasnt sure the best way to go about this. Here is my simple plan,
> can some of you give me advs/disadvs of the idea.
>
> Production is in archivelog mode. I plan to create the QA database
> architecture very similarly, tables, views, indexes, etc...but this QA db will
> be in a constant state of recovery, always applying productions archivelogs....
>
> This seems like a simple plan, but is there any information in the archivelogs
> that specifies db_name or anything like that. I guess my question is, can I
> apply redo logs to a different database that the one they originally came from?
>
> THanks in advance
> -Kenny
Received on Thu Oct 14 1999 - 17:04:00 CDT