tag:blogger.com,1999:blog-39653036010019408792024-03-12T17:11:11.397-07:00Navaneeth's BlogOracle DBA related workouts for 9i,10g,11g Versions.Navaneethhttp://www.blogger.com/profile/06691943267983308816noreply@blogger.comBlogger95125tag:blogger.com,1999:blog-3965303601001940879.post-74869421816500418902014-02-25T23:00:00.003-08:002014-02-25T23:26:11.908-08:00<div dir="ltr" style="text-align: left;" trbidi="on">
<a href="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAgQAAABvCAIAAAAczE9xAAAO5klEQVR4nO1dTZLrPA7Lab9z9PFm8RazmPt4Ft+rjiOSECXbkqAAxUolNCVDICWm03+vQxAEQfh6vI7j+N9//yOTyWSyr7Kfnx+nGczpRIIgCMIkqBkIgiAIsBn8CF2QgPuBPafs/IlAJ/WZMGoGr3/+yFpNAu5n7Dll509kdFKrGQwSdzoZ2S3GnlN2/kRGJ7WawSBxp5OR3WLsOWXnT2R0UqsZDBJ3OhnZLcaeU3b+REYn9SrN4OPel+eZLqsVdzqZpiwAT7f4S6Wm26KcFkJVdahKcZ4qCk7eMcN/it0oxYK2VKm0Ep7WDAppiPKdF3c6mXwi1AyAgR3++tyWeZGva5WPX6omn5BiHVuzVJKEl2gGrhZFq/j1gCeulHbCKdWwrLnyAv2tM8pClJoxiRiQ0+O0w8GiXDVen7UaiRk9sbC3q/Ifb1eksJesGt9cKn36LNQM3DVndGl9YucZXA3LmltbWMAO5/hEDMhpIRRWuE+i1tp2tV2nJm+RouqcaCuUSpM+SzSDQqMzddcJ9IoiowmnVMOydlbv/HhL2eHMslg1p8UagcJWIhsGBGzKQp7/MLtFivw8422FUmnSZ6FmAKi7K3eDwfDx9bHOxusTH0h6xTk+ETdafof/PhbyFnAFSQqYz0Ke/xi7S4qq88tLpUmfJZpB33oK1aLIibWyyMbrSIRbfxfLbmIihuX0vK7zS3exHbVarXY3LM9/mF2UIu+caBNLpU+fJZrB61S+bk2DNYCAzIQTq2FBK9QDkkaqupFRLQ5LxLCcgtp7xTvcjce6RTOAu2f4D7MbpaiqMcsWKZW8Pqs0gy1NAu5nFDkFRyEF/z2MTmo1g0HiTicju8UWz6n7NpOI/05GJ7WawSBxp5OR3WLsOWXnT2R0UqsZDBJ3OhnZLcaeU3b+REYntZrBIHGnk5HdYuw5ZedPZHRSp5pBx79Ulv1rEnA/Y88pO38io5O63gwEQRCEL4GagSAIglD7noHQAQm4H9hzys6fCHRSpz4m+vn5OY4/slaTgPsZe07Z+RMZndRqBsPEnc9Hdt3Yc8rOn8jopFYzGCbufD6y68aeU3b+REYntZrBMHHn85FdN/acsvMnMjqp25rB64RfTzHj+VIRfHbaGDBV4QQEwL3w7dxgO3PkdOcsBGyaEOiAX7qsME9Z3gbv8OoOag1WTQ6zp0vl4dqAzSDKd3ED6zw+68k+2uF9AdXntywhzyG58dwJ8VpsUu3LaEO6q5MlbWQzyFdaPlg1OcweLZXna6OlGeB0Rt3pFtLuEBwJWktHcHHTaBX5d2HuhGBp1zceSKgM2KxmYD0gfWCganKYDWsGUUZaB/Z8TBTdwObVvfHZ/zIAc+JbZ7Rw77VBM4gei8VuvPGG2eBmAGo1ueGLraGaHGZPN4OHa6PWDNwp8O1tsFtbxSTuwtxbuFVlF1wt5Yhh5Mysounz2eo+xLJEjyBHO228YTb3Y6LDOwXAKOtUTQ6zwR8THTfXRq4ZdGTRUq82A7swvJIjKFB7045g65zVDCJZvnzjDbPpzQB4Iuehmpxh45sBlrGxNmAzwGnLvKwWR7VioqaCBQLDk8HR7TCH1p/ciCbEsljCmY23064bact+A9l63GDV5DBb5xvI1pOojdpXBvYtAL69DbbvIGxYtWJAMIhsDXaXEG0ed3jHz+a6e6Z74xW3A+mTJW3BHy2N0u0GqyaH2Qo/WnqhNlo+Jrqyhul5GmN0v3Uiqxp7Ttn5Exmd1PoN5GHizucju27sOWXnT2R0UqsZDBN3Ph/ZdWPPKTt/IqOTWs1gmLjz+ciuG3tO2fkTGZ3UqWZwy3/X/E6TgPsZe07Z+RMZndT1ZiAIgiB8CdQMBEEQBP0P5AcgAfcDe07Z+ROBTurUx0TFNSEJCbgf2HPKzp8IdFKrGTwICbgf2HPKzp8IdFKrGTwICbgf2HPKzp8IdFKrGTwICbgf2HPKzp8IdFK3NYPPv3b011PMeL5UBJ+d7nAw1vytJccD7jsFHdUQce5YS4c+wI/DkgMLv5tTdzjmDDx5Pe293MjxOzwSP5M+6yn4u4LnncmXB8x4tBx2DCiVR2vjHWmvgY2KncdnPdlHNww7m8bOwqxmgA/N6KwEz3FYcqAbk7lX37kDCIBR1WIe3AzsEjIrAmtJNgN3tqYycF/iXbxZP3i6VJ6ujXeAvZa/UxSMzw43IIpsGjsL4Eur35hinxSPhZ6R1NFGBZMXwfhwbD1Sq9NGnmJUMqegAsHY6jHUtGGeQHW/dAzMf2XgKulu8LuaQX6BFHi0VAbUxjvAvWZ7UXSDKLg4uaJSsGNfn3A9mOR4gI1nt1ax5fBWzHjA5GeSmQM3ugr2dnLzty6hSiN/uOBR0TxzPyZyC74IduN/PcOaQfRod3G0WHYM/pjo9tp4R6Jr3v2SDI6gttxJzmOr5071vuNR7aZ4/2T80ZxR5BFojqskUjjyZLLmeqpUQZklb5cZBYhN/55B1X/AGmj6noFbe+7L4rkdmEzQ9D17I8Z/z6DqP1pq4x0Arrn3y+w6yyYzSaaMOkQZANBNiydHLEu1GbhzXmkGEbfoqht/RtNAzAo7k6yqowAxNQP70uZazeDYuxngtGVeVovj+mm1VG099zFREd8UGZ3y4PRvOtBbIwEHUA+Ze4HgKKAqyPSPidzn7qXrzeCIKw3vSltsTbt4D4z/mMh97l662gyOz3cBgBYIBh7sfH0CLBiQHIzbv4Fs4+2cbmRV8IheMecRJCKaE0/lTu5eyuTUvVStgaQIvy+nf2XglhC4VHg6fl68qDfgtP7iCS6elBw8mPijpTagrzb+RoJr9y5gYzQJCM7EVkTDF1F+ERp5ZDYMC9j5E4FOav0G8oOY1QwO8xZstXdeS5HBKKiybwp2/kSgk1rN4EFIwP3AnlN2/kSgk1rN4EFIwP3AnlN2/kSgkzrVDG7575rfaRJwP2PPKTt/IqOTut4MBEEQhC+BmoEgCIKg/4H8ACTgfmDPKTt/ItBJnfqY6Ofn5zj+yFpNAu5n7Dll509kdFKrGQwTdz4f2XVjzyk7fyKjk1rNYJi48/nIrht7Ttn5Exmd1GoGw8Sdz0d23dhzys6fyOikbmgGr9crP28R3DR2G+uohkioDgHN36Jw/NEQfHcwZ9NyLMOobDBn4Mnrae/lRs7d4VFO83nBmxpkAe/o6n4HGY+Ww26DS+Xu2nimGWyZ6YzNagb40IzOSvAchyUHRmup3qvv3AEEwCh3LeAwnWVg1XgtyWbgztZUBu7LDO1tbFap3FQbcTMo2gjuM8Xz/dKcNFsNkW6FUHb74aMq2qhgclAc1t96pFanjTzFqGTxgBMcjK0eQ5nDdJb1CWv5g2JwlSyckdR9zSCTayJbsxlYT3MzOFrqwN5+pxznDWw8u7UybaBJedwScL4Km9sMCkEwjXzh4VHRPCs0g6h1/QIscFgziB4LnhsfFFNK5b7aSDcDd/a+PbmxRV8ZuLJkDn13rDtnFBmlpojH2Yyc7iGeH5WhGhWSGx8xr44CxFZuBq6MRTabvmdQ7Q2Z9EUF7K5lp4NiqWbg5gjWRvtXBtFdN85x3qJqABupoxm4c15pBhG36Kobb0stORCzws4kq+ooQGx6M2hiW+V/SzOwuVYzsFIPsFtrQx8T3WrPfUxUxDdFRpWR6TRRNjNVmPHYsztzd+CvFh6YnL0ZZPjjZhBlIUqNnSFqIVXBN7CVm0GiNmrNwL4dOM9oA6os97bbv4Fs413lbaSbKXdnRn53+Hl+dyyeyp3cvQQ4g5kjZ5UPWMiCzSCqBNcDatKW0Pllxmn9xRNcPFP0fM5WaAYXagM2A1mrNQkIzsRWi4Yvst8WodFHmH1TsPMnMjqp1QyGiVsJvrEZHOYt2GrvvJYi00SVfVOw8ycyOqnVDIaJO5+P7Lqx55SdP5HRSa1mMEzc+Xxk1409p+z8iYxO6lQzuOW/a36nScD9jD2n7PyJjE7qejMQBEEQvgRqBoIgCIL+B/IDkID7gT2n7PyJQCd16mOi4pqQhATcD+w5ZedPBDqp1QwehATcD+w5ZedPBDqp1QwehATcD+w5ZedPBDqp1QwehATcD+w5ZedPBDqp25rB5982+OspZjxfKoLPTnc4GGv+soLjAfedgkLAKttuVS2isIz+WGpLqRgLmODEUWDuDsfSger69XTX5PlqnmTfnN1VlCytKMbOZllhJuf4waVSVTjKSJWw0wyihL28AyLS0X10w7CzaewsAAEzBXd2Nq0un6kOqTMpxiSXylErFnm7l8mRm7Xumoxmxtz65rxYRXl6EcPru+OYVyp31cY7wF7LHD1R7qs8ooAosmnsLGS66ZVmECEpYJJSK/PqfdUMrqNV50wzOGBmQQBm0jHnyGaQdzbtjmPVZmA9Pc3gMIdUMZ0VxSVx9oMu7c52Hm49mOR4JDeeuzT38UivzhUwCqsKm9kVYKskE0eBFZpBNZU27Pd5d00WAXl6HXNerKJqUSWHuJxdjzvVlFK5sTbeAeiakTIi4QafFcQpidgXHrB+l9IwXPnKwH08h2VWhwVMUupgDsYetcQtjpWbgX1uT4ErXxm4t6jS65jzYhUl6+rR3XEs1gzs82ptvIeAa+5dcQIsm0wzsPF4zirJwXiuGZyDq8jPMLgZRKxWxvRmkCl1oPnFZmBPkCrDjjkvVlFTUT20O44ZpXJvbbwD7DWseOZl9YzrPmWiMlq2GWDC9mq+d4KwqCVjZx9zQFLN4AryG97V+XpNdjBpnfPRZjBmdxxrN4NMbbwD3GvgfYHrscHAg52vT9g7upGuNMNw/UdL3SeZ1UVh0Y3OL12p8Ww4TcnEUWDBZmDFP18qPE/8uLP1X5zzYhVVK8pleNy9O1ZoBq8LtfGOBNduZ7wrph8cwu1gzyk7fyLQSa3fQH4QYwR8GTx3L4F9U9zOf/Hym0iPrlTUDB6EBNwP7Dll508EOqnVDB6EBNwP7Dll508EOqlTzeCW/675nSYB9zP2nLLzJzI6qevNQBAEQfgSqBkIgiAIXjPA/zBTEARB2BJlMxAEQRC+HGoGgiAIgpqBIAiCoGYgCIIgHGoGgiAIwnEc/weL7Tmw70WEJwAAAABJRU5ErkJggg==" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><a href="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAgQAAABvCAIAAAAczE9xAAAO5klEQVR4nO1dTZLrPA7Lab9z9PFm8RazmPt4Ft+rjiOSECXbkqAAxUolNCVDICWm03+vQxAEQfh6vI7j+N9//yOTyWSyr7Kfnx+nGczpRIIgCMIkqBkIgiAIsBn8CF2QgPuBPafs/IlAJ/WZMGoGr3/+yFpNAu5n7Dll509kdFKrGQwSdzoZ2S3GnlN2/kRGJ7WawSBxp5OR3WLsOWXnT2R0UqsZDBJ3OhnZLcaeU3b+REYn9SrN4OPel+eZLqsVdzqZpiwAT7f4S6Wm26KcFkJVdahKcZ4qCk7eMcN/it0oxYK2VKm0Ep7WDAppiPKdF3c6mXwi1AyAgR3++tyWeZGva5WPX6omn5BiHVuzVJKEl2gGrhZFq/j1gCeulHbCKdWwrLnyAv2tM8pClJoxiRiQ0+O0w8GiXDVen7UaiRk9sbC3q/Ifb1eksJesGt9cKn36LNQM3DVndGl9YucZXA3LmltbWMAO5/hEDMhpIRRWuE+i1tp2tV2nJm+RouqcaCuUSpM+SzSDQqMzddcJ9IoiowmnVMOydlbv/HhL2eHMslg1p8UagcJWIhsGBGzKQp7/MLtFivw8422FUmnSZ6FmAKi7K3eDwfDx9bHOxusTH0h6xTk+ETdafof/PhbyFnAFSQqYz0Ke/xi7S4qq88tLpUmfJZpB33oK1aLIibWyyMbrSIRbfxfLbmIihuX0vK7zS3exHbVarXY3LM9/mF2UIu+caBNLpU+fJZrB61S+bk2DNYCAzIQTq2FBK9QDkkaqupFRLQ5LxLCcgtp7xTvcjce6RTOAu2f4D7MbpaiqMcsWKZW8Pqs0gy1NAu5nFDkFRyEF/z2MTmo1g0HiTicju8UWz6n7NpOI/05GJ7WawSBxp5OR3WLsOWXnT2R0UqsZDBJ3OhnZLcaeU3b+REYntZrBIHGnk5HdYuw5ZedPZHRSp5pBx79Ulv1rEnA/Y88pO38io5O63gwEQRCEL4GagSAIglD7noHQAQm4H9hzys6fCHRSpz4m+vn5OY4/slaTgPsZe07Z+RMZndRqBsPEnc9Hdt3Yc8rOn8jopFYzGCbufD6y68aeU3b+REYntZrBMHHn85FdN/acsvMnMjqp25rB64RfTzHj+VIRfHbaGDBV4QQEwL3w7dxgO3PkdOcsBGyaEOiAX7qsME9Z3gbv8OoOag1WTQ6zp0vl4dqAzSDKd3ED6zw+68k+2uF9AdXntywhzyG58dwJ8VpsUu3LaEO6q5MlbWQzyFdaPlg1OcweLZXna6OlGeB0Rt3pFtLuEBwJWktHcHHTaBX5d2HuhGBp1zceSKgM2KxmYD0gfWCganKYDWsGUUZaB/Z8TBTdwObVvfHZ/zIAc+JbZ7Rw77VBM4gei8VuvPGG2eBmAGo1ueGLraGaHGZPN4OHa6PWDNwp8O1tsFtbxSTuwtxbuFVlF1wt5Yhh5Mysounz2eo+xLJEjyBHO228YTb3Y6LDOwXAKOtUTQ6zwR8THTfXRq4ZdGTRUq82A7swvJIjKFB7045g65zVDCJZvnzjDbPpzQB4Iuehmpxh45sBlrGxNmAzwGnLvKwWR7VioqaCBQLDk8HR7TCH1p/ciCbEsljCmY23064bact+A9l63GDV5DBb5xvI1pOojdpXBvYtAL69DbbvIGxYtWJAMIhsDXaXEG0ed3jHz+a6e6Z74xW3A+mTJW3BHy2N0u0GqyaH2Qo/WnqhNlo+Jrqyhul5GmN0v3Uiqxp7Ttn5Exmd1PoN5GHizucju27sOWXnT2R0UqsZDBN3Ph/ZdWPPKTt/IqOTWs1gmLjz+ciuG3tO2fkTGZ3UqWZwy3/X/E6TgPsZe07Z+RMZndT1ZiAIgiB8CdQMBEEQBP0P5AcgAfcDe07Z+ROBTurUx0TFNSEJCbgf2HPKzp8IdFKrGTwICbgf2HPKzp8IdFKrGTwICbgf2HPKzp8IdFKrGTwICbgf2HPKzp8IdFK3NYPPv3b011PMeL5UBJ+d7nAw1vytJccD7jsFHdUQce5YS4c+wI/DkgMLv5tTdzjmDDx5Pe293MjxOzwSP5M+6yn4u4LnncmXB8x4tBx2DCiVR2vjHWmvgY2KncdnPdlHNww7m8bOwqxmgA/N6KwEz3FYcqAbk7lX37kDCIBR1WIe3AzsEjIrAmtJNgN3tqYycF/iXbxZP3i6VJ6ujXeAvZa/UxSMzw43IIpsGjsL4Eur35hinxSPhZ6R1NFGBZMXwfhwbD1Sq9NGnmJUMqegAsHY6jHUtGGeQHW/dAzMf2XgKulu8LuaQX6BFHi0VAbUxjvAvWZ7UXSDKLg4uaJSsGNfn3A9mOR4gI1nt1ax5fBWzHjA5GeSmQM3ugr2dnLzty6hSiN/uOBR0TxzPyZyC74IduN/PcOaQfRod3G0WHYM/pjo9tp4R6Jr3v2SDI6gttxJzmOr5071vuNR7aZ4/2T80ZxR5BFojqskUjjyZLLmeqpUQZklb5cZBYhN/55B1X/AGmj6noFbe+7L4rkdmEzQ9D17I8Z/z6DqP1pq4x0Arrn3y+w6yyYzSaaMOkQZANBNiydHLEu1GbhzXmkGEbfoqht/RtNAzAo7k6yqowAxNQP70uZazeDYuxngtGVeVovj+mm1VG099zFREd8UGZ3y4PRvOtBbIwEHUA+Ze4HgKKAqyPSPidzn7qXrzeCIKw3vSltsTbt4D4z/mMh97l662gyOz3cBgBYIBh7sfH0CLBiQHIzbv4Fs4+2cbmRV8IheMecRJCKaE0/lTu5eyuTUvVStgaQIvy+nf2XglhC4VHg6fl68qDfgtP7iCS6elBw8mPijpTagrzb+RoJr9y5gYzQJCM7EVkTDF1F+ERp5ZDYMC9j5E4FOav0G8oOY1QwO8xZstXdeS5HBKKiybwp2/kSgk1rN4EFIwP3AnlN2/kSgk1rN4EFIwP3AnlN2/kSgkzrVDG7575rfaRJwP2PPKTt/IqOTut4MBEEQhC+BmoEgCIKg/4H8ACTgfmDPKTt/ItBJnfqY6Ofn5zj+yFpNAu5n7Dll509kdFKrGQwTdz4f2XVjzyk7fyKjk1rNYJi48/nIrht7Ttn5Exmd1GoGw8Sdz0d23dhzys6fyOikbmgGr9crP28R3DR2G+uohkioDgHN36Jw/NEQfHcwZ9NyLMOobDBn4Mnrae/lRs7d4VFO83nBmxpkAe/o6n4HGY+Ww26DS+Xu2nimGWyZ6YzNagb40IzOSvAchyUHRmup3qvv3AEEwCh3LeAwnWVg1XgtyWbgztZUBu7LDO1tbFap3FQbcTMo2gjuM8Xz/dKcNFsNkW6FUHb74aMq2qhgclAc1t96pFanjTzFqGTxgBMcjK0eQ5nDdJb1CWv5g2JwlSyckdR9zSCTayJbsxlYT3MzOFrqwN5+pxznDWw8u7UybaBJedwScL4Km9sMCkEwjXzh4VHRPCs0g6h1/QIscFgziB4LnhsfFFNK5b7aSDcDd/a+PbmxRV8ZuLJkDn13rDtnFBmlpojH2Yyc7iGeH5WhGhWSGx8xr44CxFZuBq6MRTabvmdQ7Q2Z9EUF7K5lp4NiqWbg5gjWRvtXBtFdN85x3qJqABupoxm4c15pBhG36Kobb0stORCzws4kq+ooQGx6M2hiW+V/SzOwuVYzsFIPsFtrQx8T3WrPfUxUxDdFRpWR6TRRNjNVmPHYsztzd+CvFh6YnL0ZZPjjZhBlIUqNnSFqIVXBN7CVm0GiNmrNwL4dOM9oA6os97bbv4Fs413lbaSbKXdnRn53+Hl+dyyeyp3cvQQ4g5kjZ5UPWMiCzSCqBNcDatKW0Pllxmn9xRNcPFP0fM5WaAYXagM2A1mrNQkIzsRWi4Yvst8WodFHmH1TsPMnMjqp1QyGiVsJvrEZHOYt2GrvvJYi00SVfVOw8ycyOqnVDIaJO5+P7Lqx55SdP5HRSa1mMEzc+Xxk1409p+z8iYxO6lQzuOW/a36nScD9jD2n7PyJjE7qejMQBEEQvgRqBoIgCIL+B/IDkID7gT2n7PyJQCd16mOi4pqQhATcD+w5ZedPBDqp1QwehATcD+w5ZedPBDqp1QwehATcD+w5ZedPBDqp1QwehATcD+w5ZedPBDqp25rB5982+OspZjxfKoLPTnc4GGv+soLjAfedgkLAKttuVS2isIz+WGpLqRgLmODEUWDuDsfSger69XTX5PlqnmTfnN1VlCytKMbOZllhJuf4waVSVTjKSJWw0wyihL28AyLS0X10w7CzaewsAAEzBXd2Nq0un6kOqTMpxiSXylErFnm7l8mRm7Xumoxmxtz65rxYRXl6EcPru+OYVyp31cY7wF7LHD1R7qs8ooAosmnsLGS66ZVmECEpYJJSK/PqfdUMrqNV50wzOGBmQQBm0jHnyGaQdzbtjmPVZmA9Pc3gMIdUMZ0VxSVx9oMu7c52Hm49mOR4JDeeuzT38UivzhUwCqsKm9kVYKskE0eBFZpBNZU27Pd5d00WAXl6HXNerKJqUSWHuJxdjzvVlFK5sTbeAeiakTIi4QafFcQpidgXHrB+l9IwXPnKwH08h2VWhwVMUupgDsYetcQtjpWbgX1uT4ErXxm4t6jS65jzYhUl6+rR3XEs1gzs82ptvIeAa+5dcQIsm0wzsPF4zirJwXiuGZyDq8jPMLgZRKxWxvRmkCl1oPnFZmBPkCrDjjkvVlFTUT20O44ZpXJvbbwD7DWseOZl9YzrPmWiMlq2GWDC9mq+d4KwqCVjZx9zQFLN4AryG97V+XpNdjBpnfPRZjBmdxxrN4NMbbwD3GvgfYHrscHAg52vT9g7upGuNMNw/UdL3SeZ1UVh0Y3OL12p8Ww4TcnEUWDBZmDFP18qPE/8uLP1X5zzYhVVK8pleNy9O1ZoBq8LtfGOBNduZ7wrph8cwu1gzyk7fyLQSa3fQH4QYwR8GTx3L4F9U9zOf/Hym0iPrlTUDB6EBNwP7Dll508EOqnVDB6EBNwP7Dll508EOqlTzeCW/675nSYB9zP2nLLzJzI6qevNQBAEQfgSqBkIgiAIXjPA/zBTEARB2BJlMxAEQRC+HGoGgiAIgpqBIAiCoGYgCIIgHGoGgiAIwnEc/weL7Tmw70WEJwAAAABJRU5ErkJggg==" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><b><span style="font-size: small;">Manage using Oracle Database Service for Segregating application users and monitoring performance</span></b><br />
<a href="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAgQAAABvCAIAAAAczE9xAAAO5klEQVR4nO1dTZLrPA7Lab9z9PFm8RazmPt4Ft+rjiOSECXbkqAAxUolNCVDICWm03+vQxAEQfh6vI7j+N9//yOTyWSyr7Kfnx+nGczpRIIgCMIkqBkIgiAIsBn8CF2QgPuBPafs/IlAJ/WZMGoGr3/+yFpNAu5n7Dll509kdFKrGQwSdzoZ2S3GnlN2/kRGJ7WawSBxp5OR3WLsOWXnT2R0UqsZDBJ3OhnZLcaeU3b+REYn9SrN4OPel+eZLqsVdzqZpiwAT7f4S6Wm26KcFkJVdahKcZ4qCk7eMcN/it0oxYK2VKm0Ep7WDAppiPKdF3c6mXwi1AyAgR3++tyWeZGva5WPX6omn5BiHVuzVJKEl2gGrhZFq/j1gCeulHbCKdWwrLnyAv2tM8pClJoxiRiQ0+O0w8GiXDVen7UaiRk9sbC3q/Ifb1eksJesGt9cKn36LNQM3DVndGl9YucZXA3LmltbWMAO5/hEDMhpIRRWuE+i1tp2tV2nJm+RouqcaCuUSpM+SzSDQqMzddcJ9IoiowmnVMOydlbv/HhL2eHMslg1p8UagcJWIhsGBGzKQp7/MLtFivw8422FUmnSZ6FmAKi7K3eDwfDx9bHOxusTH0h6xTk+ETdafof/PhbyFnAFSQqYz0Ke/xi7S4qq88tLpUmfJZpB33oK1aLIibWyyMbrSIRbfxfLbmIihuX0vK7zS3exHbVarXY3LM9/mF2UIu+caBNLpU+fJZrB61S+bk2DNYCAzIQTq2FBK9QDkkaqupFRLQ5LxLCcgtp7xTvcjce6RTOAu2f4D7MbpaiqMcsWKZW8Pqs0gy1NAu5nFDkFRyEF/z2MTmo1g0HiTicju8UWz6n7NpOI/05GJ7WawSBxp5OR3WLsOWXnT2R0UqsZDBJ3OhnZLcaeU3b+REYntZrBIHGnk5HdYuw5ZedPZHRSp5pBx79Ulv1rEnA/Y88pO38io5O63gwEQRCEL4GagSAIglD7noHQAQm4H9hzys6fCHRSpz4m+vn5OY4/slaTgPsZe07Z+RMZndRqBsPEnc9Hdt3Yc8rOn8jopFYzGCbufD6y68aeU3b+REYntZrBMHHn85FdN/acsvMnMjqp25rB64RfTzHj+VIRfHbaGDBV4QQEwL3w7dxgO3PkdOcsBGyaEOiAX7qsME9Z3gbv8OoOag1WTQ6zp0vl4dqAzSDKd3ED6zw+68k+2uF9AdXntywhzyG58dwJ8VpsUu3LaEO6q5MlbWQzyFdaPlg1OcweLZXna6OlGeB0Rt3pFtLuEBwJWktHcHHTaBX5d2HuhGBp1zceSKgM2KxmYD0gfWCganKYDWsGUUZaB/Z8TBTdwObVvfHZ/zIAc+JbZ7Rw77VBM4gei8VuvPGG2eBmAGo1ueGLraGaHGZPN4OHa6PWDNwp8O1tsFtbxSTuwtxbuFVlF1wt5Yhh5Mysounz2eo+xLJEjyBHO228YTb3Y6LDOwXAKOtUTQ6zwR8THTfXRq4ZdGTRUq82A7swvJIjKFB7045g65zVDCJZvnzjDbPpzQB4Iuehmpxh45sBlrGxNmAzwGnLvKwWR7VioqaCBQLDk8HR7TCH1p/ciCbEsljCmY23064bact+A9l63GDV5DBb5xvI1pOojdpXBvYtAL69DbbvIGxYtWJAMIhsDXaXEG0ed3jHz+a6e6Z74xW3A+mTJW3BHy2N0u0GqyaH2Qo/WnqhNlo+Jrqyhul5GmN0v3Uiqxp7Ttn5Exmd1PoN5GHizucju27sOWXnT2R0UqsZDBN3Ph/ZdWPPKTt/IqOTWs1gmLjz+ciuG3tO2fkTGZ3UqWZwy3/X/E6TgPsZe07Z+RMZndT1ZiAIgiB8CdQMBEEQBP0P5AcgAfcDe07Z+ROBTurUx0TFNSEJCbgf2HPKzp8IdFKrGTwICbgf2HPKzp8IdFKrGTwICbgf2HPKzp8IdFKrGTwICbgf2HPKzp8IdFK3NYPPv3b011PMeL5UBJ+d7nAw1vytJccD7jsFHdUQce5YS4c+wI/DkgMLv5tTdzjmDDx5Pe293MjxOzwSP5M+6yn4u4LnncmXB8x4tBx2DCiVR2vjHWmvgY2KncdnPdlHNww7m8bOwqxmgA/N6KwEz3FYcqAbk7lX37kDCIBR1WIe3AzsEjIrAmtJNgN3tqYycF/iXbxZP3i6VJ6ujXeAvZa/UxSMzw43IIpsGjsL4Eur35hinxSPhZ6R1NFGBZMXwfhwbD1Sq9NGnmJUMqegAsHY6jHUtGGeQHW/dAzMf2XgKulu8LuaQX6BFHi0VAbUxjvAvWZ7UXSDKLg4uaJSsGNfn3A9mOR4gI1nt1ax5fBWzHjA5GeSmQM3ugr2dnLzty6hSiN/uOBR0TxzPyZyC74IduN/PcOaQfRod3G0WHYM/pjo9tp4R6Jr3v2SDI6gttxJzmOr5071vuNR7aZ4/2T80ZxR5BFojqskUjjyZLLmeqpUQZklb5cZBYhN/55B1X/AGmj6noFbe+7L4rkdmEzQ9D17I8Z/z6DqP1pq4x0Arrn3y+w6yyYzSaaMOkQZANBNiydHLEu1GbhzXmkGEbfoqht/RtNAzAo7k6yqowAxNQP70uZazeDYuxngtGVeVovj+mm1VG099zFREd8UGZ3y4PRvOtBbIwEHUA+Ze4HgKKAqyPSPidzn7qXrzeCIKw3vSltsTbt4D4z/mMh97l662gyOz3cBgBYIBh7sfH0CLBiQHIzbv4Fs4+2cbmRV8IheMecRJCKaE0/lTu5eyuTUvVStgaQIvy+nf2XglhC4VHg6fl68qDfgtP7iCS6elBw8mPijpTagrzb+RoJr9y5gYzQJCM7EVkTDF1F+ERp5ZDYMC9j5E4FOav0G8oOY1QwO8xZstXdeS5HBKKiybwp2/kSgk1rN4EFIwP3AnlN2/kSgk1rN4EFIwP3AnlN2/kSgkzrVDG7575rfaRJwP2PPKTt/IqOTut4MBEEQhC+BmoEgCIKg/4H8ACTgfmDPKTt/ItBJnfqY6Ofn5zj+yFpNAu5n7Dll509kdFKrGQwTdz4f2XVjzyk7fyKjk1rNYJi48/nIrht7Ttn5Exmd1GoGw8Sdz0d23dhzys6fyOikbmgGr9crP28R3DR2G+uohkioDgHN36Jw/NEQfHcwZ9NyLMOobDBn4Mnrae/lRs7d4VFO83nBmxpkAe/o6n4HGY+Ww26DS+Xu2nimGWyZ6YzNagb40IzOSvAchyUHRmup3qvv3AEEwCh3LeAwnWVg1XgtyWbgztZUBu7LDO1tbFap3FQbcTMo2gjuM8Xz/dKcNFsNkW6FUHb74aMq2qhgclAc1t96pFanjTzFqGTxgBMcjK0eQ5nDdJb1CWv5g2JwlSyckdR9zSCTayJbsxlYT3MzOFrqwN5+pxznDWw8u7UybaBJedwScL4Km9sMCkEwjXzh4VHRPCs0g6h1/QIscFgziB4LnhsfFFNK5b7aSDcDd/a+PbmxRV8ZuLJkDn13rDtnFBmlpojH2Yyc7iGeH5WhGhWSGx8xr44CxFZuBq6MRTabvmdQ7Q2Z9EUF7K5lp4NiqWbg5gjWRvtXBtFdN85x3qJqABupoxm4c15pBhG36Kobb0stORCzws4kq+ooQGx6M2hiW+V/SzOwuVYzsFIPsFtrQx8T3WrPfUxUxDdFRpWR6TRRNjNVmPHYsztzd+CvFh6YnL0ZZPjjZhBlIUqNnSFqIVXBN7CVm0GiNmrNwL4dOM9oA6os97bbv4Fs413lbaSbKXdnRn53+Hl+dyyeyp3cvQQ4g5kjZ5UPWMiCzSCqBNcDatKW0Pllxmn9xRNcPFP0fM5WaAYXagM2A1mrNQkIzsRWi4Yvst8WodFHmH1TsPMnMjqp1QyGiVsJvrEZHOYt2GrvvJYi00SVfVOw8ycyOqnVDIaJO5+P7Lqx55SdP5HRSa1mMEzc+Xxk1409p+z8iYxO6lQzuOW/a36nScD9jD2n7PyJjE7qejMQBEEQvgRqBoIgCIL+B/IDkID7gT2n7PyJQCd16mOi4pqQhATcD+w5ZedPBDqp1QwehATcD+w5ZedPBDqp1QwehATcD+w5ZedPBDqp1QwehATcD+w5ZedPBDqp25rB5982+OspZjxfKoLPTnc4GGv+soLjAfedgkLAKttuVS2isIz+WGpLqRgLmODEUWDuDsfSger69XTX5PlqnmTfnN1VlCytKMbOZllhJuf4waVSVTjKSJWw0wyihL28AyLS0X10w7CzaewsAAEzBXd2Nq0un6kOqTMpxiSXylErFnm7l8mRm7Xumoxmxtz65rxYRXl6EcPru+OYVyp31cY7wF7LHD1R7qs8ooAosmnsLGS66ZVmECEpYJJSK/PqfdUMrqNV50wzOGBmQQBm0jHnyGaQdzbtjmPVZmA9Pc3gMIdUMZ0VxSVx9oMu7c52Hm49mOR4JDeeuzT38UivzhUwCqsKm9kVYKskE0eBFZpBNZU27Pd5d00WAXl6HXNerKJqUSWHuJxdjzvVlFK5sTbeAeiakTIi4QafFcQpidgXHrB+l9IwXPnKwH08h2VWhwVMUupgDsYetcQtjpWbgX1uT4ErXxm4t6jS65jzYhUl6+rR3XEs1gzs82ptvIeAa+5dcQIsm0wzsPF4zirJwXiuGZyDq8jPMLgZRKxWxvRmkCl1oPnFZmBPkCrDjjkvVlFTUT20O44ZpXJvbbwD7DWseOZl9YzrPmWiMlq2GWDC9mq+d4KwqCVjZx9zQFLN4AryG97V+XpNdjBpnfPRZjBmdxxrN4NMbbwD3GvgfYHrscHAg52vT9g7upGuNMNw/UdL3SeZ1UVh0Y3OL12p8Ww4TcnEUWDBZmDFP18qPE/8uLP1X5zzYhVVK8pleNy9O1ZoBq8LtfGOBNduZ7wrph8cwu1gzyk7fyLQSa3fQH4QYwR8GTx3L4F9U9zOf/Hym0iPrlTUDB6EBNwP7Dll508EOqnVDB6EBNwP7Dll508EOqlTzeCW/675nSYB9zP2nLLzJzI6qevNQBAEQfgSqBkIgiAIXjPA/zBTEARB2BJlMxAEQRC+HGoGgiAIgpqBIAiCoGYgCIIgHGoGgiAIwnEc/weL7Tmw70WEJwAAAABJRU5ErkJggg==" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">exec
dbms_service.CREATE_SERVICE(SERVICE_NAME=>'test2',NETWORK_NAME=>'test2');</span></div>
<div class="MsoNormal">
<span style="font-size: small;"></span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">exec
dbms_service.START_SERVICE(SERVICE_NAME=>'test2');</span></div>
<div class="MsoNormal">
<span style="font-size: small;"></span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">alter
system set service_names=PSETLXMT,Ntest1,test2;</span></div>
<div class="MsoNormal">
<span style="font-size: small;"></span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">oracle@PSETLXMT>
show parameter local_listener</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">NAME
TYPE VALUE</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">------------------------------------
----------- ------------------------------</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">local_listener
string (ADDRESS=(PROTOCOL=tcp)(HOST=DG1224)(PORT=1628))</span></div>
<div class="MsoNormal">
<span style="font-size: small;"></span></div>
<br />
<div class="MsoNormal">
<span style="background: none repeat scroll 0% 0% yellow; color: #1f497d; font-family: "Courier New"; font-size: small;">Update the below in the tnsnames.ora
file :</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">NTEST1
=</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
(DESCRIPTION =</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
(ADDRESS_LIST =</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
(ADDRESS = (PROTOCOL = TCP)(HOST = DG1224)(PORT = 1628))</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
)</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
(CONNECT_DATA =</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
(SID_NAME=PSETLXMT)</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
(SERVICE_NAME = NTEST1)</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
)</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
)</span></div>
<div class="MsoNormal">
<span style="font-size: small;"></span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">TEST2
=</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
(DESCRIPTION =</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
(ADDRESS_LIST =</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
(ADDRESS = (PROTOCOL = TCP)(HOST = DG1224)(PORT = 1628))</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
)</span></div>
<br />
<div class="MsoNormal">
<span style="font-size: small;"><span style="color: #1f497d; font-family: "Courier New";">
(CONNECT_DATA =</span></span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
(SID_NAME=PSETLXMT)</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
(SERVICE_NAME = test2)</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
)</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
)</span></div>
<br />
<br />
<div class="MsoNormal">
<span style="background: none repeat scroll 0% 0% yellow; color: #1f497d; font-family: "Courier New"; font-size: small;">$ sqlplus test/test123#@NTEST1</span></div>
<br />
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">SQL*Plus:
Release 11.2.0.3.0 Production on Wed Jan 29 12:35:21 2014</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">Copyright
(c) 1982, 2011, Oracle. All rights reserved.</span></div>
<div class="MsoNormal">
<span style="font-size: small;"></span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">Connected
to:</span></div>
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">Oracle
Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">With
the Partitioning, Real Application Clusters, Automatic Storage Management,
OLAP,Data
Mining and Real Application Testing options</span></div>
<br />
<div class="MsoNormal">
<span lang="FR" style="color: #1f497d; font-family: "Courier New"; font-size: small;">test@NTEST1></span></div>
<div class="MsoNormal">
<span style="font-size: small;"></span></div>
<br />
<div class="MsoNormal">
<span lang="FR" style="background: none repeat scroll 0% 0% yellow; color: #1f497d; font-family: "Courier New"; font-size: small;">$ sqlplus
test/test123#@test2</span></div>
<div class="MsoNormal">
<span style="font-size: small;"></span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">SQL*Plus:
Release 11.2.0.3.0 Production on Wed Jan 29 12:35:57 2014</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">Copyright
(c) 1982, 2011, Oracle. All rights reserved.</span></div>
<div class="MsoNormal">
<span style="font-size: small;"></span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">Connected
to:</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">Oracle
Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith
the Partitioning, Real Application Clusters, Automatic Storage Management,
OLAP,Data
Mining and Real Application Testing options</span></div>
<div class="MsoNormal">
<span style="font-size: small;"></span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">test@test2></span></div>
<div class="MsoNormal">
<span style="font-size: small;"></span></div>
<br />
<div class="MsoNormal">
<span style="background: none repeat scroll 0% 0% yellow; color: #1f497d; font-family: "Courier New"; font-size: small;">able to see the sessions which connects
using the service name in the v$session</span></div>
<div class="MsoNormal">
<span style="font-size: small;"></span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">oracle@PSETLXMT>
select sid,serial#,schemaname,service_name from v$session where type
!='BACKGROUND';</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
SID SERIAL#
SCHEMANAME
SERVICE_NAME</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">----------
---------- ------------------------------
----------------------------------------------------------------</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
99 1021
FTP_DV_ETL
SYS$USERS</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
293 8047
SYS
SYS$USERS</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
387 44311
SYS
SYS$USERS</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
581 17421 FTP_DV_ETL
SYS$USERS</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
676 22123
FTP_DV_ETL
SYS$USERS</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
772 22383
FTP_DV_ETL
SYS$USERS</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
<span style="background: none repeat scroll 0% 0% yellow;">868
19337 TEST
test2</span></span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
964 12479
FTP_DV_ETL
SYS$USERS</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
<span style="background: none repeat scroll 0% 0% yellow;">1059
12187
TEST
test1</span></span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
1156 4117
FTP_DV_ETL
SYS$USERS</span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "Courier New"; font-size: small;">
1444 2519 FTP_DV_ETL
SYS$USERS</span></div>
<div class="MsoNormal">
<span style="font-size: small;"></span></div>
<br />
<div class="MsoNormal">
<span style="font-size: small;"></span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-size: small;">In the ashr report as well. </span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<a href="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAgQAAABvCAIAAAAczE9xAAAO5klEQVR4nO1dTZLrPA7Lab9z9PFm8RazmPt4Ft+rjiOSECXbkqAAxUolNCVDICWm03+vQxAEQfh6vI7j+N9//yOTyWSyr7Kfnx+nGczpRIIgCMIkqBkIgiAIsBn8CF2QgPuBPafs/IlAJ/WZMGoGr3/+yFpNAu5n7Dll509kdFKrGQwSdzoZ2S3GnlN2/kRGJ7WawSBxp5OR3WLsOWXnT2R0UqsZDBJ3OhnZLcaeU3b+REYn9SrN4OPel+eZLqsVdzqZpiwAT7f4S6Wm26KcFkJVdahKcZ4qCk7eMcN/it0oxYK2VKm0Ep7WDAppiPKdF3c6mXwi1AyAgR3++tyWeZGva5WPX6omn5BiHVuzVJKEl2gGrhZFq/j1gCeulHbCKdWwrLnyAv2tM8pClJoxiRiQ0+O0w8GiXDVen7UaiRk9sbC3q/Ifb1eksJesGt9cKn36LNQM3DVndGl9YucZXA3LmltbWMAO5/hEDMhpIRRWuE+i1tp2tV2nJm+RouqcaCuUSpM+SzSDQqMzddcJ9IoiowmnVMOydlbv/HhL2eHMslg1p8UagcJWIhsGBGzKQp7/MLtFivw8422FUmnSZ6FmAKi7K3eDwfDx9bHOxusTH0h6xTk+ETdafof/PhbyFnAFSQqYz0Ke/xi7S4qq88tLpUmfJZpB33oK1aLIibWyyMbrSIRbfxfLbmIihuX0vK7zS3exHbVarXY3LM9/mF2UIu+caBNLpU+fJZrB61S+bk2DNYCAzIQTq2FBK9QDkkaqupFRLQ5LxLCcgtp7xTvcjce6RTOAu2f4D7MbpaiqMcsWKZW8Pqs0gy1NAu5nFDkFRyEF/z2MTmo1g0HiTicju8UWz6n7NpOI/05GJ7WawSBxp5OR3WLsOWXnT2R0UqsZDBJ3OhnZLcaeU3b+REYntZrBIHGnk5HdYuw5ZedPZHRSp5pBx79Ulv1rEnA/Y88pO38io5O63gwEQRCEL4GagSAIglD7noHQAQm4H9hzys6fCHRSpz4m+vn5OY4/slaTgPsZe07Z+RMZndRqBsPEnc9Hdt3Yc8rOn8jopFYzGCbufD6y68aeU3b+REYntZrBMHHn85FdN/acsvMnMjqp25rB64RfTzHj+VIRfHbaGDBV4QQEwL3w7dxgO3PkdOcsBGyaEOiAX7qsME9Z3gbv8OoOag1WTQ6zp0vl4dqAzSDKd3ED6zw+68k+2uF9AdXntywhzyG58dwJ8VpsUu3LaEO6q5MlbWQzyFdaPlg1OcweLZXna6OlGeB0Rt3pFtLuEBwJWktHcHHTaBX5d2HuhGBp1zceSKgM2KxmYD0gfWCganKYDWsGUUZaB/Z8TBTdwObVvfHZ/zIAc+JbZ7Rw77VBM4gei8VuvPGG2eBmAGo1ueGLraGaHGZPN4OHa6PWDNwp8O1tsFtbxSTuwtxbuFVlF1wt5Yhh5Mysounz2eo+xLJEjyBHO228YTb3Y6LDOwXAKOtUTQ6zwR8THTfXRq4ZdGTRUq82A7swvJIjKFB7045g65zVDCJZvnzjDbPpzQB4Iuehmpxh45sBlrGxNmAzwGnLvKwWR7VioqaCBQLDk8HR7TCH1p/ciCbEsljCmY23064bact+A9l63GDV5DBb5xvI1pOojdpXBvYtAL69DbbvIGxYtWJAMIhsDXaXEG0ed3jHz+a6e6Z74xW3A+mTJW3BHy2N0u0GqyaH2Qo/WnqhNlo+Jrqyhul5GmN0v3Uiqxp7Ttn5Exmd1PoN5GHizucju27sOWXnT2R0UqsZDBN3Ph/ZdWPPKTt/IqOTWs1gmLjz+ciuG3tO2fkTGZ3UqWZwy3/X/E6TgPsZe07Z+RMZndT1ZiAIgiB8CdQMBEEQBP0P5AcgAfcDe07Z+ROBTurUx0TFNSEJCbgf2HPKzp8IdFKrGTwICbgf2HPKzp8IdFKrGTwICbgf2HPKzp8IdFKrGTwICbgf2HPKzp8IdFK3NYPPv3b011PMeL5UBJ+d7nAw1vytJccD7jsFHdUQce5YS4c+wI/DkgMLv5tTdzjmDDx5Pe293MjxOzwSP5M+6yn4u4LnncmXB8x4tBx2DCiVR2vjHWmvgY2KncdnPdlHNww7m8bOwqxmgA/N6KwEz3FYcqAbk7lX37kDCIBR1WIe3AzsEjIrAmtJNgN3tqYycF/iXbxZP3i6VJ6ujXeAvZa/UxSMzw43IIpsGjsL4Eur35hinxSPhZ6R1NFGBZMXwfhwbD1Sq9NGnmJUMqegAsHY6jHUtGGeQHW/dAzMf2XgKulu8LuaQX6BFHi0VAbUxjvAvWZ7UXSDKLg4uaJSsGNfn3A9mOR4gI1nt1ax5fBWzHjA5GeSmQM3ugr2dnLzty6hSiN/uOBR0TxzPyZyC74IduN/PcOaQfRod3G0WHYM/pjo9tp4R6Jr3v2SDI6gttxJzmOr5071vuNR7aZ4/2T80ZxR5BFojqskUjjyZLLmeqpUQZklb5cZBYhN/55B1X/AGmj6noFbe+7L4rkdmEzQ9D17I8Z/z6DqP1pq4x0Arrn3y+w6yyYzSaaMOkQZANBNiydHLEu1GbhzXmkGEbfoqht/RtNAzAo7k6yqowAxNQP70uZazeDYuxngtGVeVovj+mm1VG099zFREd8UGZ3y4PRvOtBbIwEHUA+Ze4HgKKAqyPSPidzn7qXrzeCIKw3vSltsTbt4D4z/mMh97l662gyOz3cBgBYIBh7sfH0CLBiQHIzbv4Fs4+2cbmRV8IheMecRJCKaE0/lTu5eyuTUvVStgaQIvy+nf2XglhC4VHg6fl68qDfgtP7iCS6elBw8mPijpTagrzb+RoJr9y5gYzQJCM7EVkTDF1F+ERp5ZDYMC9j5E4FOav0G8oOY1QwO8xZstXdeS5HBKKiybwp2/kSgk1rN4EFIwP3AnlN2/kSgk1rN4EFIwP3AnlN2/kSgkzrVDG7575rfaRJwP2PPKTt/IqOTut4MBEEQhC+BmoEgCIKg/4H8ACTgfmDPKTt/ItBJnfqY6Ofn5zj+yFpNAu5n7Dll509kdFKrGQwTdz4f2XVjzyk7fyKjk1rNYJi48/nIrht7Ttn5Exmd1GoGw8Sdz0d23dhzys6fyOikbmgGr9crP28R3DR2G+uohkioDgHN36Jw/NEQfHcwZ9NyLMOobDBn4Mnrae/lRs7d4VFO83nBmxpkAe/o6n4HGY+Ww26DS+Xu2nimGWyZ6YzNagb40IzOSvAchyUHRmup3qvv3AEEwCh3LeAwnWVg1XgtyWbgztZUBu7LDO1tbFap3FQbcTMo2gjuM8Xz/dKcNFsNkW6FUHb74aMq2qhgclAc1t96pFanjTzFqGTxgBMcjK0eQ5nDdJb1CWv5g2JwlSyckdR9zSCTayJbsxlYT3MzOFrqwN5+pxznDWw8u7UybaBJedwScL4Km9sMCkEwjXzh4VHRPCs0g6h1/QIscFgziB4LnhsfFFNK5b7aSDcDd/a+PbmxRV8ZuLJkDn13rDtnFBmlpojH2Yyc7iGeH5WhGhWSGx8xr44CxFZuBq6MRTabvmdQ7Q2Z9EUF7K5lp4NiqWbg5gjWRvtXBtFdN85x3qJqABupoxm4c15pBhG36Kobb0stORCzws4kq+ooQGx6M2hiW+V/SzOwuVYzsFIPsFtrQx8T3WrPfUxUxDdFRpWR6TRRNjNVmPHYsztzd+CvFh6YnL0ZZPjjZhBlIUqNnSFqIVXBN7CVm0GiNmrNwL4dOM9oA6os97bbv4Fs413lbaSbKXdnRn53+Hl+dyyeyp3cvQQ4g5kjZ5UPWMiCzSCqBNcDatKW0Pllxmn9xRNcPFP0fM5WaAYXagM2A1mrNQkIzsRWi4Yvst8WodFHmH1TsPMnMjqp1QyGiVsJvrEZHOYt2GrvvJYi00SVfVOw8ycyOqnVDIaJO5+P7Lqx55SdP5HRSa1mMEzc+Xxk1409p+z8iYxO6lQzuOW/a36nScD9jD2n7PyJjE7qejMQBEEQvgRqBoIgCIL+B/IDkID7gT2n7PyJQCd16mOi4pqQhATcD+w5ZedPBDqp1QwehATcD+w5ZedPBDqp1QwehATcD+w5ZedPBDqp1QwehATcD+w5ZedPBDqp25rB5982+OspZjxfKoLPTnc4GGv+soLjAfedgkLAKttuVS2isIz+WGpLqRgLmODEUWDuDsfSger69XTX5PlqnmTfnN1VlCytKMbOZllhJuf4waVSVTjKSJWw0wyihL28AyLS0X10w7CzaewsAAEzBXd2Nq0un6kOqTMpxiSXylErFnm7l8mRm7Xumoxmxtz65rxYRXl6EcPru+OYVyp31cY7wF7LHD1R7qs8ooAosmnsLGS66ZVmECEpYJJSK/PqfdUMrqNV50wzOGBmQQBm0jHnyGaQdzbtjmPVZmA9Pc3gMIdUMZ0VxSVx9oMu7c52Hm49mOR4JDeeuzT38UivzhUwCqsKm9kVYKskE0eBFZpBNZU27Pd5d00WAXl6HXNerKJqUSWHuJxdjzvVlFK5sTbeAeiakTIi4QafFcQpidgXHrB+l9IwXPnKwH08h2VWhwVMUupgDsYetcQtjpWbgX1uT4ErXxm4t6jS65jzYhUl6+rR3XEs1gzs82ptvIeAa+5dcQIsm0wzsPF4zirJwXiuGZyDq8jPMLgZRKxWxvRmkCl1oPnFZmBPkCrDjjkvVlFTUT20O44ZpXJvbbwD7DWseOZl9YzrPmWiMlq2GWDC9mq+d4KwqCVjZx9zQFLN4AryG97V+XpNdjBpnfPRZjBmdxxrN4NMbbwD3GvgfYHrscHAg52vT9g7upGuNMNw/UdL3SeZ1UVh0Y3OL12p8Ww4TcnEUWDBZmDFP18qPE/8uLP1X5zzYhVVK8pleNy9O1ZoBq8LtfGOBNduZ7wrph8cwu1gzyk7fyLQSa3fQH4QYwR8GTx3L4F9U9zOf/Hym0iPrlTUDB6EBNwP7Dll508EOqnVDB6EBNwP7Dll508EOqlTzeCW/675nSYB9zP2nLLzJzI6qevNQBAEQfgSqBkIgiAIXjPA/zBTEARB2BJlMxAEQRC+HGoGgiAIgpqBIAiCoGYgCIIgHGoGgiAIwnEc/weL7Tmw70WEJwAAAABJRU5ErkJggg==" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img alt="" border="0" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAgQAAABvCAIAAAAczE9xAAAO5klEQVR4nO1dTZLrPA7Lab9z9PFm8RazmPt4Ft+rjiOSECXbkqAAxUolNCVDICWm03+vQxAEQfh6vI7j+N9//yOTyWSyr7Kfnx+nGczpRIIgCMIkqBkIgiAIsBn8CF2QgPuBPafs/IlAJ/WZMGoGr3/+yFpNAu5n7Dll509kdFKrGQwSdzoZ2S3GnlN2/kRGJ7WawSBxp5OR3WLsOWXnT2R0UqsZDBJ3OhnZLcaeU3b+REYn9SrN4OPel+eZLqsVdzqZpiwAT7f4S6Wm26KcFkJVdahKcZ4qCk7eMcN/it0oxYK2VKm0Ep7WDAppiPKdF3c6mXwi1AyAgR3++tyWeZGva5WPX6omn5BiHVuzVJKEl2gGrhZFq/j1gCeulHbCKdWwrLnyAv2tM8pClJoxiRiQ0+O0w8GiXDVen7UaiRk9sbC3q/Ifb1eksJesGt9cKn36LNQM3DVndGl9YucZXA3LmltbWMAO5/hEDMhpIRRWuE+i1tp2tV2nJm+RouqcaCuUSpM+SzSDQqMzddcJ9IoiowmnVMOydlbv/HhL2eHMslg1p8UagcJWIhsGBGzKQp7/MLtFivw8422FUmnSZ6FmAKi7K3eDwfDx9bHOxusTH0h6xTk+ETdafof/PhbyFnAFSQqYz0Ke/xi7S4qq88tLpUmfJZpB33oK1aLIibWyyMbrSIRbfxfLbmIihuX0vK7zS3exHbVarXY3LM9/mF2UIu+caBNLpU+fJZrB61S+bk2DNYCAzIQTq2FBK9QDkkaqupFRLQ5LxLCcgtp7xTvcjce6RTOAu2f4D7MbpaiqMcsWKZW8Pqs0gy1NAu5nFDkFRyEF/z2MTmo1g0HiTicju8UWz6n7NpOI/05GJ7WawSBxp5OR3WLsOWXnT2R0UqsZDBJ3OhnZLcaeU3b+REYntZrBIHGnk5HdYuw5ZedPZHRSp5pBx79Ulv1rEnA/Y88pO38io5O63gwEQRCEL4GagSAIglD7noHQAQm4H9hzys6fCHRSpz4m+vn5OY4/slaTgPsZe07Z+RMZndRqBsPEnc9Hdt3Yc8rOn8jopFYzGCbufD6y68aeU3b+REYntZrBMHHn85FdN/acsvMnMjqp25rB64RfTzHj+VIRfHbaGDBV4QQEwL3w7dxgO3PkdOcsBGyaEOiAX7qsME9Z3gbv8OoOag1WTQ6zp0vl4dqAzSDKd3ED6zw+68k+2uF9AdXntywhzyG58dwJ8VpsUu3LaEO6q5MlbWQzyFdaPlg1OcweLZXna6OlGeB0Rt3pFtLuEBwJWktHcHHTaBX5d2HuhGBp1zceSKgM2KxmYD0gfWCganKYDWsGUUZaB/Z8TBTdwObVvfHZ/zIAc+JbZ7Rw77VBM4gei8VuvPGG2eBmAGo1ueGLraGaHGZPN4OHa6PWDNwp8O1tsFtbxSTuwtxbuFVlF1wt5Yhh5Mysounz2eo+xLJEjyBHO228YTb3Y6LDOwXAKOtUTQ6zwR8THTfXRq4ZdGTRUq82A7swvJIjKFB7045g65zVDCJZvnzjDbPpzQB4Iuehmpxh45sBlrGxNmAzwGnLvKwWR7VioqaCBQLDk8HR7TCH1p/ciCbEsljCmY23064bact+A9l63GDV5DBb5xvI1pOojdpXBvYtAL69DbbvIGxYtWJAMIhsDXaXEG0ed3jHz+a6e6Z74xW3A+mTJW3BHy2N0u0GqyaH2Qo/WnqhNlo+Jrqyhul5GmN0v3Uiqxp7Ttn5Exmd1PoN5GHizucju27sOWXnT2R0UqsZDBN3Ph/ZdWPPKTt/IqOTWs1gmLjz+ciuG3tO2fkTGZ3UqWZwy3/X/E6TgPsZe07Z+RMZndT1ZiAIgiB8CdQMBEEQBP0P5AcgAfcDe07Z+ROBTurUx0TFNSEJCbgf2HPKzp8IdFKrGTwICbgf2HPKzp8IdFKrGTwICbgf2HPKzp8IdFKrGTwICbgf2HPKzp8IdFK3NYPPv3b011PMeL5UBJ+d7nAw1vytJccD7jsFHdUQce5YS4c+wI/DkgMLv5tTdzjmDDx5Pe293MjxOzwSP5M+6yn4u4LnncmXB8x4tBx2DCiVR2vjHWmvgY2KncdnPdlHNww7m8bOwqxmgA/N6KwEz3FYcqAbk7lX37kDCIBR1WIe3AzsEjIrAmtJNgN3tqYycF/iXbxZP3i6VJ6ujXeAvZa/UxSMzw43IIpsGjsL4Eur35hinxSPhZ6R1NFGBZMXwfhwbD1Sq9NGnmJUMqegAsHY6jHUtGGeQHW/dAzMf2XgKulu8LuaQX6BFHi0VAbUxjvAvWZ7UXSDKLg4uaJSsGNfn3A9mOR4gI1nt1ax5fBWzHjA5GeSmQM3ugr2dnLzty6hSiN/uOBR0TxzPyZyC74IduN/PcOaQfRod3G0WHYM/pjo9tp4R6Jr3v2SDI6gttxJzmOr5071vuNR7aZ4/2T80ZxR5BFojqskUjjyZLLmeqpUQZklb5cZBYhN/55B1X/AGmj6noFbe+7L4rkdmEzQ9D17I8Z/z6DqP1pq4x0Arrn3y+w6yyYzSaaMOkQZANBNiydHLEu1GbhzXmkGEbfoqht/RtNAzAo7k6yqowAxNQP70uZazeDYuxngtGVeVovj+mm1VG099zFREd8UGZ3y4PRvOtBbIwEHUA+Ze4HgKKAqyPSPidzn7qXrzeCIKw3vSltsTbt4D4z/mMh97l662gyOz3cBgBYIBh7sfH0CLBiQHIzbv4Fs4+2cbmRV8IheMecRJCKaE0/lTu5eyuTUvVStgaQIvy+nf2XglhC4VHg6fl68qDfgtP7iCS6elBw8mPijpTagrzb+RoJr9y5gYzQJCM7EVkTDF1F+ERp5ZDYMC9j5E4FOav0G8oOY1QwO8xZstXdeS5HBKKiybwp2/kSgk1rN4EFIwP3AnlN2/kSgk1rN4EFIwP3AnlN2/kSgkzrVDG7575rfaRJwP2PPKTt/IqOTut4MBEEQhC+BmoEgCIKg/4H8ACTgfmDPKTt/ItBJnfqY6Ofn5zj+yFpNAu5n7Dll509kdFKrGQwTdz4f2XVjzyk7fyKjk1rNYJi48/nIrht7Ttn5Exmd1GoGw8Sdz0d23dhzys6fyOikbmgGr9crP28R3DR2G+uohkioDgHN36Jw/NEQfHcwZ9NyLMOobDBn4Mnrae/lRs7d4VFO83nBmxpkAe/o6n4HGY+Ww26DS+Xu2nimGWyZ6YzNagb40IzOSvAchyUHRmup3qvv3AEEwCh3LeAwnWVg1XgtyWbgztZUBu7LDO1tbFap3FQbcTMo2gjuM8Xz/dKcNFsNkW6FUHb74aMq2qhgclAc1t96pFanjTzFqGTxgBMcjK0eQ5nDdJb1CWv5g2JwlSyckdR9zSCTayJbsxlYT3MzOFrqwN5+pxznDWw8u7UybaBJedwScL4Km9sMCkEwjXzh4VHRPCs0g6h1/QIscFgziB4LnhsfFFNK5b7aSDcDd/a+PbmxRV8ZuLJkDn13rDtnFBmlpojH2Yyc7iGeH5WhGhWSGx8xr44CxFZuBq6MRTabvmdQ7Q2Z9EUF7K5lp4NiqWbg5gjWRvtXBtFdN85x3qJqABupoxm4c15pBhG36Kobb0stORCzws4kq+ooQGx6M2hiW+V/SzOwuVYzsFIPsFtrQx8T3WrPfUxUxDdFRpWR6TRRNjNVmPHYsztzd+CvFh6YnL0ZZPjjZhBlIUqNnSFqIVXBN7CVm0GiNmrNwL4dOM9oA6os97bbv4Fs413lbaSbKXdnRn53+Hl+dyyeyp3cvQQ4g5kjZ5UPWMiCzSCqBNcDatKW0Pllxmn9xRNcPFP0fM5WaAYXagM2A1mrNQkIzsRWi4Yvst8WodFHmH1TsPMnMjqp1QyGiVsJvrEZHOYt2GrvvJYi00SVfVOw8ycyOqnVDIaJO5+P7Lqx55SdP5HRSa1mMEzc+Xxk1409p+z8iYxO6lQzuOW/a36nScD9jD2n7PyJjE7qejMQBEEQvgRqBoIgCIL+B/IDkID7gT2n7PyJQCd16mOi4pqQhATcD+w5ZedPBDqp1QwehATcD+w5ZedPBDqp1QwehATcD+w5ZedPBDqp1QwehATcD+w5ZedPBDqp25rB5982+OspZjxfKoLPTnc4GGv+soLjAfedgkLAKttuVS2isIz+WGpLqRgLmODEUWDuDsfSger69XTX5PlqnmTfnN1VlCytKMbOZllhJuf4waVSVTjKSJWw0wyihL28AyLS0X10w7CzaewsAAEzBXd2Nq0un6kOqTMpxiSXylErFnm7l8mRm7Xumoxmxtz65rxYRXl6EcPru+OYVyp31cY7wF7LHD1R7qs8ooAosmnsLGS66ZVmECEpYJJSK/PqfdUMrqNV50wzOGBmQQBm0jHnyGaQdzbtjmPVZmA9Pc3gMIdUMZ0VxSVx9oMu7c52Hm49mOR4JDeeuzT38UivzhUwCqsKm9kVYKskE0eBFZpBNZU27Pd5d00WAXl6HXNerKJqUSWHuJxdjzvVlFK5sTbeAeiakTIi4QafFcQpidgXHrB+l9IwXPnKwH08h2VWhwVMUupgDsYetcQtjpWbgX1uT4ErXxm4t6jS65jzYhUl6+rR3XEs1gzs82ptvIeAa+5dcQIsm0wzsPF4zirJwXiuGZyDq8jPMLgZRKxWxvRmkCl1oPnFZmBPkCrDjjkvVlFTUT20O44ZpXJvbbwD7DWseOZl9YzrPmWiMlq2GWDC9mq+d4KwqCVjZx9zQFLN4AryG97V+XpNdjBpnfPRZjBmdxxrN4NMbbwD3GvgfYHrscHAg52vT9g7upGuNMNw/UdL3SeZ1UVh0Y3OL12p8Ww4TcnEUWDBZmDFP18qPE/8uLP1X5zzYhVVK8pleNy9O1ZoBq8LtfGOBNduZ7wrph8cwu1gzyk7fyLQSa3fQH4QYwR8GTx3L4F9U9zOf/Hym0iPrlTUDB6EBNwP7Dll508EOqnVDB6EBNwP7Dll508EOqlTzeCW/675nSYB9zP2nLLzJzI6qevNQBAEQfgSqBkIgiAIXjPA/zBTEARB2BJlMxAEQRC+HGoGgiAIgpqBIAiCoGYgCIIgHGoGgiAIwnEc/weL7Tmw70WEJwAAAABJRU5ErkJggg==" /></a><span style="font-size: x-small;"><span style="color: #1f497d;"> </span></span></div>
<span style="font-size: x-small;">
</span><br />
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
</div>
<div class="MsoNormal">
</div>
<div class="MsoNormal">
</div>
<div class="MsoNormal">
</div>
<span style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; mso-ansi-language: EN-SG; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-SG; mso-fareast-theme-font: minor-latin;"><span style="mso-no-proof: yes;"></span></span></div>
Navaneethhttp://www.blogger.com/profile/06691943267983308816noreply@blogger.com1tag:blogger.com,1999:blog-3965303601001940879.post-1168295612052499182012-06-13T19:52:00.001-07:002012-06-13T20:38:13.702-07:00Oracle 9.2.0.6 to 11.2.0.2 upgrade steps<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;"></span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">The below steps followed for upgrading a production database which is of size 400GB.<br /><br />Preupgrade steps :<br />--------------------------------------<br /><br />9206 oracle home = /usr/oracle/ora_9_2_0_5<br /><br />> do the count on the PG022 server on 9.2.0.6 database before going for upgrade.<br /><br />step 1: Shut down the existing database STRASPRD in old 9.2.0.6 home.<br /><br />>shutdown immediate<br /><br />step 2: copy the datafile from old filesystem to new filesystem<br /><br />> script copy_DF_strasprd.sh<br /><br />step 3a: Backup the spfile with new name.<br /><br />> copy spfilestrasprd.ora spfilestrasprd20120519.ora.bkp<br /><br />step 3b : change the controlfile locations in the pfile/spfile in 9.2.0.6 home with new database<br /><br />step 4: connect sqlplus and startup nomount<br /><br />> sqlplus /nolog <br />> startup nomount<br /><br />step 4: Recreate the controlfile.<br /><br />> script control_file_creation_script<br /><br />step 5: Mount the database<br /><br />>alter database mount<br /><br />step 6: Recover using backup controlfile and open resetlogs<br /><br />> recover database using backup controlfile until cancel;<br /><br />> alter database open resetlogs;<br /><br />step 7: create a new temporary tablepsace - remove the copy in DF copy script file.<br /><br /><br />create temporary tablespace TEMP tempfile '/prd/HK/strauss/undo/temp_01.dbf' size 1000M autoextend on next 1000M maxsize 8000M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;<br /><br />step 8: check the datafiles count and logfiles, controlfile locations as per the new filesystem.<br /><br />select name from v$datafile;<br />select * from v$controlfile;<br />select * from v$logfile;<br />select * from v$reocver_file;<br /><br />step 9: check the count of invalid obejcts and database components versions and status before going for upgrade.<br /><br />select owner,count(*),object_type from dba_objects where status !='VALID' group by owner,object_type;<br />15:21:37 SQL> select owner,count(*),object_type from dba_objects where status !='VALID' group by owner,object_type;<br /><br />OWNER COUNT(*) OBJECT_TYPE<br />------------------------------ ---------- ------------------<br />SYS 1 TRIGGER<br />SYS 1 PROCEDURE<br />SYS 8 PACKAGE BODY<br />SYSTEM 371 PACKAGE<br />SYSTEM 394 PACKAGE BODY<br />IBROKER 17 PACKAGE<br />IBROKER 21 PACKAGE BODY<br /><br />7 rows selected.<br /><br />select COMP_NAME,version,status from dba_registry;<br />15:24:01 SQL> select COMP_NAME,version,status from dba_registry;<br /><br />COMP_NAME VERSION STATUS<br />--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------ ----------<br />Oracle9i Catalog Views 9.2.0.6.0 VALID<br />Oracle9i Packages and Types 9.2.0.6.0 VALID<br /><br /><br />step 10: Shutdown the database for 9.2.0.8 upgrade.<br /><br />> shutdown immediate<br /><br /><br /><br />Upgrade to 9.2.0.8 steps :<br />-------------------------------------------------------------------<br /><br />step 1: set the environment variables<br /><br />export ORACLE_HOME=/prd/strauss/oradump/9.2.0.8<br />export PATH=/prd/strauss/oradump/9.2.0.8/bin:$PATH<br />export LD_LIBRARY_PATH=/prd/strauss/oradump/9.2.0.8/lib32<br />export LD_LIBRARY_PATH_64=/prd/strauss/oradump/9.2.0.8/lib<br /><br /><br />step 2: copy the spfile to the new 9.2.0.8 oracle home<br /><br />cp /usr/oracle/ora_9_2_0_5/dbs/spfilestrasprd.ora /prd/strauss/oradump/9.2.0.8/dbs/spfilestrasprd.ora<br /><br />step 3b: start the database using 9.2.0.8 home <br /><br />export ORACLE_SID=strasprd<br />sqlplus -v<br />sqlplus /nolog<br />sqlplus / as sysdba<br /><br />step 4: startup the database and check parameters for shared pool and java pool - refer document.<br /><br />> startup<br /><br />SQL> SHOW PARAMETER SHARED_POOL_SIZE<br />SQL> SHOW PARAMETER JAVA_POOL_SIZE<br /><br /> If the system is using a server parameter file: <br /> If necessary, set the value of the SHARED_POOL_SIZE initialization parameter to at least 150 MB: <br /><br /> SQL> ALTER SYSTEM SET SHARED_POOL_SIZE='150M' SCOPE=spfile; <br /><br /> If necessary, set the value of the JAVA_POOL_SIZE initialization parameter to at least 150 MB: <br /> SQL> ALTER SYSTEM SET JAVA_POOL_SIZE='150M' SCOPE=spfile; <br /><br />step 6: shutdown immediate and startup in migrate mode<br /><br />SQL> STARTUP MIGRATE<br />SQL> SPOOL 9208_cpatch.log<br />SQL> @?/rdbms/admin/catpatch.sql<br />SQL> SPOOL OFF<br /><br />Review the 9208_patch.log file for errors and inspect the list of components that is displayed at the end of catpatch.sql script. <br />This list provides the version and status of each SERVER component in the database. <br />If necessary, rerun the catpatch.sql script after correcting any problems. <br /><br />step 7: restart the database<br /><br />> SHUTDOWN<br />> STARTUP<br /><br />step 8: Run the utlrp.sql script to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. <br />This step is optional but recommended. <br /><br />> @?/rdbms/admin/utlrp.sql<br /><br />step 9: check the count of invalid obejcts and database components versions and status before going for upgrade.<br /><br />select owner,count(*) from dba_objects where status !='VALID' group by owner;<br />select * from dba_registry;<br /><br />rerun the utlrp.sql script if needed.<br /><br /><br />11.2.0.2 Preupgrade steps <br />---------------------------------------------------------------------------<br />>>>>>>> Note: we can execute the below steps from the 9.2.0.8 oracle home. <<<<<<<<<<<<<<br /><br />Step 1: Complete Checklist for Manual Upgrades to 11gR2 [ID 837570.1] -- refer metalink<br /><br />Log in as oracle and copy the file utlu112i_2.sql from the 11gR2<br />ORACLE_HOME/rdbms/admin directory to a directory outside of the<br />Oracle Home.<br />Execute utlu112i_2.sql and spool the output to a file. Examine the output<br />of the upgrade information tool.<br /><br />SQL> @utlu112i_2<br /><br />check the recommendations and follow.</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;"></span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">From this step it differs for Manual upgrade and upgrade using DBUA.</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<br /></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;"></span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">For manual upgrade follow the below steps.</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;"><br />Step 2: Mandatory steps to be followed before upgrade <br /><br />CREATE TABLESPACE sysaux DATAFILE '/prd/HK/strauss/admin/sysaux01.dbf' SIZE 500M REUSE EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE;<br /><br />Step 3: drop the perfstat and rbs tablespace which is not needed for upgrade.<br /><br />> drop tablespace perfstat including contents and datafiles;<br />> drop tablespace rbs including contents and datafiles;<br />select * from v$tablespace;<br /><br />Step 4: Convert any dictionary managed tablespace to localy managed tablespace - refer metalink document -> How To Change A Dictionary Managed Tablespace To A Locally Managed Tablespace? [ID 735978.1]<br /><br />SQL> select tablespace_name,extent_management from dba_tablespaces;<br />SQL> SELECT tablespace_name, status FROM dba_tablespaces;<br /><br />SQL>SELECT tablespace_name FROM dba_tablespaces WHERE contents = 'TEMPORARY';<br /><br />SQL>SELECT s.segment_name, s.tablespace_name, t.extent_management FROM dba_segments s, dba_tablespaces t WHERE s.tablespace_name = t.tablespace_name<br />AND s.segment_type = 'ROLLBACK'<br /><br />SQL>SELECT tablespace_name, status FROM dba_tablespaces WHERE contents = 'UNDO';<br /><br /> >> Make all the tablespaces readonly before doing conversion of system tablespace aprat from temp.<br /><br />ALTER TABLESPACE ITRADE_DAT READ ONLY;<br />ALTER TABLESPACE ITRADE_IDX READ ONLY;<br />ALTER TABLESPACE IBROKER_DAT READ ONLY;<br />ALTER TABLESPACE IBROKER_IDX READ ONLY;<br />ALTER TABLESPACE SYSAUX READ ONLY;<br /><br />SELECT logins FROM v$instance<br /><br />ALTER SYSTEM ENABLE RESTRICTED SESSION;<br /><br />EXECUTE DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL('SYSTEM');<br /><br />SELECT extent_management FROM dba_tablespaces WHERE tablespace_name = 'SYSTEM';<br /><br />ALTER SYSTEM DISABLE RESTRICTED SESSION;<br /><br />ALTER TABLESPACE ITRADE_DAT READ WRITE;<br />ALTER TABLESPACE ITRADE_IDX READ WRITE;<br />ALTER TABLESPACE IBROKER_DAT READ WRITE;<br />ALTER TABLESPACE IBROKER_IDX READ WRITE;<br />ALTER TABLESPACE SYSAUX READ WRITE;<br /><br />for time zone check the values and update as per the recomendation -- refer metalink<br /><br />SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME LIKE 'DST_%' ORDER BY PROPERTY_NAME; -- optional<br /><br />Step 5: Do all the recomendations provided by @utlu112i_2 script. -- mandatory<br /><br />Step 6: connect roles is obsolete in 11g please use below query and grant privilege as needed<br /><br />SELECT grantee FROM dba_role_privs WHERE granted_role = 'CONNECT' AND grantee NOT IN ('SYS', 'OUTLN', 'SYSTEM', 'CTXSYS',<br />'DBSNMP','LOGSTDBY_ADMINISTRATOR','ORDSYS','ORDPLUGINS', 'OEM_MONITOR', 'WKSYS', 'WKPROXY','WK_TEST',<br />'WKUSER', 'MDSYS', 'LBACSYS', 'DMSYS','WMSYS', 'OLAPDBA', 'OLAPSVR','OLAP_USER','OLAPSYS', 'EXFSYS', 'SYSMAN',<br />'MDDATA','SI_INFORMTN_SCHEMA','XDB', 'ODM');<br /><br />SQL> SELECT GRANTEE,PRIVILEGE FROM DBA_SYS_PRIVS WHERE GRANTEE ='CONNECT';<br /><br />>> The below query generate grant statements for users who has connect role<br /><br />select 'grant create view,CREATE TABLE,ALTER SESSION,CREATE CLUSTER,CREATE SYNONYM,CREATE SEQUENCE,CREATE DATABASE LINK to ' ||grantee ||';' FROM dba_role_privs <br />WHERE granted_role = 'CONNECT' and grantee NOT IN ('SYS', 'OUTLN', 'SYSTEM', 'CTXSYS', 'DBSNMP','LOGSTDBY_ADMINISTRATOR',<br /> 'ORDSYS','ORDPLUGINS', 'OEM_MONITOR', 'WKSYS', 'WKPROXY','WK_TEST', 'WKUSER', 'MDSYS', 'LBACSYS', 'DMSYS','WMSYS', 'EXFSYS', 'SYSMAN', 'MDDATA','SI_INFORMTN_SCHEMA', 'XDB', 'ODM');<br /><br /><br />>>> check all the necessary recomendations are followed and make sure there is nor issues.<br /><br />Step 7: gather stats for all schemas which has stale statistics <br /><br />>EXEC DBMS_STATS.GATHER_SCHEMA_STATS('SYS',OPTIONS=>'GATHER',ESTIMATE_PERCENT => DBMS_STATS.AUTO_SAMPLE_SIZE, METHOD_OPT =>'FOR ALL COLUMNS SIZE AUTO', CASCADE => TRUE);<br /><br />Step 8: Copy the parameter file to the 11.2.0.2 location and change the necessary parameters.<br /><br />cp /prd/strauss/oradump/9.2.0.8/dbs/spfilestrasprd.ora /prd/strauss/oracle/11.2.0/dbs/initstrasprd.ora<br /><br />check - > parameters to be added/changed in 11.2.0.2<br />arhcivelog location<br />controlfile locaton<br />--------------------------------------------------------<br />Note : <br />set shared pool size to at least 448M<br />set COMPATIBLE parameter to 10.1.0 until after the upgrade has been completed successfully<br />----------------------------------------------------------------<br />*.compatible='11.2.0'<br />*.DB_RECOVERY_FILE_DEST_SIZE=1024M<br />*.db_recovery_file_dest='/usr/oracle/upgrade11G/fast_recovery_area' - need to change ,check the current environment<br />*.diagnostic_dest='/prd/stss/strasprd/data01/diag'<br />*.log_archive_format='strasprd_T%T_S%S%r.arc'<br />*.memory_max_target=13G<br />*.memory_target=13G<br />*.optimizer_mode='FIRST_ROWS_1000'<br />*.optimizer_secure_view_merging=FALSE<br />*.UNDO_MANAGEMENT='AUTO'<br />*.UNDO_RETENTION=600<br />*.undo_tablespace='UNDOTBS'<br />*.WORKAREA_SIZE_POLICY='auto'<br />*.job_queue_processes=1<br /><br /><br />Step 9:Shutdown the database and listener in 9.2.0.8 <br /><br />shutdown immediate<br />lsnrctl stop LISTENER_STRASPRD<br /><br /><br />11g Upgrade steps:<br />------------------------------------------------------------<br /><br />Step 1: set the environment variables for 11.2.0.2<br /><br />export ORACLE_HOME=/prd/strauss/oracle/11.2.0.2<br />export PATH=/prd/strauss/oracle/11.2.0.2/bin:$PATH<br />export LD_LIBRARY_PATH=/prd/strauss/oracle/11.2.0.2/lib - optional try if errors<br />export LD_LIBRARY_PATH_64=/prd/strauss/oracle/11.2.0.2/lib - optional try if errors<br /><br />cd $ORACLE_HOME<br />export ORACLE_SID=strasprd<br /><br />sqlplus -v<br />sqlplus /nolog<br />sqlplus / as sysdba</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">sql>startup upgrade</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">SQL> @/prd/strauss/oracle/11.2.0/rdbms/admin/catupgrd.sql</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">sql> shutdown immediate</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">sql> startup</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">11g post upgrade steps :</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">------------------------------------------</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">07:31:35 SQL> alter system set optimizer_mode='FIRST_ROWS_1000' scope=spfile;<br /><br />System altered.<br /><br />Elapsed: 00:00:00.01<br />07:32:03 SQL> alter system set optimizer_secure_view_merging=FALSE scope=spfile;<br /><br />System altered.<br /><br />Elapsed: 00:00:00.00<br />07:32:08 SQL> alter system set compatible='11.2.0' scope=spfile;<br /><br />System altered.<br /><br />Elapsed: 00:00:00.01<br />07:32:17 SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value<br />FROM DATABASE_PROPERTIES<br />WHERE PROPERTY_NAME LIKE 'DST_%'<br />ORDER BY PROPERTY_NAME;07:32:26 2 07:32:26 3 07:32:26 4<br /><br />PROPERTY_NAME VALUE<br />------------------------------ ------------------------------------------------------------<br />DST_PRIMARY_TT_VERSION 1<br />DST_SECONDARY_TT_VERSION 0<br />DST_UPGRADE_STATE NONE<br /><br />Elapsed: 00:00:00.00<br />07:32:31 SQL> SELECT version FROM v$timezone_file;<br /><br /> VERSION<br />----------<br /> 1<br /><br />Elapsed: 00:00:00.01<br />07:32:40 SQL> alter session set "_with_subquery"=materialize;<br /><br />Session altered.<br /><br />Elapsed: 00:00:00.00<br />07:32:45 SQL> alter session set "_simple_view_merging"=TRUE;<br /><br />Session altered.<br /><br />Elapsed: 00:00:00.00<br />07:32:50 SQL> SELECT version FROM v$timezone_file;<br /><br /> VERSION<br />----------<br /> 1<br /><br />Elapsed: 00:00:00.00<br />07:35:59 SQL> exec DBMS_DST.BEGIN_PREPARE(11);<br /><br />PL/SQL procedure successfully completed.<br /><br />Elapsed: 00:00:00.03<br />07:37:30 SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value<br />FROM DATABASE_PROPERTIES<br />WHERE PROPERTY_NAME LIKE 'DST_%'<br />ORDER BY PROPERTY_NAME;07:37:37 2 07:37:37 3 07:37:37 4<br /><br />PROPERTY_NAME VALUE<br />------------------------------ ------------------------------------------------------------<br />DST_PRIMARY_TT_VERSION 1<br />DST_SECONDARY_TT_VERSION 11<br />DST_UPGRADE_STATE PREPARE<br /><br />Elapsed: 00:00:00.00<br />07:37:38 SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value<br />FROM DATABASE_PROPERTIES<br />WHERE PROPERTY_NAME LIKE 'DST_%'<br />ORDER BY PROPERTY_NAME;07:38:28 2 07:38:28 3 07:38:28 4<br /><br />PROPERTY_NAME VALUE<br />------------------------------ ------------------------------------------------------------<br />DST_PRIMARY_TT_VERSION 1<br />DST_SECONDARY_TT_VERSION 11<br />DST_UPGRADE_STATE PREPARE<br /><br />Elapsed: 00:00:00.00<br />07:38:30 SQL> TRUNCATE TABLE SYS.DST$TRIGGER_TABLE;<br /><br />Table truncated.<br /><br />Elapsed: 00:00:00.09<br />07:38:43 SQL> TRUNCATE TABLE sys.dst$affected_tables;<br /><br />Table truncated.<br /><br />Elapsed: 00:00:00.01<br />07:38:57 SQL> TRUNCATE TABLE sys.dst$error_table;<br /><br />Table truncated.<br /><br />Elapsed: 00:00:00.02<br />07:39:07 SQL> set serveroutput on<br />BEGIN<br />DBMS_DST.FIND_AFFECTED_TABLES<br />(affected_tables => 'sys.dst$affected_tables',<br />log_errors => TRUE,<br />log_errors_table => 'sys.dst$error_table');<br />END;<br />/07:39:25 SQL> 07:39:25 2 07:39:25 3 07:39:25 4 07:39:25 5 07:39:25 6 07:39:25 7<br /><br />PL/SQL procedure successfully completed.<br /><br />Elapsed: 00:00:01.66<br />07:39:28 SQL> SELECT * FROM sys.dst$affected_tables;<br /><br />no rows selected<br /><br />Elapsed: 00:00:00.00<br />07:39:44 SQL> SELECT * FROM sys.dst$error_table;<br /><br />no rows selected<br /><br />Elapsed: 00:00:00.00<br />07:40:01 SQL> EXEC DBMS_DST.END_PREPARE;<br />A prepare window has been successfully ended.<br /><br />PL/SQL procedure successfully completed.<br /><br />Elapsed: 00:00:00.02<br />07:44:20 SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value<br />FROM DATABASE_PROPERTIES<br />WHERE PROPERTY_NAME LIKE 'DST_%'<br />ORDER BY PROPERTY_NAME;07:44:29 2 07:44:29 3 07:44:29 4<br /><br />PROPERTY_NAME VALUE<br />------------------------------ ------------------------------------------------------------<br />DST_PRIMARY_TT_VERSION 1<br />DST_SECONDARY_TT_VERSION 0<br />DST_UPGRADE_STATE NONE<br /><br />Elapsed: 00:00:00.00<br />07:44:30 SQL> shutdown immediate<br />Database closed.<br />Database dismounted.<br />07:46:18 SQL> set serveroutput on<br />07:46:19 SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value<br />FROM DATABASE_PROPERTIES<br />WHERE PROPERTY_NAME LIKE 'DST_%'<br />ORDER BY PROPERTY_NAME;<br />07:46:26 2 07:46:26 3 07:46:26 4<br />PROPERTY_NAME VALUE<br />------------------------------ ------------------------------------------------------------<br />DST_PRIMARY_TT_VERSION 1<br />DST_SECONDARY_TT_VERSION 0<br />DST_UPGRADE_STATE NONE<br /><br />Elapsed: 00:00:00.02<br />07:46:26 SQL> purge dba_recyclebin;<br /><br />DBA Recyclebin purged.<br /><br />Elapsed: 00:00:00.19<br />07:46:43 SQL> TRUNCATE TABLE SYS.DST$TRIGGER_TABLE;<br /><br />Table truncated.<br /><br />Elapsed: 00:00:00.03<br />07:46:52 SQL> TRUNCATE TABLE sys.dst$affected_tables;<br /><br />Table truncated.<br /><br />Elapsed: 00:00:00.02<br />07:46:59 SQL> TRUNCATE TABLE sys.dst$error_table;<br /><br />Table truncated.<br /><br />Elapsed: 00:00:00.01<br />07:47:07 SQL> alter session set "_with_subquery"=materialize;<br /><br />Session altered.<br /><br />Elapsed: 00:00:00.01<br />07:47:17 SQL> alter session set "_simple_view_merging"=TRUE;<br /><br />Session altered.<br /><br />Elapsed: 00:00:00.00<br />07:47:26 SQL> EXEC DBMS_DST.BEGIN_UPGRADE(11);<br />An upgrade window has been successfully started.<br /><br />PL/SQL procedure successfully completed.<br /><br />Elapsed: 00:00:00.26<br />07:47:42 SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value<br />FROM DATABASE_PROPERTIES<br />WHERE PROPERTY_NAME LIKE 'DST_%'<br />ORDER BY PROPERTY_NAME;07:48:03 2 07:48:03 3 07:48:03 4<br /><br />PROPERTY_NAME VALUE<br />------------------------------ ------------------------------------------------------------<br />DST_PRIMARY_TT_VERSION 11<br />DST_SECONDARY_TT_VERSION 1<br />DST_UPGRADE_STATE UPGRADE<br /><br />Elapsed: 00:00:00.01<br />07:48:04 SQL> SELECT OWNER, TABLE_NAME, UPGRADE_IN_PROGRESS FROM ALL_TSTZ_TABLES where UPGRADE_IN_PROGRESS='YES';<br /><br />no rows selected<br /><br />Elapsed: 00:00:00.36<br />07:48:14 SQL> shutdown immediate<br />Database closed.<br />Database dismounted.<br />ORACLE instance shut down.<br />07:48:55 SQL> startup<br />ORACLE instance started.<br /><br />Total System Global Area 1.2831E+10 bytes<br />Fixed Size 2160072 bytes<br />Variable Size 6375344696 bytes<br />Database Buffers 6442450944 bytes<br />Redo Buffers 11247616 bytes<br />Database mounted.<br />Database opened.<br />07:49:20 SQL> alter session set "_with_subquery"=materialize;<br />alter session set "_simple_view_merging"=TRUE;<br />Session altered.<br /><br />Elapsed: 00:00:00.02<br />07:49:21 SQL> alter session set "_with_subquery"=materialize;<br />alter session set "_simple_view_merging"=TRUE;alter session set "_with_subquery"=materialize<br /> *<br />ERROR at line 1:<br />ORA-00911: invalid character<br /><br /><br />Elapsed: 00:00:00.00<br />07:49:26 SQL> alter session set "_simple_view_merging"=TRUE;<br /><br />Session altered.<br /><br />Elapsed: 00:00:00.00<br />07:49:33 SQL> alter session set "_with_subquery"=materialize;<br /><br />Session altered.<br /><br />Elapsed: 00:00:00.00<br />07:49:37 SQL> set serveroutput on<br />VAR numfail number<br />07:49:46 SQL> 07:49:46 SQL> BEGIN<br />07:49:46 2 DBMS_DST.UPGRADE_DATABASE(:numfail,<br />07:49:46 3 parallel => TRUE,<br />07:49:46 4 log_errors => TRUE,<br />07:49:46 5 log_errors_table => 'SYS.DST$ERROR_TABLE',<br />07:49:46 6 log_triggers_table => 'SYS.DST$TRIGGER_TABLE',<br />07:49:46 7 error_on_overlap_time => FALSE,<br />07:49:46 8 error_on_nonexisting_time => FALSE);<br />07:49:46 9 DBMS_OUTPUT.PUT_LINE('Failures:'|| :numfail);<br />07:49:46 10 END;<br />07:49:46 11 /<br />Failures:0<br /><br />PL/SQL procedure successfully completed.<br /><br />Elapsed: 00:00:00.06<br />07:49:48 SQL> VAR fail number<br />BEGIN<br />DBMS_DST.END_UPGRADE(:fail);<br />DBMS_OUTPUT.PUT_LINE('Failures:'|| :fail);<br />END;<br />/07:50:15 SQL> 07:50:15 2 07:50:15 3 07:50:15 4 07:50:15 5<br />An upgrade window has been successfully ended.<br />Failures:0<br /><br />PL/SQL procedure successfully completed.<br /><br />Elapsed: 00:00:00.52<br />07:50:17 SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value<br />FROM DATABASE_PROPERTIES<br />WHERE PROPERTY_NAME LIKE 'DST_%'<br />ORDER BY PROPERTY_NAME;07:50:31 2 07:50:31 3 07:50:31 4<br /><br />PROPERTY_NAME VALUE<br />------------------------------ ------------------------------------------------------------<br />DST_PRIMARY_TT_VERSION 11<br />DST_SECONDARY_TT_VERSION 0<br />DST_UPGRADE_STATE NONE<br /><br />Elapsed: 00:00:00.00<br />07:50:32 SQL> SELECT * FROM v$timezone_file;<br /><br />FILENAME VERSION<br />-------------------- ----------<br />timezlrg_11.dat 11<br /><br />Elapsed: 00:00:00.01<br />07:50:41 SQL> select TZ_VERSION from registry$database;<br /><br />TZ_VERSION<br />----------<br /> 1<br /><br />Elapsed: 00:00:00.00<br />07:50:54 SQL> update registry$database set TZ_VERSION = (select version FROM v$timezone_file);<br />commit;<br />1 row updated.<br /><br />Elapsed: 00:00:00.01<br />07:51:12 SQL><br /><br />Commit complete.</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">sql> @/prd/strauss/oracle/11.2.0.2/rdbms/admin/utlrp.sql</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<br /></div>
<div style="font-family: "Courier New",Courier,monospace;">
<br /></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">For Upgrade using DBUA follow the below steps.</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<br /></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">1. start the database and listener in 9.2.0.8 home, the database should be in openmode in 9.2.0.8.</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<br /></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">2. Add the entry in the /var/opt/oracle/oratab file with the 9.2.0.8 home.</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<br /></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">3.Now set the oracle home for New oracle 11g</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">4.start the DBUA.</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">5. The DBUA should recognize the 9208 database and show the database for upgrading.</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">6. Proceed with next as per the requirment.</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">Note: For upgrade using DBUA you no need to do any preupgrade steps like creating SYSAUX and changing parameters or Database timzone upadte, DBUA automaticaly does all these while upgrading.</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">You need to take care of the connect privileges since its deprecated in 11g.</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<br /></div>
<div style="font-family: "Courier New",Courier,monospace;">
<br /></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">Regards,</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">Navaneeth </span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;"><br /></span></div>
</div>Navaneethhttp://www.blogger.com/profile/06691943267983308816noreply@blogger.com2tag:blogger.com,1999:blog-3965303601001940879.post-8929867104562762772012-04-03T22:38:00.000-07:002012-04-03T22:38:36.133-07:00Standby database redo transfer by different modes<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: "Courier New",Courier,monospace;"><br />
Redo transferred by different modes to standby database:<br />
<br />
Here in the standby database, if realtime apply is enabled, the redo data will be applied from the redolog file directly before archiving.Otherwise it will be archived and after it will be applied to the standby database.<br />
<br />
And the redo applying(either by block wise or SQL wise) will be differed based on the physical and logical standby database.<br />
<br />
1.Using Archiver Processes (ARCn) to Archive Redo Data<br />
By default, redo transport services use ARCn processes to archive the online redo log files on the primary database. ARCn archival processing supports only the maximum performance level of data protection in Data Guard configurations. You must use the LGWR process to transmit redo data to standby locations that operate in other data protection modes.</div><div class="separator" style="clear: both; font-family: "Courier New",Courier,monospace; text-align: center;"><a href="http://1.bp.blogspot.com/-zEsVdNQNntA/T3veBcUK6UI/AAAAAAAAAIw/Iab-DGZg6n0/s1600/1.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="243" src="http://1.bp.blogspot.com/-zEsVdNQNntA/T3veBcUK6UI/AAAAAAAAAIw/Iab-DGZg6n0/s320/1.bmp" width="320" /></a></div><div style="font-family: "Courier New",Courier,monospace;"><br />
Archiving to Local Destinations Before Archiving to Remote Destinations<br />
<br />
2.Using the Log Writer Process (LGWR) to Archive Redo Data<br />
<br />
You can optionally enable redo transport services to use the LGWR process to transmit redo data to remote destinations.<br />
Using the LGWR process differs from ARCn processing (described in Section 5.3.1), because instead of waiting for the online redo log to switch at the primary database and then writing the entire archived redo log at the remote destination all at once, the LGWR process selects a standby redo log file at the standby site that reflects the log sequence number (and size) of the current online redo log file of the primary database. Then, as redo is generated at the primary database, it is also transmitted to the remote destination. The transmission to the remote destination will either be synchronous or asynchronous, based on whether the SYNC or the ASYNC attribute is set on the LOG_ARCHIVE_DEST_n parameter. Synchronous LGWR processing is required for the maximum protection and maximum availability modes of data protection in Data Guard configurations. <br />
LGWR SYNC Archival to a Remote Destination with Standby Redo Log Files<br />
</div><div class="separator" style="clear: both; font-family: "Courier New",Courier,monospace; text-align: center;"><a href="http://2.bp.blogspot.com/-ydLoq_oU15s/T3veN9vrTvI/AAAAAAAAAI4/ZkUH8N9u7v0/s1600/2.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="242" src="http://2.bp.blogspot.com/-ydLoq_oU15s/T3veN9vrTvI/AAAAAAAAAI4/ZkUH8N9u7v0/s320/2.bmp" width="320" /></a></div><div style="font-family: "Courier New",Courier,monospace;"><br />
<br />
Thanks & Regards,<br />
Navaneeth<br />
</div></div>Navaneethhttp://www.blogger.com/profile/06691943267983308816noreply@blogger.com0tag:blogger.com,1999:blog-3965303601001940879.post-72948772182215719492012-03-28T22:14:00.001-07:002012-03-28T22:31:37.473-07:00Command to disable or enable firewall<div dir="ltr" style="text-align: left;" trbidi="on"><span style="font-family: Arial,sans-serif; font-size: small;"> <div style="color: black; font-family: "Courier New",Courier,monospace;"></div><div style="color: black; font-family: "Courier New",Courier,monospace;"><b>netsh firewall set opmode mode = </b><i>mode</i> </div><div style="color: black; font-family: "Courier New",Courier,monospace;">Mode = enable or disable<br />
</div><div style="color: black; font-family: "Courier New",Courier,monospace;"></div><div style="color: black; font-family: "Courier New",Courier,monospace;"></div><div style="color: black; font-family: "Courier New",Courier,monospace;"><span style="font-size: x-small;">Thank you</span></div><div style="color: black; font-family: "Courier New",Courier,monospace;"></div><div style="color: black; font-family: "Courier New",Courier,monospace;"><span style="font-size: x-small;">Regards,</span></div><div style="color: black; font-family: "Courier New",Courier,monospace;"><span style="font-size: x-small;">Navaneeth</span></div><div style="color: black;"></div><div></div></span> </div>Navaneethhttp://www.blogger.com/profile/06691943267983308816noreply@blogger.com0tag:blogger.com,1999:blog-3965303601001940879.post-9016286657935737162012-03-28T22:13:00.001-07:002012-03-28T22:13:39.331-07:00Rename a datafile in the primary and propogate the changes to the standby database<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: "Courier New",Courier,monospace;">Rename a datafile in the primary database and manually propagate the changes to the standby database.<br />
<br />
<b>PRIMARY</b><br />
<br />
1. Set STANDBY_FILE_MANAGEMENT=MANUAL on both Primary and Standby Database. <br />
<br />
SQL> show parameter standby_file_manag<br />
<br />
NAME TYPE VALUE<br />
------------------------------------ ----------- </div><div style="font-family: "Courier New",Courier,monospace;">standby_file_management string AUTO</div><div style="font-family: "Courier New",Courier,monospace;"><br />
SQL> col value format a50</div><div style="font-family: "Courier New",Courier,monospace;">SQL> select name,value from v$parameter where name like 'db_unique_name';<br />
<br />
NAME VALUE<br />
------------- ------------------------------------------------</div><div style="font-family: "Courier New",Courier,monospace;">db_unique_name orcl11g<br />
<br />
SQL><br />
SQL> alter system set standby_file_management=MANUAL;<br />
<br />
System altered.<br />
<br />
SQL> show parameter standby_file<br />
<br />
NAME TYPE VALUE<br />
------------------------------------ ----------- <br />
standby_file_management string MANUAL<br />
<br />
<br />
2. Take the Tablespace offline on the Primary Database: <br />
<br />
SQL> select * from v$tablespace;<br />
<br />
TS# NAME INC BIG FLA ENC<br />
---------- ------------------------------ --- --- --- ---<br />
0 SYSTEM YES NO YES<br />
1 SYSAUX YES NO YES<br />
2 UNDOTBS1 YES NO YES<br />
4 USERS YES NO YES<br />
3 TEMP NO NO YES<br />
6 FDB YES NO YES<br />
<br />
6 rows selected.<br />
<br />
<br />
SQL> alter tablespace users offline;<br />
<br />
Tablespace altered.<br />
<br />
3. Rename Datafile on Primary Site: <br />
<br />
copy the file using OS command to the new location<br />
<br />
4. Rename the Datafile in the Primary Database. <br />
<br />
SQL> alter tablespace users rename datafile 'D:\app\nvcob\oradata\orcl11g\USERS01.DBF' TO 'D:\app\nav6cob\oradata\orcl11g_1\USERS01.DBF';<br />
<br />
Tablespace altered.<br />
<br />
5. Bring the Tablespace back online: <br />
<br />
SQL> ALTER TABLESPACE USERS ONLINE;<br />
<br />
Tablespace altered.<br />
<br />
SQL> ALTER SYSTEM SWITCH LOGFILE;<br />
<br />
System altered.<br />
<br />
SQL><br />
<br />
------------------------------------------------------<br />
<br />
STANDBY <br />
<br />
<br />
<br />
<br />
SQL> alter system set standby_file_management=MANUAL;<br />
<br />
System altered.<br />
<br />
SQL> select name,value from v$parameter where name like 'db_unique_name';<br />
<br />
NAME VALUE<br />
-------------------------------------------------------------------------------- --------------------------------------------------<br />
db_unique_name 11gstdby<br />
<br />
SQL> show parameter standby_file<br />
<br />
NAME TYPE VALUE<br />
------------------------------------ ----------- ------------------------------<br />
standby_file_management string MANUAL<br />
SQL><br />
<br />
1. Stop Redo Apply on Standby Database.<br />
<br />
SQL> recover managed standby database cancel;<br />
Media recovery complete.<br />
<br />
<br />
2. Shutdown the Standby Database.<br />
<br />
SQL> shutdown immediate<br />
ORA-01109: database not open<br />
<br />
<br />
Database dismounted.<br />
ORACLE instance shut down.<br />
<br />
<br />
3. Move the Datafile to the new location at the Standby site.<br />
<br />
Copy the file using OS command to the new location.<br />
<br />
4. Start and mount the Standby Database.<br />
<br />
<br />
SQL> startup mount<br />
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance<br />
ORACLE instance started.<br />
<br />
Total System Global Area 535662592 bytes<br />
Fixed Size 1375792 bytes<br />
Variable Size 209715664 bytes<br />
Database Buffers 318767104 bytes<br />
Redo Buffers 5804032 bytes<br />
Database mounted.<br />
<br />
5.Rename the Datafile in the Standby Database control file. <br />
<br />
SQL> alter database rename file 'D:\app\nav6cob\oradata\11gstdby\USERS01.DBF' to 'D:\app\nav6cob\oradata\11gstdby_1\USERS01.DBF';<br />
<br />
Database altered.<br />
<br />
6. On the Standby Database, restart Redo Apply: <br />
<br />
SQL> recover managed standby database disconnect from session;<br />
Media recovery complete.<br />
<br />
<br />
7. Set STANDBY_FILE_MANAGEMENT=AUTO on both Primary and Standby Database. <br />
<br />
<br />
SQL> alter system set standby_file_management=auto;<br />
<br />
System altered.<br />
<br />
SQL> show parameter standby_file<br />
<br />
NAME TYPE VALUE<br />
------------------------------------ ----------- ------------------------------<br />
standby_file_management string AUTO<br />
SQL> select file#,name from v$datafile where name like '%USERS%';<br />
<br />
FILE# NAME<br />
---------- ----------------------------------------------------------------------------------------------------<br />
4 D:\APP\NAV6COB\ORADATA\11GSTDBY_1\USERS01.DBF<br />
<br />
SQL></div></div>Navaneethhttp://www.blogger.com/profile/06691943267983308816noreply@blogger.com0tag:blogger.com,1999:blog-3965303601001940879.post-75459179302104132122012-03-28T22:10:00.000-07:002012-03-28T22:10:49.040-07:00Oracle export/import done from Higher to lower version<div dir="ltr" style="text-align: left;" trbidi="on"><span style="font-family: Arial,sans-serif; font-size: x-small;"> <div><b>Export :</b></div><div></div><div>[oracle@HN300949l ~]$ expdp test/test DUMPFILE=test10092011.dmp DIRECTORY=EXPDP SCHEMAS=test version=10.2.0.1</div><div></div><div>Export: Release 11.2.0.1.0 - Production on Mon Oct 10 12:52:15 2011</div><div></div><div>Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.</div><div></div><div>Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production</div><div>With the Partitioning, OLAP, Data Mining and Real Application Testing options</div><div>Starting "TEST"."SYS_EXPORT_SCHEMA_01": test/******** DUMPFILE=test10092011.dmp DIRECTORY=EXPDP SCHEMAS=test version=10.2.0.1</div><div>Estimate in progress using BLOCKS method...</div><div>Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA</div><div>Total estimation using BLOCKS method: 55.68 MB</div><div>Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA</div><div></div><div>Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC</div><div>Processing object type SCHEMA_EXPORT/TABLE/TABLE</div><div>Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX</div><div>Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT</div><div>Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS</div><div>Processing object type SCHEMA_EXPORT/TABLE/COMMENT</div><div>Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS</div><div></div><div>. . exported "TEST"."DEDUPLICATE_TAB" 9.552 MB 1000 rows</div><div>. . exported "TEST"."NOCOMPRESS_TAB" 9.552 MB 1000 rows</div><div>. . exported "TEST"."KEEP_DUPLICATES_TAB" 9.552 MB 1000 rows</div><div>. . exported "TEST"."COMPRESS_TAB" 9.552 MB 1000 rows</div><div>. . exported "TEST"."SF_TAB" 5.335 KB 1 rows</div><div>. . exported "TEST"."BF_TAB" 5.335 KB 1 rows</div><div>. . exported "TEST"."MY_CUSTOMERS" 6.335 KB 1 rows</div><div>. . exported "TEST"."TEST" 6.382 KB 1 rows</div><div>. . exported "TEST"."OUTER_NTAB" 0 KB 0 rows</div><div>. . exported "TEST"."INNER_NTAB" 0 KB 0 rows</div><div>. . exported "TEST"."STU_TAB" 0 KB 0 rows</div><div>. . exported "TEST"."PER_TAB" 0 KB 0 rows</div><div>. . exported "TEST"."TIME_TABLE" 0 KB 0 rows</div><div>Master table "TEST"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded</div><div>******************************************************************************</div><div>Dump file set for TEST.SYS_EXPORT_SCHEMA_01 is:</div><div> /u01/app/oracle/test10092011.dmp</div><div>Job "TEST"."SYS_EXPORT_SCHEMA_01" successfully completed at 12:57:30</div><div></div><div></div><div>****************************************** -----------------------------------------------------------*********************************************************</div><div><b>Import :</b></div><div></div><div>D:\oracle\product\10.2.0\db_1\BIN></div><div>D:\oracle\product\10.2.0\db_1\BIN>impdp 'sys/database as sysdba' directory=DATA_PUMP_DIR dumpfile=test10092011.dmp</div><div></div><div>Import: Release 10.2.0.1.0 - Production on Monday, 10 October, 2011 13:50:20</div><div></div><div>Copyright (c) 2003, 2005, Oracle. All rights reserved.</div><div></div><div>Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production</div><div>With the Partitioning, OLAP and Data Mining options</div><div>Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded</div><div>Starting "SYS"."SYS_IMPORT_FULL_01": 'sys/******** AS SYSDBA' directory=DATA_PUMP_DIR dumpfile=test10092011.dmp</div><div>Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA</div><div>Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC</div><div>Processing object type SCHEMA_EXPORT/TABLE/TABLE</div><div>Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA</div><div>. . imported "TEST"."DEDUPLICATE_TAB" 9.552 MB 1000 rows</div><div>. . imported "TEST"."NOCOMPRESS_TAB" 9.552 MB 1000 rows</div><div>. . imported "TEST"."KEEP_DUPLICATES_TAB" 9.552 MB 1000 rows</div><div>. . imported "TEST"."COMPRESS_TAB" 9.552 MB 1000 rows</div><div>. . imported "TEST"."SF_TAB" 5.335 KB 1 rows</div><div>. . imported "TEST"."BF_TAB" 5.335 KB 1 rows</div><div>. . imported "TEST"."MY_CUSTOMERS" 6.335 KB 1 rows</div><div>. . imported "TEST"."TEST" 6.382 KB 1 rows</div><div>. . imported "TEST"."OUTER_NTAB" 0 KB 0 rows</div><div>. . imported "TEST"."INNER_NTAB" 0 KB 0 rows</div><div>. . imported "TEST"."STU_TAB" 0 KB 0 rows</div><div>. . imported "TEST"."PER_TAB" 0 KB 0 rows</div><div>. . imported "TEST"."TIME_TABLE" 0 KB 0 rows</div><div>Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX</div><div>Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS</div><div>Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS</div><div>Job "SYS"."SYS_IMPORT_FULL_01" successfully completed at 13:51:04</div><div></div><div></div><div><span style="color: blue;">Regards,</span></div><div><span style="color: blue;">Navaneeth</span></div><div></div><div></div></span> </div>Navaneethhttp://www.blogger.com/profile/06691943267983308816noreply@blogger.com3tag:blogger.com,1999:blog-3965303601001940879.post-3084643922069747612012-03-28T22:07:00.001-07:002012-03-28T22:07:41.067-07:00Oracle DB cloning Simple steps using RMAN<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: "Courier New",Courier,monospace;"></div><div class="MsoNormal" style="font-family: "Courier New",Courier,monospace; margin-left: 0.5in; text-indent: -0.25in;"><span style="font-size: small;"><span style="color: black;"> 1)<span style="font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;"> </span></span><span style="color: black;">Install Oracle Home software on new server. Make the Oracle Home directory structure same as old server.<br />
<br />
2) Create an Oracle Service same as on old server from OS prompt:<br />
<br />
cd <oracle_home>\bin<br />
set ORACLE_SID=<oracle_sid><br />
oradim -new -sid %ORACLE_SID% -intpwd MYSECRETPASSWORD -startmode M<br />
<br />
3) Configure listener on new server using netca utility from OS prompt.<br />
<br />
4) Create/check same directory structure on new server for controlfiles, datafiles, redo logfiles, dump files, networking files like sqlnet.ora, tnsnames.ora, listener.ora. This information can be obtained as follows on old server:<br />
<br />
conn / as sysdba<br />
select member from v$logfile ;<br />
select name from v$datafile ;<br />
<br />
For rest of the files (e.g. controfiles, dump/trace,log files), see parameter file on old server.</oracle_sid></oracle_home></span></span></div><div class="MsoNormal" style="font-family: "Courier New",Courier,monospace; margin-left: 0.5in;"><span style="font-size: small;"><br />
</span></div><div class="MsoNormal" style="font-family: "Courier New",Courier,monospace; margin-left: 0.5in;"><span style="font-size: small;"><span style="color: black;">5. copy the backup files to the same location which RMAN access it from.</span></span></div><div class="MsoNormal" style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><br />
</span></div><div class="MsoNormal" style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="color: black;"> 5.1 Startup nomount using pfile (taken backup)</span></span></div><div class="MsoNormal" style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><br />
</span></div><div class="MsoNormal" style="font-family: "Courier New",Courier,monospace; margin-left: 0.5in;"><span style="font-size: small;"><span style="color: black;">6. Restore controlfile from backup</span></span></div><div class="MsoNormal" style="font-family: "Courier New",Courier,monospace; margin-left: 0.5in;"><span style="font-size: small;"><span style="color: black;">7. restore database</span></span></div><div class="MsoNormal" style="font-family: "Courier New",Courier,monospace; margin-left: 0.5in;"><span style="font-size: small;"><span style="color: black;">8. open database</span></span></div><div class="MsoNormal" style="font-family: "Courier New",Courier,monospace; margin-left: 0.5in;"><span style="font-size: small;"><br />
</span></div><div class="MsoNormal" style="font-family: "Courier New",Courier,monospace; margin-left: 0.5in;"><span style="font-size: small;"><span style="color: black;">Reagrds,</span></span></div><div class="MsoNormal" style="font-family: "Courier New",Courier,monospace; margin-left: 0.5in;"><span style="font-size: small;"><span style="color: black;">Navaneeth </span></span></div></div>Navaneethhttp://www.blogger.com/profile/06691943267983308816noreply@blogger.com0tag:blogger.com,1999:blog-3965303601001940879.post-60203753626349766882012-03-22T04:33:00.000-07:002012-03-22T04:33:09.129-07:00Simple RMAN Script for Creating Standby database<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: "Courier New",Courier,monospace;">RMAN Script for creating standby database:</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">run {<br />
allocate channel prmy1 type disk;<br />
allocate channel prmy2 type disk;<br />
allocate channel prmy3 type disk;<br />
allocate channel prmy4 type disk;<br />
allocate auxiliary channel stby type disk;<br />
duplicate target database for standby from active database<br />
spfile<br />
parameter_value_convert 'orcl','orclsby1'<br />
set db_unique_name='orclsby1'<br />
set db_file_name_convert='/orcl/','/orclsby1/'<br />
set log_file_name_convert='/orcl/','/orclsby1/'<br />
set control_files='/u01/app/oracle/oradata/orclsby1.ctl'<br />
set log_archive_max_processes='5'<br />
set fal_client='orclsby1'<br />
set fal_server='orcl'<br />
set standby_file_management='AUTO'<br />
set log_archive_config='dg_config=(orcl,orclsby1)'<br />
set log_archive_dest_1='service=orcl ASYNC <br />
valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=orcl';<br />
}</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><b>Adding standby redologs in standby database:</b></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">alter database add standby logfile<br />
('/u01/app/oracle/oradata/orcl/srl01.log',<br />
'/u01/app/oracle/oradata/orcl/srl02.log',<br />
'/u01/app/oracle/oradata/orcl/srl03.log',<br />
'/u01/app/oracle/oradata/orcl/srl04.log')<br />
size 52428800<br />
/</div><div style="font-family: "Courier New",Courier,monospace;">Regards,</div><div style="font-family: "Courier New",Courier,monospace;">Navaneeth</div></div>Navaneethhttp://www.blogger.com/profile/06691943267983308816noreply@blogger.com0tag:blogger.com,1999:blog-3965303601001940879.post-59831968503607398702012-03-22T04:21:00.000-07:002012-03-22T04:21:40.043-07:00Standby recovery done in production environment 9i<div dir="ltr" style="text-align: left;" trbidi="on"><br style="font-family: "Courier New",Courier,monospace;" /><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">http://dbaspot.com/forums/oracle-server/71881-physical-standby-database-cannot-close-gap-if-any-gap-exists.html</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;">'ORA-00280: change 3220290269 for thread 1 is in sequence #17219</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00278: log file 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17218.ARC' no longer needed for this recovery</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;">ORA-00279: change 3220290274 generated at 04/11/2010 19:03:32 needed for thread 1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00289: suggestion : D:\ORADATA\sys8\ARCHIVE\LOG_1_17220.ARC</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00280: change 3220290274 for thread 1 is in sequence #17220</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00278: log file 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17219.ARC' no longer needed for this recovery</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;">ORA-00279: change 3220300520 generated at 04/11/2010 23:27:08 needed for thread 1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00289: suggestion : D:\ORADATA\sys8\ARCHIVE\LOG_1_17221.ARC</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00280: change 3220300520 for thread 1 is in sequence #17221</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00278: log file 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17220.ARC' no longer needed for this recovery</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;">ORA-00279: change 3220300533 generated at 04/11/2010 23:27:16 needed for thread 1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00289: suggestion : D:\ORADATA\sys8\ARCHIVE\LOG_1_17222.ARC</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00280: change 3220300533 for thread 1 is in sequence #17222</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00278: log file 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17221.ARC' no longer needed for this recovery</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;">ORA-00279: change 3220304453 generated at 04/12/2010 01:05:52 needed for thread 1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00289: suggestion : D:\ORADATA\sys8\ARCHIVE\LOG_1_17223.ARC</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00280: change 3220304453 for thread 1 is in sequence #17223</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00278: log file 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17222.ARC' no longer needed for this recovery</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;">ORA-00279: change 3220304456 generated at 04/12/2010 01:05:53 needed for thread 1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00289: suggestion : D:\ORADATA\sys8\ARCHIVE\LOG_1_17224.ARC</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00280: change 3220304456 for thread 1 is in sequence #17224</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00278: log file 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17223.ARC' no longer needed for this recovery</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;">ORA-00279: change 3220429248 generated at 04/12/2010 09:49:53 needed for thread 1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00289: suggestion : D:\ORADATA\sys8\ARCHIVE\LOG_1_17225.ARC</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00280: change 3220429248 for thread 1 is in sequence #17225</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00278: log file 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17224.ARC' no longer needed for this recovery</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;">ORA-00308: cannot open archived log 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17225.ARC'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-27041: unable to open file</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">OSD-04002: unable to open file</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.</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;">SQL></span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">SQL> recover standby database until cancel;</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00279: change 3220429248 generated at 04/12/2010 09:49:53 needed for thread 1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00289: suggestion : D:\ORADATA\sys8\ARCHIVE\LOG_1_17225.ARC</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00280: change 3220429248 for thread 1 is in sequence #17225</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;">Specify log: {<ret>=suggested | filename | AUTO | CANCEL}</ret></span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">AUTO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00279: change 3220572194 generated at 04/12/2010 10:46:06 needed for thread 1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00289: suggestion : D:\ORADATA\sys8\ARCHIVE\LOG_1_17226.ARC</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00280: change 3220572194 for thread 1 is in sequence #17226</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00278: log file 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17225.ARC' no longer needed for this recovery</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;">ORA-00279: change 3220627014 generated at 04/12/2010 11:06:36 needed for thread 1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00289: suggestion : D:\ORADATA\sys8\ARCHIVE\LOG_1_17227.ARC</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00280: change 3220627014 for thread 1 is in sequence #17227</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00278: log file 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17226.ARC' no longer needed for this recovery</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;">ORA-00279: change 3220627289 generated at 04/12/2010 11:06:51 needed for thread 1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00289: suggestion : D:\ORADATA\sys8\ARCHIVE\LOG_1_17228.ARC</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00280: change 3220627289 for thread 1 is in sequence #17228</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00278: log file 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17227.ARC' no longer needed for this recovery</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;">ORA-00279: change 3220763002 generated at 04/12/2010 12:27:59 needed for thread 1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00289: suggestion : D:\ORADATA\sys8\ARCHIVE\LOG_1_17229.ARC</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00280: change 3220763002 for thread 1 is in sequence #17229</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00278: log file 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17228.ARC' no longer needed for this recovery</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;">ORA-00279: change 3220899620 generated at 04/12/2010 13:24:57 needed for thread 1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00289: suggestion : D:\ORADATA\sys8\ARCHIVE\LOG_1_17230.ARC</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00280: change 3220899620 for thread 1 is in sequence #17230</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00278: log file 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17229.ARC' no longer needed for this recovery</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;">ORA-00279: change 3221036980 generated at 04/12/2010 14:44:50 needed for thread 1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00289: suggestion : D:\ORADATA\sys8\ARCHIVE\LOG_1_17231.ARC</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00280: change 3221036980 for thread 1 is in sequence #17231</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00278: log file 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17230.ARC' no longer needed for this recovery</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;">ORA-00279: change 3221165247 generated at 04/12/2010 16:11:07 needed for thread 1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00289: suggestion : D:\ORADATA\sys8\ARCHIVE\LOG_1_17232.ARC</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00280: change 3221165247 for thread 1 is in sequence #17232</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00278: log file 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17231.ARC' no longer needed for this recovery</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;">ORA-00279: change 3221302585 generated at 04/12/2010 17:30:15 needed for thread 1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00289: suggestion : D:\ORADATA\sys8\ARCHIVE\LOG_1_17233.ARC</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00280: change 3221302585 for thread 1 is in sequence #17233</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00278: log file 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17232.ARC' no longer needed for this recovery</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;">ORA-00279: change 3221437356 generated at 04/12/2010 18:37:11 needed for thread 1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00289: suggestion : D:\ORADATA\sys8\ARCHIVE\LOG_1_17234.ARC</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00280: change 3221437356 for thread 1 is in sequence #17234</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00278: log file 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17233.ARC' no longer needed for this recovery</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;">ORA-00279: change 3221499410 generated at 04/12/2010 19:02:44 needed for thread 1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00289: suggestion : D:\ORADATA\sys8\ARCHIVE\LOG_1_17235.ARC</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00280: change 3221499410 for thread 1 is in sequence #17235</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00278: log file 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17234.ARC' no longer needed for this recovery</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;">ORA-00279: change 3221499630 generated at 04/12/2010 19:03:02 needed for thread 1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00289: suggestion : D:\ORADATA\sys8\ARCHIVE\LOG_1_17236.ARC</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00280: change 3221499630 for thread 1 is in sequence #17236</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00278: log file 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17235.ARC' no longer needed for this recovery</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;">ORA-00279: change 3221663610 generated at 04/12/2010 20:36:12 needed for thread 1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00289: suggestion : D:\ORADATA\sys8\ARCHIVE\LOG_1_17237.ARC</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00280: change 3221663610 for thread 1 is in sequence #17237</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00278: log file 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17236.ARC' no longer needed for this recovery</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;">ORA-00279: change 3221809532 generated at 04/12/2010 21:37:13 needed for thread 1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00289: suggestion : D:\ORADATA\sys8\ARCHIVE\LOG_1_17238.ARC</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00280: change 3221809532 for thread 1 is in sequence #17238</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00278: log file 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17237.ARC' no longer needed for this recovery</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;">ORA-00279: change 3221951748 generated at 04/12/2010 22:41:44 needed for thread 1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00289: suggestion : D:\ORADATA\sys8\ARCHIVE\LOG_1_17239.ARC</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00280: change 3221951748 for thread 1 is in sequence #17239</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00278: log file 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17238.ARC' no longer needed for this recovery</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;">ORA-00279: change 3222098577 generated at 04/12/2010 23:39:32 needed for thread 1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00289: suggestion : D:\ORADATA\sys8\ARCHIVE\LOG_1_17240.ARC</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00280: change 3222098577 for thread 1 is in sequence #17240</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00278: log file 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17239.ARC' no longer needed for this recovery</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;">ORA-00279: change 3222248037 generated at 04/13/2010 00:55:46 needed for thread 1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00289: suggestion : D:\ORADATA\sys8\ARCHIVE\LOG_1_17241.ARC</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00280: change 3222248037 for thread 1 is in sequence #17241</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00278: log file 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17240.ARC' no longer needed for this recovery</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;">ORA-00279: change 3222264966 generated at 04/13/2010 01:05:47 needed for thread 1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00289: suggestion : D:\ORADATA\sys8\ARCHIVE\LOG_1_17242.ARC</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00280: change 3222264966 for thread 1 is in sequence #17242</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00278: log file 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17241.ARC' no longer needed for this recovery</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;">ORA-00279: change 3222265468 generated at 04/13/2010 01:06:02 needed for thread 1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00289: suggestion : D:\ORADATA\sys8\ARCHIVE\LOG_1_17243.ARC</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00280: change 3222265468 for thread 1 is in sequence #17243</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00278: log file 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17242.ARC' no longer needed for this recovery</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;">ORA-00279: change 3222405780 generated at 04/13/2010 02:19:18 needed for thread 1</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00289: suggestion : D:\ORADATA\sys8\ARCHIVE\LOG_1_17244.ARC</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00280: change 3222405780 for thread 1 is in sequence #17244</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-00278: log file 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17243.ARC' no longer needed for this recovery</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;">ORA-00308: cannot open archived log 'D:\ORADATA\sys8\ARCHIVE\LOG_1_17244.ARC'</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">ORA-27041: unable to open file</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">OSD-04002: unable to open file</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">O/S-Error: (OS 2) The system cannot find the file specified.</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;">SQL> disc</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">With the Partitioning, OLAP and Oracle Data Mining options</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">JServer Release 9.2.0.7.0 - Production</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">SQL> conn / as sysdba</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">Connected.</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">SQL></span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">SQL> set pages 100</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">SQL> set lines 1000</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">SQL></span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">SQL> select sequence#,archived,applied,deleted from v$archived_log where completion_time like '12-APR-10%';</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;"> SEQUENCE# ARC APP DEL</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">---------- --- --- ---</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17222 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17223 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17224 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17225 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17226 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17227 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17228 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17229 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17230 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17231 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17232 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17233 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17234 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17235 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17236 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17237 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17238 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17239 YES YES NO</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;">18 rows selected.</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> select sequence#,archived,applied,deleted from v$archived_log where completion_time like '13-APR-10%';</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;"> SEQUENCE# ARC APP DEL</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">---------- --- --- ---</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17240 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17241 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17242 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17243 YES YES NO</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> select sequence#,archived,applied,deleted from v$archived_log where completion_time like '13-APR-10%';</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;"> SEQUENCE# ARC APP DEL</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">---------- --- --- ---</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17240 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17241 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17242 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17243 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17244 YES NO NO</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> select sequence#,archived,applied,deleted from v$archived_log where completion_time like '13-APR-10%';</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;"> SEQUENCE# ARC APP DEL</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">---------- --- --- ---</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17240 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17241 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17242 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17243 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17244 YES NO NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17245 YES NO NO</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;">6 rows selected.</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> select sequence#,archived,applied,deleted from v$archived_log where completion_time like '13-APR-10%';</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;"> SEQUENCE# ARC APP DEL</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">---------- --- --- ---</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17240 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17241 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17242 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17243 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17244 YES NO NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17245 YES NO NO</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;">6 rows selected.</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> select sequence#,archived,applied,deleted from v$archived_log where completion_time like '13-APR-10%';</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;"> SEQUENCE# ARC APP DEL</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">---------- --- --- ---</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17240 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17241 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17242 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17243 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17244 YES NO NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17245 YES NO NO</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;">6 rows selected.</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> select sequence#,archived,applied,deleted from v$archived_log where completion_time like '13-APR-10%';</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;"> SEQUENCE# ARC APP DEL</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">---------- --- --- ---</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17240 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17241 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17242 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17243 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17244 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17245 YES YES NO</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;">6 rows selected.</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> select sequence#,archived,applied,deleted from v$archived_log where completion_time like '13-APR-10%';</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;"> SEQUENCE# ARC APP DEL</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">---------- --- --- ---</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17240 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17241 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17242 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17243 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17244 YES YES NO</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> 17245 YES YES NO</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;">6 rows selected.</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> exit</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">With the Partitioning, OLAP and Oracle Data Mining options</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">JServer Release 9.2.0.7.0 - Production</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;">C:\Documents and Settings\Administrator></span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">Regards,</span><br />
<span style="font-family: "Courier New",Courier,monospace;">Navaneeth </span></div>Navaneethhttp://www.blogger.com/profile/06691943267983308816noreply@blogger.com0tag:blogger.com,1999:blog-3965303601001940879.post-15279653849960991032012-03-22T04:17:00.000-07:002012-03-22T04:17:01.005-07:00Retention policy and Recovery Window<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;"><b><span lang="EN" style="color: black;">Retention policy:</span></b></div><div style="font-family: "Courier New",Courier,monospace;"><span lang="EN" style="color: black; font-size: 10pt;">Assume the following retention policy illustrated in figure below. The retention policy has the following aspects:</span></div><div style="font-family: "Courier New",Courier,monospace; margin-left: 0.5in; text-indent: -0.25in;"><span lang="EN" style="color: black; font-size: 10pt;">·<span style="font-size-adjust: none; font-size: 7pt; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;"> </span></span><span lang="EN" style="color: black; font-size: 10pt;">The recovery window is 7 days.</span></div><div style="font-family: "Courier New",Courier,monospace; margin-left: 0.5in; text-indent: -0.25in;"><span lang="EN" style="color: black; font-size: 10pt;">·<span style="font-size-adjust: none; font-size: 7pt; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;"> </span></span><span lang="EN" style="color: black; font-size: 10pt;">Database backups are scheduled every two weeks on these days:</span></div><div style="font-family: "Courier New",Courier,monospace; margin-left: 1in; text-indent: -0.25in;"><span lang="EN" style="color: black; font-size: 10pt;">o<span style="font-size-adjust: none; font-size: 7pt; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;"> </span></span><span lang="EN" style="color: black; font-size: 10pt;">January 1</span></div><div style="font-family: "Courier New",Courier,monospace; margin-left: 1in; text-indent: -0.25in;"><span lang="EN" style="color: black; font-size: 10pt;">o<span style="font-size-adjust: none; font-size: 7pt; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;"> </span></span><span lang="EN" style="color: black; font-size: 10pt;">January 15</span></div><div style="font-family: "Courier New",Courier,monospace; margin-left: 1in; text-indent: -0.25in;"><span lang="EN" style="color: black; font-size: 10pt;">o<span style="font-size-adjust: none; font-size: 7pt; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;"> </span></span><span lang="EN" style="color: black; font-size: 10pt;">January 29</span></div><div style="font-family: "Courier New",Courier,monospace; margin-left: 1in; text-indent: -0.25in;"><span lang="EN" style="color: black; font-size: 10pt;">o<span style="font-size-adjust: none; font-size: 7pt; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;"> </span></span><span lang="EN" style="color: black; font-size: 10pt;">February 12</span></div><div style="font-family: "Courier New",Courier,monospace; margin-left: 0.5in; text-indent: -0.25in;"><span lang="EN" style="color: black; font-size: 10pt;">·<span style="font-size-adjust: none; font-size: 7pt; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;"> </span></span><span lang="EN" style="color: black; font-size: 10pt;">The database runs in </span><code><span lang="EN" style="font-size: 10pt;">ARCHIVELOG</span></code><span lang="EN" style="color: black; font-size: 10pt;"> mode, and archived logs are saved on disk only as long as needed for the retention policy.</span></div><div class="MsoNormal" style="font-family: "Courier New",Courier,monospace; margin-bottom: 12pt;"><span lang="EN" style="color: black; font-size: 10pt;">Part 1</span></div><div class="separator" style="clear: both; font-family: "Courier New",Courier,monospace; text-align: center;"><a href="http://4.bp.blogspot.com/-N5mtA1vdf2Y/T2sJmLrREMI/AAAAAAAAAIY/9hYh_XhCwd4/s1600/1.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="120" src="http://4.bp.blogspot.com/-N5mtA1vdf2Y/T2sJmLrREMI/AAAAAAAAAIY/9hYh_XhCwd4/s200/1.bmp" width="200" /></a></div><div class="MsoNormal" style="font-family: "Courier New",Courier,monospace; margin-bottom: 12pt;"><br />
</div><div style="font-family: "Courier New",Courier,monospace; margin: 0in 0in 0.0001pt;"><span lang="EN" style="color: black; font-size: 10pt;">As illustrated in Figure , the current time is January 23 and the point of recoverability is January 16. Hence, the January 14 backup is needed for recovery, and so are the archived logs from log sequence 500 through 850. The logs before 500 and the January 1 backup are obsolete because they are not needed for recovery to a point within the window.</span></div><div style="font-family: "Courier New",Courier,monospace; margin: 0in 0in 0.0001pt;"><span lang="EN" style="color: black; font-size: 10pt;">Assume the same scenario a week later, as depicted in </span></div><div class="titleinfigure" style="font-family: "Courier New",Courier,monospace; margin: 0in 0in 0.0001pt;"><span lang="EN" style="color: black; font-size: 10pt;"> Recovery Window, Part 2</span></div><div class="separator" style="clear: both; font-family: "Courier New",Courier,monospace; text-align: center;"><a href="http://1.bp.blogspot.com/-6mX9pQut5-A/T2sJ6HO7DTI/AAAAAAAAAIg/Yvwy3oD67BU/s1600/1.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="106" src="http://1.bp.blogspot.com/-6mX9pQut5-A/T2sJ6HO7DTI/AAAAAAAAAIg/Yvwy3oD67BU/s200/1.bmp" width="200" /></a></div><div class="titleinfigure" style="font-family: "Courier New",Courier,monospace; margin: 0in 0in 0.0001pt;"><br />
</div><br />
<div style="font-family: "Courier New",Courier,monospace; margin: 0in 0in 0.0001pt;"><span lang="EN" style="color: black; font-size: 10pt;">In this scenario, the current time is January 30 and the point of recoverability is January 23. Note how the January 14 backup is <span class="italic">not</span> obsolete even though a more recent backup (January 28) exists in the recovery window. This situation occurs because restoring the January 28 backup does not enable you to recover to the earliest time in the window, January 23. To ensure recoverability to any point within the window, you must save the January 14 backup as well as all archived redo logs from log sequence 500 to 1150.</span></div><div class="MsoNormal" style="font-family: "Courier New",Courier,monospace;"><br />
</div><div class="MsoNormal" style="font-family: "Courier New",Courier,monospace;"><br />
</div><div class="titleinfigure" style="font-family: "Courier New",Courier,monospace; margin: 0in 0in 0.0001pt;"><span style="color: black; font-size: 10pt;">CONTROL_FILE_RECORD_KEEP_TIME = retention period + level 0 backup interval + 1<br />
<br />
for e.g.<br />
<br />
</span></div><div class="titleinfigure" style="font-family: "Courier New",Courier,monospace; margin: 0in 0in 0.0001pt;"><span style="color: black; font-size: 10pt;"> Level 0 backup once a week with retention policy of a recovery windows of 14 days then in this <br />
case the CONTROL_FILE_RECORD_KEEP_TIME should be 14+7+1=22</span><span lang="EN" style="color: black; font-size: 10pt;"></span></div><div class="MsoNormal" style="font-family: "Courier New",Courier,monospace;"><br />
</div><div class="MsoNormal" style="font-family: "Courier New",Courier,monospace;"><span style="font-size: 10pt;">Regards,</span></div><div class="MsoNormal" style="font-family: "Courier New",Courier,monospace;"><span style="font-size: 10pt;">Navaneeth </span></div></div>Navaneethhttp://www.blogger.com/profile/06691943267983308816noreply@blogger.com0tag:blogger.com,1999:blog-3965303601001940879.post-52783825108915927072012-03-01T22:42:00.002-08:002012-03-01T22:50:09.247-08:00Oracle 11g Arch diag<div dir="ltr" style="text-align: left;" trbidi="on"><div class="separator" style="clear: both; text-align: center;"><a href="http://2.bp.blogspot.com/-Ey70X-tgtp8/T1BsuwrUizI/AAAAAAAAAIQ/1dlKLADRcHc/s1600/oracle11g_arch.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="261" src="http://2.bp.blogspot.com/-Ey70X-tgtp8/T1BsuwrUizI/AAAAAAAAAIQ/1dlKLADRcHc/s320/oracle11g_arch.bmp" width="320" /></a></div><div class="separator" style="clear: both; text-align: center;"><a href="http://4.bp.blogspot.com/-Keb4F7aX1A4/T1Br0ZsYTsI/AAAAAAAAAII/OQZsXsxUPHc/s1600/oracle11g_arch.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><br />
</a></div><br />
</div>Navaneethhttp://www.blogger.com/profile/06691943267983308816noreply@blogger.com31tag:blogger.com,1999:blog-3965303601001940879.post-56102037526611885852012-03-01T20:58:00.003-08:002012-03-01T21:20:13.289-08:00Oracle Data Pump<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"></span></div><div style="border-color: -moz-use-text-color -moz-use-text-color rgb(196, 209, 230); border-style: none none solid; border-width: medium medium 1pt; font-family: "Courier New",Courier,monospace; padding: 0in;"><h2 style="border: medium none; padding: 0in;"><span style="color: #333333; font-size: small;">Oracle DataPump</span></h2><h2 style="border: medium none; padding: 0in;"><span style="color: #333333; font-size: small;"></span></h2></div><div class="MsoNormal" style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;">Oracle Data Pump is the replacement for the original Export and Import utilities.Available starting in Oracle Database 10g, Oracle Data Pump enables very high-speed movement of data and metadata from one database to another.<br />
</span></div><h3 style="font-family: "Courier New",Courier,monospace;"><span style="color: #333333; font-size: small;">NEW CONCEPTS IN ORACLE DATA PUMP</span></h3><div class="MsoNormal" style="font-family: "Courier New",Courier,monospace; margin-bottom: 12pt;"><span style="font-size: small;">Two new concepts in Oracle Data Pump that are different from original Export and Import.<br />
<br />
<b>DIRECTORY OBJECTS </b><br />
Data Pump differs from original Export and Import in that all jobs run primarily on the server using server processes. These server processes access files for the Data Pump jobs using directory objects that identify the location of the files. </span><br />
<span style="font-size: small;"><br />
</span><br />
<span style="font-size: small;"><b>INTERACTIVE COMMAND-LINE MODE </b><br />
There is now a very powerful interactive command-line mode which allows the user to monitor and control Data Pump Export and Import operations.<br />
<br />
CHANGING FROM ORIGINAL EXPORT/IMPORT TO ORACLE DATA PUMP<br />
<b>CREATING DIRECTORY OBJECTS </b><br />
In order to use Data Pump, the database administrator must create a directory object and grant privileges to the user on that directory object. If a directory object is not specified, a default directory object called data_pump_dir is provided. In the following example, the following SQL statement creates a directory object named dpumpdir1 that is mapped to a directory located at </span><br />
<span style="font-size: small;">D:\test\. <br />
<br />
You would login to SQL*Plus as system and enter the following SQL command to <br />
create a directory. <br />
<br />
1. sql> CREATE DIRECTORY </span><span style="font-size: small;">dpumpdir1 </span><span style="font-size: small;"> AS ‘</span><span style="font-size: small;">D:\test\</span><span style="font-size: small;">’; <br />
<br />
After a directory is created, you need to grant READ and WRITE permission on the <br />
directory to other users. For example, to allow the Oracle database to read and to write to files on behalf of user scott in the directory named by dpumpdir1, you must execute the following command: <br />
<br />
2. sql> GRANT READ,WRITE ON DIRECTORY dpumpdir1 TO scott; <br />
<br />
Note that READ or WRITE permission to a directory object means only that the Oracle database will read or write that file on your behalf. You are not given direct access to those files outside of the Oracle database unless you have the appropriate operating system privileges. Similarly, the Oracle database requires permission from the operating system to read and write files in the directories. <br />
<br />
Once the directory access is granted, the user scott can export his database objects with command arguments: <br />
<br />
3. Run the command<br />
<br />
cmd> expdp username/password DIRECTORY=dpumpdir1 dumpfile=scott.dmp <br />
<br />
COMPARISON OF COMMAND-LINE PARAMETERS FROM ORIGINAL EXPORT AND IMPORT TO DATA PUMP <br />
<br />
1) Example import of tables from scott’s account to Nav’s account <br />
<br />
Original Import: <br />
<br />
cmd> imp username/password FILE=scott.dmp FROMUSER=scott TOUSER=Nav TABLES=(*) <br />
<br />
Data Pump Import: <br />
<br />
cmd> impdp username/password DIRECTORY=dpumpdir1 DUMPFILE=scott.dmp <br />
TABLES=scott.emp REMAP_SCHEMA=scott:Nav<br />
<br />
Note how the FROMUSER/TOUSER syntax is replaced by the REMAP_SCHEMA <br />
option. <br />
<br />
2) Example export of an entire database to a dump file with all GRANTS, INDEXES, <br />
and data <br />
<br />
cmd> exp username/password FULL=y FILE=fulldb.dmp GRANTS=y INDEXES=y ROWS=y <br />
</span><br />
<span style="font-size: small;">cmd> expdp username/password FULL=y INCLUDE=GRANT INCLUDE= INDEX <br />
DIRECTORY=dpumpdir1 DUMPFILE=fulldb.dmp CONTENT=ALL <br />
<br />
The INCLUDE parameter allows you to specify which object (and its dependent objects) you want to keep in the export job. The EXCLUDE parameter allows you to specify which object (and its dependent objects) you want to keep out of the export job. You cannot mix the two parameters in one job. Both parameters work with Data Pump Import as well, and you can use different INCLUDE and EXCLUDE options for different operations on the same dump file. <br />
<br />
3) Tuning Parameters <br />
<br />
Unlike Original Export and Import, which used the BUFFER, COMMIT, COMPRESS, <br />
CONSISTENT, DIRECT, and RECORDLENGTH parameters, Data Pump needs no <br />
tuning to achieve maximum performance. Data Pump chooses the best method to <br />
ensure that data and metadata are exported and imported in the most efficient manner. Initialization parameters should be sufficient upon installation. <br />
<br />
4) Moving data between versions <br />
<br />
The Data Pump method for moving data between different database versions is different from the method used by original Export and Import. With original Export, you had to run an older version of Export to produce a dump file that was compatible with an older database version. With Data Pump, you use the current Export version and simply use the VERSION parameter to specify the target database version. You cannot specify versions earlier than Oracle Database 10g (since Data Pump did not exist before 10g). <br />
<br />
Example: <br />
<br />
cmd> expdp username/password TABLES=hr.employees VERSION=10.1 <br />
DIRECTORY=dpumpdir1 DUMPFILE=emp.dmp <br />
<br />
Data Pump Import can always read dump file sets created by older versions of Data <br />
Pump Export. <br />
<br />
Note that Data Pump Import cannot read dump files produced by original Export. <br />
<br />
<b> 11g RELEASE 1 NEW FEATURES</b><br />
<br />
• Compression on data and/or metadata<br />
• Encryption options with data and/or metadata<br />
• Partition options with import<br />
• Reuse dumpfiles<br />
• Remap Tables during import<br />
• Remap data within specified columns during an export.<br />
• Automatically restart worker processes on certain errors<br />
<br />
<b> 11g RELEASE 2 NEW FEATURES</b><br />
<br />
• Available Legacy Mode<br />
• Tables are able to reside on multiple<br />
• Wildcard usage in table names expanded for tables and partitions<br />
• Removed limitations on Real Application Cluster concurrent usage<br />
• Support for Editions </span><span style="color: #333333; font-size: small;"> </span></div><div class="MsoNormal" style="font-family: "Courier New",Courier,monospace; margin-bottom: 12pt;"><span style="font-size: small;"><b><span style="color: #333333;">MAXIMIZING THE POWER OF ORACLE DATA PUMP </span></b></span></div><div class="MsoNormal" style="font-family: "Courier New",Courier,monospace; margin-bottom: 12pt;"><span style="font-size: small;">Data Pump works great with default parameters, but once you are comfortable with Data Pump, there are new capabilities that you will want to explore. <br />
<br />
<b> PARALLELISM </b><br />
</span><br />
<span style="font-size: small;">Now Data Pump operations can take advantage of the server’s parallel processes to read or write multiple data streams simultaneously (PARALLEL is only available in the Enterprise Edition of Oracle Database 10g.) <br />
<br />
The number of parallel processes can be changed on the fly using Data Pump’s <br />
interactive command-line mode. You may have a certain number of processes running <br />
during the day and decide to change that number if more system resources become <br />
available at night (or vice versa). For best performance, you should do the following: <br />
<br />
• Make sure your system is well balanced across CPU, memory, and I/O. <br />
<br />
• Have at least one dump file for each degree of parallelism. If there aren’t enough dump files, performance will not be optimal because multiple threads of <br />
execution will be trying to access the same dump file.<br />
<br />
• Put files that are members of a dump file set on separate disks so that they will be written and read in parallel. <br />
<br />
• For export operations, use the %U variable in the DUMPFILE parameter so <br />
multiple dump files can be automatically generated. <br />
<br />
Example: <br />
<br />
cmd> expdp username/password DIRECTORY=dpumpdir1 JOB_NAME=hr <br />
DUMPFILE=par_exp%u.dmp PARALLEL=4 <br />
<br />
<b>REMAP</b><br />
<br />
• REMAP_TABLESPACE – This allows you to easily import a table into a different <br />
tablespace from which it was originally exported. The databases have to be 10.1 <br />
or later. <br />
<br />
Example: <br />
<br />
cmd> impdp username/password REMAP_TABLESPACE=tb1:tb6 DIRECTORY=dpumpdir1 DUMPFILE=employees.dmp <br />
<br />
• REMAP_DATAFILES – This is a very useful feature when you move databases <br />
between platforms that have different file naming conventions. This parameter <br />
changes the source datafile name to the target datafile name in all SQL <br />
statements where the source datafile is referenced. Because the <br />
REMAP_DATAFILE value uses quotation marks, it’s best to specify the <br />
parameter within a parameter file. <br />
<br />
Example: <br />
The parameter file, payroll.par, has the following content: <br />
DIRECTORY=dpump_dir1 <br />
FULL=Y <br />
DUMPFILE=db_full.dmp <br />
REMAP_DATAFILE=”’C:\DB1\HRDATA\PAYROLL\tbs6.dbf’:’/db1/hrdata/payroll/tbs6.dbf’” <br />
You can then issue the following command: <br />
<br />
cmd> impdp username/password PARFILE=payroll.par </span></div><h3 style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><a href="http://www.blogger.com/post-edit.g?blogID=3965303601001940879&postID=5610203752661188585" name="aref4"></a></span><span style="color: #333333; font-size: small;">EVEN MORE ADVANCED FEATURES OF ORACLE DATA PUMP </span></h3><div class="MsoNormal" style="font-family: "Courier New",Courier,monospace; margin-bottom: 12pt;"><span style="font-size: small;">Beyond the command-line and performance features of Oracle Data Pump are new <br />
capabilities that DBAs will find invaluable. A couple of prominent features are described <br />
here. <br />
<br />
<b> INTERACTIVE COMMAND-LINE MODE </b><br />
<br />
You have much more control in monitoring and controlling Data Pump jobs with <br />
interactive command-line mode. Because Data Pump jobs run entirely on the server, <br />
you can start an export or import job, detach from it, and later reconnect to the job to monitor its progress. Here are some of the things you can do while in this mode: <br />
<br />
• See the status of the job. All of the information needed to monitor the job’s <br />
execution is available. <br />
<br />
• Add more dump files if there is insufficient disk space for an export file.<br />
<br />
• Change the default size of the dump files.<br />
<br />
• Stop the job (perhaps it is consuming too many resources) and later restart it <br />
(when more resources become available). <br />
<br />
• Restart the job. If a job was stopped for any reason (system failure, power <br />
outage), you can attach to the job and then restart it. <br />
<br />
• Increase or decrease the number of active worker processes for the job. <br />
(Enterprise Edition only.) <br />
<br />
• Attach to a job from a remote site (such as from home) to monitor status. <br />
<br />
<b> NETWORK MODE </b><br />
<br />
Data Pump gives you the ability to pass data between two databases over a network (via a database link), without creating a dump file on disk. This is very useful if you’re moving data between databases, like data marts to data warehouses, and disk space is not readily available. Note that if you are moving large volumes of data, Network mode is probably going to be slower than file mode.<br />
<br />
Network export creates the dump file set on the instance where the Data Pump job is running and extracts the metadata and data from the remote instance. <br />
<br />
Network export gives you the ability to export read-only databases. (Data Pump Export cannot run locally on a read-only instance because the job requires write operations on the instance.) This is useful when there is a need to export data from a standby database.<br />
<br />
<b> GENERATING SQLFILES </b><br />
<br />
In original Import, the INDEXFILE parameter generated a text file which contained the SQL commands necessary to recreate tables and indexes that you could then edit to get a workable DDL script. <br />
<br />
With Data Pump, it’s a lot easier to get a workable DDL script. When you run Data <br />
Pump Import and specify the SQLFILE parameter, a text file is generated that has the necessary DDL (Data Definition Language) in it to recreate all object types, not just tables and indexes. Although this output file is ready for execution, the DDL statements are not actually executed, so the target system will not be changed. <br />
<br />
SQLFILEs can be particularly useful when pre-creating tables and objects in a new <br />
database. Note that the INCLUDE and EXCLUDE parameters can be used for tailoring <br />
sqlfile output. For example, if you want to create a database that contains all the tables and indexes of the source database, but that does not include the same constraints, grants, and other metadata, you would issue a command as follows: <br />
<br />
cmd> impdp username/password DIRECTORY=dpumpdir1 DUMPFILE=expfull.dmp <br />
SQLFILE=dpumpdir2:expfull.sql INCLUDE=TABLE,INDEX <br />
<br />
The SQL file named expfull.sql is written to dpumpdir2 and would include SQL DDL <br />
that could be executed in another database to create the tables and indexes as desired. </span></div><h3 style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><a href="http://www.blogger.com/post-edit.g?blogID=3965303601001940879&postID=5610203752661188585" name="aref5"></a></span><span style="color: #333333; font-size: small;">FREQUENTLY ASKED QUESTIONS</span></h3><div class="MsoNormal" style="font-family: "Courier New",Courier,monospace; margin-bottom: 12pt;"><span style="font-size: small;"><br />
What makes Data Pump faster than original Export and Import? <br />
<br />
There are three main reasons that Data Pump is faster than original Export and Import. </span><br />
<span style="font-size: small;">First, the Direct Path data access method (which permits the server to bypass SQL and go right to the data blocks on disk) has been rewritten to be much more efficient and now supports Data Pump Import and Export. </span><br />
<span style="font-size: small;"><br />
</span><br />
<span style="font-size: small;">Second, because Data Pump does its processing on the server rather than in the client, much less data has to be moved between client and server. </span><br />
<span style="font-size: small;"><br />
</span><br />
<span style="font-size: small;">Finally, Data Pump was designed from the ground up to take advantage of modern hardware and operating system architectures in ways that original Export/ and Import cannot. These factors combine to produce significant performance improvements for Data Pump over original Export and Import </span><br />
<span style="font-size: small;"><br />
</span><br />
<span style="font-size: small;">How much faster is Data Pump than the original Export and Import utilities? <br />
<br />
For a single stream, Data Pump Export is approximately 2 times faster than original Export and Data Pump Import is approximately 15 to 40 times faster than original Import. Speed can be dramatically improved using the PARALLEL parameter. <br />
<br />
Why is Data Pump slower on small jobs? <br />
<br />
Data Pump was designed for big jobs with lots of data. Each Data Pump job has a <br />
master table that has all the information about the job and is needed for restartability. The overhead of creating this master table makes small jobs take longer, but the speed in processing large amounts of data gives Data Pump a significant advantage in medium and larger jobs. <br />
<br />
Are original Export and Import going away? <br />
<br />
Original Export is being deprecated with the Oracle Database 11g release. Original <br />
Import will always be supported so that dump files from earlier releases (release 5.0 and later) will be able to be imported. Original and Data Pump dump file formats are not compatible. <br />
<br />
Are Data Pump dump files and original Export and Import dump files compatible? <br />
<br />
No, the dump files are not compatible or interchangeable. If you have original Export dump files, you must use original Import to load them. <br />
<br />
How can I monitor my Data Pump jobs to see what is going on? <br />
<br />
In interactive mode, you can get a lot of detail through the STATUS command. In <br />
SQL, you can query the following views: <br />
<br />
• DBA_DATAPUMP_JOBS - all active Data Pump jobs and the state of each <br />
job <br />
• USER_DATAPUMP_JOBS – summary of the user’s active Data Pump jobs <br />
• DBA_DATAPUMP_SESSIONS – all active user sessions that are attached to <br />
a Data Pump job <br />
• V$SESSION_LONGOPS – shows all progress on each active Data Pump job <br />
<br />
Can I use gzip with Data Pump? <br />
<br />
You can do a Data Pump Export and then run the dump files through gzip to compress <br />
them. You cannot compress the dump files prior to writing them. (The new <br />
COMPRESS parameter can be used to compress metadata, and metadata compression <br />
is enabled by default in Oracle Database 10g Release 2.) </span><br />
<span style="font-size: small;"><br />
</span><br />
<span style="font-size: small;">Regards,</span><br />
<span style="font-size: small;">Navaneeth</span></div></div>Navaneethhttp://www.blogger.com/profile/06691943267983308816noreply@blogger.com0tag:blogger.com,1999:blog-3965303601001940879.post-38956681073366896842012-01-30T02:07:00.000-08:002012-01-30T03:00:14.186-08:00Restore archivelogs to a different location<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: "Courier New",Courier,monospace;">In some scenarios we may need to restore the archivelogs to a different location from its primary location using RMAN from its backups. </div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">Below are the methods to do it.</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><b>1. The below scripts restores the archive logs to a temporary location which is given in the run script.</b></div><div style="font-family: "Courier New",Courier,monospace;">RMAN> run</div><div style="font-family: "Courier New",Courier,monospace;">2> {</div><div style="font-family: "Courier New",Courier,monospace;">3> set archivelog destination to 'D:\backup';</div><div style="font-family: "Courier New",Courier,monospace;">4> restore archivelog from logseq=250 until logseq=264;</div><div style="font-family: "Courier New",Courier,monospace;">5> }</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">executing command: SET ARCHIVELOG DESTINATION</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">Starting restore at 30-JAN-12</div><div style="font-family: "Courier New",Courier,monospace;">using channel ORA_DISK_1</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: starting archive log restore to user-specified destination</div><div style="font-family: "Courier New",Courier,monospace;">archive log destination=D:\backup</div><div style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: restoring archive log</div><div style="font-family: "Courier New",Courier,monospace;">archive log thread=1 sequence=250</div><div style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: restoring archive log</div><div style="font-family: "Courier New",Courier,monospace;">archive log thread=1 sequence=251</div><div style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: restoring archive log</div><div style="font-family: "Courier New",Courier,monospace;">archive log thread=1 sequence=252</div><div style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: restoring archive log</div><div style="font-family: "Courier New",Courier,monospace;">archive log thread=1 sequence=253</div><div style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: restoring archive log</div><div style="font-family: "Courier New",Courier,monospace;">archive log thread=1 sequence=254</div><div style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: restoring archive log</div><div style="font-family: "Courier New",Courier,monospace;">archive log thread=1 sequence=255</div><div style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: restoring archive log</div><div style="font-family: "Courier New",Courier,monospace;">archive log thread=1 sequence=256</div><div style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: restoring archive log</div><div style="font-family: "Courier New",Courier,monospace;">archive log thread=1 sequence=257</div><div style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: restoring archive log</div><div style="font-family: "Courier New",Courier,monospace;">archive log thread=1 sequence=258</div><div style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: restoring archive log</div><div style="font-family: "Courier New",Courier,monospace;">archive log thread=1 sequence=259</div><div style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: restoring archive log</div><div style="font-family: "Courier New",Courier,monospace;">archive log thread=1 sequence=260</div><div style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: restoring archive log</div><div style="font-family: "Courier New",Courier,monospace;">archive log thread=1 sequence=261</div><div style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: restoring archive log</div><div style="font-family: "Courier New",Courier,monospace;">archive log thread=1 sequence=262</div><div style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: restoring archive log</div><div style="font-family: "Courier New",Courier,monospace;">archive log thread=1 sequence=263</div><div style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: restoring archive log</div><div style="font-family: "Courier New",Courier,monospace;">archive log thread=1 sequence=264</div><div style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: reading from backup piece D:\BACKUP\ARCH_BKP\BKP_ARCH_12N22PES_1_1</div><div style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: restored backup piece 1</div><div style="font-family: "Courier New",Courier,monospace;">piece handle=D:\BACKUP\ARCH_BKP\BKP_ARCH_12N22PES_1_1 tag=TAG20120130T153139</div><div style="font-family: "Courier New",Courier,monospace;">channel ORA_DISK_1: restore complete, elapsed time: 00:00:56</div><div style="font-family: "Courier New",Courier,monospace;">Finished restore at 30-JAN-12<b><br />
</b></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><b>2. Copy the archives to a different location and restore it to the same default location </b></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">RMAN> copy archivelog 'D:\orcl10g_arch\ARC00250_0747232149.001' to 'D:\backup\arch_bkp';</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">Regards,</div><div style="font-family: "Courier New",Courier,monospace;">Navaneeth</div></div>Navaneethhttp://www.blogger.com/profile/06691943267983308816noreply@blogger.com0tag:blogger.com,1999:blog-3965303601001940879.post-75007673867377047072012-01-10T02:03:00.000-08:002012-01-10T02:21:52.023-08:00Oracle ACL Configuration on 11g for using Network packages<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: "Courier New",Courier,monospace;">In Oracle 11g network packages/system packages like UTL_MAIL,UTL_SMTP,UTL_TCP are restricted from a normal user by using Access Control List (ACL). Oracle has introduced Fine-grained Access to use External Network Services.</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">Simply giving Execute privilege to these packages may not be essential to use these packages.</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">We will need to create the below Access Control List to allow use these packages to a normal user.</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">Below is the procedure to create an access control list (ACL) with an initial privilege setting. </div><div style="font-family: "Courier New",Courier,monospace;">An ACL must have at least one privilege setting. The ACL has no access control effect unless it is assigned to network target. </div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><b>BEGIN<br />
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (<br />
acl =>'SCOTT.xml',<br />
description => 'ACL for users to send mail.',<br />
principal => 'SCOTT',<br />
is_grant => TRUE,<br />
privilege => 'connect',<br />
start_date => null,<br />
end_date => null<br />
);<br />
END;<br />
/</b></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">Use below to add a privilege to grant or deny the network access to the user. The access control entry (ACE) will be created if it does not exist.</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><b>BEGIN<br />
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(<br />
acl => 'SCOTT.xml',<br />
principal => 'SCOTT',<br />
is_grant => TRUE,<br />
privilege => 'connect');<br />
END;<br />
/</b></div><div style="font-family: "Courier New",Courier,monospace;">Use Below to assign an access control list (ACL) to a host computer, domain, or IP subnet, and if specified, the TCP port range.</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;"><b>BEGIN<br />
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(<br />
acl => 'SCOTT.xml',<br />
host => 'Mail Server name',<br />
lower_port => 25);<br />
END;<br />
/</b><br />
<b>commit;</b></div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">dont forget to give commit at end of the session to make these changes permanent.</div><div style="font-family: "Courier New",Courier,monospace;"><br />
The below procedure deletes a privilege in an access control list.</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><b>BEGIN<br />
DBMS_NETWORK_ACL_ADMIN.delete_privilege ( <br />
acl => 'SCOTT.xml', <br />
principal => 'MN',<br />
is_grant => TRUE, <br />
privilege => 'connect');<br />
COMMIT;<br />
END;<br />
/</b></div><div style="font-family: "Courier New",Courier,monospace;"><b><br />
</b></div><div style="font-family: "Courier New",Courier,monospace;">Execute privilege is must after running the above procedures.<b><br />
</b></div><div style="font-family: "Courier New",Courier,monospace;"><b><br />
</b></div><div style="font-family: "Courier New",Courier,monospace;"><b>select grantee , table_name , privilege from dba_tab_privs where table_name = 'UTL_MAIL' and grantee = 'PUBLIC';</b></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">GRANTEE TABLE_NAME PRIVILEGE <br />
---------- ----------- -----------------<br />
PUBLIC UTL_MAIL EXECUTE </div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><b>select acl,host,lower_port,upper_port from DBA_NETWORK_ACLS;</b></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">ACL HOST LOWER_PORT UPPER_PORT --------------------------------------------------------- <br />
/sys/acls/SCOTT.xml mailservername 25 25<br />
/sys/acls/SCOTT.xml Mailservername<br />
/sys/acls/SCOTT.xml mailserver.in.com</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><br />
<b>select acl,principal,privilege,is_grant from DBA_NETWORK_ACL_PRIVILEGES;</b> </div><div style="font-family: "Courier New",Courier,monospace;">ACL PRINCIPAL PRIVILE IS_GR<br />
----------------- ------------ --------- ---------------<br />
/sys/acls/SCOTT.xml SCOTT connect true </div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><b>SELECT HOST, LOWER_PORT, UPPER_PORT, ACL,<br />
DECODE(<br />
DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE_ACLID(aclid, 'SCOTT', 'connect'),<br />
1, 'GRANTED', 0, 'DENIED', null) PRIVILEGE<br />
FROM DBA_NETWORK_ACLS<br />
WHERE host IN<br />
(SELECT * FROM TABLE(DBMS_NETWORK_ACL_UTILITY.DOMAINS('msxsmtp.server.bosch.com')))<br />
ORDER BY <br />
DBMS_NETWORK_ACL_UTILITY.DOMAIN_LEVEL(host) DESC, LOWER_PORT, UPPER_PORT;</b></div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;"><br />
HOST LOWER_PORT UPPER_PORT ACL PRIVILE</div><div style="font-family: "Courier New",Courier,monospace;">-------------------- ---------- ------------------------------<br />
smtp.server.in.com 25 25 /sys/acls/SCOTT.xml GRANTED<br />
smtp.server.in.com /sys/acls/SCOTT.xml<br />
GRANTED</div><div style="font-family: "Courier New",Courier,monospace;"><br />
For adding additional users to the ACL use below<br />
<br />
<b>BEGIN<br />
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(<br />
acl => 'SCOTT.xml',<br />
principal => 'MN',<br />
is_grant => TRUE,<br />
privilege => 'connect');<br />
END;<br />
/<br />
<br />
<br />
BEGIN<br />
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(<br />
acl => 'SCOTT.xml',<br />
host => 'Mail Server name',<br />
lower_port => 25);<br />
END;<br />
/<br />
commit;</b><br />
<br />
Reference :<br />
<br />
<br />
http://oracleflash.com/36/Oracle-11g-Access-Control-List-for-External-Network-Services.html<br />
<br />
</div><div style="font-family: "Courier New",Courier,monospace;">http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_networkacl_adm.htm<br />
<br />
Regards,</div><div style="font-family: "Courier New",Courier,monospace;">Navaneeth</div></div>Navaneethhttp://www.blogger.com/profile/06691943267983308816noreply@blogger.com4tag:blogger.com,1999:blog-3965303601001940879.post-44634242688157236502011-10-31T06:18:00.001-07:002011-10-31T06:24:58.971-07:00Transaction Slot on a Block<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: "Courier New",Courier,monospace;">Transaction Slot on a Oracle Block :<br />
</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">Your process does some DML that's going to update a table, so, Oracle reserves a slot in the transaction header of a rollback segment. This is specified by the rollback number, slot, and wrap. This is what's stored in the transaction slot of the data block that's to be modified. So, now that transaction slot in the data block points to that placeholder in the rollback segment header. When rows in the data block are updated, then in the data block's row directory, the lock byte for that row is set to point to that transaction slot. So, the row directory entry (lock byte) for an updated row points to a specific transaction slot in the data block's transaction header, which in turn points to the rollback transaction slot, which in turn points to where the before images are actually recorded in the rollback segment.</div><div style="font-family: "Courier New",Courier,monospace;"><br />
Reference :<br />
<br />
Very good one...<br />
<br />
http://www.proligence.com/itl_waits_demystified.html<br />
<br />
<br />
</div><div style="font-family: "Courier New",Courier,monospace;">Regards,</div><div style="font-family: "Courier New",Courier,monospace;">Navaneeth</div></div>Navaneethhttp://www.blogger.com/profile/06691943267983308816noreply@blogger.com0tag:blogger.com,1999:blog-3965303601001940879.post-77429368638649585802011-10-18T04:13:00.000-07:002011-10-18T04:13:46.249-07:00Using 10g Logminer on 9.2.0.7 archive files<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><br />
<b>in 9i production server </b><br />
<br />
SQL> execute DBMS_LOGMNR_D.build ('dictionary.ora','C:\BCH\VER2.0\EXPORT\MONTHLY',OPTIONs => DBMS_LOGMNR_D.store_in_flat_file);<br />
<br />
PL/SQL procedure successfully completed.<br />
<br />
<b>in 10g test server using 10g logminer to analyse 9.2.0.7 archive logfiles</b><br />
<br />
execute DBMS_LOGMNR.ADD_LOGFILE('D:\je_rda\JE_logmining\LOG_1_31443.ARC',options => dbms_logmnr.new);<br />
<br />
<br />
execute DBMS_LOGMNR.START_LOGMNR(dictfilename =>'D:\je_rda\JE_logmining\dictionary.ora');<br />
<br />
select * from v$logmnr_logs<br />
select * from v$logmnr_logfile<br />
desc v$logmnr_stats<br />
<br />
select SEG_OWNER,SEG_NAME,TABLE_NAME,SEG_TYPE,ROW_ID,SESSION#,SERIAL#,USERNAME,SESSION_INFO,SQL_REDO,SQL_UNDO,AUDIT_SESSIONID from v$logmnr_contents</span></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><b><span style="font-size: small;">Reference :</span></b></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;">Oracle 10g New Features of LogMiner [ID 249001.1]<br />
LogMiner - Frequently Asked Questions (FAQ) [ID 174504.1]<br />
Oracle9i LogMiner New Features [ID 148616.1]<br />
LogMiner Utility Release 8.1.x - 10g [ID 291686.1];</span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><br />
</span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"></span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><br />
Regards,</span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;">Navaneeth</span></div></div>Navaneethhttp://www.blogger.com/profile/06691943267983308816noreply@blogger.com0tag:blogger.com,1999:blog-3965303601001940879.post-6903442007761067742011-10-13T23:56:00.000-07:002011-10-14T00:00:31.218-07:00Sharing folder from RHEL5 machine to Windows machine<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: "Courier New",Courier,monospace;">Configuring Samba service on RHEL5 machine<br />
<br />
Create a share folder in RHEL5 machine which u want to share with Windows machine.<br />
<br />
Check Linux machine for the samba packages whether installed or not.<br />
<br />
</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;"><b>[root@nav1 ~]# rpm -qa *samba*</b><br />
sblim-cmpi-samba-0.5.2-31.el5_2.1<br />
sblim-cmpi-samba-test-1-31.el5_2.1<br />
samba-3.0.33-3.7.el5<br />
samba-client-3.0.33-3.7.el5<br />
sblim-cmpi-samba-devel-1-31.el5_2.1<br />
system-config-samba-1.2.41-3.el5<br />
samba-common-3.0.33-3.7.el5<br />
samba-swat-3.0.33-3.7.el5<br />
You have new mail in /var/spool/mail/root<br />
<br />
<b>[root@nav1 ~]# service smb status</b><br />
smbd (pid 3635 3068 3029) is running...<br />
nmbd (pid 3032) is running...<br />
[root@nav1 ~]# <br />
<br />
<b>[root@nav1 ~]# useradd samba -d /home/samba</b><br />
<b>[root@nav1 ~]# smbpasswd -a samba</b><br />
New SMB password:<br />
Retype new SMB password:<br />
Added user samba.<br />
[root@nav1 ~]# cat /etc/samba/smb<br />
smb.conf smbusers <br />
<b>[root@nav1 ~]# cat /etc/samba/smb.conf </b><br />
<br />
[windows]<br />
path = /u01/windows<br />
writeable = yes<br />
; browseable = yes<br />
valid users = az, nv, samba<br />
[root@nav1 ~]# <br />
<br />
After doing any changes to smb.conf file, please restart smb service to take effect of the changes as below.<br />
<br />
<b>[root@nav1 ~]# service smb restart</b><br />
Shutting down SMB services: [ OK ]<br />
Shutting down NMB services: [ OK ]<br />
Starting SMB services: [ OK ]<br />
Starting NMB services: [ OK ]<br />
[root@nav1 ~]#<br />
<br />
Now go to Windows machine and try to Map the network drive using the RHEL5 machine IP and share name and Samba username/password.<br />
It should work fine.<br />
<br />
<b>Reference:</b></div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">http://mars.netanya.ac.il/~unesco/cdrom/LDP/Samba/HTML_FORMAT/SMB-HOWTO.html#toc6<br />
<br />
<br />
Regards,<br />
Navaneeth</div></div>Navaneethhttp://www.blogger.com/profile/06691943267983308816noreply@blogger.com0tag:blogger.com,1999:blog-3965303601001940879.post-88818093083370738232011-10-13T23:41:00.000-07:002011-10-13T23:47:24.344-07:00Sharing folder from Windows to RHEL5 machine<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: "Courier New",Courier,monospace;">First share a folder in windows and give permission to everyone to access to that folder.<b> </b></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">Go to linux machine and do the below steps<br />
<br />
Prerequsties should be , all the packages for running SAMBA service should be installed on the Linux machine. And the SAMABA service should be running on the machine.<br />
<br />
Please use below commands for checking about the SAMBA service.<br />
<br />
<b>[root@nav1 ~]# rpm -qa *samba*</b><br />
sblim-cmpi-samba-0.5.2-31.el5_2.1<br />
sblim-cmpi-samba-test-1-31.el5_2.1<br />
samba-3.0.33-3.7.el5<br />
samba-client-3.0.33-3.7.el5<br />
sblim-cmpi-samba-devel-1-31.el5_2.1<br />
system-config-samba-1.2.41-3.el5<br />
samba-common-3.0.33-3.7.el5<br />
samba-swat-3.0.33-3.7.el5<br />
You have new mail in /var/spool/mail/root<br />
<br />
<b>[root@nav1 ~]# service smb status</b><br />
smbd (pid 3635 3068 3029) is running...<br />
nmbd (pid 3032) is running...<br />
[root@nav1 ~]# </div><div style="font-family: "Courier New",Courier,monospace;"><b> </b></div><div style="font-family: "Courier New",Courier,monospace;"><b>[root@nav1 ~]# smbclient -L WindowsIP -U APAC/WinUsrId<br />
Password: </b><br />
Domain=[APAC] OS=[Windows 5.1] Server=[Windows 2000 LAN Manager]<br />
<br />
Sharename Type Comment<br />
--------- ---- -------<br />
IPC$ IPC Remote IPC<br />
D$ Disk Default share<br />
ADMIN$ Disk Remote Admin<br />
C$ Disk Default share<br />
linux_share Disk <br />
Domain=[APAC] OS=[Windows 5.1] Server=[Windows 2000 LAN Manager]<br />
<br />
Server Comment<br />
--------- -------<br />
<br />
Workgroup Master<br />
--------- -------<br />
<b>[root@nav1 /]# smbclient \\\\WindowsIP\\linux_share -U APAC/WinUsrId<br />
Password: </b><br />
Domain=[APAC] OS=[Windows 5.1] Server=[Windows 2000 LAN Manager]<br />
smb: \> ls<br />
. D 0 Thu Oct 13 21:29:35 2011<br />
.. D 0 Thu Oct 13 21:29:35 2011<br />
<br />
59616 blocks of size 2097152. 37993 blocks available<br />
<b>smb: \> ls</b><br />
. D 0 Thu Oct 13 21:41:10 2011<br />
.. D 0 Thu Oct 13 21:41:10 2011<br />
sfsdf A 0 Thu Oct 13 21:41:07 2011<br />
<br />
59616 blocks of size 2097152. 37993 blocks available<br />
<b>smb: \> </b><br />
<br />
<b>For Configuring through GUI use below option</b><br />
<br />
go to <b>places</b> menu -> <b>connect to server </b><br />
<br />
it will open a <b>connet to server configuration menu </b><br />
<br />
1. select service type as "<b>Windows Share</b>"<br />
2. Enter <b>Windows Server name</b> which u want to share in the <b>server name</b> option<br />
3. Enter <b>share folder</b> name in the <b>folder name</b> option<br />
4. Enter <b>windows username</b> in the <b>username</b> option<br />
5. Enter <b>windows Domain name</b> in <b>domain name</b> option<br />
6. Name to use for connection is optional and u can use whatever name u want<br />
<br />
at last give connect it will ask for <b>password for windows user id</b>, give the <b>passwd </b>thats it !! </div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">it will be connected to the windows share folder and u will be able to do whatever u want.</div><div style="font-family: "Courier New",Courier,monospace;"><br />
<b>Reference:</b><br />
<br />
http://mars.netanya.ac.il/~unesco/cdrom/LDP/Samba/HTML_FORMAT/SMB-HOWTO-7.html<br />
<br />
Regards,</div><div style="font-family: "Courier New",Courier,monospace;">Navaneeth</div></div>Navaneethhttp://www.blogger.com/profile/06691943267983308816noreply@blogger.com0tag:blogger.com,1999:blog-3965303601001940879.post-81656703435506885412011-10-13T23:20:00.001-07:002011-10-13T23:27:38.823-07:00Adding Harddisk on RHEL5<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: "Courier New",Courier,monospace;"><b>[root@localhost ~]# fdisk -l</b><br />
<br />
Disk /dev/sda: 10.7 GB, 10737418240 bytes<br />
255 heads, 63 sectors/track, 1305 cylinders<br />
Units = cylinders of 16065 * 512 = 8225280 bytes<br />
<br />
Device Boot Start End Blocks Id System<br />
/dev/sda1 * 1 6 48163+ 83 Linux<br />
/dev/sda2 7 515 4088542+ 83 Linux<br />
/dev/sda3 516 776 2096482+ 82 Linux swap / Solaris<br />
/dev/sda4 777 1305 4249192+ 5 Extended<br />
/dev/sda5 777 1305 4249161 83 Linux<br />
<br />
Disk /dev/sdb: 7516 MB, 7516192768 bytes<br />
255 heads, 63 sectors/track, 913 cylinders<br />
Units = cylinders of 16065 * 512 = 8225280 bytes<br />
<br />
Disk /dev/sdb doesn't contain a valid partition table<br />
<b>[root@localhost ~]# fdisk /dev/sdb</b><br />
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel<br />
Building a new DOS disklabel. Changes will remain in memory only,<br />
until you decide to write them. After that, of course, the previous<br />
content won't be recoverable.<br />
<br />
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)<br />
<br />
<b>Command (m for help): m</b><br />
Command action<br />
a toggle a bootable flag<br />
b edit bsd disklabel<br />
c toggle the dos compatibility flag<br />
d delete a partition<br />
l list known partition types<br />
m print this menu<br />
n add a new partition<br />
o create a new empty DOS partition table<br />
p print the partition table<br />
q quit without saving changes<br />
s create a new empty Sun disklabel<br />
t change a partition's system id<br />
u change display/entry units<br />
v verify the partition table<br />
w write table to disk and exit<br />
x extra functionality (experts only)<br />
<br />
<b>Command (m for help): n</b><br />
Command action<br />
e extended<br />
p primary partition (1-4)<br />
<b>p</b><br />
<b>Partition number (1-4): 1</b><br />
<b>First cylinder (1-913, default 1): </b><br />
Using default value 1<br />
Last cylinder or +size or +sizeM or +sizeK (1-913, default 913): <br />
Using default value 913<br />
<br />
<b>Command (m for help): p</b><br />
<br />
Disk /dev/sdb: 7516 MB, 7516192768 bytes<br />
255 heads, 63 sectors/track, 913 cylinders<br />
Units = cylinders of 16065 * 512 = 8225280 bytes<br />
<br />
Device Boot Start End Blocks Id System<br />
/dev/sdb1 1 913 7333641 83 Linux<br />
<br />
<b>Command (m for help): w</b><br />
The partition table has been altered!<br />
<br />
Calling ioctl() to re-read partition table.<br />
Syncing disks.<br />
<br />
<b>[root@localhost ~]# mount -t ext3 /dev/sdb1 /u01</b><br />
<br />
<b>[root@nav1 ~]# df -h</b><br />
Filesystem Size Used Avail Use% Mounted on<br />
/dev/sda2 3.8G 1.9G 1.7G 53% /<br />
/dev/sda5 4.0G 137M 3.6G 4% /home<br />
/dev/sda1 46M 11M 33M 24% /boot<br />
tmpfs 506M 0 506M 0% /dev/shm<br />
/dev/sdb1 6.9G 144M 6.4G 3% /u01<br />
<br />
<b>For mounting permanently add the entry in the fstab file in "/etc" location as below</b><br />
<br />
<b>[root@nav1 ~]# cat /etc/fstab</b> <br />
LABEL=/ / ext3 defaults 1 1<br />
LABEL=/home /home ext3 defaults 1 2<br />
LABEL=/boot /boot ext3 defaults 1 2<br />
tmpfs /dev/shm tmpfs defaults 0 0<br />
devpts /dev/pts devpts gid=5,mode=620 0 0<br />
sysfs /sys sysfs defaults 0 0<br />
proc /proc proc defaults 0 0<br />
LABEL=SWAP-sda3 swap swap defaults 0 0<br />
/dev/sdb1 /u01 ext3 defaults 0 0<br />
<br />
Regards,<br />
Navaneeth</div></div>Navaneethhttp://www.blogger.com/profile/06691943267983308816noreply@blogger.com0tag:blogger.com,1999:blog-3965303601001940879.post-2084435401410039812011-10-05T00:22:00.000-07:002011-10-05T00:44:34.915-07:0011gr1 Clean up failed cluster installation on linux RHEL5<div dir="ltr" style="text-align: left;" trbidi="on"><span style="font-family: "Courier New", Courier, monospace;"><strong>Cleaned up a failed oracle 11gr1 crs installation on RHEL5</strong></span><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;"></span><br />
<span style="font-family: "Courier New", Courier, monospace;"><strong>in node1</strong></span><br />
<br />
<span style="font-family: "Courier New", Courier, monospace;"><strong>[root@rac1 ~]# cd /u01/app/oracle/product/11.1.0/crs/</strong></span><br />
<span style="font-family: "Courier New", Courier, monospace;">[root@rac1 crs]# ls</span><br />
<span style="font-family: "Courier New", Courier, monospace;">bin css install JRE nls oui rdbms srvm</span><br />
<span style="font-family: "Courier New", Courier, monospace;">cdata cv install.platform ldap OPatch perl relnotes xdk</span><br />
<span style="font-family: "Courier New", Courier, monospace;">cfgtoollogs diagnostics inventory lib opmn plsql root.sh</span><br />
<span style="font-family: "Courier New", Courier, monospace;">clone evm jdk log oracore precomp slax</span><br />
<span style="font-family: "Courier New", Courier, monospace;">crs has jlib network oraInst.loc racg sqlplus</span><br />
<br />
<span style="font-family: "Courier New", Courier, monospace;">[root@rac1 crs]# cd install</span><br />
<span style="font-family: "Courier New", Courier, monospace;"><strong>[root@rac1 install]# ./rootdelete.sh</strong></span><br />
<br />
<span style="font-family: "Courier New", Courier, monospace;">Getting local node name</span><br />
<span style="font-family: "Courier New", Courier, monospace;">NODE = rac1</span><br />
<span style="font-family: "Courier New", Courier, monospace;">PRKO-2006 : Invalid node name: rac1</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Stopping resources. </span><br />
<span style="font-family: "Courier New", Courier, monospace;">This could take several minutes.</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Error while stopping resources. Possible cause: CRSD is down.</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Stopping Cluster Synchronization Services. </span><br />
<span style="font-family: "Courier New", Courier, monospace;">Unable to communicate with the Cluster Synchronization Services daemon.</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Oracle CRS stack is not running.</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Oracle CRS stack is down now.</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Removing script for Oracle Cluster Ready services</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Updating ocr file for downgrade</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Cleaning up SCR settings in '/etc/oracle/scls_scr'</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Cleaning up Network socket directories</span><br />
<br />
<span style="font-family: "Courier New", Courier, monospace;"><strong>[root@rac1 install]# ./rootdeinstall.sh </strong></span><br />
<span style="font-family: "Courier New", Courier, monospace;">Verifying existence of ocr.loc file</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Removing contents from OCR device</span><br />
<span style="font-family: "Courier New", Courier, monospace;">2560+0 records in</span><br />
<span style="font-family: "Courier New", Courier, monospace;">2560+0 records out</span><br />
<span style="font-family: "Courier New", Courier, monospace;">10485760 bytes (10 MB) copied, 0.145772 seconds, 71.9 MB/s</span><br />
<span style="font-family: "Courier New", Courier, monospace;">[root@rac1 install]#</span><br />
<br />
<span style="font-family: "Courier New", Courier, monospace;"><strong>in node2</strong></span><br />
<br />
<span style="font-family: "Courier New", Courier, monospace;">[oracle@rac2 bin]$ su -</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Password: </span><br />
<span style="font-family: "Courier New", Courier, monospace;"><strong>[root@rac2 ~]# cd /u01/app/oracle/product/11.1.0/crs/</strong></span><br />
<span style="font-family: "Courier New", Courier, monospace;"><strong>[root@rac2 crs]# cd install</strong></span><br />
<span style="font-family: "Courier New", Courier, monospace;"><strong>[root@rac2 install]# ./rootdelete.sh</strong></span><br />
<br />
<span style="font-family: "Courier New", Courier, monospace;">Getting local node name</span><br />
<span style="font-family: "Courier New", Courier, monospace;">NODE = rac2.localdomain</span><br />
<span style="font-family: "Courier New", Courier, monospace;">PRKO-2006 : Invalid node name: rac2.localdomain</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Oracle Cluster Registry initialization failed with invalid format: PROC-22: The OCR backend has an invalid format</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Oracle CRS stack is not running.</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Oracle CRS stack is down now.</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Removing script for Oracle Cluster Ready services</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Updating ocr file for downgrade</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Cleaning up SCR settings in '/etc/oracle/scls_scr'</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Cleaning up Network socket directories</span><br />
<br />
<span style="font-family: "Courier New", Courier, monospace;"><strong>[root@rac2 install]# ./rootdeinstall.sh</strong> </span><br />
<span style="font-family: "Courier New", Courier, monospace;">Verifying existence of ocr.loc file</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Removing contents from OCR device</span><br />
<span style="font-family: "Courier New", Courier, monospace;">2560+0 records in</span><br />
<span style="font-family: "Courier New", Courier, monospace;">2560+0 records out</span><br />
<span style="font-family: "Courier New", Courier, monospace;">10485760 bytes (10 MB) copied, 0.126807 seconds, 82.7 MB/s</span><br />
<span style="font-family: "Courier New", Courier, monospace;">[root@rac2 install]#</span><br />
<br />
<span style="font-family: "Courier New", Courier, monospace;"><strong>in node1</strong></span><br />
<br />
<span style="font-family: "Courier New", Courier, monospace;"><strong>[oracle@rac1 oui]$ cd bin</strong></span><br />
<span style="font-family: "Courier New", Courier, monospace;"><strong>[oracle@rac1 bin]$ ./runInstaller</strong></span><br />
<span style="font-family: "Courier New", Courier, monospace;">Starting Oracle Universal Installer...</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Checking swap space: must be greater than 500 MB. Actual 2047 MB Passed</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-10-05_11-51-47AM. Please wait ...[oracle@rac1 bin]$ Oracle Universal Installer, Version 11.1.0.6.0 Production</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Copyright (C) 1999, 2007, Oracle. All rights reserved.</span><br />
<span style="font-family: "Courier New", Courier, monospace;">/u01/app/oracle/product/11.1.0/crs/bin/crsctl.bin: error while loading shared libraries: /u01/app/oracle/product/11.1.0/crs/lib/libclntsh.so.11.1: file too short</span><br />
<span style="font-family: "Courier New", Courier, monospace;">-bash: /u01/app/oracle/product/11.1.0/crs/bin/crsctl: No such file or directory</span><br />
<span style="font-family: "Courier New", Courier, monospace;">-bash: /u01/app/oracle/product/11.1.0/crs/bin/crsctl: No such file or directory</span><br />
<br />
You can check Metalink note <strong>How to Clean Up After a Failed 10g or 11.1 Oracle Clusterware Installation [ID 239998.1] </strong>for more info.<br />
<br />
<span style="font-family: "Courier New", Courier, monospace;">Regards,</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Navaneeth</span></div>Navaneethhttp://www.blogger.com/profile/06691943267983308816noreply@blogger.com0tag:blogger.com,1999:blog-3965303601001940879.post-40307292667861857572011-10-02T00:52:00.000-07:002011-10-02T21:02:30.305-07:00Adding new hardisk in Solaris10<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: "Courier New",Courier,monospace;">Adding new hardisk in Solaris10</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><b># format</b></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><b>FORMAT MENU:</b></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">disk - select a disk</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">type - select (define) a disk type</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">partition - select (define) a partition table</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">current - describe the current disk</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">format - format and analyze the disk</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">fdisk - run the fdisk program</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">repair - repair a defective sector</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">label - write label to the disk</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">analyze - surface analysis</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">defect - defect list management</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">backup - search for backup labels</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">verify - read and display labels</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">save - save new disk/partition definitions</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">inquiry - show vendor, product and revision</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">volname - set 8-character volume name</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">! - execute , then return</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">quit</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><b>format>p</b></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><b>partition> p</b></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">Current partition table (unnamed):</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">Total disk cylinders available: 2044 + 2 (reserved cylinders)</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">Part Tag Flag Cylinders Size Blocks</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">0 unassigned wm 0 0 (0/0/0) 0</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">1 unassigned wm 0 0 (0/0/0) 0</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">2 backup wu 0 - 2043 3.99GB (2044/0/0) 8372224</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">3 unassigned wm 0 0 (0/0/0) 0</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">4 unassigned wm 0 0 (0/0/0) 0</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">5 unassigned wm 0 0 (0/0/0) 0</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">6 unassigned wm 0 0 (0/0/0) 0</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">7 unassigned wm 0 0 (0/0/0) 0</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">8 boot wu 0 - 0 2.00MB (1/0/0) 4096</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">9 unassigned wm 0 0 (0/0/0) 0</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><b>partition> 3</b></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">Part Tag Flag Cylinders Size Blocks</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">3 unassigned wm 0 0 (0/0/0) 0</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">Enter partition id tag[unassigned]:</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">Enter partition permission flags[wm]:</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">Enter new starting cyl[0]: 1</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">Enter partition size[0b, 0c, 1e, 0.00mb, 0.00gb]: 2043c</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><b>partition> p</b></div><div style="font-family: "Courier New",Courier,monospace;"> </div><div style="font-family: "Courier New",Courier,monospace;">Current partition table (unnamed):</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">Total disk cylinders available: 2044 + 2 (reserved cylinders)</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">Part Tag Flag Cylinders Size Blocks</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">0 unassigned wm 0 0 (0/0/0) 0</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">1 unassigned wm 0 0 (0/0/0) 0</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">2 backup wu 0 - 2043 3.99GB (2044/0/0) 8372224</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">3 unassigned wm 1 - 2043 3.99GB (2043/0/0) 8368128</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">4 unassigned wm 0 0 (0/0/0) 0</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">5 unassigned wm 0 0 (0/0/0) 0</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">6 unassigned wm 0 0 (0/0/0) 0</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">7 unassigned wm 0 0 (0/0/0) 0</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">8 boot wu 0 - 0 2.00MB (1/0/0) 4096</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">9 unassigned wm 0 0 (0/0/0) 0</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><b>partition> q</b></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">FORMAT MENU:</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">disk - select a disk</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">type - select (define) a disk type</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">partition - select (define) a partition table</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">current - describe the current disk</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">format - format and analyze the disk</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">fdisk - run the fdisk program</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">repair - repair a defective sector</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">label - write label to the disk</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">analyze - surface analysis</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">defect - defect list management</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">backup - search for backup labels</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">verify - read and display labels</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">save - save new disk/partition definitions</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">inquiry - show vendor, product and revision</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">volname - set 8-character volume name</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">! - execute , then return</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">quit</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><b>format> l</b></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">Ready to label disk, continue? y</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><b>format> q</b></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><b># newfs /dev/rdsk/c1t1d0s3</b></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">newfs: construct a new file system /dev/rdsk/c1t1d0s3: (y/n)? y</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">/dev/rdsk/c1t1d0s3: 8368128 sectors in 2043 cylinders of 128 tracks, 32 sectors</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">4086.0MB in 79 cyl groups (26 c/g, 52.00MB/g, 6400 i/g)</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">super-block backups (for fsck -F ufs -o b=#) at:</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">32, 106560, 213088, 319616, 426144, 532672, 639200, 745728, 852256, 958784,</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">7350464, 7456992, 7563520, 7670048, 7776576, 7883104, 7989632, 8096160,</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">8202688, 8309216</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><b># mkdir /u01</b></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><b># mount -f ufs /dev/dsk/c1t1d0s3 /u01</b></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><b># df -h</b></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">Filesystem size used avail capacity Mounted on</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">/dev/dsk/c1t0d0s0 9.3G 4.4G 4.8G 48% /</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">/devices 0K 0K 0K 0% /devices</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">ctfs 0K 0K 0K 0% /system/contract</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">proc 0K 0K 0K 0% /proc</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">mnttab 0K 0K 0K 0% /etc/mnttab</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">swap 938M 924K 937M 1% /etc/svc/volatile</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">objfs 0K 0K 0K 0% /system/object</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">sharefs 0K 0K 0K 0% /etc/dfs/sharetab</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">/usr/lib/libc/libc_hwcap1.so.1</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">9.3G 4.4G 4.8G 48% /lib/libc.so.1</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">fd 0K 0K 0K 0% /dev/fd</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">swap 937M 112K 937M 1% /tmp</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">swap 937M 36K 937M 1% /var/run</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">/hgfs 16G 4.0M 16G 1% /hgfs</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">/tmp/VMwareDnD 0K 0K 0K 0% /var/run/vmblock</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">/dev/dsk/c1t1d0s3 3.9G 4.0M 3.9G 1% /u01</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">#</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><b># bash</b></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><b>bash-3.00# mount -p</b></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">/dev/dsk/c1t0d0s0 - / ufs - no rw,intr,largefiles,logging,xattr,onerror=panic</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">/devices - /devices devfs - no</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">ctfs - /system/contract ctfs - no</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">proc - /proc proc - no</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">mnttab - /etc/mnttab mntfs - no</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">swap - /etc/svc/volatile tmpfs - no xattr</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">objfs - /system/object objfs - no</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">sharefs - /etc/dfs/sharetab sharefs - no</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">/usr/lib/libc/libc_hwcap1.so.1 - /lib/libc.so.1 lofs - no</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">fd - /dev/fd fd - no rw</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">swap - /tmp tmpfs - no xattr</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">swap - /var/run tmpfs - no xattr</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">/hgfs - /hgfs vmhgfs - no</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">/tmp/VMwareDnD - /var/run/vmblock vmblock - no</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">/dev/dsk/c1t1d0s3 - /u01 ufs - no rw,intr,largefiles,logging,xattr,onerror=panic</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><b>bash-3.00# man fstype</b></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">Regards,</div><div style="font-family: "Courier New",Courier,monospace;">Navaneeth</div></div>Navaneethhttp://www.blogger.com/profile/06691943267983308816noreply@blogger.com0tag:blogger.com,1999:blog-3965303601001940879.post-69993975826918709572011-09-29T07:25:00.000-07:002011-10-02T21:40:38.726-07:00Information on Statistics collection on 11gR2<div dir="ltr" style="text-align: left;" trbidi="on"><span style="font-family: "Courier New",Courier,monospace;">In 11gR2 statistics collection is automatic by default.The statistics will be collected by using an auto job, if the statistics found to be stale for an object or if any DDL command used against the object. </span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">Please see the below for the job details.</span><br />
<br />
<b><span style="font-family: "Courier New",Courier,monospace;">select client_name,status,consumer_group,attributes from DBA_AUTOTASK_CLIENT</span></b><br />
<span style="font-family: "Courier New",Courier,monospace;"> </span><br />
<span style="font-family: "Courier New",Courier,monospace;">CLIENT_NAME STATUS CONSUMER_GROUP </span><br />
<span style="font-family: "Courier New",Courier,monospace;">------------ --------- -------------- </span><br />
<span style="font-family: "Courier New",Courier,monospace;">auto optimzer stat collection ENABLED ORA$AUTOTASK_STATS_GROUP</span><br />
<br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">The stale percent is determined based on the number of DML operations occured on the table ie., the percentage of number of rows updated or inserted or deleted on the table. By default the threshold limit for the stale percentage is 10%.</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">You can check this values by using the below query.</span><br />
<br />
<b><span style="font-family: "Courier New",Courier,monospace;">select dbms_stats.GET_PREFS ('STALE_PERCENT','OWNER','TABLENAME') from dual.</span></b><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">To check the objects considered for auto stats collection we can check the parameter AUTOSTATS_TARGET.The value of this parameter controls the objects considered for stats collection.</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">The values:</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> 'ALL' - Statistics collected for all objects in system</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> 'ORACLE' - Statistics collected for all Oracle owned objects</span><br />
<span style="font-family: "Courier New",Courier,monospace;"> 'AUTO' - Oracle decides on which objects to collect statistics</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">We can check this by using the below query</span><br />
<br />
<b><span style="font-family: "Courier New",Courier,monospace;">select dbms_stats.GET_PREFS ('AUTOSTATS_TARGET') from dual;</span></b><br />
<span style="font-family: "Courier New",Courier,monospace;">DBMS_STATS.GET_PREFS('AUTOSTATS_TARGET') </span><br />
<span style="font-family: "Courier New",Courier,monospace;">-------------------------------------------</span><br />
<span style="font-family: "Courier New",Courier,monospace;">AUTO </span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">To check the percentage of rows modified or inserted or deleted on the tables you can use the below query </span><br />
<br />
<b><span style="font-family: "Courier New",Courier,monospace;">select * from DBA_TAB_MODIFICATIONS where table_owner='SCOTT'</span></b><br />
<span style="font-family: "Courier New",Courier,monospace;">If you need to check the information about stats collection on your tables, you can use the below query</span><br />
<br />
<b><span style="font-family: "Courier New",Courier,monospace;">select * from DBA_TAB_STATS_HISTORY where owner='SCOTT'</span></b><br />
<b><span style="font-family: "Courier New",Courier,monospace;">select client_name, JOB_SCHEDULER_STATUS from DBA_AUTOTASK_CLIENT_JOB</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">where client_name='%stats%';</span></b><br />
<span style="font-family: "Courier New",Courier,monospace;">To enable or disable the Auto stats job please use the below procs.</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">ENABLE:</span><br />
<br />
<b><span style="font-family: "Courier New",Courier,monospace;">BEGIN</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> DBMS_AUTO_TASK_ADMIN.ENABLE(</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> client_name => 'auto optimizer stats collection',</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> operation => NULL,</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> window_name => NULL);</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">END;</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">/</span></b><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">DISABLE:</span><br />
<br />
<b><span style="font-family: "Courier New",Courier,monospace;">BEGIN</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> DBMS_AUTO_TASK_ADMIN.DISABLE(</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> client_name => 'auto optimizer stats collection', </span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> operation => NULL, </span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"> window_name => NULL);</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">END;</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">/</span></b><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">Other useful queries</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">SELECT client_name, window_name, jobs_created, jobs_started, jobs_completed FROM dba_autotask_client_history WHERE client_name like '%stats%';</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">SELECT * FROM dba_autotask_client_history WHERE client_name like '%stats%';</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">Select client_name, JOB_SCHEDULER_STATUS from DBA_AUTOTASK_CLIENT_JOB where client_name='auto optimizer stats collection';</span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">SELECT client_name, window_name, jobs_created, jobs_started, jobs_completed FROM dba_autotask_client_history WHERE client_name like '%stats%';</span><br />
<br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">Regards,</span><br />
<span style="font-family: "Courier New",Courier,monospace;">Navaneeth</span></div>Navaneethhttp://www.blogger.com/profile/06691943267983308816noreply@blogger.com4tag:blogger.com,1999:blog-3965303601001940879.post-65002798504443592742011-09-26T01:41:00.000-07:002011-09-26T01:41:34.994-07:00Starting windows services starts database automaticaly and maintain services on Windows<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: "Courier New",Courier,monospace;">Sometimes starting the Windows Oracle services starts the database automatically. You can check this in Windows registry as mentioned below.</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"> Open the registry with <b>regedit</b>. <b> </b></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"> <b>HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\oracle_home_name</b>.</div><div style="font-family: "Courier New",Courier,monospace;"> There will be a key called:</div><div style="font-family: "Courier New",Courier,monospace;"> <b>ORA_SID_AUTOSTART</b>. SID is your database SID.</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"> This key should be set to <b>TRUE</b>. If you want to start the database automatically once the service is started. </div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"> If you want to manually start the database set <b>ORA_SID_AUTOSTART</b> to <b>FALSE</b>. The service will start but not the database. </div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">There is also an <b>ORA_SID_SHUTDOWN</b> which you want to be <b>TRUE </b>so that if the server is shut down the service will shutdown the database automatically.</div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><b>For Deleting a service</b></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;">you can use </div><div style="font-family: "Courier New",Courier,monospace;"> </div><div style="font-family: "Courier New",Courier,monospace;">> oradim or sc delete <servicename></servicename></div><div style="font-family: "Courier New",Courier,monospace;"> </div><div style="font-family: "Courier New",Courier,monospace;"> </div><div style="font-family: "Courier New",Courier,monospace;">Regards,</div><div style="font-family: "Courier New",Courier,monospace;">Navaneeth</div><div style="font-family: "Courier New",Courier,monospace;"></div></div>Navaneethhttp://www.blogger.com/profile/06691943267983308816noreply@blogger.com0tag:blogger.com,1999:blog-3965303601001940879.post-1473991606201735592011-09-25T22:05:00.000-07:002011-09-25T22:05:29.787-07:00Incremental backup size of 4th week is Huge<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;">This is tested in production environment. There was an issue in the incremental backup of a 10.2.0.3 database server. The every months 4th week cumulative incremental backup size is huge(comes around 400 Gigs).</span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><br />
</span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;">Database size - 335 GB.</span> </div><span style="font-size: small;"><br style="font-family: "Courier New",Courier,monospace;" /></span><br />
<div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;">Backup scenario:</span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><br />
</span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;">> 1st sunday of every month - Level 0 Incremental backup</span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"> script => Backup incremental level = 0 database tag='Complete_Backup';</span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><br />
</span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;">> Every Sunday of the month - Level 1 Cumulative Incremental backup</span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"> script => Backup incremental level = 1 cumulative database tag='Cumulative_Backup';</span></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;">Once the backup is completed the backup's will be moved from the local drive to tape drive(ie: once in a week) </span></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;">The issue was because of the Incremental backups are moved from its original location to tape drive. It was proved by the below query.</span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><br />
</span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="color: black;">select recid, file#, to_char(creation_change#) create#, incremental_level lvl, to_char(incremental_change#) inc#, <br />
to_char(checkpoint_change#) ckp#, datafile_blocks BLKS, block_size blksz, blocks_read READ, <br />
round((blocks_read/datafile_blocks) * 100,2) READpc,<br />
blocks WRTN, round((blocks/datafile_blocks)*100,2) WRTNpc, <br />
completion_time, used_change_tracking bct <br />
from v$backup_datafile where <br />
completion_time > to_date('17-Jun-11 12:32:00', 'dd-mon-rr hh24:mi:ss ') <br />
and file# > 0;<br />
<br />
</span></span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="color: black;"> If we see the query output </span><span style="color: black;">we can find that for several Datafiles the 'incremental_change#' is 0 or the same as the Datafile Creation SCN. This means that the RMAN Incremental Backup cannot find a corresponding Level 0 Backup and takes a full Backup of these Datafiles. Therefore the Size of the Backup is growing that much.</span></span></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="color: black;">So to avoid this we have to ensure that </span><span style="color: black;">Level 0 Backup from Week 1 for all Datafiles is available for all 4 Weeks (until the next Level 0 Backup is taken).</span><span style="color: black;">Even do not move this Backup outside RMAN - RMAN must be able to access the Level 0 Backup at its cataloged Location.</span></span></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="color: black;">We tested by not moving the Incremental Level 0 backup until the 4th weeks backup was taken from its original location. After this the 4th week backup was fine and was creating the backup size of normal.</span></span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><br />
</span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;">Hope this helps !</span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><br />
</span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;">Regards,</span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;">Navaneeth</span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><br />
</span></div></div>Navaneethhttp://www.blogger.com/profile/06691943267983308816noreply@blogger.com0tag:blogger.com,1999:blog-3965303601001940879.post-91135243844009984372011-09-21T04:11:00.000-07:002011-09-21T04:41:52.492-07:00Rename/Move a datafile in the primary and propagate the changes in the standby database.<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: "Courier New",Courier,monospace;">Rename a datafile in the primary database and manually propagate the changes to the standby database.<br />
<br />
<b> in PRIMARY</b><br />
<br />
1. Set STANDBY_FILE_MANAGEMENT=MANUAL on both Primary and Standby Database. <br />
<br />
SQL> show parameter standby_file_manag<br />
<br />
NAME TYPE VALUE<br />
------------------------------------ ----------- <br />
standby_file_management string AUTO</div><div style="font-family: "Courier New",Courier,monospace;"><br />
SQL> select name,value from v$parameter where name like 'db_unique_name';<br />
<br />
NAME VALUE<br />
----------------- --------------- <br />
db_unique_name orcl11g<br />
<br />
SQL><br />
SQL> alter system set standby_file_management=MANUAL;<br />
<br />
System altered.<br />
<br />
SQL> show parameter standby_file<br />
<br />
NAME TYPE VALUE<br />
------------------------------------ ----------- <br />
standby_file_management string MANUAL</div><div style="font-family: "Courier New",Courier,monospace;"> </div><div style="font-family: "Courier New",Courier,monospace;"><b>in standby</b></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"></div><div style="font-family: "Courier New",Courier,monospace;">SQL> alter system set standby_file_management=MANUAL;<br />
<br />
System altered.<br />
<br />
SQL> select name,value from v$parameter where name like 'db_unique_name';<br />
<br />
NAME VALUE<br />
------------------ ------------<br />
db_unique_name 11gstdby<br />
<br />
SQL> show parameter standby_file<br />
<br />
NAME TYPE VALUE<br />
------------------------------------ ----------- <br />
standby_file_management string MANUAL</div><div style="font-family: "Courier New",Courier,monospace;"> </div><div style="font-family: "Courier New",Courier,monospace;"><b>in PRIMARY</b></div><div style="font-family: "Courier New",Courier,monospace;"><br />
2. Take the Tablespace offline on the Primary Database: <br />
<br />
SQL> select * from v$tablespace;<br />
<br />
TS# NAME INC BIG FLA ENC<br />
---------- ------------------------------ --- --- --- ---<br />
0 SYSTEM YES NO YES<br />
1 SYSAUX YES NO YES<br />
2 UNDOTBS1 YES NO YES<br />
4 USERS YES NO YES<br />
3 TEMP NO NO YES<br />
6 FDB YES NO YES<br />
<br />
6 rows selected.<br />
<br />
<br />
SQL> alter tablespace users offline;<br />
<br />
Tablespace altered.<br />
<br />
3. Rename Datafile on Primary Site: <br />
<br />
copy the file using OS command to the new location<br />
<br />
<br />
4. Rename the Datafile in the Primary Database. <br />
<br />
SQL> alter tablespace users rename datafile 'D:\app\nvcb\oradata\orcl11g\USERS01.DBF' TO 'D:\app\nvcb\oradata\orcl11g_1\USERS01.DBF';<br />
<br />
Tablespace altered.<br />
<br />
5. Bring the Tablespace back online: <br />
<br />
SQL> ALTER TABLESPACE USERS ONLINE;<br />
<br />
Tablespace altered.</div><div style="font-family: "Courier New",Courier,monospace;"><b>in standby </b><br />
<br />
1. Stop Redo Apply on Standby Database.<br />
<br />
SQL> recover managed standby database cancel;<br />
Media recovery complete.<br />
<br />
2. Shutdown the Standby Database.<br />
<br />
SQL> shutdown immediate<br />
ORA-01109: database not open<br />
<br />
Database dismounted.<br />
ORACLE instance shut down.<br />
<br />
3. Move the Datafile to the new location at the Standby site.<br />
<br />
Copy the file using OS command to the new location.<br />
<br />
4. Start and mount the Standby Database.<br />
<br />
SQL> startup mount<br />
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance<br />
ORACLE instance started.<br />
<br />
Total System Global Area 535662592 bytes<br />
Fixed Size 1375792 bytes<br />
Variable Size 209715664 bytes<br />
Database Buffers 318767104 bytes<br />
Redo Buffers 5804032 bytes<br />
Database mounted.<br />
<br />
5.Rename the Datafile in the Standby Database control file. <br />
<br />
SQL> alter database rename file 'D:\app\nvcb\oradata\11gstdby\USERS01.DBF' to 'D:\app\nvcb\oradata\11gstdby_1\USERS01.DBF';<br />
<br />
Database altered.<br />
<br />
6. On the Standby Database, restart Redo Apply: <br />
<br />
SQL> recover managed standby database disconnect from session;<br />
Media recovery complete.<br />
<br />
<br />
7. Set STANDBY_FILE_MANAGEMENT=AUTO on both Primary and Standby Database. <br />
<br />
<br />
SQL> alter system set standby_file_management=auto;<br />
<br />
System altered.<br />
<br />
SQL> show parameter standby_file<br />
<br />
NAME TYPE VALUE<br />
------------------------------------ ----------- <br />
standby_file_management string AUTO</div><div style="font-family: "Courier New",Courier,monospace;"><br />
SQL> select file#,name from v$datafile where name like '%USERS%';<br />
<br />
FILE# NAME</div><div style="font-family: "Courier New",Courier,monospace;">---------- -----------------------------------------------<br />
4 D:\APP\nvcb\ORADATA\11GSTDBY_1\USERS01.DBF<br />
<br />
<b>in Primary</b><br />
<br />
SQL> alter system set standby_file_management=auto;<br />
<br />
System altered.<br />
<br />
SQL> show parameter standby_file<br />
<br />
NAME TYPE VALUE<br />
------------------------------------ ----------- <br />
standby_file_management string AUTO<b> </b><br />
<b><br />
</b><br />
SQL> select file#,name from v$datafile where name like '%USERS%';<br />
<br />
FILE# NAME<br />
---------- --------------------------------------<br />
<br />
4 D:\APP\NAV6COB\ORADATA\ORCL11G_1\USERS01.DBF<br />
<br />
</div><div style="font-family: "Courier New",Courier,monospace;">Regards,</div><div style="font-family: "Courier New",Courier,monospace;">Navaneeth</div></div>Navaneethhttp://www.blogger.com/profile/06691943267983308816noreply@blogger.com0