What a loss of functionality in Data Guard?

What a loss of functionality so you really want to do it even if as you found Jeremy you can’t have long flashback retention you do want to use it bagel broker introduces some 10.2 and in 10.2 I had I would say I have it had some pretty bad problems their car broker wasn’t really stable in 10.2 I consider this an 11 it stabilized and from 11g onwards I would say always use the data car broker and certainly in 11.2 I didn’t have problems 11.1 some people say they did so 10.2 it wasn’t really there 11 users are we going to go over that use all going to go over the broker oh yes good technology I want you to do with yeah I guess that makes sense why I never did because I started 10-2 in right it sucked so let’s go we’ll see what this was crying no you find something doesn’t work in the first release and of course you don’t trust it ever again every you’re right you get comfortable with what works right yeah okay maybe if I got time to tinker but ya know almond.

You know to use almond to create your humble environments I always would it’s a sort of big false approach do it with armor and now all sorts of role transition services which your net execute with the broker with our manor from sequel plus the change in the role again to make the best out I’m already destroyed the role transition service going back a couple of slides if you have a snapshot standbys your stealth up as a physical fanboy role change the snapshot when you open this then when you reverse it back to apply the accumulation jazz that’s another role change I’ve talked about this slide system migration that’s a role change your primary might be the single instance window system you’ll stand by is the rack Linux system role change reverse them that all of a sudden your linear track is the primary and your windows is no exception redo as the samurais so all wrong transition services very important and you’ll see the syntax for doing this.

And the reasons I mentioned briefly multi counts now you’re not going to get away with not studying multi-tenant so whilst I’ll do is I’ll just put up there’s none of you using it at the moment I’ll give you just a very quick little list about multi talents which I’ll put into these I just writing it down to make sure I don’t forget anything now basically there’s one database there is one instance what does that mean it means one control file it means one let’s try to redo it means one undo table space that’s actually a bit different that’s different in release 12.2 so it’s one that a person one instance one day on the sets of background processes right never forget that there’s only one database in one instance right so what makes a difference well you have a CD be seen you been that’s the container database CDB and Canada herbaceous what is it well this is the database you have a CD be then you have PDP PDP pluggable containers pluggable containers and that begs the question of what is a container okay.

So what is a container try to contain this you have the root container 12 a container is nothing more than it’s a set of table spaces and a service you all market rack you know what services a container is a set of table spaces in the service you have a root container that’s the control structure it has systems so forks on doom temp and you use it to manage the environment then there’s what we call the feed container the food container that’s basically an extra 10 place this is system sis aux and temp just since this auction temp it’s just empty template is only ever read-only so it’s a read-only empty template then you have a pluggable container huggable containers and depending on your license as many as you want the pluggable container what’s this half the pluggable container has system silks Hank and all your user table spaces any number of user table spaces right amassed a vital point is got its own data dictionary.

So the root container is the control structures on the sounds of them each pluggable container is its own set of tape will space plus service and it has shared access to the resources managed from the root which are of course control far redo on do and so that’s what multi challenges and if not nearly as complicated if people would have you believe now that is a multi tenant in about twenty lines so to convert to multi heavens you take you to create your new CD be and at that point, you’ll see me be we just have roots and feed nothing more much ok any thank your 12 scene yep okay ladies a default 12-1 we were to build a brand new we’d get the multi-tenant we get a CD be would we get any pee DBS and it depends on how you credit databases okay if you’re the wrong video it’s just huge like a book do you want them okay and when he created the other basis if you do it create the database for the credible and that’s all you’ll get with the correct database command okay.

But if you use a BBC, yeah you get to see DBZ a few days yeah because business day Chris the root contains the sea container and then goes on to create the portable container and that scenario right there is not you don’t need an additional license nope as long as you have only one pluggable complainer, so the idea there is the body will do is create an empty CD be just for this and then you take your rise out of base your production databases you discard it’s a control file its redo it some disabled space they just get thrown away leave you with that and then you plug a med and the plug-in process in effect mount these table spaces on the root container on this on it sort of mount those on the CDB this sounds very similar eminence portable table spaces the underlying technology I’m sure is very close indeed but you don’t have to so basically you don’t have to do anything to recreate any metadata like you would transport you have to run the scripts against the data dictionary okay.

So they can run in those on bones, so thanks please pluggable container has a vented dictionary describing is local tables if users its grants it’s PL sequel you know all that says roles to their narcissus back yourself because I think it’s created when you plug it in yep okay so you don’t have to explicitly go create you create a trigger and redo no no no no no no no no no no get into that with transport or tail spaces, yeah, yeah so that’s all right now in most chance environment alterations done the roots because there’s only one database which is the root bridge in managed from the root and if you think that better guard is all about read oh well anyone is trying to redo so you do that from the root so basically anything you do is now the guard if done in the root container you cannot do anything about a guard in a pluggable container. After all, a pluggable container can’t manipulate things like redoing it could generate read it but if you logged on to the applicable content.

And you should come and like also system switch log files yeah I ain’t going to do anything such things don’t know to happen from the roots and everything is done for the entire data basis why Christopher Higgins is all about physical structures and pluggable containers all logical structures within the physical database now the only thing you can do is if you are in a true multi-tenant environment you can exclude certain pluggable tables pluggable databases now maybe your production databases have five pluggable containers you could have a physical standby to put only one of them so in effect you don’t bother to propagate changes for loads of textured table spaces you can create your pluggable database but moss and all the standbys you can choose which sound bites to create them in and that will control where you’re going to propagate the data files and so on their spelling snake next so not wash your hands you just do it all in the root container.

There’s no real difference this thing takes up to the very end now depending on your release you’re all 11g possibly moving to 12 we’re already we’re on 12 so 12 fine you would access to pretty much everything going to talk about that’s just the history of what you’ve course as you go through things now and of all these the only licensed point is that your time ago so nothing concludes our introduction I try to position data guard as being a lot more than zero divorces that are so trying to do makes a lot more than zero divorces so what you have to do is to find what you want to achieve now what are you actually doing this for nice and choose the appropriate technology.

Leave a comment