Moving Oracle Database Between Mount points

Ø Take Backup of the database through RMAN. Below are some configuration changes which helps you take the backup effectively. Run the below commands in RMAN prompt.
1. Configure the backup location
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup_dumps/IDC/RMAN_Backups/RMAN_MX210XRL_%U';
2. Switch on contrfolfile autobackup
CONFIGURE CONTROLFILE AUTOBACKUP ON;
3. Set parallel parameter to 2 for the speedy backup.
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
Ø Take Backup of the database along with archives.
RMAN> Backup database plus archivelog;
Ø Create the new logfile groups with new mount point and drop the groups with old logfile members.
SQL>alter database ADD LOGFILE GROUP 4 ('/mwm_oradata_01/MX210XRL/redo04.log') size 100m;
SQL>Alter database drop logfile group 1;
Ø Once the backup is done shut down the database and change the parameter file for appropriate location of controlfiles.
Ø Move the control files physically from OS level to the new mount point(or Create the controlfile from the from rman backup by bringing the database in nomount state).
For 2nd option here is the command:
RMAN>restore controlfile from '/backup_dumps/IDC/MWM21DEV_HotBackup_03082011/RMAN_04mj1i6m_1_1';
Ø Mount the database and run the below command from rman to change the newname for datafiles and to restore the database from latest backup set.
RMAN>run
{
set newname for datafile '/mwm_oradata_03/MX210XRL/system01.dbf' TO '/mwm_oradata_01/MX210XRL/system01.dbf';
set newname for datafile '/mwm_oradata_03/MX210XRL/SYSAUX.dbf' TO '/mwm_oradata_01/MX210XRL/SYSAUX.dbf';
set newname for datafile '/mwm_oradata_03/MX210XRL/UNDOTBS1.dbf' TO '/mwm_oradata_01/MX210XRL/UNDOTBS1.dbf';
set newname for datafile '/mwm_oradata_03/MX210XRL/tools01.dbf' TO '/mwm_oradata_01/MX210XRL/tools01.dbf';
set newname for datafile '/mwm_oradata_03/MX210XRL/cists01.dbf' TO '/mwm_oradata_01/MX210XRL/cists01.dbf';
set newname for datafile '/mwm_oradata_03/MX210XRL/xmldbts01.dbf' TO '/mwm_oradata_01/MX210XRL/xmldbts01.dbf';
Restore database;
switch datafile all;
}
Ø Once done connect to the database as sysdba and run the below command.
SQL> Recover database;
Ø Check the datafile,controlfile and redo log file locations.
SQL> select name from v$datafile;
SQL> select name from v$controlfile;
SQL> select member from v$logfile;

Joomla Errors

Below Listed are Joomla Common errors:
*Unable to connect to database or database error:
If you are unable to find any of the error messages in the previous section then please see below you may find it here!!!
Database Errors:
I am not going to list out the error messages since all needs the basic procedure. Which I have listed below
1.Verify database settings, usually database settings for any application are found in these files: config.php, configuration.php, include(s)/config.php,wp-config.php, Settings.php, etc….
2.Check whether database name and Username are correct if they are correct then reset the database password.
3.Check the database host. It may be usully ‘localhost’ unless your server has separate MySQL server.
4.If everything is okay then try uploading the testdatabase script and check.
5.If the test database script too fails then contact your host.
6.If test database script success then the issue is with your application or other settings.
7. If any table is corrupted and you see table name in error message then try run this SQL query.

* Database Error where a database Table name is specified usually sessions table:
Fix: This is caused by crashing Table, Repair the table.
* Joomla links are not working results in Page not found.
Fix: Usually a .htaccess.txt file comes with Joomla rename it to ,htaccess, try disabling SEO options SEF URL redirect. Not got the ,htaccess the try adding this file:
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_URI} !^/index.php
RewriteCond %{REQUEST_URI} (/|\.php|\.html|\.htm|\.feed|\.pdf|\.raw|/[^.]*)$ [NC]
RewriteRule (.*) index.php
RewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization},L]

What is frameset ?

The frameset element is used to hold and display a separate document on a web page.

<html>
<frameset cols=”50%,*,25%”>
<frame src=”test1.html” />
<frame src=”test2.html” />
<frame src=”test3.html” />
</frameset>
</html>

Here page test1 using 50% of layout and test3 using 25% occupy the layout. The rest of the space transfer to test2.html that is 25% (100%-50%+25%= 25%).

Play background music in your blogger!!

The simplest method of adding background sound is to include a line like this in your blog template.

<bgsound src="http://yoursite.com/background.mp3" loop=infinite>
Steps to add:  Go to Blogger dashboard Design-> Edit HTML-> below body tag add this code.
<bgsound src="http://yoursite.com/yoursound.mp3" loop=infinite>

Example:
 <body>
 <bgsound src="http://yoursite.com/yoursound.mp3" loop=infinite>


 Here http://yoursite.com/yoursound.mp3 is path of mp3file.

Add facebook comment to blogger!!!

Step 1: Visit http://developers.facebook.com/setup/ give your website URL and website name.
Step 2:  Create new app at https://developers.facebook.com/apps
step3: Now change  App ID in the code

<b:if cond='data:blog.pageType == &quot;item&quot;'>
  <p align='left'><img alt='Mangalre news' class='icon-action' src='https://lh6.googleusercontent.com/-nfUWFHVQt9U/TnylcyEO5_I/AAAAAAAAAOE/O_TfQUF1l8M/h80/comments.png'/></p>
  <div id='fb-root'/>
  <script>
  window.fbAsyncInit = function() {
  FB.init({appId: &#39;654329081782653&#39;, status: true, cookie: true,
  xfbml: true});
  };
  (function() {
  var e = document.createElement(&#39;script&#39;); e.async = true;
  e.src = document.location.protocol  +
  &#39;//connect.facebook.net/en_US/all.js&#39;;
  e.async = true;
  document.getElementById(&#39;fb-root&#39;).appendChild(e);
  }());
  </script>
  <fb:comments/>
  </b:if>

Step5: Place this code in  Blogger dashboard and navigate to  Edit HTML in Templates. 

Design->edit html->

Search for the code <data:post.body/> or <div class=’post-header-line-1′/> and paste the code below <data:post.body/> or <div class=’post-header-line-1′/> and save the template.

Step4: Hide the comments 

Settings->Comments->Select Hide 

Thats all............