Home » RDBMS Server » Backup & Recovery » Unable to perform restore (Oracle, 10.2.0.4.0, Windows Server 2003)
Unable to perform restore [message #397273] Thu, 09 April 2009 14:04 Go to next message
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 #397279 is a reply to message #397273] Thu, 09 April 2009 14:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
RMAN-06100: no channel to restore a backup or copy of datafile %d
 *Cause:  A datafile, tablespace, or database restore could not proceed
          because the backup of the indicated file exists on a device type
          that was not allocated for restore.
 *Action: None - this is an informational message.  See message 6026 for
          further details.

RMAN-06026: some targets not found - aborting restore
 *Cause:  Some of the files specified for restore could not be found.
          Message 6023, 6024, or 6025 is also issued to indicate which
          files could not be found.  Some common reasons why a file
          can not be restored are that there is no backup
          or copy of the file that is known to recovery manager, or
          there are no backups or copies that fall within the criteria
          specified on the RESTORE command, or some datafile copies have
          been made but not cataloged.
 *Action: The Recovery Manager LIST command can be used to display the
          backups and copies that Recovery Manager
          knows about.  Select the files to be restored from that list.

Regards
Michel
Re: Unable to perform restore [message #397282 is a reply to message #397279] Thu, 09 April 2009 15:28 Go to previous messageGo to next message
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 #397293 is a reply to message #397282] Thu, 09 April 2009 23:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You try to restore from a disk channel, if, for instance, you used a tape channel to backup then a disk channel is unable to restore.
Check the channel you used to backup.
Execute a LIST to see what are your known backups.

Regards
Michel
Re: Unable to perform restore [message #397386 is a reply to message #397293] Fri, 10 April 2009 07:45 Go to previous messageGo to next message
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 #397388 is a reply to message #397386] Fri, 10 April 2009 07:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
And now can you restore?

Regards
Michel
Re: Unable to perform restore [message #397390 is a reply to message #397388] Fri, 10 April 2009 08:04 Go to previous messageGo to next message
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 #397408 is a reply to message #397390] Fri, 10 April 2009 09:11 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I thought we already deal with this.
You need to do a point in time recovery.
Re: Unable to perform restore [message #397411 is a reply to message #397408] Fri, 10 April 2009 09:16 Go to previous message
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 Sad .

Thanks,
Shekhar
Previous Topic: Backup Control file
Next Topic: fixing missing archive in RMAN
Goto Forum:
  


Current Time: Fri Nov 22 08:38:38 CST 2024