Removing Virus from affected USB

Hi All,

Welcome back,

Many times our usb disks or hardisks will be affected with virus and all the folders will become shortcuts. When you double click on the shortcuts virus gets affected.
But actually, all folders will be hidden as operating system files and we cannot see or edit it, unless we disable the option (hide protected operating system files) in folder options. 

We can remove this virus, to do this please follow below;

First of all, Disable autorun in your desktop -->

 - Create restore point before doing this, so that any problem we can restore the system.
 - Open notepad and key in below string (just copy and paste).

REGEDIT4
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\IniFileMapping\Autorun.inf]
@="@SYS:DoesNotExist"

 - Save it as <filename>.reg
 - Double click the file for this reg entry to be created.

Then, delete autorun.inf file from USB disk or hard disk.
 - Disable HIDE protected operating system files from folder options
 - Then delete only the shortcuts (Note - only shortcuts)
 - Then go to command prompt and execute the below command at command mode.
 attrib -s -h -a /s /d <drive letter of USB>:\*.*

 - Then all the hidden folders will be unhide it. 

Hope this was helpful. Please comment if it is not working.

yours Lovingly,

Kishore Soma

Brrestore from point of termination

Hello,

Welcome back, here is the below with a very important knowledge sharing

some times for huge databases, we face problems with tape or disk and if it get fails at 90 or 95%, then we will have to restore the entire database again. 

This is no more needed, there is an option to restore from the point of termination in brtools. Use below command to do this; 

brrestore -b <backuplogfile> -d <utl/disk/tape> -c force -r <utl file path> -m full -l E -f <restoration log file>

Example of this is --> 

brrestore -b bejczqjj.anf -d util_file -c force -r /oracle/TST/112_64/dbs/initTST.utl -m full -l E -f rejedtge.rsb

This will check for all files restored correctly and which are not restored as per the log file provided (rejedtge.rsb). compares it with backup (logfile provided --> bejczqjj.anf). Restores only files which are not restored correctly. 

This saves time as well as we dont have to restore entire backup if restore fails due to any reason. 

This has been tested in real time scenario and it works well

Be happy and Enjoy.......

Request you to for comments on this.........

Oracle commands/SQL script reference;

Please check the link for all Oracle SQL command references;

Click here

Oracle BASIC concepts for Beginners

Hi,
Hope all are doing fine.

Please find below document link for the same. This document covers almost all concepts of Oracle helpful for beginners and also to brush up the oracle basic concepts

CLICK HERE

If you need any more documents, please do write back to us or comment here.

Thanks and Regards.........

SAP BASIS Book for beginners

Please find below link for SAP BASIS R3 handbook, good for beginners

Click here

Technical Stuff

Hello Friends,

I have started new blog for any technical help on anything and everything. So if you need any help regarding any domain/technical thing (personal/official) please do post here, we will get back to you with necessary details and information that may help.

Regards,
Kishore Soma