Oracle 10gR2 Encore un autre problème RMAN-06023
Bonjour à tous,
Après avoir recherché sur ce forum et sur autres Oracle, étant débutant avec l'outil RMAN, je suis un peu embêté sur ce point...
Mon SGBB est Oracle 10gR2, dont le filesystem a crashé il y a 2 semaines et a depuis été remonté. Reste maintenant à restaurer la base depuis les sauvegardes RMAN (dont je n'ai aucune connaissance).
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
|
RMAN> restore controlfile from '/swapcom/flash_recovery_area/SWAPCOM/backupset/backupset/2007_08_02/o1_mf_ncsn1_TAG20070802T172400_3c3yckh7_.bkp';
Starting restore at 30-AUG-07
using channel ORA_DISK_1
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output filename=/export/swapcom/oracle/oradata/swapcom/swapcom/control01.ctl
output filename=/export/swapcom/oracle/oradata/swapcom/swapcom/control02.ctl
output filename=/export/swapcom/oracle/oradata/swapcom/swapcom/control03.ctl
Finished restore at 30-AUG-07
RMAN> restore spfile from '/swapcom/flash_recovery_area/SWAPCOM/backupset/backupset/2007_08_02/o1_mf_ncsn1_TAG20070802T172400_3c3yckh7_.bkp';
Starting restore at 30-AUG-07
using channel ORA_DISK_1
channel ORA_DISK_1: autobackup found: /swapcom/flash_recovery_area/SWAPCOM/backupset/backupset/2007_08_02/o1_mf_ncsn1_TAG20070802T172400_3c3yckh7_.bkp
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 30-AUG-07
RMAN> startup mount
database is already started
database mounted
released channel: ORA_DISK_1
RMAN> restore database;
Starting restore at 30-AUG-07
Starting implicit crosscheck backup at 30-AUG-07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=157 devtype=DISK
Crosschecked 62 objects
Finished implicit crosscheck backup at 30-AUG-07
Starting implicit crosscheck copy at 30-AUG-07
using channel ORA_DISK_1
Crosschecked 8 objects
Finished implicit crosscheck copy at 30-AUG-07
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/30/2007 15:24:59
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 |
Merci beaucoup pour toute idée qui me permettrait de me sortir de cette situation...
