tag:blogger.com,1999:blog-33052929710375281102024-03-14T00:54:09.047-07:00arir's Oracle BlogOracle blog to help fellow DBA's with their ongoing quest to master the Oracle Database and it's multiplying featuresAri Riikonenhttp://www.blogger.com/profile/13408446454232280294noreply@blogger.comBlogger15125tag:blogger.com,1999:blog-3305292971037528110.post-12022508824085599832014-08-22T13:41:00.001-07:002014-08-23T02:31:40.070-07:00CHEF: New dev progress on oracle cookbookGreetings,<br />
<br />
After the summer holidays, the oracle cookbook will undergo some major changes. With Dominique (THE co-author), we'll be streamlining the cookbook to more LWRP/HRWP style. v1.3.0 will include some tidy-up on the cookbook, but v2.0.0 will bust the bank. My personal goal is to get the grid infrastructure install and ASM disk usage incorporated to the cookbook (v1.3.0). It's one of the steps closer to the RAC. Also going to glance the patching of existing Oracle installations through (amazing) Chef installations, is on the queue. I'm also working to convert my simple ksh Oracle backup script to Ruby. This will be a circle end of the DBA work I've been doing for the past years. So, stay tuned for more from the oracle cookbook! Check the Road map on README.md.<br />
<br />
We'll also change the documentation structure of the cookbook. The README.md is getting way too big for the getting the relevant information for the audience, so we'll be splitting it to smaller doc files.<br />
<br />
Br, Ari aka @dmoarir or arir on IRCAri Riikonenhttp://www.blogger.com/profile/13408446454232280294noreply@blogger.com0tag:blogger.com,1999:blog-3305292971037528110.post-72081693936592303222014-05-23T19:08:00.001-07:002014-05-24T13:09:15.223-07:00CHEF: oracle cookbook v1.2.0 now released!New version 1.2.0 of the oracle cookbook now available at:<br />
<br />
<a href="http://community.opscode.com/cookbooks/oracle">http://community.opscode.com/cookbooks/oracle</a><br />
and<br />
<a href="https://github.com/aririikonen/oracle">https://github.com/aririikonen/oracle</a><br />
<br />
New in v1.2.0<br />
<br />
<ul>
<li>Support for Oracle 12c databases with DBEXPRESS configured out of the box</li>
<li>Fixed few issues on recording oracle version and timestamp of the installation (get_version.rb)</li>
</ul>
<br />
Try it out and please report any issues to GitHub.<br />
<a href="https://github.com/aririikonen/oracle/issues">https://github.com/aririikonen/oracle/issues</a><br />
<br />
Next I'll start to bake the Oracle 12c Grid Infrastructure installation.<br />
<div>
<br /></div>
Ari Riikonenhttp://www.blogger.com/profile/13408446454232280294noreply@blogger.com1tag:blogger.com,1999:blog-3305292971037528110.post-5398695465614648642014-04-21T14:40:00.000-07:002014-04-21T14:40:29.326-07:00CHEF: What's new in oracle cookbook v1.1.2?After discussing with Eric Wolfe (<a href="https://twitter.com/atomic_penguin" target="_blank">@atomic_penquin</a>) at #ChefConf2014, I added a recipe to handle the OS setup for Oracle databases on CentOS/RedHat. ora_os_setup.rb will perform the following tasks:<br />
<br />
<ul>
<li>Create the 'oracle' os user based on the encrypted data bag information</li>
<li>Install dependency rpm packages for the Oracle binaries</li>
<li>Configure kernel parameters</li>
</ul>
<div>
<br /></div>
<div>
Basically it is just a reduced default.rb. Tested it, but if you find any issues with it, please create an issue/pull request on GitHub.</div>
<div>
<br /></div>
<div>
<a href="https://github.com/aririikonen/oracle" target="_blank">https://github.com/aririikonen/oracle</a></div>
<div>
or</div>
<div>
<a href="http://community.opscode.com/cookbooks/oracle" target="_blank">http://community.opscode.com/cookbooks/oracle</a></div>
Ari Riikonenhttp://www.blogger.com/profile/13408446454232280294noreply@blogger.com0tag:blogger.com,1999:blog-3305292971037528110.post-90542312004624663492014-04-11T05:04:00.003-07:002014-04-11T13:53:55.826-07:00CHEF: Installing Oracle database with Virtualbox (or vmware workstation, vagrant(vmware plugin)), chef-solo and test kitchen<h1 style="border: 0px; clear: both; color: #2b2b2b; margin: 0px 0px 12px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-size: small;"><span style="font-weight: normal; line-height: 22.153844833374023px;">"As hot as the microwave popcorn after the beep!"</span></span></h1>
<div>
<span style="line-height: 22.153844833374023px;">My friend Scott Russell (<a href="https://github.com/sc0ttruss" target="_blank">sc0ttruss</a>) has created a really nifty bash script to install an Oracle 11.2 database without the full and sometimes heavy chef environment solely for testing purposes.</span><br />
<span style="line-height: 22.153844833374023px;"><br /></span>
<span style="font-size: small;"><span style="line-height: 22.153844833374023px;">This bash script uses chef-solo, vagrant (virtualbox or vmware ws (vagrant-plugin)), test-kitchen, bento images to pop up an Oracle VM (CentOS) in less than 35 minutes (run time).</span></span><span style="line-height: 22.153844833374023px;"> </span><span style="line-height: 22.153844833374023px;">Of course run time depends heavily on the HW you are running.</span><span style="line-height: 22.153844833374023px;"> It works with the latest Oracle v1.1.1 cookbook.</span></div>
<div>
<span style="font-size: small;"><span style="font-weight: normal; line-height: 22.153844833374023px;"><br /></span></span></div>
<div>
Testkichenscripts:</div>
<div>
<a href="https://github.com/sc0ttruss/Testkitchenscripts">https://github.com/sc0ttruss/Testkitchenscripts</a></div>
<div>
<br /></div>
<div>
He also has a nice blog post about it here:</div>
<div>
<a href="http://blog.inetmedia.co.uk/wp/?p=8">http://blog.inetmedia.co.uk/wp/?p=8</a></div>
<div>
<br /></div>
<div>
Check it out! Try it out!</div>
Ari Riikonenhttp://www.blogger.com/profile/13408446454232280294noreply@blogger.com1tag:blogger.com,1999:blog-3305292971037528110.post-10474015869757923682014-04-04T15:45:00.000-07:002014-04-06T10:42:48.783-07:00CHEF: Announcing relaunched oracle cookbook v1.1.0!I'm happy to let you know, that the v1.1.0 of the cookbook has been released. I've released under my own user-id on GitHub. Please check it out at:<br />
<br />
<a href="https://github.com/aririikonen/oracle"><span style="font-size: large;">Oracle chef cookbook v1.1.0</span></a><br />
<br />
<h4>
New features in version v1.1.0</h4>
<br />
<ul>
<li>Configure the EM dbconsole (Enterprise Manager Database Control)</li>
<li>Install Oracle Client and patch it to the latest patch</li>
</ul>
<div>
<br />
Few notes:<br />
<br /></div>
<div>
The EM dbconsole is configured for every database. You can turn it off from <span style="font-family: Courier New, Courier, monospace;">attributes/default.rb</span>, if you don't want it configured by default. It does extend the install time, but I also modified the <span style="font-family: Courier New, Courier, monospace;">default_template.dbt</span> to have less options on by default. The older template is now named as <span style="font-family: Courier New, Courier, monospace;">midrange_template.dbt</span>. For v1.1.1 I will make the template file name it as a node attribute, so that you can override it from a role for example.<br />
<br />
For the Oracle client, please modify the <span style="font-family: Courier New, Courier, monospace;">templates/default/tnsnames.ora</span> to best match your database layout. Currently it is only has an example.</div>
<div>
<br /></div>
<div>
Please try it out, contribute and read the "Roadmap" chapter on the README.md for planned features.</div>
Ari Riikonenhttp://www.blogger.com/profile/13408446454232280294noreply@blogger.com1tag:blogger.com,1999:blog-3305292971037528110.post-47064887661631810832014-03-10T01:36:00.002-07:002014-04-08T10:56:42.305-07:00CHEF: echa-oracle cookbook update coming out soon (v1.1.0)Update 4/8/2014: v1.1.1 is out! <a href="https://github.com/aririikonen/oracle">https://github.com/aririikonen/oracle</a><br />
<br />
Just wanted to post an announcement about the echa-oracle cookbook. There's going to be an update to version 1.1.0 soon. I've added a possibility to install Oracle Client 11.2 as well. Please, stay tuned.Ari Riikonenhttp://www.blogger.com/profile/13408446454232280294noreply@blogger.com6tag:blogger.com,1999:blog-3305292971037528110.post-7892494187881931682013-07-22T14:01:00.002-07:002014-04-20T13:03:31.496-07:00CHEF: echa-oracle updated to v1.0.4, Patch 16619892 - 11.2.0.3.7 Patch Set UpdateUpdated the cookbook to use the latest Oracle patch which was released on 7/16/2013, Patch 16619892 - 11.2.0.3.7 Patch Set Update. Downloaded the new patch from <a href="https://support.oracle.com/">https://support.oracle.com</a> and placed it to the HTTPS media site (check the cookbook README.md for more details). At the same go decided to update the opatch version from 11.2.0.3.3 to 11.2.0.3.4.<br />
<br />
Procedure itself was straight forward. Depends of course if you are overriding the default attributes from the <span style="font-family: Courier New, Courier, monospace;">ora_quickstart</span> role or just using the default attributes.<br />
<br />
1. Changed the <span style="font-family: Courier New, Courier, monospace;">attributes/default.rb</span>.<br />
<blockquote class="tr_bq">
<span style="font-family: Courier New, Courier, monospace;">default[:oracle][:rdbms][:latest_patch][:url] = 'https://secure.server.localdomain/path/to/<b><span style="color: red;">p16619892_112030_Linux-x86-64.zip</span></b>'</span> </blockquote>
<blockquote class="tr_bq">
<span style="font-family: 'Courier New', Courier, monospace;">default[:oracle][:rdbms][:latest_patch][:dirname] = '</span><b style="font-family: 'Courier New', Courier, monospace;"><span style="color: red;">16619892</span></b><span style="font-family: 'Courier New', Courier, monospace;">'</span></blockquote>
<div>
2. Changed the <span style="font-family: Courier New, Courier, monospace;">ora_quickstart.rb</span> role.</div>
<div>
<blockquote class="tr_bq">
<span style="font-family: Courier New, Courier, monospace;">name "ora_quickstart"</span><span style="font-family: Courier New, Courier, monospace;">description "Role applied to Oracle quickstart test machines."</span><span style="font-family: Courier New, Courier, monospace;">run_list 'recipe[echa-oracle]', 'recipe[echa-oracle::logrotate_alert_log]', 'recipe[echa-oracle::logrotate_listener]', 'recipe[echa-oracle::createdb]'</span><span style="font-family: Courier New, Courier, monospace;">override_attributes :oracle => {:rdbms => {:latest_patch => {:url => 'https://</span><span style="font-family: 'Courier New', Courier, monospace;">secure.server.localdomain/path/to/<b><span style="color: red;">p16619892_112030_Linux-x86-64.zip</span></b>'}, :opatch_update_url => 'https://</span><span style="font-family: 'Courier New', Courier, monospace;">secure.server.localdomain/path/to</span><span style="font-family: 'Courier New', Courier, monospace;">/<b><span style="color: red;">p6880880_112000_Linux-x86-64.zip</span></b>', :install_files => ['https://</span><span style="font-family: 'Courier New', Courier, monospace;">secure.server.localdomain/path/to</span><span style="font-family: 'Courier New', Courier, monospace;">/p10404530_112030_Linux-x86-64_1of7.zip', 'https://</span><span style="font-family: 'Courier New', Courier, monospace;">secure.server.localdomain/path/to</span><span style="font-family: 'Courier New', Courier, monospace;">/p10404530_112030_Linux-x86-64_2of7.zip']}}</span></blockquote>
</div>
3. Uploaded the role to Hosted Chef.<br />
<blockquote class="tr_bq">
<span style="font-family: 'Courier New', Courier, monospace;">knife role from file roles/ora_quickstart.rb</span></blockquote>
<div>
4. After changing <span style="font-family: Courier New, Courier, monospace;">metadata.rb</span>, <span style="font-family: Courier New, Courier, monospace;">CHANGELOG.md</span> and<span style="font-family: Courier New, Courier, monospace;"> README.md</span>, committed & pushed to GitHub.</div>
<div>
<br /></div>
<div>
5. Uploaded the new cookbook v1.0.4 to Hosted Chef.</div>
<blockquote class="tr_bq">
<span style="font-family: Courier New, Courier, monospace;">knife cookbook upload echa-oracle --freeze</span></blockquote>
<div>
6. Ran a test on EC2, which proved to be successful. (Old post, but still using the same procedure for testing - <a href="http://oraarir.blogspot.fi/2013/06/chef-echa-oracle-v100-cookbook-tests-on.html">CHEF: echa-oracle v1.0.0 cookbook tests on EC2</a>)<br />
<br />
For further details about the cookbook check from Opscode community site at <a href="http://community.opscode.com/cookbooks/oracle">http://community.opscode.com/cookbooks/oracle</a>.</div>
<div>
<br /></div>
Ari Riikonenhttp://www.blogger.com/profile/13408446454232280294noreply@blogger.com0tag:blogger.com,1999:blog-3305292971037528110.post-28736491497844740062013-06-25T04:49:00.001-07:002014-04-20T13:02:16.258-07:00CHEF: echa-oracle v1.0.0 cookbook tests on DigitalOcean<u><b>Update on 4/4/2014:</b></u> The cookbook has been re-launched at <a href="https://github.com/aririikonen/oracle">https://github.com/aririikonen/oracle</a>, also available from Chef community site at <a href="http://community.opscode.com/cookbooks/oracle">http://community.opscode.com/cookbooks/oracle</a>.<br />
<br />
Further smoke testing for echa-oracle v1.0.0 cookbook. This time on DigitalOcean CentOS 6.4 x64 VM. (check out <a href="https://www.digitalocean.com/">https://www.digitalocean.com</a>, low cost VM's)<br />
<br />
<b>Pre-reqs (mainly the same as for EC2, post below):</b><br />
<ul><span style="background-color: white; color: #444444; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; line-height: 18px;">
<li style="font-size: 13px;">Opscode sign up (<a href="https://community.opscode.com/users/new" style="color: #4d469c; text-decoration: none;">https://community.opscode.com/users/new</a>)</li>
<li style="font-size: 13px;">Hosted Chef (free) setup (<a href="https://learnchef.opscode.com/" style="color: #4d469c; text-decoration: none;">https://learnchef.opscode.com/</a>)</li>
<li style="font-size: 13px;">echa-oracle cookbook uploaded (<a href="https://github.com/aririikonen/oracle">https://github.com/aririikonen/oracle</a>)</li>
<li style="font-size: 13px;">ora_quickstart role set and uploaded (check echa-oracle cookbook README.md for more info)</li>
<li><span style="font-size: x-small;">Oracle media on a HTTPS or HTTP site, preferably a non-public site. Check the following </span><span style="font-family: Courier New, Courier, monospace;">derault.rb</span><span style="font-size: x-small;"> attributes:</span></li>
<ul style="font-size: 13px;">
<li><span class="n" style="color: #333333; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; white-space: pre;">default</span><span class="o" style="color: #333333; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; font-weight: bold; white-space: pre;">[</span><span class="ss" style="color: #990073; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; white-space: pre;">:oracle</span><span class="o" style="color: #333333; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; font-weight: bold; white-space: pre;">][</span><span class="ss" style="color: #990073; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; white-space: pre;">:rdbms</span><span class="o" style="color: #333333; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; font-weight: bold; white-space: pre;">][</span><span class="ss" style="color: #990073; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; white-space: pre;">:install_files</span><span class="o" style="color: #333333; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; font-weight: bold; white-space: pre;">]</span></li>
<li><span class="o" style="color: #333333; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; font-weight: bold; white-space: pre;"><span class="n" style="font-weight: normal;">default</span><span class="o">[</span><span class="ss" style="color: #990073; font-weight: normal;">:oracle</span><span class="o">][</span><span class="ss" style="color: #990073; font-weight: normal;">:rdbms</span><span class="o">][</span><span class="ss" style="color: #990073; font-weight: normal;">:opatch_update_url</span><span class="o">]</span></span></li>
<li><span class="n" style="color: #333333; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; white-space: pre;">default</span><span class="o" style="color: #333333; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; font-weight: bold; white-space: pre;">[</span><span class="ss" style="color: #990073; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; white-space: pre;">:oracle</span><span class="o" style="color: #333333; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; font-weight: bold; white-space: pre;">][</span><span class="ss" style="color: #990073; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; white-space: pre;">:rdbms</span><span class="o" style="color: #333333; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; font-weight: bold; white-space: pre;">][</span><span class="ss" style="color: #990073; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; white-space: pre;">:latest_patch</span><span class="o" style="color: #333333; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; font-weight: bold; white-space: pre;">][</span><span class="ss" style="color: #990073; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; white-space: pre;">:url</span><span class="o" style="color: #333333; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; font-weight: bold; white-space: pre;">]</span></li>
</ul>
</span></ul>
<span style="background-color: white; color: #444444; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18px;">
</span><b>More straight forward steps:</b><br />
<ul>
<li>Whipped out a 2G MEM VM (CentOS 6.4 x64)</li>
<li>Modified /etc/hosts to add a valid FQDN</li>
<li>Bootstrapped with:</li>
</ul>
<div>
<span style="font-family: Courier New, Courier, monospace;">knife bootstrap FQDN -r 'role[ora_quickstart]' -j '{"oracle" :{"rdbms" :{"dbs" :{"FOO" :false}}}}'</span><br />
<br />
<span style="font-family: inherit;"><b>Result:</b></span><br />
<span style="font-family: inherit;"><br /></span>
<span style="font-family: inherit;">Success.</span><br />
<span style="font-family: inherit;"><br /></span>
<span style="font-family: inherit;"><b>Notes (also check below for EC2 notes):</b></span><br />
<ul>
<li>Deployment will take some time, especially installing the Oracle binaries, latest patch and db creation, so don't be alarmed if it seems to be stuck, it isn't. Just check 'top' on the VM to verify this.</li>
<li>Swap missing again, so you'll need to add it later on.</li>
<li>Check that /dev/shm is big enough.</li>
</ul>
<div>
<b>Sample output:</b></div>
</div>
<div>
<b><br /></b></div>
<div>
<a href="https://gist.github.com/aririikonen/5925691">https://gist.github.com/aririikonen/5925691</a></div>
Ari Riikonenhttp://www.blogger.com/profile/13408446454232280294noreply@blogger.com0tag:blogger.com,1999:blog-3305292971037528110.post-36837050026496753562013-06-25T03:22:00.002-07:002014-04-20T13:02:45.014-07:00CHEF: echa-oracle v1.0.0 cookbook tests on EC2<b><u>Update on 4/4/2014:</u></b> The cookbook has been re-lauched at <a href="https://github.com/aririikonen/oracle">https://github.com/aririikonen/oracle</a> (v1.1.x), also available from Chef community site at <a href="http://community.opscode.com/cookbooks/oracle">http://community.opscode.com/cookbooks/oracle</a>.<br />
<br />
Been a while since I've posted something. This time it is about Chef and the new echa-oracle cookbook. At the time writing this post, echa-oracle cookbook has not been released yet, but I'll link the GitHub repo here once it is available.<br />
<br />
Wanted to make sure, that before releasing the echa-oracle cookbook, I'll run a few smoke tests against some instances on EC2 and post the results here.<br />
<br />
<b>Pre-reqs:</b><br />
<ul>
<li>Opscode sign up (<a href="https://community.opscode.com/users/new">https://community.opscode.com/users/new</a>)</li>
<li>Hosted Chef (free) setup (<a href="https://learnchef.opscode.com/">https://learnchef.opscode.com/</a>)</li>
<li>Chef client with knife-ec2 setup (<a href="http://wiki.opscode.com/display/chef/EC2+Bootstrap+Fast+Start+Guide">http://wiki.opscode.com/display/chef/EC2+Bootstrap+Fast+Start+Guide</a>)</li>
<li>knife.rb ready with ec2 details</li>
<li>echa-oracle cookbook uploaded (<a href="https://github.com/aririikonen/oracle">https://github.com/aririikonen/oracle</a>)</li>
<li>ora_quickstart role set and uploaded (check echa-oracle cookbook README.md for more info)</li>
<li>Oracle media on a HTTPS or HTTP site, preferably a non-public site. Check the following <span style="font-family: Courier New, Courier, monospace;">derault.rb</span> attributes:</li>
<ul>
<li><span class="n" style="background-color: white; color: #333333; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; line-height: 18px; white-space: pre;">default</span><span class="o" style="background-color: white; color: #333333; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; font-weight: bold; line-height: 18px; white-space: pre;">[</span><span class="ss" style="background-color: white; color: #990073; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; line-height: 18px; white-space: pre;">:oracle</span><span class="o" style="background-color: white; color: #333333; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; font-weight: bold; line-height: 18px; white-space: pre;">][</span><span class="ss" style="background-color: white; color: #990073; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; line-height: 18px; white-space: pre;">:rdbms</span><span class="o" style="background-color: white; color: #333333; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; font-weight: bold; line-height: 18px; white-space: pre;">][</span><span class="ss" style="background-color: white; color: #990073; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; line-height: 18px; white-space: pre;">:install_files</span><span class="o" style="background-color: white; color: #333333; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; font-weight: bold; line-height: 18px; white-space: pre;">]</span></li>
<li><span class="o" style="background-color: white; color: #333333; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; font-weight: bold; line-height: 18px; white-space: pre;"><span class="n" style="font-weight: normal;">default</span><span class="o">[</span><span class="ss" style="color: #990073; font-weight: normal;">:oracle</span><span class="o">][</span><span class="ss" style="color: #990073; font-weight: normal;">:rdbms</span><span class="o">][</span><span class="ss" style="color: #990073; font-weight: normal;">:opatch_update_url</span><span class="o">]</span></span></li>
<li><span class="n" style="background-color: white; color: #333333; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; line-height: 18px; white-space: pre;">default</span><span class="o" style="background-color: white; color: #333333; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; font-weight: bold; line-height: 18px; white-space: pre;">[</span><span class="ss" style="background-color: white; color: #990073; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; line-height: 18px; white-space: pre;">:oracle</span><span class="o" style="background-color: white; color: #333333; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; font-weight: bold; line-height: 18px; white-space: pre;">][</span><span class="ss" style="background-color: white; color: #990073; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; line-height: 18px; white-space: pre;">:rdbms</span><span class="o" style="background-color: white; color: #333333; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; font-weight: bold; line-height: 18px; white-space: pre;">][</span><span class="ss" style="background-color: white; color: #990073; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; line-height: 18px; white-space: pre;">:latest_patch</span><span class="o" style="background-color: white; color: #333333; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; font-weight: bold; line-height: 18px; white-space: pre;">][</span><span class="ss" style="background-color: white; color: #990073; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; line-height: 18px; white-space: pre;">:url</span><span class="o" style="background-color: white; color: #333333; font-family: Consolas, 'Liberation Mono', Courier, monospace; font-size: 12px; font-weight: bold; line-height: 18px; white-space: pre;">]</span></li>
</ul>
</ul>
<b>Steps:</b><br />
<br />
Made sure the knife ec2 commands were working fine with<br />
<br />
<span style="font-family: Courier New, Courier, monospace;">knife ec2 server list</span><br />
<br />
Bootstrapped a new flavor m1.small instance with ora_quickstart role. ora_quickstart role is described in detail on the echa-oracle cookbook README.md.<br />
<br />
<span style="font-family: Courier New, Courier, monospace;">knife ec2 server create -I ami-9bf6e0ef -S pem_name <pem>-i ~/.ssh/pem_file_name<pem>.pem -x ec2-user -G sec_group <sec_group>-f m1.small --ebs-size 20 </sec_group></pem></pem></span><span style="font-family: 'Courier New', Courier, monospace;">-r "role[ora_quickstart]"</span><span style="font-family: 'Courier New', Courier, monospace;"> -j '{"oracle" : {"rdbms": {"dbs": {"FOO" : false}}}}'</span><br />
<br />
<div>
<b>Result:</b></div>
<div>
<br /></div>
<div>
Success.<br />
<br /></div>
<b>Notes:</b><br />
<ul>
<li>Deployment will take some time, especially installing the Oracle binaries, latest patch and db creation, so don't be alarmed if it seems to be stuck, it isn't. Just check 'top' on the instance to verify this.</li>
<li>Used a Red Hat Enterprise Linux 6.4 AMI (<span style="font-family: 'Courier New', Courier, monospace;">ami-9bf6e0ef</span><span style="font-family: inherit;">)</span></li>
<li>By default, an EC2 instance doesn't come with swap. Depending on the flavor, you need to add 2x memory size swap on the VM. It is a normal Oracle recommendation, but you can get further details by checking the 11.2. documentation.</li>
<li>I had to use --ebs-size 20 parameter to get a bigger 20GB disk for the deployment. m1.small comes with 7GB as a default configuration.</li>
<li>Already mentioned in the echa-oracle cookbook README.md, but resize the /dev/shm as well. You might face some issues with a running Oracle database, if it is not big enough.</li>
<li>If you don't want to create a database(s) at the same deployment, you can leave the <span style="font-family: 'Courier New', Courier, monospace;">-j '{"oracle" : {"rdbms": {"dbs": {"FOO" : false}}}}'</span> option out. Although you are able to create the database(s) later on by adding the node attributes directly with <span style="font-family: Courier New, Courier, monospace;">knife node edit</span>.</li>
</ul>
<b>Sample output of the test deployment:</b><br />
<br />
<a href="https://gist.github.com/aririikonen/5936747">https://gist.github.com/aririikonen/5936747</a>Ari Riikonenhttp://www.blogger.com/profile/13408446454232280294noreply@blogger.com12tag:blogger.com,1999:blog-3305292971037528110.post-46582108571683299632010-10-22T00:54:00.000-07:002010-10-22T00:56:27.361-07:00Run cron jobs the first Saturday of the month<div style="font-family: Arial,Helvetica,sans-serif;">Running tasks on the first Saturday of the week. Example runs the partition maintenance on Oracle Enterprise Manager - Grid Control every first Saturday of the month. </div><br />
<span style="font-size: small;"><span style="font-family: "Courier New",Courier,monospace;"># OEM Partition Maintenance Run</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">00 04 * * 0 [ `date +\%e` -le 7 ] && [ -f /opt/oracle/scripts/gc_part_maint.ksh ] && /opt/oracle/scripts/gc_part_maint.ksh > /dev/null 2>&1</span></span>Ari Riikonenhttp://www.blogger.com/profile/13408446454232280294noreply@blogger.com0tag:blogger.com,1999:blog-3305292971037528110.post-81768407780392814312010-03-12T00:03:00.000-08:002010-03-12T00:05:30.014-08:00Listener log parsing for unique connections<span style="font-family: Arial,Helvetica,sans-serif;">A small one liner to check out the unique IP addresses (or hostnames) from the listener.log.</span><br />
<br />
<div style="font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;">cat /opt/oracle/10R2/network/log/listener.log | awk -F"=" {'print $10'} | sed -e 's/......$//g' | sort -k 1,1 -u<br />
cat /opt/oracle/10R2/network/log/listener.log | awk -F"=" {'print $12'} | sed -e 's/......$//g' | sort -k 1,1 -u </span></div>Ari Riikonenhttp://www.blogger.com/profile/13408446454232280294noreply@blogger.com0tag:blogger.com,1999:blog-3305292971037528110.post-37578826374266453332010-03-11T23:38:00.000-08:002010-03-12T00:06:08.780-08:00Parsing alert log (gegrep) - Solaris 10<span style="font-family: Arial,Helvetica,sans-serif;">You can easily parse the Oracle alert log with gegrep to find out the times as well as the parsed line.</span><br />
<br />
<div style="font-family: "Trebuchet MS",sans-serif;"># Show two lines before the matching string</div><div style="font-family: "Trebuchet MS",sans-serif;">gegrep -B 2 ORA- alert_DB1.log</div><div style="font-family: "Trebuchet MS",sans-serif;"><br />
</div><div style="font-family: "Trebuchet MS",sans-serif;"># Show how many times the database has been started up and when</div><div style="font-family: "Trebuchet MS",sans-serif;">gegrep -B 1 "Completed: ALTER DATABASE OPEN" alert_DB1.log</div>Ari Riikonenhttp://www.blogger.com/profile/13408446454232280294noreply@blogger.com0tag:blogger.com,1999:blog-3305292971037528110.post-38375944622226191012010-03-09T06:06:00.000-08:002010-03-09T06:07:33.486-08:00Restore database to a different path - set newname for datafile script (UNIX/Linux)<span style="font-size: small;"><span style="font-family: Arial,Helvetica,sans-serif;">This script helps you to set the new name for datafiles during restoration to a different path. Script will ask two inputs: new path and restoration SCN.</span></span><br />
<br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">set serveroutput on;</span><br />
<span style="font-family: "Courier New",Courier,monospace;">set linesize 300</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">declare</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> cursor df is</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> select name from v$datafile</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> union all</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> select name from v$tempfile</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> union all</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> select member as name from v$logfile;</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> </span><br />
<span style="font-family: "Courier New",Courier,monospace;"> cursor df2 is</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> select case when instr (file_name, '/') > 0</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> then</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> substr (file_name, instr (file_name, '/', -1) + 1)</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> end as file_name</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> from (select name as file_name from v$datafile</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> union all</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> select name as file_name from v$tempfile</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> union all</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> select member as file_name from v$logfile);</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;"> newPath varchar2(300);</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> newScn number(15);</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> s_df varchar2(300);</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> s_df2 varchar2(300);</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> </span><br />
<span style="font-family: "Courier New",Courier,monospace;">begin</span><br />
<span style="font-family: "Courier New",Courier,monospace;">-- dbms_output.put_line('Enter the set newname path (omit trailing ''/''):');</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> newPath := '&PATH';</span><br />
<span style="font-family: "Courier New",Courier,monospace;">-- dbms_output.put_line('Enter the SCN:');</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> newScn := &SCN;</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> dbms_output.put_line('run');</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> dbms_output.put_line('{');</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> dbms_output.put_line('set until scn = '||newScn||';');</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;"> open df;</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> open df2;</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;"> fetch df into s_df;</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> fetch df2 into s_df2;</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;"> while df%FOUND loop</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> dbms_output.put_line('set newname for datafile '''||s_df||''' to '''||newPath||'/'||s_df2||''';');</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> fetch df into s_df;</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> fetch df2 into s_df2;</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> end loop;</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;"> dbms_output.put_line('restore database;');</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> dbms_output.put_line('switch all;');</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> dbms_output.put_line('}');</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;"> close df;</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> close df2;</span><br />
<span style="font-family: "Courier New",Courier,monospace;">end;</span><br />
<span style="font-family: "Courier New",Courier,monospace;">/</span><br />
<br />
<span style="font-size: small;"><span style="font-family: Arial,Helvetica,sans-serif;">Example output:</span></span><br />
<br />
<span style="font-size: small;"><span style="font-family: "Courier New",Courier,monospace;">SQL>@plsql_set_newname_for_datafile.sql<br />
Enter value for path: /path/to/the/new/localtion<br />
old 27: newPath := '&PATH';<br />
new 27: newPath := '/path/to/the/new/localtion';<br />
Enter value for scn: 1234123<br />
old 29: newScn := &SCN;<br />
new 29: newScn := 1234123;<br />
run<br />
{<br />
set until scn = 1234123;<br />
set newname for datafile '/current/datafile/path/system01.dbf' to '/path/to/the/new/localtion/system01.dbf';<br />
set newname for datafile '/current/datafile/path/undotbs01.dbf' to '/path/to/the/new/localtion/undotbs01.dbf';<br />
set newname for datafile '/current/datafile/path/sysaux01.dbf' to '/path/to/the/new/localtion/sysaux01.dbf';<br />
set newname for datafile '/current/datafile/path/users01.dbf' to '/path/to/the/new/localtion/users01.dbf';<br />
set newname for datafile '/current/datafile/path/temp01.dbf' to '/path/to/the/new/localtion/temp01.dbf';<br />
set newname for datafile '/current/datafile/path/redo01_1.rdo' to '/path/to/the/new/localtion/redo01_1.rdo';<br />
set newname for datafile '/current/datafile/path/redo02_1.rdo' to '/path/to/the/new/localtion/redo02_1.rdo';<br />
set newname for datafile '/current/datafile/path/redo03_1.rdo' to '/path/to/the/new/localtion/redo03_1.rdo';<br />
restore database;<br />
switch all;<br />
}<br />
<br />
PL/SQL procedure successfully completed.</span></span>Ari Riikonenhttp://www.blogger.com/profile/13408446454232280294noreply@blogger.com0tag:blogger.com,1999:blog-3305292971037528110.post-24714355047489350402010-03-09T05:51:00.000-08:002010-03-09T06:06:50.636-08:00How to easily rename all Oracle database datafiles (UNIX/Linux)<div style="font-family: Arial,Helvetica,sans-serif;">The following script helps to rename the Oracle database datafiles to a different location. It will generate executable output as 'alter database rename file..'. You just need to specify the path (without the trailing '/'), where you want to rename the datafiles.</div><br />
<span style="font-family: "Courier New",Courier,monospace; font-size: small;">set serveroutput on;<br />
set linesize 300<br />
<br />
declare<br />
cursor df is<br />
select name from v$datafile<br />
union all<br />
select name from v$tempfile<br />
union all<br />
select member as name from v$logfile;<br />
<br />
cursor df2 is<br />
select case when instr (file_name, '/') > 0<br />
then<br />
substr (file_name, instr (file_name, '/', -1) + 1)<br />
end as file_name<br />
from (select name as file_name from v$datafile<br />
union all<br />
select name as file_name from v$tempfile<br />
union all<br />
select member as file_name from v$logfile);<br />
<br />
newPath varchar2(300);<br />
s_df varchar2(300);<br />
s_df2 varchar2(300);<br />
<br />
begin<br />
-- dbms_output.put_line('Enter the renamed database path (omit trailing ''/''):');<br />
newPath := '&PATH';<br />
<br />
open df;<br />
open df2;<br />
<br />
fetch df into s_df;<br />
fetch df2 into s_df2;<br />
<br />
while df%FOUND loop<br />
dbms_output.put_line('alter database rename file '''||s_df||''' to '''||newPath||'/'||s_df2||''';');<br />
fetch df into s_df;<br />
fetch df2 into s_df2;<br />
end loop;<br />
<br />
close df;<br />
close df2;<br />
end;<br />
/</span><br />
<div style="font-family: Arial,Helvetica,sans-serif;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif;">You get for example the following output.</div><br />
<span style="font-size: small;"><span style="font-family: "Courier New",Courier,monospace;">SQL*Plus: Release 11.1.0.7.0 - Production on Tue Mar 9 14:19:51 2010</span><br style="font-family: "Courier New",Courier,monospace;" /><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">Copyright (c) 1982, 2008, Oracle. All rights reserved.</span><br style="font-family: "Courier New",Courier,monospace;" /><br style="font-family: "Courier New",Courier,monospace;" /><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">Connected to:</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">With the Partitioning, OLAP, Data Mining and Real Application Testing options</span><br style="font-family: "Courier New",Courier,monospace;" /><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">SQL>@plsql_alter_database_rename_file.sql</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">Enter value for path: /path/to/the/new/localtion</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">old 26: newPath := '&PATH';</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">new 26: newPath := '/path/to/the/new/localtion';</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">alter database rename file '/current/datafile/path/system01.dbf' to '/path/to/the/new/localtion/system01.dbf';</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">alter database rename file '/current/datafile/path/undotbs01.dbf' to '/path/to/the/new/localtion/undotbs01.dbf';</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">alter database rename file '/current/datafile/path/sysaux01.dbf' to '/path/to/the/new/localtion/sysaux01.dbf';</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">alter database rename file '/current/datafile/path/users01.dbf' to '/path/to/the/new/localtion/users01.dbf';</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">alter database rename file '/current/datafile/path/temp_small01.dbf' to '/path/to/the/new/localtion/temp_small01.dbf';</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">alter database rename file '/current/datafile/path/redo14_2.rdo' to '/path/to/the/new/localtion/redo14_2.rdo';</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">alter database rename file '/current/datafile/path/redo15_2.rdo' to '/path/to/the/new/localtion/redo15_2.rdo';</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">alter database rename file '/current/datafile/path/redo16_2.rdo' to '/path/to/the/new/localtion/redo16_2.rdo';</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">alter database rename file '/current/datafile/path/redo13_1.rdo' to '/path/to/the/new/localtion/redo13_1.rdo';</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">alter database rename file '/current/datafile/path/redo14_1.rdo' to '/path/to/the/new/localtion/redo14_1.rdo';</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">alter database rename file '/current/datafile/path/redo15_1.rdo' to '/path/to/the/new/localtion/redo15_1.rdo';</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">alter database rename file '/current/datafile/path/redo16_1.rdo' to '/path/to/the/new/localtion/redo16_1.rdo';</span><br style="font-family: "Courier New",Courier,monospace;" /><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">PL/SQL procedure successfully completed.</span></span>Ari Riikonenhttp://www.blogger.com/profile/13408446454232280294noreply@blogger.com0tag:blogger.com,1999:blog-3305292971037528110.post-10729752836529366092009-11-04T14:43:00.000-08:002010-03-09T05:57:39.269-08:00Example of Incrementally Updated RMAN backups (start phase)<span style="font-family: arial;"><span style="font-size: small;">This example shows how RMAN marks the first incremental backup as '1' and not '0'. RMAN does not change the backup to become an incremental '0', as many people would think.<br />
</span></span><br />
<div><br />
<div style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: small;">RMAN parameters</span></div></div><div><div><br />
<blockquote><span style="font-family: "Courier New",Courier,monospace;">RMAN> show all;</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">RMAN configuration parameters for database with db_unique_name DB11G are:</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;</span><br />
<span style="font-family: "Courier New",Courier,monospace;">CONFIGURE BACKUP OPTIMIZATION ON;</span><br />
<span style="font-family: "Courier New",Courier,monospace;">CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default</span><br />
<span style="font-family: "Courier New",Courier,monospace;">CONFIGURE CONTROLFILE AUTOBACKUP ON;</span><br />
<span style="font-family: "Courier New",Courier,monospace;">CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/opt/oracle/backup/%F';</span><br />
<span style="font-family: "Courier New",Courier,monospace;">CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default</span><br />
<span style="font-family: "Courier New",Courier,monospace;">CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default</span><br />
<span style="font-family: "Courier New",Courier,monospace;">CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default</span><br />
<span style="font-family: "Courier New",Courier,monospace;">CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/opt/oracle/backup/DB11G_%U.rbk';</span><br />
<span style="font-family: "Courier New",Courier,monospace;">CONFIGURE MAXSETSIZE TO UNLIMITED; # default</span><br />
<span style="font-family: "Courier New",Courier,monospace;">CONFIGURE ENCRYPTION FOR DATABASE OFF; # default</span><br />
<span style="font-family: "Courier New",Courier,monospace;">CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default</span><br />
<span style="font-family: "Courier New",Courier,monospace;">CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default</span><br />
<span style="font-family: "Courier New",Courier,monospace;">CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default</span><br />
<span style="font-family: "Courier New",Courier,monospace;">CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/oracle/11R1/dbs/snapcf_DB11G.f'; # default</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">RMAN> exit</span></blockquote></div><div><br />
<br />
<span style="font-family: arial;"><span style="font-size: small;"><span style="font-family: 'courier new';"><span style="font-size: small;"><span style="font-family: Arial,Helvetica,sans-serif;">Run the first incremental backup</span><br />
</span></span></span></span></div><div><span style="font-family: arial;"><span style="font-size: small;"></span></span><br />
<br />
<blockquote><span style="font-family: "Courier New",Courier,monospace;">[oracle@server backup]$ rman target /</span><br />
<span style="font-family: "Courier New",Courier,monospace;">Recovery Manager: Release 11.1.0.7.0 - Production on Thu Nov 5 00:31:57 2009</span><br />
<span style="font-family: "Courier New",Courier,monospace;">Copyright (c) 1982, 2007, Oracle. All rights reserved.</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">connected to target database: DB11G (DBID=170286104)</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">RMAN> RUN</span><br />
<span style="font-family: "Courier New",Courier,monospace;">{</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> RECOVER COPY OF DATABASE</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> WITH TAG 'incr_update';</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> BACKUP</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> INCREMENTAL LEVEL 1</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> FOR RECOVER OF COPY WITH TAG 'incr_update'</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> DATABASE;</span><br />
<span style="font-family: "Courier New",Courier,monospace;">}2> 3> 4> 5> 6> 7> 8> 9></span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">Starting recover at 05-NOV-09</span><br />
<span style="font-family: "Courier New",Courier,monospace;">using target database control file instead of recovery catalog</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">allocated channel: ORA_DISK_1</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: SID=937 device type=DISK</span><br />
<span style="font-family: "Courier New",Courier,monospace;">no copy of datafile 1 found to recover</span><br />
<span style="font-family: "Courier New",Courier,monospace;">no copy of datafile 2 found to recover</span><br />
<span style="font-family: "Courier New",Courier,monospace;">no copy of datafile 3 found to recover</span><br />
<span style="font-family: "Courier New",Courier,monospace;">no copy of datafile 4 found to recover</span><br />
<span style="font-family: "Courier New",Courier,monospace;">no copy of datafile 5 found to recover</span><br />
<span style="font-family: "Courier New",Courier,monospace;">Finished recover at 05-NOV-09</span><br />
</blockquote></div><div><blockquote><span style="font-family: "Courier New",Courier,monospace;">Starting backup at 05-NOV-09</span><br />
<span style="font-family: "Courier New",Courier,monospace;">using channel ORA_DISK_1</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">no parent backup or copy of datafile 2 found</span><br />
<span style="font-family: "Courier New",Courier,monospace;">no parent backup or copy of datafile 1 found</span><br />
<span style="font-family: "Courier New",Courier,monospace;">no parent backup or copy of datafile 3 found</span><br />
<span style="font-family: "Courier New",Courier,monospace;">no parent backup or copy of datafile 4 found</span><br />
<span style="font-family: "Courier New",Courier,monospace;">no parent backup or copy of datafile 5 found</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: starting datafile copy</span><br />
<span style="font-family: "Courier New",Courier,monospace;">input datafile file number=00002 name=/opt/oracle/oradata/DB11G/sysaux01.dbf</span><br />
<span style="font-family: "Courier New",Courier,monospace;">output file name=/opt/oracle/backup/DB11G_data_D-DB11G_I-170286104_TS-SYSAUX_FNO-2_09kti14r.rbk tag=INCR_UPDATE RECID=1 STAMP=702088421</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:15</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: starting datafile copy</span><br />
<span style="font-family: "Courier New",Courier,monospace;">input datafile file number=00001 name=/opt/oracle/oradata/DB11G/system01.dbf</span><br />
<span style="font-family: "Courier New",Courier,monospace;">output file name=/opt/oracle/backup/DB11G_data_D-DB11G_I-170286104_TS-SYSTEM_FNO-1_0akti176.rbk tag=INCR_UPDATE RECID=2 STAMP=702088479</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:05</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: starting datafile copy</span><br />
<span style="font-family: "Courier New",Courier,monospace;">input datafile file number=00003 name=/opt/oracle/oradata/DB11G/undotbs01.dbf</span><br />
<span style="font-family: "Courier New",Courier,monospace;">output file name=/opt/oracle/backup/DB11G_data_D-DB11G_I-170286104_TS-UNDOTBS1_FNO-3_0bkti197.rbk tag=INCR_UPDATE RECID=3 STAMP=702088530</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: starting datafile copy</span><br />
<span style="font-family: "Courier New",Courier,monospace;">input datafile file number=00004 name=/opt/oracle/oradata/DB11G/example01.dbf</span><br />
<span style="font-family: "Courier New",Courier,monospace;">output file name=/opt/oracle/backup/DB11G_data_D-DB11G_I-170286104_TS-EXAMPLE_FNO-4_0ckti1ak.rbk tag=INCR_UPDATE RECID=4 STAMP=702088544</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: starting datafile copy</span><br />
<span style="font-family: "Courier New",Courier,monospace;">input datafile file number=00005 name=/opt/oracle/oradata/DB11G/users01.dbf</span><br />
<span style="font-family: "Courier New",Courier,monospace;">output file name=/opt/oracle/backup/DB11G_data_D-DB11G_I-170286104_TS-USERS_FNO-5_0dkti1b4.rbk tag=INCR_UPDATE RECID=5 STAMP=702088548</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01</span><br />
<span style="font-family: "Courier New",Courier,monospace;">Finished backup at 05-NOV-09</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">Starting Control File and SPFILE Autobackup at 05-NOV-09</span><br />
<span style="font-family: "Courier New",Courier,monospace;">piece handle=/opt/oracle/backup/c-170286104-20091105-00 comment=NONE</span><br />
<span style="font-family: "Courier New",Courier,monospace;">Finished Control File and SPFILE Autobackup at 05-NOV-09</span></blockquote><blockquote><span style="font-family: "Courier New",Courier,monospace;">Recovery Manager complete.</span> </blockquote><div><br />
<span style="font-family: arial;"><span style="font-size: small;"><span style="font-family: 'courier new';"><span style="font-size: small;"><span style="font-family: Arial,Helvetica,sans-serif;">Do some changes to the database</span><br />
</span></span></span></span></div><br />
<blockquote><span style="font-family: "Courier New",Courier,monospace;">[oracle@server backup]$ dba</span><br />
<span style="font-family: "Courier New",Courier,monospace;">SQL*Plus: Release 11.1.0.7.0 - Production on Thu Nov 5 00:36:05 2009</span><br />
<span style="font-family: "Courier New",Courier,monospace;">Copyright (c) 1982, 2008, Oracle. All rights reserved.</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">Connected to:</span><br />
<span style="font-family: "Courier New",Courier,monospace;">Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production</span><br />
<span style="font-family: "Courier New",Courier,monospace;">With the Partitioning, OLAP, Data Mining and Real Application Testing options</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">SQL> create table test (foo varchar2(10));</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">Table created.</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">SQL> insert into test values ('testing');</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">1 row created.</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">SQL> commit;</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">Commit complete.</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">SQL> exit</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production</span><br />
<span style="font-family: "Courier New",Courier,monospace;">With the Partitioning, OLAP, Data Mining and Real Application Testing options</span></blockquote><div><br />
<span style="font-family: arial;"><span style="font-size: small;"><span style="font-family: 'courier new';"><span style="font-size: small;"><span style="font-family: Arial,Helvetica,sans-serif;">Run another incrementally updated backup </span><br />
</span></span></span></span><br />
<br />
<blockquote><span style="font-family: "Courier New",Courier,monospace;">[oracle@server backup]$ rman target /</span><br />
<span style="font-family: "Courier New",Courier,monospace;">Recovery Manager: Release 11.1.0.7.0 - Production on Thu Nov 5 00:38:09 2009</span><br />
<span style="font-family: "Courier New",Courier,monospace;">Copyright (c) 1982, 2007, Oracle. All rights reserved.</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">connected to target database: DB11G (DBID=170286104)</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">RMAN> RUN</span><br />
<span style="font-family: "Courier New",Courier,monospace;">{</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> RECOVER COPY OF DATABASE</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> WITH TAG 'incr_update';</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> BACKUP</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> INCREMENTAL LEVEL 1</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> FOR RECOVER OF COPY WITH TAG 'incr_update'</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> DATABASE;</span><br />
<span style="font-family: "Courier New",Courier,monospace;">}2> 3> 4> 5> 6> 7> 8> 9></span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">Starting recover at 05-NOV-09</span><br />
<span style="font-family: "Courier New",Courier,monospace;">using target database control file instead of recovery catalog</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">allocated channel: ORA_DISK_1</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: SID=963 device type=DISK</span><br />
<span style="font-family: "Courier New",Courier,monospace;">no copy of datafile 1 found to recover</span><br />
<span style="font-family: "Courier New",Courier,monospace;">no copy of datafile 2 found to recover</span><br />
<span style="font-family: "Courier New",Courier,monospace;">no copy of datafile 3 found to recover</span><br />
<span style="font-family: "Courier New",Courier,monospace;">no copy of datafile 4 found to recover</span><br />
<span style="font-family: "Courier New",Courier,monospace;">no copy of datafile 5 found to recover</span><br />
<span style="font-family: "Courier New",Courier,monospace;">Finished recover at 05-NOV-09</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">Starting backup at 05-NOV-09</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">using channel ORA_DISK_1</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: starting incremental level 1 datafile backup set</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: specifying datafile(s) in backup set</span><br />
<span style="font-family: "Courier New",Courier,monospace;">input datafile file number=00002 name=/opt/oracle/oradata/DB11G/sysaux01.dbf</span><br />
<span style="font-family: "Courier New",Courier,monospace;">input datafile file number=00001 name=/opt/oracle/oradata/DB11G/system01.dbf</span><br />
<span style="font-family: "Courier New",Courier,monospace;">input datafile file number=00003 name=/opt/oracle/oradata/DB11G/undotbs01.dbf</span><br />
<span style="font-family: "Courier New",Courier,monospace;">input datafile file number=00004 name=/opt/oracle/oradata/DB11G/example01.dbf</span><br />
<span style="font-family: "Courier New",Courier,monospace;">input datafile file number=00005 name=/opt/oracle/oradata/DB11G/users01.dbf</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: starting piece 1 at 05-NOV-09</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: finished piece 1 at 05-NOV-09</span><br />
<span style="font-family: "Courier New",Courier,monospace;">piece handle=/opt/oracle/backup/DB11G_0fkti1g6_1_1.rbk tag=TAG20091105T003830 comment=NONE</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03</span><br />
<span style="font-family: "Courier New",Courier,monospace;">Finished backup at 05-NOV-09</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">Starting Control File and SPFILE Autobackup at 05-NOV-09</span><br />
<span style="font-family: "Courier New",Courier,monospace;">piece handle=/opt/oracle/backup/c-170286104-20091105-01 comment=NONE</span><br />
<span style="font-family: "Courier New",Courier,monospace;">Finished Control File and SPFILE Autobackup at 05-NOV-09</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">RMAN> exit</span></blockquote><blockquote><span style="font-family: "Courier New",Courier,monospace;">Recovery Manager complete.</span> </blockquote></div><div><br />
<span style="font-family: arial;"><span style="font-size: small;"><span style="font-family: 'courier new';"><span style="font-size: small;"><span style="font-family: Arial,Helvetica,sans-serif;">Do more updated to the database</span><br />
</span></span></span></span></div><div><span style="font-family: arial;"><span style="font-size: small;"><span style="font-family: 'courier new';"><span style="font-size: small;"><br />
</span></span></span></span></div><blockquote><span style="font-family: "Courier New",Courier,monospace;">[oracle@server backup]$ dba</span><br />
<span style="font-family: "Courier New",Courier,monospace;">SQL*Plus: Release 11.1.0.7.0 - Production on Thu Nov 5 00:38:58 2009</span><br />
<span style="font-family: "Courier New",Courier,monospace;">Copyright (c) 1982, 2008, Oracle. All rights reserved.</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">Connected to:</span><br />
<span style="font-family: "Courier New",Courier,monospace;">Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production</span><br />
<span style="font-family: "Courier New",Courier,monospace;">With the Partitioning, OLAP, Data Mining and Real Application Testing options</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">SQL> insert into test values ('testing2');</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">1 row created.</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">SQL> commit;</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">Commit complete.</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">SQL> exit</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production</span><br />
<span style="font-family: "Courier New",Courier,monospace;">With the Partitioning, OLAP, Data Mining and Real Application Testing options</span></blockquote><div><div style="font-family: Arial,Helvetica,sans-serif;"><br />
<span style="font-size: small;"><span style="font-size: small;">Run the third incrementally updated backup</span></span></div><span style="font-family: arial;"><span style="font-size: small;"><span style="font-family: 'courier new';"><span style="font-size: small;"> </span></span></span></span><br />
<br />
<blockquote><span style="font-family: "Courier New",Courier,monospace;">[oracle@server backup]$ rman target /</span><br />
<span style="font-family: "Courier New",Courier,monospace;">Recovery Manager: Release 11.1.0.7.0 - Production on Thu Nov 5 00:39:31 2009</span><br />
<span style="font-family: "Courier New",Courier,monospace;">Copyright (c) 1982, 2007, Oracle. All rights reserved.</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">connected to target database: DB11G (DBID=170286104)</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">RMAN> RUN</span><br />
<span style="font-family: "Courier New",Courier,monospace;">{</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> RECOVER COPY OF DATABASE</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> WITH TAG 'incr_update';</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> BACKUP</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> INCREMENTAL LEVEL 1</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> FOR RECOVER OF COPY WITH TAG 'incr_update'</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> DATABASE;</span><br />
<span style="font-family: "Courier New",Courier,monospace;">}2> 3> 4> 5> 6> 7> 8> 9></span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">Starting recover at 05-NOV-09</span><br />
<span style="font-family: "Courier New",Courier,monospace;">using target database control file instead of recovery catalog</span><br />
<span style="font-family: "Courier New",Courier,monospace;">allocated channel: ORA_DISK_1</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: SID=946 device type=DISK</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: starting incremental datafile backup set restore</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: specifying datafile copies to recover</span><br />
<span style="font-family: "Courier New",Courier,monospace;">recovering datafile copy file number=00001 name=/opt/oracle/backup/DB11G_data_D-DB11G_I-170286104_TS-SYSTEM_FNO-1_0akti176.rbk</span><br />
<span style="font-family: "Courier New",Courier,monospace;">recovering datafile copy file number=00002 name=/opt/oracle/backup/DB11G_data_D-DB11G_I-170286104_TS-SYSAUX_FNO-2_09kti14r.rbk</span><br />
<span style="font-family: "Courier New",Courier,monospace;">recovering datafile copy file number=00003 name=/opt/oracle/backup/DB11G_data_D-DB11G_I-170286104_TS-UNDOTBS1_FNO-3_0bkti197.rbk</span><br />
<span style="font-family: "Courier New",Courier,monospace;">recovering datafile copy file number=00004 name=/opt/oracle/backup/DB11G_data_D-DB11G_I-170286104_TS-EXAMPLE_FNO-4_0ckti1ak.rbk</span><br />
<span style="font-family: "Courier New",Courier,monospace;">recovering datafile copy file number=00005 name=/opt/oracle/backup/DB11G_data_D-DB11G_I-170286104_TS-USERS_FNO-5_0dkti1b4.rbk</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: reading from backup piece /opt/oracle/backup/DB11G_0fkti1g6_1_1.rbk</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: piece handle=/opt/oracle/backup/DB11G_0fkti1g6_1_1.rbk tag=TAG20091105T003830</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: restored backup piece 1</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: restore complete, elapsed time: 00:00:03</span><br />
<span style="font-family: "Courier New",Courier,monospace;">Finished recover at 05-NOV-09</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">Starting backup at 05-NOV-09</span><br />
<span style="font-family: "Courier New",Courier,monospace;">using channel ORA_DISK_1</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: starting incremental level 1 datafile backup set</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: specifying datafile(s) in backup set</span><br />
<span style="font-family: "Courier New",Courier,monospace;">input datafile file number=00002 name=/opt/oracle/oradata/DB11G/sysaux01.dbf</span><br />
<span style="font-family: "Courier New",Courier,monospace;">input datafile file number=00001 name=/opt/oracle/oradata/DB11G/system01.dbf</span><br />
<span style="font-family: "Courier New",Courier,monospace;">input datafile file number=00003 name=/opt/oracle/oradata/DB11G/undotbs01.dbf</span><br />
<span style="font-family: "Courier New",Courier,monospace;">input datafile file number=00004 name=/opt/oracle/oradata/DB11G/example01.dbf</span><br />
<span style="font-family: "Courier New",Courier,monospace;">input datafile file number=00005 name=/opt/oracle/oradata/DB11G/users01.dbf</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: starting piece 1 at 05-NOV-09</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: finished piece 1 at 05-NOV-09</span><br />
<span style="font-family: "Courier New",Courier,monospace;">piece handle=/opt/oracle/backup/DB11G_0hkti1ih_1_1.rbk tag=TAG20091105T003944 comment=NONE</span><br />
<span style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03</span><br />
<span style="font-family: "Courier New",Courier,monospace;">Finished backup at 05-NOV-09</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">Starting Control File and SPFILE Autobackup at 05-NOV-09</span><br />
<span style="font-family: "Courier New",Courier,monospace;">piece handle=/opt/oracle/backup/c-170286104-20091105-02 comment=NONE</span><br />
<span style="font-family: "Courier New",Courier,monospace;">Finished Control File and SPFILE Autobackup at 05-NOV-09</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">RMAN> exit</span></blockquote></div><blockquote><div><span style="font-family: arial; font-size: small;">Recovery Manager complete.</span> </div></blockquote><div><br />
<span style="font-family: arial;"><span style="font-size: small;"><span style="font-family: 'courier new';"><span style="font-size: small;"><span style="font-family: Arial,Helvetica,sans-serif;">Report the INCREMENTAL_LEVEL from V$BACKUP_SET</span><br />
</span></span></span></span></div><div><span style="font-family: arial;"><span style="font-size: small;"><span style="font-family: 'courier new';"><span style="font-size: small;"> </span></span></span></span></div><blockquote style="font-family: "Courier New",Courier,monospace;">[oracle@server backup]$ dba<br />
SQL*Plus: Release 11.1.0.7.0 - Production on Thu Nov 5 00:39:55 2009<br />
Copyright (c) 1982, 2008, Oracle. All rights reserved.<br />
<br />
Connected to:<br />
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production<br />
With the Partitioning, OLAP, Data Mining and Real Application Testing options<br />
<br />
SQL> r<br />
1 select START_TIME, BACKUP_TYPE, INCREMENTAL_LEVEL<br />
2 from v$backup_set<br />
3 where start_time > sysdate-1<br />
4* order by 1<br />
<br />
START_TIME B INCREMENTAL_LEVEL<br />
-------------------- - -----------------<br />
05-NOV-2009 00:35:49 D<br />
05-NOV-2009 00:38:30 I 1<br />
05-NOV-2009 00:38:33 D<br />
05-NOV-2009 00:39:45 I 1<br />
05-NOV-2009 00:39:48 D</blockquote><div><br />
<span style="font-family: arial;"><span style="font-size: small;">As you can see. The level has not changed to '0' by Oracle RMAN, even though this was the start of an incrementally updated backup.<br />
</span></span></div><span style="font-family: arial;"><span style="font-size: small;"></span></span></div></div>Ari Riikonenhttp://www.blogger.com/profile/13408446454232280294noreply@blogger.com0