Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, vishnudas.

Asked: October 31, 2018 - 1:35 pm UTC

Last updated: November 05, 2018 - 1:37 am UTC

Version: 11.2.0.1.0

Viewed 1000+ times

You Asked

hi there we are using oracle database 11g (11.2.0.1.0 Standard Edition one) for our production db
i have gone through the docs to setup automatic log apply which is available only for
Enterprise Edition..

i saw the notes from the doc saying that

'It is possible to simulate a standby database environment with databases running Oracle Database Standard Edition. You can do this by manually transferring archived redo log files using an operating system copy utility or using custom scripts that periodically send archived redo log files from one database to the other. '

my doubt is how can i up a standby database from the primary db???
do i have to create a listner for my standby db??




would you guys please help me to resolve this..



and Connor said...

my doubt is how can i up a standby database from the primary db???


If we forget the term "standby" for a moment, then think about what you would if your production server caught fire? You would:

- get a new server
- restore the production database from backup
- recover it forward with archivelogs
- open it for business

DataGuard automates all of this, but if you don't have it, you can do it yourself. So the steps are:

1) Create a manual standby

- get a new server
- install oracle software as per normal
- take a production backup and restore it to a new server
- you don't explicitly need a listener but you may as well have one to save effort if you ever have to activate this database

2) Keep the standby in sync

- If the backup you used to create the standby was from last night, you would take all the archives from that point (from production), copy them over to the standby node and run a recover command. This bring your database back up to date. Do *not* open the database. Just leave it mounted.

- Now (say) every hour etc, you simply poll your production database for *new* archivelogs, copy them over to the standby server, and keep running the recover.

That's what we mean by manual standby.

Rating

  (4 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

vishnudas, November 02, 2018 - 5:18 am UTC

i got cleared 80% of your answer..and forgive me if i am
troubling you again :D :D :D
1) do i have to install software only on standby??
2) do i have to create the same directory structure for my
standby database???

if you guys have any official docs for this article???

Smith, November 02, 2018 - 12:41 pm UTC

Yes,vishnudas.
Just install software only for standby database.
And restore and recover database using rman utility. after this process, your database is in "mount" mode not in "open" mode.
And In Production database, Tranfer archive log to Stand-by database. And using rman utility to apply archive log to database on stand-by database so your database also up to date.when your production database down. Your Stand-by database is ready for use.

i hope you understand.
Connor McDonald
November 05, 2018 - 1:36 am UTC

good input.

Smith, November 02, 2018 - 12:42 pm UTC

vishnudas, for directory structure,
I think You need same directory structure but not know in onwards 11g Database.

vishnudas, November 05, 2018 - 6:52 am UTC

Thank you guys for your valuable support :) :)
Thank you smith for your comment, now i go for a stable Testing
:)

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database