This forum is currently locked. You can't register or post questions at this time. (read more)

Regarding Poorman's Dataguard

All posts relating to Oracle database administration.

Moderator: Tim...

sivakumarocp
Advisor
Posts: 260
Joined: Sat Jun 27, 2009 3:53 am
Location: India

Regarding Poorman's Dataguard

Postby sivakumarocp » Fri Mar 23, 2012 11:28 am

Hi Tim,

Tomorrow I am going to perform production database migration from one host to another which is running on solaris O/S.

For this activity i need to migrate two databases are running on same host.

My lead said need to use Poorman dataguard concept for once curcial database!

I head of Dataguard, but I haven't heard about Poorman Dataguard!

what it is actually and how do i setup. and what is the purpose of this kind of setup
Regards
Sivakumar.A
www.sivakumardba.com

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Regarding Poorman's Dataguard

Postby Tim... » Fri Mar 23, 2012 1:21 pm

Hi.

I can't be sure what he means, so it's probably best to ask him, but he may mean one of the following:

1) Make a backup of the database. Move the backup to the new server and recover it there. Rather than opening it when you're done, keep it in recovery mode and manually ship the archived redo logs across to it and keep recovering.

2) Basically, the same thing, but start by using a database duplication (RMAN DUPLICATE).

Like I say, you best ask him to see what he means by that.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

sivakumarocp
Advisor
Posts: 260
Joined: Sat Jun 27, 2009 3:53 am
Location: India

Re: Regarding Poorman's Dataguard

Postby sivakumarocp » Wed Apr 04, 2012 5:14 am

Hi Tim,

sorry for the late reply on this topic.
Actually I did host migration successfully on that day itself using poorman dataguard concept.
Poorman dataguard is nothing but, couple of minutes before to start the production down time we will setup standby database on new host using backups + archivelogs on the database which we are going to move and we will apply archivelogs whichever is generating on production.

Once the production down time starts we just copy the remainig archive logs and apply to standby database. after that need to shutdown the standby database and remove standby controlfile. then from production database copy the redologs and controlfiles and transfer it to new host.

now we should be able to start the database on new host with out resetlogs option!

Purpose of using this method is to eliminate production down time when we have databse with has huge size :)

Please let me know your comments on this.
Regards
Sivakumar.A
www.sivakumardba.com

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Regarding Poorman's Dataguard

Postby Tim... » Wed Apr 04, 2012 10:03 am

Hi.

I have no comments. This is a pretty typical manual migration.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

sivakumarocp
Advisor
Posts: 260
Joined: Sat Jun 27, 2009 3:53 am
Location: India

Re: Regarding Poorman's Dataguard

Postby sivakumarocp » Thu Apr 05, 2012 2:12 am

:D
Regards
Sivakumar.A
www.sivakumardba.com

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Regarding Poorman's Dataguard

Postby Tim... » Thu Apr 05, 2012 9:19 am

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 0 guests