Unable to perform restore [message #397273] |
Thu, 09 April 2009 14:04 |
shekharnegi12
Messages: 52 Registered: October 2008
|
Member |
|
|
Hello,
I'm trying to perform a restore from the available backup set and it doesnt work. Following is what I'm doing:
RMAN> shutdown immediate;
database dismounted
Oracle instance shut down
RMAN> startup nomount;
connected to target database (not started)
Oracle instance started
Total System Global Area 1845493760 bytes
Fixed Size 1299988 bytes
Variable Size 176163308 bytes
Database Buffers 1660944384 bytes
Redo Buffers 7086080 bytes
RMAN> restore database;
Starting restore at 09-APR-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=486 devtype=DISK
RMAN-00571: =====================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =========
RMAN-00571: =====================================================
RMAN-03002: failure of restore command at 04/09/2009 14:59:38
ORA-01507: database not mounted
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
RMAN> restore database;
Starting restore at 09-APR-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=486 devtype=DISK
RMAN-00571: =====================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =========
RMAN-00571: =====================================================
RMAN-03002: failure of restore command at 04/09/2009 15:00:01
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of datafile 41
RMAN-06100: no channel to restore a backup or copy of datafile 40
RMAN-06100: no channel to restore a backup or copy of datafile 39
RMAN-06100: no channel to restore a backup or copy of datafile 38
RMAN-06100: no channel to restore a backup or copy of datafile 37
RMAN-06100: no channel to restore a backup or copy of datafile 36
RMAN-06100: no channel to restore a backup or copy of datafile 35
RMAN-06100: no channel to restore a backup or copy of datafile 33
RMAN-06100: no channel to restore a backup or copy of datafile 32
RMAN-06100: no channel to restore a backup or copy of datafile 31
RMAN-06100: no channel to restore a backup or copy of datafile 30
RMAN-06100: no channel to restore a backup or copy of datafile 29
RMAN-06100: no channel to restore a backup or copy of datafile 28
RMAN-06100: no channel to restore a backup or copy of datafile 27
RMAN-06100: no channel to restore a backup or copy of datafile 26
RMAN-06100: no channel to restore a backup or copy of datafile 25
RMAN-06100: no channel to restore a backup or copy of datafile 24
RMAN-06100: no channel to restore a backup or copy of datafile 23
RMAN-06100: no channel to restore a backup or copy of datafile 22
RMAN-06100: no channel to restore a backup or copy of datafile 21
RMAN-06100: no channel to restore a backup or copy of datafile 20
RMAN-06100: no channel to restore a backup or copy of datafile 19
RMAN-06100: no channel to restore a backup or copy of datafile 18
RMAN-06100: no channel to restore a backup or copy of datafile 17
RMAN-06100: no channel to restore a backup or copy of datafile 16
RMAN-06100: no channel to restore a backup or copy of datafile 15
RMAN-06100: no channel to restore a backup or copy of datafile 14
RMAN-06100: no channel to restore a backup or copy of datafile 13
RMAN-06100: no channel to restore a backup or copy of datafile 12
RMAN-06100: no channel to restore a backup or copy of datafile 11
RMAN-06100: no channel to restore a backup or copy of datafile 10
RMAN-06100: no channel to restore a backup or copy of datafile 8
RMAN-06100: no channel to restore a backup or copy of datafile 6
RMAN-06100: no channel to restore a backup or copy of datafile 5
RMAN-06100: no channel to restore a backup or copy of datafile 4
RMAN-06100: no channel to restore a backup or copy of datafile 3
RMAN-06100: no channel to restore a backup or copy of datafile 2
RMAN-06100: no channel to restore a backup or copy of datafile 1
Please help its urgent!
Thanks,
SN
|
|
|
|
Re: Unable to perform restore [message #397282 is a reply to message #397279] |
Thu, 09 April 2009 15:28 |
shekharnegi12
Messages: 52 Registered: October 2008
|
Member |
|
|
I appreciate your quick response Michel.
the backup of the indicated file exists on a device type that was not allocated for restore.
If the above is true should I be able to see the backupset when I issue list backup? I mention this because when I run this command I see all backup files with its tag number showing the exact location of my backup.
some datafile copies have been made but not cataloged.
I have not cataloged my DB backup. Do i need to do that? If yes can you please help me with that?
Thanks,
SN
|
|
|
|
Re: Unable to perform restore [message #397386 is a reply to message #397293] |
Fri, 10 April 2009 07:45 |
shekharnegi12
Messages: 52 Registered: October 2008
|
Member |
|
|
Rman>backup database plus archivelog;
Starting backup at 10-APR-09
current log archived
using target database control file instead of recovery catalog
allocated channel: [B]ORA_DISK_1[/B]
channel ORA_DISK_1: sid=414 devtype=DISK
skipping archive log file E:\ORACLE\FLASH_RECOVERY_AREA\NGS1\ARCHIVELOG\2009_04_
01\O1_MF_1_310_4X7O876J_.ARC; already backed up 1 time(s)
skipping archive log file E:\ORACLE\FLASH_RECOVERY_AREA\NGS1\ARCHIVELOG\2009_04_
01\O1_MF_1_311_4X7WHQK7_.ARC; already backed up 1 time(s)
skipping archive log file E:\ORACLE\FLASH_RECOVERY_AREA\NGS1\ARCHIVELOG\2009_04_
01\O1_MF_1_312_4X7ZVPLZ_.ARC; already backed up 1 time(s)
skipping archive log file E:\ORACLE\FLASH_RECOVERY_AREA\NGS1\ARCHIVELOG\2009_04_
01\O1_MF_1_313_4X89F5FH_.ARC; already backed up 1 time(s)
skipping archive log file E:\ORACLE\FLASH_RECOVERY_AREA\NGS1\ARCHIVELOG\2009_04_
02\O1_MF_1_314_4X8MNBCW_.ARC; already backed up 1 time(s)
[I]channel ORA_DISK_1:[/I] starting piece 1 at 10-APR-09
I think I'm using disk channel and not tape channel (sbt).
Execute a LIST to see what are your known backups.
Thats what I was refering yesterday that I can see the backupset when I issue list backup on my DB. Please suggest..
|
|
|
|
Re: Unable to perform restore [message #397390 is a reply to message #397388] |
Fri, 10 April 2009 08:04 |
shekharnegi12
Messages: 52 Registered: October 2008
|
Member |
|
|
The above I copied was from yesterday's backup so no I cant restore. I know that the backup is correct and its been recognized by the DB. I'm missing something that has to be done before restore. Please suggest.
|
|
|
|
Re: Unable to perform restore [message #397411 is a reply to message #397408] |
Fri, 10 April 2009 09:16 |
shekharnegi12
Messages: 52 Registered: October 2008
|
Member |
|
|
Hey Mahesh,
Well the Point in time recovery never worked for me. I've started all over again but this time the different(good) thing is that my RMAN recognizes the backupset but doesn't cooperate to restore. I know you have wasted too much time with me. I apologize for that .
Thanks,
Shekhar
|
|
|