==================================================================================
                                   Hot Backup
==================================================================================

1) Putting tablespaces in backup mode:

	alter database begin backup;
   
2) Checking tablespaces status:

	select * from v$backup;

3) Copy ORADATA folder containing tablespaces, control files, and redo log files:

	Source: 	E:\Oracle\product\10.2.0\oradata
	Destination:	E:\HOT_BACKUP\oradata

4) Putting tablespaces out of the backup mode:

	alter database end backup;

5) Checking tablespaces status:

	select * from v$backup;

6) Switch the archive log:
	
	alter system archive log current;

7) Backup the control file:

	alter database backup controlfile to 'E:\HOT_BACKUP\control_bkp.ctl';

8) Copy archive logs to the backup location:

	Source: 	F:\oracle\product\10.2.0\flash_recovery_area\ISDB\Archive
	Destination:	E:\HOT_BACKUP\Archive-backup

	=====> Copied only two days archive logs

==================================================================================
                                Restore Hot Backup
==================================================================================
	
1) Shutdown database:

	shutdown immediate;

2) Rename existing ORADATA folder for safety reasons:

	Old Name: 	E:\Oracle\product\10.2.0\oradata
	New Name:	E:\Oracle\product\10.2.0\oradata-installed

3) Copy ORADATA folder from hot backup:

	Source:		E:\HOT_BACKUP\oradata-backup
	Destination: 	E:\Oracle\product\10.2.0\oradata

4) Remove existing REDO log files & Control files (copied from hot backup):

	Source:		E:\Oracle\product\10.2.0\oradata

5) Restoring Control File from hot backup:

	Source:		E:\HOT_BACKUP\control_bkp.ctl
	Destination:	E:\Oracle\product\10.2.0\oradata\CONTROL01.ctl
			E:\Oracle\product\10.2.0\oradata\CONTROL02.ctl
			E:\Oracle\product\10.2.0\oradata\CONTROL03.ctl

6) Start database in mount state:

	startup mount;

7*) Recover database using the following (ERROR IN THIS STEP):

	recover database until cancel using backup controlfile;


	SCREEN OUTPUT
	=============

	ORA-00279: change 17147044857 generated at 04/17/2017 09:12:22 needed for thread 1
	ORA-00289: suggestion : 	F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ISDB\ARCHIVE\ARC47217_632015589.1
	ORA-00280: change 17147044857 for thread 1 is in sequence #47217
	Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

	MY INPUT:	 E:\HOT_BACKUP\Archive-backup\ARC47217_632015589.1


	ORA-00279: change 17147045518 generated at 04/17/2017 09:22:50 needed for thread 1
	ORA-00289: suggestion :	F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ISDB\ARCHIVE\ARC47218_632015589.1
	ORA-00280: change 17147045518 for thread 1 is in sequence #47218
	ORA-00278: log file 'E:\HOT_BACKUP\Archive-backup\ARC47217_632015589.1' no longer needed for this recovery
	Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

	MY INPUT:	 Pressed ENTER, as this archive file does not exist in Archive Log backup folder

	ORA-00308: cannot open archived log 'F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ISDB\ARCHIVE\ARC47218_632015589.1'
	ORA-27041: unable to open file
	OSD-04002: unable to open file
	O/S-Error: (OS 2) The system cannot find the file specified.


8) Open Database:

	alter database open resetlogs;