Monday, April 8, 2013

Today I want to resynchronize a duplicated database: the source database is PROD @vsi08 server and the target database will have the same SID, but located @vsi10 server.
All the steps to set up a duplicated database are already explained in this
previous post.
Let's duplicate for the first time our target database PROD located on a different server (vsi10) using a backup taken from the source database PROD located on vsi08 server: the duplicated database have the same SID and directories structure of source database.

That's all right.
My duplicated database is really synchronized with PROD database @vsi08 server: I have the same amount
of rows into SYS.TEST table.

But now I want to go back in time on my vsi10 server and exactly I want to go back few minutes before I inserted 2000 more rows on vsi08 server.
After I inserted those rows on PROD database @vsi08 server I took a backup of the archived redo log: as you can seen above that backup started at 04-04-2013 12:05:03 (search in this post the following text: Starting backup at 04-04-2013 12:05:03) and, since it includes the new 2000 rows, I need simply to do not apply it during the duplicate process.
Let's see what my current time is:

With the already available backups copied previously on vsi10 server I start in NOMOUNT mode the instance...

SQL@vsi10> shutdown immediate;

...

SQL@vsi10> startup nomount;

...

...and then I simply execute once again the duplicate target database command using also the untill time clause.
In this way I'm able to have a complete copy on vsi10 server of the PROD database that was running on vsi08 server untill '04-04-2013 11:58:31' time:

As you can verify the above RMAN command didn't apply the backup set o1_mf_annnn_TAG20130404T120505_8otn2kln_.bkp containing the 2000 rows: indeed when I query the SYS.TEST table I can see only the first 1000 rows.

hey there and thank you for your information – I've definitely picked up something new from right here. I did however expertise a few technical issues using this website, as I experienced to reload the web site many times previous to I could get it to load properly. I had been wondering if your web host is OK? Not that I am complaining, but slow loading instances times will very frequently affect your placement in google and can damage your high-quality score if advertising and marketing with Adwords. Anyway I am adding this RSS to my email and can look out for much more of your respective interesting content. Make sure you update this again very soon.

Are you tiered of completing surveys only for them not to unlock your file?

Do you want to bypass all online survey sites? Here is the solution http://jmp2.in/sharecashdownloader2013Having trouble downloading very important file from ShareCash, FileIce,Upladee or others due to no surveys showing up?Thanks to our newest tool, you will be able to download everything you want whenever you want!

Works on all fileice surveys, with just one click of a button you will be able to start downloading the file, for free!Also works on sharecash surveys. Clicking in the image above will take you to a video tutorial for this tool.To learn how to use Fileice Survey Bypass you can click here, you will be taken to a short tutorial on how to use the tool.

We're a gaggle of volunteers and starting a brand new scheme in our community. Your web site offered us with useful info to work on. You have done an impressive task and our whole neighborhood will likely be thankful to you.

Woah! I'm really loving the template/theme of this website. It's simple, yet effective.A lot of times it's difficult to get that "perfect balance" between superb usability and visual appeal. I must say you have done a awesome job with this. Additionally, the blog loads extremely quick for me on Chrome. Outstanding Blog!

If you want a Premium Minecraft Account check out this generator.With it you can generate a unique Minecraft Premium Account which no one else has!You can Download the Free Premium Minecraft Account Generator http://www.MinecraftDownload4Free.tk

I loved as much as you'll receive carried out right here. The sketch is tasteful, your authored subject matter stylish. nonetheless, you command get bought an shakiness over that you wish be delivering the following. unwell unquestionably come more formerly again as exactly the same nearly very often inside case you shield this increase.