recover database error [message #427333] |
Thu, 22 October 2009 01:54 |
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 #427340 is a reply to message #427337] |
Thu, 22 October 2009 02:31 |
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-----
|
|
|
|