I have been Migrated a Live Database almost 200GB with Zero Down Time . My step was. 1- Take RMAN backup from source Database. My Script was RMAN> run {2> allocate channel d1 type disk FORMAT “E:\rman-backup\Weekly_%T_L0_%d-%s_%p.db” MAXPIECESIZE 500M;3> allocate … Continue reading
To export selected users daily, you can do it very easily backup.bat expdp system/password parfile=dailybackup.ora dailybackup.ora DIRECTORY=dailybackup reuse_dumpfiles=y LOGFILE=Daily.log DUMPFILE=Daily%u.dmp Schemas = scott,hr,system FILESIZE=5gb
In have two fodders i.e. source and target. In this demo it is explained that all files from source folder should be copied or update the target folder. As show in the picture I have created some files in source … Continue reading
To change the files extension in once using script its very easy. I need to change the multiple files extension , it was difficult to change one by one. So I created a script to change at once and reuse … Continue reading
Make a batch file suppose load_data.bat –content of the file is –you keep the batch and controlfile in the same folder where the datafiles are there. –This script will upload all data files within the same folder whatever fortmat they … Continue reading
Objective How to take backups on shared disk of another machine on windows machine.. Steps are following Follow the below steps to take backups on remote disk : + Suppose I have a target database on Machine A and the remote … Continue reading
To find sessions generating lots of redo, you can use either of the following methods. Both methods examine the amount of undo generated. When a transaction generates undo, it will automatically generate redo as well. The methods are: 1) Query … Continue reading
