Travellers Trail

Thursday, 10 May 2012

snapshot and fast start db

Very simple to change the standby to snapshop (allows you wirt)

Wednesday, 9 May 2012

Oracle Active Data Guard

Oracle Active Data Guard SE1: N SE: N EE: Y - Extra cost option

Tuesday, 8 May 2012

Data Guard using RMAN


run {
  allocate channel prmy1 type disk;
  allocate channel prmy2 type disk;
  allocate channel prmy3 type disk;
  allocate channel prmy4 type disk;
  allocate auxiliary channel stby type disk;
  duplicate target database for standby from active database
    spfile
    parameter_value_convert 'nidb1_uk','nidb1_fr'
    set db_unique_name='nidb1_fr'
    set db_create_file_dest='+SBDAT'
    set db_recovery_file_dest='+SBFRA'
    set db_recovery_file_dest_size='5G'
    set control_files='+SBDAT'
    set log_archive_max_processes='5'
    set fal_client='nidb1_fr'
    set fal_server='nidb1_uk'
    set standby_file_management='AUTO'
    set log_archive_config='dg_config=(nidb1_uk,nidb1_fr)'
    set log_archive_dest_2='service=nidb1_uk ASYNC
    valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=nidb1_uk'
  ;
}

Thursday, 29 March 2012

My Notes

My notes.

Quran Sura Yasin

Quran Sura Yasin, sura 36

Search or sort Apache logs

Search or sort Apache logs

Script to count unique ips in apache access log


cat my-web-app-access_log.4 | grep "04/Mar/2012:10:" >> day_04.txt

awk '{!a[$1]++}END{for(i in a) if ( a[i] >10 ) print a[i],i }' myfile.txt  | sort -nr | more

awk '{!a[$1]++}END{for(i in a) if ( a[i] >10 ) print a[i],i }' myfile.txt

Wednesday, 29 February 2012

Flashback

At last we have the lience to use Flashback:

Good site.
http://www.oracle-developer.net/display.php?id=313


SQL> FLASHBACK TABLE t TO BEFORE DROP;