Hot Backup and Cloning

 

 Hot Backup :

A hot backup is taken when the database needs  totally open and available to its users. It is an online backup. All files of the database are copied and there may be changes to the database during the copy.For the hot backup the database must be running in the ARCHIVELOG Mode.

The benefit of taking a hot backup is that the database is available for use while the backup is occurring and one can recover the database to any point in time.

For Hot Backup  the database must be informed when the backup is starting and when it is going to complete. 

  •  Alter database begin backup
  •  Alter database end backup 

 Backup Procedure : 

Gather all the Info for the backup Purpose .

  •  select name from v$datafile ;
  • select * from v$controlfile ;
  • select name from v$logfile ;
  • select NAME from v$archived_log ;
  • create pfile from spfile ; 

Perform a log switch and note down the old and current log  sequence of database 

  • Alter system archivelog current  ;
  • archive log list   ;

 Place or  inform source database to be in backup mode 

  • alter database begin backup 
  • select * from v$backup;
     

Copy all the datafilse and log files to remote server or backup location . Once the copy is completed end the backup mode of database .

  • alter database end backup 

Perform a log switch and note down the old and current log  sequence of database 

  • Alter system archivelog current  ;
  • archive log list   ;

 Take the control file trace backup in source Database .

  • alter database backup contorfile to trace  as '/tmp/ctrl_hotbkup.sql';

Cloning 

Copy all archive log files generated on the source database during begin backup and the end backup mode to the target server.

Modify the contents of trace file and edit the database name and modify the location of data files and log files  .

Note: Change the “REUSE” parameter to “SET” and RESETLOGS option.

Make sure to copy the archivelogs in the same location on target server as on the source server 

Move the pfile to DBS location and modify the pfile to change the DB name an control file locations

Steps :

  •  Startup the database in nomount stage using modified pfile .
  •  Create the control file for the clone database using the trace control file.
  • Recover the database using backup control file option
  • " recover database using backup controlfile until cancel ; "
  • Open the database in Resetlogs  mode 
  • "alter database open :"
 
 

 


     

     

Comments

Post a Comment

Popular posts from this blog

FRA Usage and Administration

Image
 In Oracle database, the Flash Recovery Area or FRA is a location on disk where the database can create and manage several kinds of backup and recovery-related files. Main file types are archivelog, flashback log, backups, as well as mirrors for your control files and redo log files. All files in the FRA are Oracle-managed files. Using a Flash Recovery Area simplifies the administration of your database by automatically retaining them for as long as they are needed for restore and recovery activities, and deleting them when they are no longer needed, because the space is needed for another backup and recovery-related purpose. Checking the current usage  You can check the configuration by looking at two parameters.The parameters are db_receovery_file_dest and second one db_recovery_file_dest_size .  db_receovery_file_dest point to location where the files will be located in Server . FOr normal single Databases this will be any directory for RAC this will b...
Read more

Cold Backup Cloning of Database .

 Cold Backup :  A cold backup is done when there is no user activity going on with the system. Also called as offline backup, is taken when the database is not running and no users are logged in. all files of the database are copied and no changes during the copy are made. Cold backup can be preformed when Database is in archive mode as well as Non archive log mode  . Backup Strategy :  Gather all the details of physical files (CRD) files in  database . redo log files are online redo log and archived redo log ones .   Select file_name,tablespace_name from dba_data_files  ; select * from v$controlfile  select member from v$logfile ; select name from v$archived_Log ;  create pfile from spfile  Backup  the contol file manually . alter database backup controlfile to trace as '/tmp/coldbackup_controlfile.sql' ;     Stop all the DB services (Database ,Listener)on source DB Server. Copy all the files(Datafiles,redo...
Read more

Oracle Architecture SGA

Image
 Architecture :   Basic Memory Structures Oracle Database includes several memory areas, each of which contains multiple subcomponents. The basic memory structures associated with Oracle Database include: ·          System global area (SGA) The SGA is a group of shared memory structures, known as SGA components , that contain data and control information for one Oracle Database instance. All server and background processes share the SGA. Examples of data stored in the SGA include cached data blocks and shared SQL areas. ·          Program global area (PGA) A PGA is a nonshared memory region that contains data and control information exclusively for use by an Oracle process. Oracle Database creates the PGA when an Oracle process starts.One PGA exists for each server process and background process. The collection of individual PGAs is the total instance PGA, or instance PGA . Database ...
Read more