Hi,
I need a little help with Recovery. This is my testcase:
- Database running on virtual machine (linux) in archivelog
- nightly snapshot-based backup of the whole virtual machine
- archivelogs are duplicated on local disk and remote disk (via sshfs and log_archive_dest_2)
At lunch I recover the whole nightly snapshot for simulating a disaster. These are my steps to bring back the Database to the last possible time with only archivelogs - I know that some data is lost now.
- copy the missing archivelogs from the sshfs to the local host (virtual machine)
- start the the database in mount -mode
- connect rman
CATALOG START WITH /path/ - to get the missing archivelogs (sequence 11-20)- RECOVER DATABASE UNTIL SEQUENCE 21;
Ausgabe von 5.:
starting media recovery
archived log for thread 1 with sequence 11 is already on disk as file /ora/archiv/KITA_1_11_875808530.dbf
archived log for thread 1 with sequence 12 is already on disk as file /ora/archiv/KITA_1_12_875808530.dbf
archived log for thread 1 with sequence 13 is already on disk as file /ora/archiv/KITA_1_13_875808530.dbf
archived log for thread 1 with sequence 14 is already on disk as file /ora/archiv/KITA_1_14_875808530.dbf
archived log for thread 1 with sequence 15 is already on disk as file /ora/archiv/KITA_1_15_875808530.dbf
archived log for thread 1 with sequence 16 is already on disk as file /ora/archiv/KITA_1_16_875808530.dbf
archived log for thread 1 with sequence 17 is already on disk as file /ora/archiv/KITA_1_17_875808530.dbf
archived log for thread 1 with sequence 18 is already on disk as file /ora/archiv/KITA_1_18_875808530.dbf
archived log for thread 1 with sequence 19 is already on disk as file /ora/archiv/KITA_1_19_875808530.dbf
archived log for thread 1 with sequence 20 is already on disk as file /ora/archiv/KITA_1_20_875808530.dbf
archived log file name=/ora/archiv/KITA_1_11_875808530.dbf thread=1 sequence=11
archived log file name=/ora/archiv/KITA_1_12_875808530.dbf thread=1 sequence=12
archived log file name=/ora/archiv/KITA_1_13_875808530.dbf thread=1 sequence=13
archived log file name=/ora/archiv/KITA_1_14_875808530.dbf thread=1 sequence=14
archived log file name=/ora/archiv/KITA_1_15_875808530.dbf thread=1 sequence=15
archived log file name=/ora/archiv/KITA_1_16_875808530.dbf thread=1 sequence=16
archived log file name=/ora/archiv/KITA_1_17_875808530.dbf thread=1 sequence=17
archived log file name=/ora/archiv/KITA_1_18_875808530.dbf thread=1 sequence=18
archived log file name=/ora/archiv/KITA_1_19_875808530.dbf thread=1 sequence=19
archived log file name=/ora/archiv/KITA_1_20_875808530.dbf thread=1 sequence=20
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/ora/data/KITA/system01.dbf'
media recovery complete, elapsed time: 00:00:36
Finished recover at 01-APR-15
I don't know why this happens. Afterwards I did recover database;alter database open; and everything is working, expect the fact, that the archivelog with sequence number 11 is overwritten (that would be correct if I didn't make the recover). I checked ARCHIVE LOG LIST:
archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /mnt/sshfs/archiv/KITA
Oldest online log sequence 9
Next log sequence to archive 11
Current log sequence 11
What's wrong with my plan? How can I avoid that the database overwrites the archivelogs?
Thanks for help.