261 reputation
135
bio website auxilitus.co.uk
location United Kingdom
age 46
visits member for 3 years, 3 months
seen 10 hours ago
Application Support Specialist

Oct
1
answered How do I determine the licensing cost of Oracle Standard Edition for HyperV instances?
May
24
awarded  Caucus
May
24
awarded  Constituent
May
4
comment Duplicating a Database with RMAN
Am I missing something here? Are you creating the new instance as you should be able to set up the instance to use an spfile before running the rman duplicate command. Otherwise you'll need to take a note of the control file names as you will need to edit the pfile to update the control file statement if I am not mistaken
Aug
26
comment Can the default minimum date range for 'datetime' be changed in SQL Server 2008 R2?
If memory serves me right, this goes back to the change from the julian calendar to the gregorian Calendar in 1752. The 1st jan was the first full year after the change hence the reason for it being selected. Picking dates prior to the change in calendars is fraught with complications.
Jul
9
comment Flashback feature in Oracle 11g?
@madhu, this on is very much a it depends issue. Flashback logs changes just like archive logs So the volume of changes will dictate how much space you'll need. For example I did some work on an 80gb database but it generated 250gb of flashback logs, but that was some pretty extreme changes to the database. Hopefully you have a good idea of what needs to be done and set the flashback recovery area appropriately. Then keep an eye on the flashback recovery area usage view to monitor its usage of that area
Jul
7
comment Flashback feature in Oracle 11g?
A word of warning about just creating a restore point, there is a limit on how much flashback is held. Use create retore point before_Load guaranteed flashback database. Also make sure your the size of yor recovery area and disk space is sufficient to hold your changes. If you run out of space it can easily mean you cannot restore from it.
May
19
awarded  Yearling
Nov
21
awarded  Fanatic
Oct
29
comment Should I use SQL JOIN or IN Clause?
I agree with the use of exists rather than a join when trying to avaoid duplication. From my own experience with SQL server was the exists and inner join produced the same query plan anyway. I did have some performance concerns about 'in' statements but they only surfaced when the select in the in statement started to return several thousand rows.
Sep
28
answered Is this a standard way to design a database?
Sep
17
comment Oracle Backup and Recovery Issue
Assuming these are os files a simple restore would work, but if your using ASM you will need to take care of the original files as new ones will be created. The original ones will just take up space and make removing them a little harder later on.
Sep
12
awarded  Enthusiast
Aug
28
answered Check if DISTINCT is really necessary
Jul
22
comment Oracle Restore and recover Database on the same host?
No one main point when duplicating using the commands I've said it uses the backups as a point of reference. There is an option to copy the live data base but this has failed in my experience. As for a good DBA I'm not so sure, I've done this a lot out of a requirement to update preproduction environments using this method hence the details but as far as oracle I've still got a long way to go. But hey, the journey is fun.
Jul
20
awarded  Editor
Jul
20
revised Oracle Restore and recover Database on the same host?
inital draft was a rough outline, added more detail in the edited version
Jul
20
answered Oracle Restore and recover Database on the same host?
Jun
21
answered Why does DataContext.SubmitChanges() Exist?
May
20
awarded  Teacher