Home » RDBMS Server » Backup & Recovery » recover database error
recover database error [message #427333] Thu, 22 October 2009 01:54 Go to next message
Loles
Messages: 9
Registered: April 2009
Junior Member
Can somebody help me?

RMAN> run {
2> shutdown immediate;
3> startup mount;
4> set until sequence 4527;
5> restore database;
6> recover database;
7> alter database open resetlogs;
8> }

database closed
database dismounted
Oracle instance shut down

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area     587202560 bytes

Fixed Size                     2022536 bytes
Variable Size                251659128 bytes
Database Buffers             331350016 bytes
Redo Buffers                   2170880 bytes

executing command: SET until clause

Starting restore at 22-OCT-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=157 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /data/oracle/oradata/oragis/system01.dbf
restoring datafile 00002 to /data/oracle/oradata/oragis/undotbs01.dbf
restoring datafile 00003 to /data/oracle/oradata/oragis/sysaux01.dbf
restoring datafile 00004 to /data/oracle/oradata/oragis/users01.dbf
[...]
channel ORA_DISK_1: reading from backup piece /backup/zape/backup_zape_1kksc3ni_ 52_1
ORA-19870: error al leer parte de la copia de seguridad /backup/zape/backup_zape _1kksc3ni_52_1
ORA-19505: fallo al identificar el archivo "/backup/zape/backup_zape_1kksc3ni_52 _1"
ORA-27037: no se ha podido obtener el estado del archivo
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
failover to previous backup

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/22/2009 10:29:52
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
Re: recover database error [message #427337 is a reply to message #427333] Thu, 22 October 2009 02:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Find or uncatalog the missing backup hoping you have another one.

Regards
Michel
Re: recover database error [message #427340 is a reply to message #427337] Thu, 22 October 2009 02:31 Go to previous messageGo to next message
Loles
Messages: 9
Registered: April 2009
Junior Member
I did the backup so:

backup tag 'zipi' as backupset incremental level 0 database;

And when I see the catalog with list backup; I can see the backupset with the datafiles 1 to 4 into it.

I think there is any failure to read the file:
[...]
ORA-19870: error al leer parte de la copia de seguridad /backup/zape/backup_zape _1kksc3ni_52_1
ORA-19505: fallo al identificar el archivo "/backup/zape/backup_zape_1kksc3ni_52 _1"
ORA-27037: no se ha podido obtener el estado del archivo
Linux-x86_64 Error: 2: No such file or directory
[...]

Can it be?

I have verified that the file is owned by the oracle user and the permissions are: -rw-r-----
Re: recover database error [message #427477 is a reply to message #427340] Thu, 22 October 2009 15:55 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Have you verified that the directory /backup/zape has the appropriate privileges?

As the oracle user, can you create a file in the /backup/zape directory?

[Updated on: Thu, 22 October 2009 15:56]

Report message to a moderator

Previous Topic: Incomplete Recover - Srt Until time - Date format
Next Topic: Mirror datafiles
Goto Forum:
  


Current Time: Sun Dec 11 02:19:43 CST 2016

Total time taken to generate the page: 0.21033 seconds