Home » RDBMS Server » Backup & Recovery » RMAN Recovery
RMAN Recovery [message #273394] Wed, 10 October 2007 05:13 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Oracle Version: 9.2.0.1.0
Operating System: windows server 2003
Question (including full error messages and setup scripts where applicable):

Dear All,

I m testing RMAN Backup and Recovery
i had taken the backup with the following script

CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK

TO 'D:\oracle\backup\CONTROLFILE_RMAN_BACKUP_%F.bak';
RUN
{
ALLOCATE CHANNEL disk1 DEVICE TYPE DISK MAXPIECESIZE = 1G FORMAT 'D:\oracle\backup\%D_RMAN_BACKUP_%U.bak';
BACKUP DATABASE TAG 'FULL_BACKUP';
RELEASE CHANNEL disk1;
}


The above backup script create the following backupsets at specified location D:\oracle\backup

1- CONTROLFILE_RMAN_BACKUP_C-812287729-20071004-00.BAK
2- 04_RMAN_BACKUP_2HITL2TI_2_1.BAK
3- 04_RMAN_BACKUP_2HITL2TI_1_1.BAK

Now due to space issue i had put these backupsets at c:\backup
Next i had deleted user01.dbf belonging to users tablespace manually to test recovery process
Can u please tell me how can i recover the users tablespace by using RMAN backup which was moved to c:\backup
but that RMAN backup was taken at D:\oracle\backup

Although i had tested it in 10g by simply catalog the backupsets
RMAN>catalog backuppiece 'd:\oracle\backup\CONTROLFILE_RMAN_BACKUP_C-812287729-20071004-00.BAK'
RMAN>catalog backuppiece 'd:\oracle\backup\04_RMAN_BACKUP_2HITL2TI_2_1.BAK'
RMAN>catalog backuppiece 'd:\oracle\backup\04_RMAN_BACKUP_2HITL2TI_1_1.BAK'

But how to do it in 9i ?

Thanx in advance
Re: RMAN Recovery [message #273406 is a reply to message #273394] Wed, 10 October 2007 06:18 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Have you tried to un-catalog the backup pieces from D:\oracle\backup and re-catalog them under c:\backup? If so, what errors did you get?
Re: RMAN Recovery [message #273748 is a reply to message #273406] Thu, 11 October 2007 10:02 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
In 9i, You cannot catalog backup sets or pieces.

Source: http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmmaint.htm#456321
Re: RMAN Recovery [message #273804 is a reply to message #273748] Thu, 11 October 2007 14:01 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
What a bummer Sad

Looks like one should use "backup backupset" to move backupsets to a different location in 9i.
Previous Topic: AUTOMATIC SCRIPT TO RECOVER A STANDBY
Next Topic: Can you instruct me to delete expired backup?
Goto Forum:
  


Current Time: Fri Dec 02 12:20:14 CST 2016

Total time taken to generate the page: 0.10069 seconds