Unisoft Technologies Nagpur

First Add 4 Hard Disk in VMware. Start Machine. Then Go to Disk Management. Right Click on Unallocated Disk list. Then Click on initialize disk. Right Click on unallocated disk 1. Then Click on New Partition Then Next. Select option External Partition Button then  Next --> Next -->   Finish (Note:Repeat Step 5 for all Unallocated HDD). Unallocated HDD is a free space and color is Green. Right click on 1st HDD   Then  Click on new logical drive  Then Next -> Next --> Next  Click on do not Assign drive letter or Drive path option button  Then Next Click on do not Format this partition option button  Then Next ---> Finish. (Note: Repeat Step 5 for all Healthy HDD) Then free space HDD is healthy and color is Blue. Close Computer Management Window And Go to Command prompt. C:\>Documents And Settings\Administrator> Asmtoolg Asmtoolg Operation Window open. Click on Add or change label option. And  then Next Th...

First Add 4 Hard Disk in VMware. Start Machine. Then Go to Disk Management. Right Click on Unallocated Disk list. Then Click on initialize disk. Right Click on unallocated disk 1. Then Click on New Partition Then Next. Select option External Partition Button then  Next --> Next -->   Finish (Note:Repeat Step 5 for all Unallocated HDD). Unallocated HDD is a free space and color is Green. Right click on 1st HDD   Then  Click on new logical drive  Then Next -> Next --> Next  Click on do not Assign drive letter or Drive path option button  Then Next Click on do not Format this partition option button  Then Next ---> Finish. (Note: Repeat Step 5 for all Healthy HDD) Then free space HDD is healthy and color is Blue. Close Computer Management Window And Go to Command prompt. C:\>Documents And Settings\Administrator> Asmtoolg Asmtoolg Operation Window open. Click on Add or change label option. And  then Next The...

Set Up and Use a Flashback Data Archive Retaining a historical record of all changes to rows in critical tables is error prone and requires custom applications or database triggers to maintain repositories for the historical changes. Every time you create a new application or update a table in an application that requires historical tracking, you must make changes to your tracking application as well. You can use Flashback Data Archive to save historical changes automatically to all key tables for as long as possible. Understanding Flashback Data Archive In Flashback Data Archive you create one or more repository areas (dedicated tablespace) (one of which can be the default), assign a default retention period for objects in the repository, and then mark the appropriate tables for tracking. A Flashback Data Archive acts much like an undo tablespace. However, a Flashback Data Archive records only UPDATE and DELETE statements but not INSERT statements. In addition, undo dat...

Figures shown in these notes are from Oracle® Database Concepts 11 g Release 2 Objectives These notes introduce the Oracle server architecture.   The architecture includes physical components, memory components, processes, and logical structures. Primary Architecture Components The figure shown above details the Oracle architecture. Oracle server :   An Oracle server includes an Oracle Instance and an Oracle database .   ·         An Oracle database includes several different types of files:   datafiles, control files, redo log files and archive redo log files.   The Oracle server also accesses parameter files and password files.   ·         This set of files has several purposes.   o    One is to enable system users to process SQL statements.   o    Another is to improve system performance.   o    Still a...