Home » RDBMS Server » Backup & Recovery » RMAN Recovery
RMAN Recovery [message #285887] Thu, 06 December 2007 00:12 Go to next message
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 #285889 is a reply to message #285887] Thu, 06 December 2007 00:16 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Please read the OraFAQ Forum Guide before posting.
Re: RMAN Recovery [message #285890 is a reply to message #285887] Thu, 06 December 2007 00:27 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

You can't catalog of one database copy from a database other than the connected target database.

[Updated on: Thu, 06 December 2007 00:31]

Report message to a moderator

Re: RMAN Recovery [message #285891 is a reply to message #285887] Thu, 06 December 2007 00:29 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

And also I suspect in oracle database 9i backup piece was not available.
Re: RMAN Recovery [message #286004 is a reply to message #285887] Thu, 06 December 2007 05:03 Go to previous message
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.
Previous Topic: Archive log issue
Next Topic: SCN no.
Goto Forum:
  


Current Time: Fri Dec 09 23:15:51 CST 2016

Total time taken to generate the page: 0.10528 seconds