| RMAN Recovery [message #273394] |
Wed, 10 October 2007 05:13  |
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  |
Frank Naude
Messages: 4580
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?
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
