| RMAN Recovery [message #285887] |
Thu, 06 December 2007 00:12  |
M.Shakeel Azeem
Messages: 226
Registered: September 2006
|
Senior Member |
|
|
Dear ALL,
i had taken the Hot RMAN backup at location G:\oracle\backup by using 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';
SQL "alter database backup controlfile to trace as ''D:\oracle\backup\Controlfile_Backup_Trace.trc''";
RELEASE CHANNEL disk1;
}
Three backup pieces were created
2 for datafiles
1- 05_RMAN_BACKUP_01J2RQAM_1_1.BAK
2- 05_RMAN_BACKUP_01J2RQAM_1_2.BAK
and 1 for control file autobackup
CONTROLFILE_RMAN_BACKUP_C-1938688979-20071205-00.BAK
Now these all backup pieces are moved from G:\oracle\backup to D:\oracle\backup
i want to restore database from the new location
In 10g its possible by catalog all the backup pieces
RMAN>CATALOG BACKUPPIECE 'D:\oracle\backup\05_RMAN_BACKUP_01J2RQAM_1_1.BAK';
but when i try to execute the same command in 9i i got the following error
RMAN> catalog backuppiece 'D:\oracle\backup\05_RMAN_BACKUP_01J2RQAM_1_1.BAK'
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "backuppiece": expecting one of: "archivelog, ba
ckup, controlfilecopy, clone, datafilecopy"
RMAN-01007: at line 1 column 9 file: standard input
How can we accomplish this in 9i ?
Please suggest.
|
|
|
|
|
|
|
|
|
|
| Re: RMAN Recovery [message #286004 is a reply to message #285887] |
Thu, 06 December 2007 05:03  |
 |
ebrian
Messages: 2794
Registered: April 2006
|
Senior Member |
|
|
|
If possible, create a partition named G: with the same directory structure as before (\oracle\backup) or create a mapped drive named G: and create the same directory structure (\oracle\backup). RMAN will know no difference at this point.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
