dbstrike.blogspot.com
DB Strike: June 2015
http://dbstrike.blogspot.com/2015_06_01_archive.html
When your database just start messing around. Thursday, June 4, 2015. RMAN: Restore missing archivelogs. SQL select sequence#, applied, to char(first time,’dd-mm-yyyy hh24:mi:ss’) first time. Order by sequence#;. SQL select process,sequence#,status from v$managed standby;. PROCESS STATUS SEQUENCE# FIRST TIME. MRP0 WAIT FOR GAP 7279. WAIT FOR GAP means thare are missing archivelogs. You need to recover them. We first identify whose are missing:. Oracle@ora-test ]$ sqlplus / as sysdba. You can now check.
dbstrike.blogspot.com
DB Strike: May 2015
http://dbstrike.blogspot.com/2015_05_01_archive.html
When your database just start messing around. Tuesday, May 26, 2015. Postgres SQL: Day to day tips. Transform an int as readable timestamp:. Select to timestamp(FIELD TO CONVERT) from table;. Subscribe to: Posts (Atom). Postgres SQL: Day to day tips. View my complete profile. Messages les plus consultés. TNS-12535: TNS:operation timed out. Specific to Oracle 11G If you see the errors in the alert logfile : * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * . Oracle 10g dbconsole setup.
dbstrike.blogspot.com
DB Strike: October 2013
http://dbstrike.blogspot.com/2013_10_01_archive.html
When your database just start messing around. Wednesday, October 30, 2013. Postgres SQL: Administration usefull querries queries. Sum(CASE WHEN waiting THEN 1 ELSE 0 END) AS waiting,. Sum(CASE WHEN current query=' IDLE ' THEN 1 ELSE 0 END) AS idle,. Sum(CASE WHEN current query=' IDLE in transaction' THEN 1 ELSE 0 END) AS idletransaction,. Sum(CASE WHEN current query=' insufficient privilege ' THEN 1 ELSE 0 END) as unknown,. FROM pg stat activity WHERE procpid! Waiting idle idletransaction unknown active.
dbstrike.blogspot.com
DB Strike: Linux articles
http://dbstrike.blogspot.com/p/linux.html
When your database just start messing around. Linux: Allow a user to execute only specific root command(s). Linux: generate random password (script). Subscribe to: Posts (Atom). RMAN: Restore missing archivelogs. View my complete profile. Messages les plus consultés. TNS-12535: TNS:operation timed out. Specific to Oracle 11G If you see the errors in the alert logfile : * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * . Oracle 10g dbconsole setup. PHP with oci8 support on centos.
dbstrike.blogspot.com
DB Strike: February 2014
http://dbstrike.blogspot.com/2014_02_01_archive.html
When your database just start messing around. Friday, February 21, 2014. Sometimes, your loose all your controlfiles, your instance is down, and you think you're in a big sh* . But here's a solution. Check your last controlfile backup to get your DBID :. Ls -l *.bck. Rw-rw- - 1 oracle oracle 10092544 Apr 15 15:49 c-159519437-20110415-06.bck. The DBID is the first number block : 159519437. Then, go to RMAN and restore your controlfile from the last backup:. Restore controlfile from autobackup;. How to see...
dbstrike.blogspot.com
DB Strike: April 2015
http://dbstrike.blogspot.com/2015_04_01_archive.html
When your database just start messing around. Thursday, April 9, 2015. Postgres SQL: Install and first launch. Create and setup the postgres user:. Root@localhost ]# useradd postgres -m /home/postgres. If you don't have the home dir yet, you can add it at a later stage. You just need to stop all processes used by it first. Root@localhost ]# mkdir -p /home/postgres. Root@localhost ]# chown postgres:postgres /home/postgres. Root@localhost ]# usermod -d /home/postgres postgres. Creating system views . ok.
dbstrike.blogspot.com
DB Strike: February 2012
http://dbstrike.blogspot.com/2012_02_01_archive.html
When your database just start messing around. Tuesday, February 28, 2012. Flashback archive (Oracle 11g). In Oracle 11g, you have the possibility to use flashback archive. This feature allow you to keep track of data change on specific table (used by your application for example). Here, we will use this feature to keep track of historical data on transaction on specific table. Fisrt, we need to create a tablespace (TBS FBARC) that will store these data:. We can now add tables:. The UNDO tablespace has to...
dbstrike.blogspot.com
DB Strike: April 2012
http://dbstrike.blogspot.com/2012_04_01_archive.html
When your database just start messing around. Tuesday, April 3, 2012. Sometimes, when all your datafiles are on the same volume, you can have a lack of space and risks fulling it. In that case, you should move some of your DB datafiles (*.dbf) to another volume. To do so, you have a few steps to follow:. Tablespace with the files to move must be offline. Move the datafile(s) with the OS command. Rename the datafile with SQL. Put the tablespace online. 1 Put the tablespace offline:. 2 Move the file(s).
dbstrike.blogspot.com
DB Strike: Linux: Generate a random password
http://dbstrike.blogspot.com/2014/02/linux-generate-random-password.html
When your database just start messing around. Tuesday, February 4, 2014. Linux: Generate a random password. The main script, has to be saved in a separate file, or modified as a function:. Len=${#charspool[*]} if [ $# -lt 1 ]; then num=$1; else num=$1; fi randomnumbers=$(head -c $num /dev/urandom od -t u1 awk '{for (i = 2; i = NF; i ) print $i}') for c in $randomnumbers; do echo -n ${charspool[$( c % len) ]} done echo. And to call it:. Echo $(/path/to/script/gen password.sh $lenPassword);. David Coulon&#...
dbstrike.blogspot.com
DB Strike: January 2014
http://dbstrike.blogspot.com/2014_01_01_archive.html
When your database just start messing around. Wednesday, January 29, 2014. Linux: Allow a user to execute only specific root command(s). Sometimes you want a linux user to be able to execute root command(s). To do so, you need to modify the /etc/sudoers file (with visudo). However, almost everyone add a line like the below:. Which is far from being the right thing to do. You basically just gave the user username all root rights. To do it properly, you should know the synopsis of that line:. Rollback Segm...
