N/APosted on - 08/07/2011
I have oracle 9i DB installed, is it possible to make a batch file scripts utility which first creates a user then imports dump file and then gives grants. With the help of this utility it is possible to switch within no time from primary db server to secondary server within no time. This utility can be helpful in such DB server environment which has got a backup or secondary server .
Awaiting your response,
Single click oracle DB backup utility
It actually depends if you are running the personal, the entrprise or the personal version. The Enterprise and the personal version has alike features. The difference of the standard version is that it lacks some of the features including: automated parallel query, export tranportable table spaces, function-based indexes, materialized views, parallel DML, sample scan, advanced queuing, plan stability, advanced replication, network access control, multiplexing, automated standby database, fast-start fault recovery, parallele back-up memory, and some other detailed features. But yes, oracle allows workspace management, wherein in one database, multiple transactionally consistent environments can exist. Oracle Data Guard comes in every oracle release and it is like a recovery system that makes the secondary server in read-only to still accept changes and modification from the primary server. Cloning your primary server or making a secondary server means preparing first the primary. You need to enforece the Alter Database Force Logging to remove the risk of losing files. You can clone the primary database using RMAN. It will duplicate the database and make the duplicate as a template but it will also change as the main server changes. You need to perform a redo log switch in the main server to see if it is really in sync with the secondary server.