Archive

Archive for the ‘tools’ Category

Backup methods and tools for Oracle

January 20th, 2013 No comments

In order for one to get appealing results, they have higher chances of getting positive results in terms of using the best options that enable one to settle with affirmative and timely operational methods

There are different factors that promote backup frequency and they include

The rate of transaction rate

Availability of database

The value of the data company

ARCHIVELOG mode:

SQL> CONNECT sys AS SYSDBA

SQL> STARTUP MOUNT EXCLUSIVE;

SQL> ALTER DATABASE ARCHIVELOG;

SQL> ARCHIVE LOG START;

SQL> ALTER DATABASE OPEN;

 

databases in ARCHIVELOG mode:

log_archive_start         = TRUE

log_archive_dest_1        = ‘LOCATION=/arch_dir_name’

log_archive_dest_state_1  = ENABLE

log_archive_format        = %d_%t_%s.arc

 

difference between restoring and recovering?

SQL> connect SYS as SYSDBA

SQL> RECOVER DATABASE UNTIL TIME ‘2001-03-06:16:00:00’ USING BACKUP CONTROLFILE;

 

RMAN> run {

set until time to_date(’04-Aug-2004 00:00:00′, ‘DD-MON-YYYY HH24:MI:SS’);

  restore database;

  recover database;

online database backups?

ALTER TABLESPACE xyz BEGIN BACKUP;

! cp xyzFile1 /backupDir/

ALTER TABLESPACE xyz END BACKUP;

ALTER SYSTEM SWITCH LOGFILE;   — Force log switch to update control file headers

ALTER DATABASE BACKUP CONTROLFILE TO ‘/backupDir/control.dbf’;

RMAN can be operated from Oracle Enterprise Manager, or from command line. Here are the command line arguments:

 

Argument     Value          Description

—————————————————————————–

target       quoted-string  connect-string for target database

catalog      quoted-string  connect-string for recovery catalog

nocatalog    none           if specified, then no recovery catalog

cmdfile      quoted-string  name of input command file

log          quoted-string  name of output message log file

trace        quoted-string  name of output debugging message log file

append       none           if specified, log is opened in append mode

debug        optional-args  activate debugging

msgno        none           show RMAN-nnnn prefix for all messages

send         quoted-string  send a command to the media manager

pipe         string         building block for pipe names

timeout      integer        number of seconds to wait for pipe input

 

[oracle@localhost oracle]$ rman

Recovery Manager: Release 10.1.0.2.0 – Production

Copyright (c) 1995, 2004, Oracle.  All rights reserved.

 

RMAN> connect target;

 

connected to target database: ORCL (DBID=1058957020)

RMAN> backup database;

backup and restore a database using RMAN?

rman target sys/*** nocatalog

run {

  allocate channel t1 type disk;

  backup

    format ‘/app/oracle/backup/%d_t%t_s%s_p%p’

      (database);

   release channel t1;

}

 

Example RMAN restore:

 

rman target sys/*** nocatalog

run {

  allocate channel t1 type disk;

  # set until time ‘Aug 07 2000 :51’;

  restore tablespace users;  recover tablespace users;

  release channel t1;

Categories: oracle, tools Tags:

Backup methods and tools for PostgresQL

January 17th, 2013 No comments

There are different methods that one can use in order to backup and restore files.

Using pgdump, new file for each day

Process

Go to Server create a Directory called Drive:\PostgresqlBack then create a sub directory called “bin” in the Drive:\PostgresqlBack

comerr32.dll

gssapi32.dll

k5sprt32.dll

krb_32.dll

libeay32.dll

libiconv2.dll

libpq.dll

Microsoft.VC80.CRT.manifest

msvcm80.dll

msvcp80.dll

msvcr80.dll

pg_dump.dll

ssleay32.dll

zlib1.dll

Create batch file called something, example is postgresqlBackup.bat. The file must be located in PostgresqlBack directory not the bin folder.

 

Open the File then Copy/Paste the following

 

@echo off

for /f “tokens=1-4 delims=/ ” %%i in (“%date%”) do (

set dow=%%i

set month=%%j

set day=%%k

set year=%%l

)

set datestr=%month%_%day%_%year%

echo datestr is %datestr%

set BACKUP_FILE=<NameOfTheFile>_%datestr%.backup

echo backup file name is %BACKUP_FILE%

SET PGPASSWORD=<PassWord>

echo on

bin\pg_dump -i -h <HostName> -p 5432 -U <UserName> -F c -b -v -f %BACKUP_FILE% <DATABASENAME>

Change <NameOfTheFile> to something. Setting is the first part of the file name then followed by the date the file was created with the extension .backup

Change the <PassWord > setting above to the correct password for the backup users.

Change <HostName> either to ip address or dns name of the server hosting Postgresql.

Change <UserName> to backup user make sure this users has access to database for backup purposes

Change <DATABASENAME> to the database name being backed up.

Save the File

Create Task for the MS Task Scheduler

Using .pgpass and pgdumpall, same file

Achieving automated backup in a windows environment

 

Create a .pgpass file

Lock down the .pgpass file

Using NTFS permissions, disable access to this file for everybody except the user pg is running as

Create a script to call pg_dumpall

   SET PGPASSFILE=C:\foo\bar\PG_BACKUP\PGPASSFILE\pgpass.conf

“C:\Program Files\PostgreSQL\8.2\bin\pg_dumpall.exe” -U scfcu_postgres > C:\foo\bar\PG_BACKUP\db.out cu

Handling Large Databases

Use compressed dumps. You can use your favorite compression program, for example gzip:

pg_dump dbname | gzip > filename.gz

Reload with:

gunzip -c filename.gz | psql dbname

or:

cat filename.gz | gunzip | psql dbname

Use split. pg_dump dbname | split -b 1m – filename

Reload with: cat filename* | psql dbname

You can use PostgreSQL’s continuous WAL archiving method. First you need to set wal_level=archive, then do a full filesystem-level backup (between issuing pg_start_backup() and pg_stop_backup() commands) and then just copy over newer WAL files by configuring the archive_command option.

 

Update: Check out Barman for an easier way to set up WAL archiving for backup.

You can use PostgreSQL’s continuous WAL archiving method. First you need to set wal_level=archive, then do a full filesystem-level backup (between issuing pg_start_backup() and pg_stop_backup() commands) and then just copy over newer WAL files by configuring the archive_command option.

Advantages:

Incremental, the WAL archives include everything necessary to restore the current state of the database

Almost no overhead, copying WAL files is cheap

You can restore the database at any point in time (this feature is called PITR, or point-in-time recovery)

Disadvantages:

More complicated to set up than pg_dump

The full backup will be much larger than a pg_dump because all internal table structures and indexes are included

Doesn’t work work well for write-heavy databases, since recovery will take a long time.

 

Categories: Postgresql, tools Tags:

Open Source html and Developer Tools on Linux – Kdevelop is one of the Perfect Open Source Html and Developer Tools!

March 21st, 2012 No comments

If you are looking for one of the best open source html and developer tools on Linux then Kdevelop is may be the right option for you. It was created in 1998. It is plug in based so you can remove and add plugs to create the particular feature set you require. It support fifteen programming language with specific feature. It also offers various other features to the users such as version control, application wizard, code snippets, RAD tools, code reformatting, QuickOpen support and documentation viewer. One of the best advantage of Kdevelop is it takes a great deal of the low level tasks out of the hands of the users

Anjuta has the flexible & powerful user interface, which allows you drag & drop tools in a layout to arrange GUI any way that you like. Every user configured layout is very persistent for project (thus you may have various layouts for each project you are going). Anjuta as well enjoys the powerful plug-in system, which allows you choose which of the plugins are active & which are not for every project. Like all the open source projects, you may also develop your plug ins for Anjuta. The most strong tools in Anjuta program is project manager. The tool will open any automake or autoconf based project. The project manager will not add any of the Anjuta based information to project, thus the project is maintained as well as developed outside of the Anjuta also.

Glade

Glade is the RAD (that is rapid application development) application used for making the GTK+ toolkit & for GNOME desktop. The interface is same to The GIMP and is customized and embedded in Anjuta. The glade also includes many interface building blocks, like dialog labels, text boxes, check boxes, numeric entries, as well as menus, to make development of the interfaces faster. Interface designs are been stored in the XML format that also allows the designs to be very easily interfaced with the external tools.

Open Source Html and Developer Tools on Linux – Offering Powerful User Interface!

March 20th, 2012 No comments

Though there are numerous various Linux based open source html and developer tools available but you must need to choose the right tool through which you can take your development to another level.  Anjuta is such type of open source developer tool available for users through which they can perform project management, application wizard and syntax highlighting. It is very easy to install and meet all your C and C++ programming needs. It has a flexible and powerful user interface which allows the user to drag and drop the tools any way they like. It has also a powerful plug-ins system which enables the users to develop their own plug-ins in Anjuta.

In case, you are the new user then you may not know which of the tools are there, however worry not. Here to help you with your Document Management Needs One of the Bluefish’s nice features is Quickba, the user defined toolbar, which allows you add some buttons just by right clicking & select Add To Quickbar. You may add HTML toolbar buttons on Quickbar. Bluefish has many easy tools to assist you add different elements to the code. Need the DHTML auto submit box? Select Auto submit Select Box from DHTML and dropdown to fill out necessary items for adding an element to the code. The Bluefish has the wizards for Apache, C, DocBook, DHTML, PHP+HTML, HTML, as well as SQL. In case, you develop the sites by hand, then you must certainly be making use of Bluefish.

Anjuta

Anjuta is the free, and open source IDE for C & C++ languages. It is simple to install and gives these features as the project management, interactive debugger, application wizards, as well as powerful source editor (with the source browsing, syntax highlighting and code completion). Anjuta team developed the powerful IDE to be simple to use as well as meet all your C & C++ programming requirements.

Open Source Html and Developer Tools on Linux – Chose the Right Developer Tools!

March 18th, 2012 No comments

Do you know that you need to have the perfect tools to take the benefits of excellent Linux development environment?  Though Linux is an excellent development environment but without good development tools it can’t do any good for you. Fortunately, there several open source developer tools of Linux available in the market for users flexibility, if you are new user then you need to understand which tool should be best for you. Bluefish is one of the most popular Linux based developer tools which can handle programming and mark-up languages with very ease and help you take your development to another level. Like other Linux application Bluefish can open multiple documents at once. In order, to take benefit of excellent Linux development environment, first you require right tools. Here is the rundown of a few of best ones out there & features they want to offer.

To take benefit of the excellent Linux development, you require right tools. Here is the rundown of a few of best ones and features that they want to offer. Linux is the great development environment and without the sound development tools, environment will not do you good. Luckily, lots of Linux or open source development programs are accessible. There are some tools that can help you to take the development to other level.

Bluefish

Bluefish is the most famous IDEs for the Web development available and it will handle the programming & markup languages, however it focuses on making the dynamic & interactive Web sites. Like a lot of Linux applications, the Bluefish is lightweight (making use of around 30% – 40% of resources that same applications use) and quickly. The bluefish will also open the multiple documents once (3,500 documents, in case, needed). It also includes the project support, search & replace (that includes regular expressions), remote file support, unlimited undo or redo, the customizable syntax for a lot of languages, the anti-aliased in windows, as well as multiple encodings support, other features.

Linux Monitoring the basics

July 19th, 2011 No comments

Due to various advantages now so many computer users are move towards the Linux operating system in place of Windows. This OS is having some easy features through which the new users can access any application without any assistance. At the same way, it is open sources platform for the users through which users can solve any sorts of work like personal, commercial and web base programs.

Among other advantage of the Linux monitoring applications are allowing the users to judge the security and web base programs to avoid any sorts of problem. Linux monitoring applications are also the right option for the users to secure their personal and commercial sensitive web base programs. Instead of others, the Linux operating system has availed include with the monitoring software through which the computer users can track the security system in their system. So, Linux monitoring application is the right option for system security. The network monitoring is simpler with the Penguin Monitor 8s.

With the ability to monitor operating systems that includes Microsoft Windows 2003, 2008, 2000, AIX, HPUX, Oracle Solaris, OS/400, as well as OpenVMS, eG Enterprise gives single pane of the glass from where the administrators will monitor the heterogeneous multi-vendor center servers from the single console. Remotely monitor the Linux server farm – and from anywhere, anytime, making use of web console.

Get proactive alerts, which help you to detect & correct the problems with Linux servers as well as applications prior to users complain. View the historical reports regarding Linux servers, which help you to determine where the bottlenecks are while you have to plan for the capacity. Easy to user interface makes sure that the Level 1 support staff will very effectively handle the customer trouble calls & call the expert Linux administrators just for solving the complex problems.

Categories: tools Tags:

MySQL Tools for Linux – Get It Now!

July 17th, 2011 No comments

Due to huge popularity of Linux operating system, the computer users are searching the best tools or applications through which users can effectively use this sort of operating system.

At present, there are numbers of leading software companies have come to market for offering their effective application tools to the users. If you want to buy the best tool for Linux operating system, then you have the good option to select the MySQL tools.

Now days, MySQL tools have managed to draw more importance from those users who wants to operate this sort of operating system easily. Keep in mind that MySQL have been written by Java, so that users are getting right solution to operate this sort of database on their computer. In this regard, it is the right option for you to use the Linux operating system easily on your computer. So, you need to move for the online and get this sort of tools for Linux operating system.

It will make & drop databases, create or drop or alter tables, delete, edit and add fields, execute any of the SQL statement, and manage users & permissions, as well as manage some keys on the fields.

One nice feature from legendary tool is you may download & change theme (not the monumental feature, however unique feature), download these themes here: the phpMyAdmin Themes (themes are the version specific). SQLyog is one more very famous SQL management tool, which has some useful features like visual schema designer, intelligent code completion, visual query builder, and data or structure synchronization.

That support HTTP or HTTPs and SSH tunneling as well as SSL connections. You may as well also specify the job manager, and define the scheduled database backup as well as make use of notification service being reminded while a few jobs are finished.

Also, there is the free Community version as well as commercial Enterprise edition. Also, you might use MONyog, MySQL Monitor & Advisor. The graphical GUI for MySQL database, is the “real” application, it will give refined user interface than possible with the systems built on HTML and PHP.

Response is instant, since there is not any delay of reloading the HTML pages. In case, your supplier allows that, MySQL Front will make the direct contact with database. Or, one small script has to get installed on publishing site.

Categories: linux, tools Tags:

Linux Monitoring Applications – Get The Proper Function To Your Entire Network!

July 14th, 2011 No comments

Linux server management is providing different dedicated web server organizations as it is one of the best procedures to make sure more secured database than other management service.

Linux is one of the well known brands in web server operating system and its dependable monitoring techniques make sure you that your server never crashes and always run smoothly. Linux monitoring applications has achieved great acknowledgement among the biggest web hoisting companies as one of the excellent web hosting platforms.

These days Linux monitoring applications are knows as the best way to ensure the performance of your system and server functioning.  By using these latest Linux monitoring applications you can get the guarantee of safety and security of your system. These techniques also ensure the users that their servers never hang or crash and also protect their vital data and applications. Linux monitoring also adds proper functioning to your entire network.

The linux based servers are to be widely used by a lot of enterprises to power the data centers. The monitoring server hardware, server hardware, as well as critical parts of server operating system that includes processors, disk, memory, as well as network interfaces is necessary for making sure that applications running on the servers are now working efficiently every time.

The eG Enterprise give 100% of web based Linux monitoring & application performance monitoring. Different Linux variants that includes SuSE Linux, Hat Linux, CentOS and Ubuntu Linux, are monitored by the eG Enterprise. Making use of the web based console, the administrators will track status of the heterogeneous server farms, get alerts while problems take place, view the reports on the historical performance, as well as plan capacity of the server farms. In order, to monitor the Linux server, you have to deploy eG agent program.

Categories: tools Tags:

FreeNX – Making RDP Connections Fast and Quick!

May 22nd, 2011 No comments

http://linuxnotebook.files.wordpress.com/2007/06/freenx1.pngThere are several methods or applications have been announced for the market in order to keep the use of computer hassle free. Especially when you are using multiple numbers of computers, you should know more details about applications like FreeNX.

This is a kind of system which allows you to get the right access from the desktop you are operating to another computer on the network. It’s the FreeNX that use to take help of the internet to offer you a better connectivity with another computer on the network.

Apart from a better connectivity, FreeNX can also offer you several more benefits which will just make your computer use hassle free and really pleasant.

With the help of the FreeNX you can login with your own desktop graphically from another system. All you need to set up the FreeNX for the computer at your home while taking the help of FreeNX client. It has been considered as an open source which is also having a safe SSH base.

This sort of application is always fast and most importantly versatile on use. While trying to set up the FreeNX, you need to assume the computer for which you want to get the connection as the server. This will be the system where you need to install the FreeNX. Freenx is the application or thin costumer server based on the nx technology.

The NoMachine nx is next generation X compression as well as roundtrip suppression. It will operate the remote X11sessions more than 56k modem dial up links and anything better. The package has the free (GPL) implementation of nxserver component. The FreeNX Server is Free NX server implementation that is based on the NoMachine.com’s technology.

FreeNX is the set of the Bash scripts (around 3000 lines of the code together) as well as comes without any support. For the FreeNX to work, just you not need FreeNX scripts, however you need compiled NX sources from the NoMachine.com installed.

The FreeNX also allows you access to the machine remotely through ssh and display is powerful when compared to the X11 over ssh & it is describe as the equivalent of the Windows Terminal Services. FreeNX is the free NX server making use of NX protocol.

Thinstation – It’s so powerful yet Open Source!

April 28th, 2011 2 comments

http://image.wareseeker.com/software/wii/hot/scr_291f9d86d2-dbimage.php-id-144534.jpeg

Thinstation has been considered as a small, yet thin and powerful open source operating system that also supports different types of connectivity protocols. Few of these connectivity protocols have been mentioned below.

Citrix ICA
NoMachine NX
2X ThinClient
Microsoft Windows terminal services

Thinstation has been announced for the market in order to help users at their schoolroom, offices and business sectors. These applications or the operating systems can be used at different departments in order to keep the workflow smooth.

Thinstation is based on Linux. However, users for Thinstation will hardly see the Linux with this sort of open source operating system. If you are trying to get direct connection for the Windows or Unix Server, then the user may feel a direct connectivity on the server.

At the same time users can have a local browser or also known as the desktop utility. Thinstation only support Windows like operating system and there will be hardly any need to have knowledge about Linux or UNIX in order to get the most of this application.

Thinstation can be added for a general PC. In this regard, you can either use old systems or even you can save more time while working with the workstation administration. Thinstation is the thin costumer Linux distribution, which makes the PC full featured thin costumer supporting major connectivity protocols: the Citrix ICA, MS Windows services (RDP), NoMachine NX, telnet, Tarantella, X, VMS term, tn5250, as well as SSH.

There is no special configuration of application servers is required to use the Thinstation! Thinstation is booted from the network (for example diskless) making use of the Etherboot or PXE and from the local floppy, CD, HD, and flashdisk. Thin client configuration is centralized simplify the management.

The Thinstation also supports the client side storage (HD/ floppy/CD/USB) as well as printers (LPT or USB). The prebuilt images as well as Live CD are accessible too! Mozilla Firefox & lighter browsers are been supported as the client side browsers.

The Thinstation is the Linux distribution, which allows you to convert the standard PCs in the full featured diskless the thin clients supporting some of the major connectivity protocols such as Ica, X, Windows terminal services, Tarantella, NX, Ssh and TN5250, Telnet. It is well booted from a network making use of Etherboot or PXE and from standard media such as CD/ floppy/hd/flash-disk. Configuration is centralized in order to simplify the terminal management.

Categories: tools Tags: ,