Oracle Recovery Manager - RMan

Connect: rman target system/manager@svc-name

Configuration:

• Device:Configure Device Type To Disk;
  

• Retention:Configure Policy To Redundancy 3;
  

• Parallelism:Configure Device Type DISK Parallelism 2;
  

• Controlfile:Configure ControlFile Autobackup on;

• Controlfile Format:Configure ControlFile Autobaclup Format For Device Type Disk To 'D:\backup\ora_cf_%F';
  

• Datafile:Configure Channel [CH#] Device Type Disk Format 'D:\oracle\backup\ora_df_%s_%p_#c_%U';
  

• Optimization:Configure Backup Optimization;

Backup:

• Backup all: Backup Database Plus Archivelog;

• Incremental Backup: Backup Incremental Level 0 Database;

• Testing Backup: Backup Validate Database Archivelog All;

• Backup Object: Backup [Datafile #, Tablespace name]

• Backup Since: Backup Database Not Backedup Since Time 'Sysdate-1';

Windows System Information Command

Windows NT winmsd
Windows 2000 msinfo32
Windows XP systeminfo

Export Oracle Data Structres

exp userid=system file=full_ddl.dmp rows=n owner=user1,user2

userid: connecting user
file: destination file
rows=n: don't export data
owner: schema's that should be backed up

Use Speech Engine in VBA

1- Define voice object
Dim vox As New SpVoice

2- Call speak
vox.Speak("Hello")

Keyboard Language of Text Fields in VBA

You can set default input keyboard language layout for every field without changing manually by alt-shift, you can set your desired setting like below
txtPers.KeyboardLanguage = 41 + 2 'Farsi Lang Id + 2
txtEng.KeyboardLanguage = 9 + 2 'English Lang ID + 2
txtEng.KeyboardLanguage = 0 'Default system Lang

Activate Spell Checking on Office

On every where of your code that you like you can put it
RunCommand acCmdSpelling

also you can put DoCmd.SetWarnings False before above call to don't display the message spell checking was successful and activate it again with DoCmd.SetWarnings True

Adding New Voucher Printer

To add new voucher printer to VoMSXpress of Siemens, first add voucher in configuration (vomscore->V03->VoucherProviderList->VoucherProvider1->Values->VoucherPrinterList) and then create a directory in voms at /app/voucher/RIC_Iran/VOP/prod_out/ with the same name of the voucher printer in GUI and set owner and mod of the directory to appropriate setting(voms:sx,775).

Finally stop start vomsservice and vomsordermgr in task manager.