Home » RDBMS Server » Backup & Recovery » Manual Hot Backup in Oracle 11gR2 (Oracle 11g R2, Windows)
Manual Hot Backup in Oracle 11gR2 [message #662169] Wed, 19 April 2017 23:43 Go to next message
1982Hashmi
Messages: 69
Registered: March 2011
Location: Islamabad
Member
I want to take & restore from hot backup without using RMAN. But It generates error at Step No. 7 while restoring. Can anybody help with that.

==================================================================================
                                   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;
Re: Manual Hot Backup in Oracle 11gR2 [message #662173 is a reply to message #662169] Thu, 20 April 2017 00:40 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

MY INPUT: Pressed ENTER, as this archive file does not exist in Archive Log backup folder
The instruction is clear: if the suggested archive file does not exist, do not press ENTER. Give it CANCEL.
Re: Manual Hot Backup in Oracle 11gR2 [message #662175 is a reply to message #662173] Thu, 20 April 2017 01:03 Go to previous message
1982Hashmi
Messages: 69
Registered: March 2011
Location: Islamabad
Member
Thanks.
Previous Topic: Error ORA - 19870 error while restoring backup piece ...
Next Topic: Not able to open database in Oracle
Goto Forum:
  


Current Time: Fri Mar 29 08:53:07 CDT 2024