more

$value) { if (strpos($param, 'color_') === 0) { google_append_color($google_ad_url, $param); } else if (strpos($param, 'url') === 0) { $google_scheme = ($GLOBALS['google']['https'] == 'on') ? 'https://' : 'http://'; google_append_url($google_ad_url, $param, $google_scheme . $GLOBALS['google'][$param]); } else { google_append_globals($google_ad_url, $param); } } return $google_ad_url; } $google_ad_handle = @fopen(google_get_ad_url(), 'r'); if ($google_ad_handle) { while (!feof($google_ad_handle)) { echo fread($google_ad_handle, 8192); } fclose($google_ad_handle); } ?>

Friday, September 23, 2011

RMAN CONTROLFILE BACKUP

9:11 PM 0 comments

Welcome to oracle virtual classroom where we simplify your understanding of all thing Oracle Software related. We hope you would join us on this journey as we proceed. Today we will be starting off with how to back up your control file using RMAN (oracle's recovery manager). What is a control file in the first place and why do we need to back it up?

Well for starters the control file in an oracle  database stores the status of the physical structure of the database. The control file is a critical aspect of the database, without it the database will not continue its operations and that is the last thing you want to happen to your database.

So here is how your would use rman controfile backup to make a copy of your control file in case your end up with a corrupt file, you will be able to restore your database.

First off connect to RMAN via the command line 
  1. $ rman
    RMAN>  connect target user/password
    RMAN> connect catalog user/password
  2. To back up the whole database:
    RMAN>  backup database; * if you want back up the database to a specific file use: RMAN> BACKUP DATABASET FORMAT ‘/backup/oracle/%d-%T-%s-%P’;
    Notice that the formatting of this information varies by platform.
      %d   The name of the database.
      %D  The current day of the month (in format DD)
      %M  The month (format MM)
      %Y  The year (YYYY)
      %T  The year, month, and day (YYYYMMDD)
      %F  Combination of DBID, day, month, year, and sequence
      %p  The piece number within the backup set.
      %s  The backup set number.
      %t  The backup set time stamp, which is a 4-byte value
Now the easy way to back up the control file is to issue the following command:
RMAN> backup controlfile;

You can also set the database to backup the file automatically that way you need to constantly worry about the file and here is how you would do that

Configuring RMAN to Automatically Backup the Control File and SPFILE

Simply set CONFIGURE CONTROLFILE AUTOBACKUP to ON, then RMAN automatically creates a control file and an SPFILE backup after you run the BACKUP or COPY commands.



Read More