on 03-23-2009 3:55 AM
Hi,
i did a whole database online & redo log backup thru db13 on my bi 7 running on oracle 10.2g.
after the job, i can see 1 arch file (....3718....dbf) in oraarch folder. The job show as finish. I can view the detail log for both brbackup and brarchive.
when i did a restore to a new server, the restore job ask for arch file 3719 that doesn't exist in the oraarch folder.
when i startup, i can see the last brbackup and brarchive, but the job show as finish with error. No detail log for both brbackup and brarchive. I check, both sapbackup and saparchive folders exist.
My question:
- why did the job show as finish with error?
- why no detail shown for brbackup and brarchive?
- why did the restore job ask for arch file that doesn't exist?
- how so that i can see the same view as in the original?
thank you.
regards,
zl
ZL,
I would suggest you to go through the sapbackup directory (on source server) for the log information. In the meantime, if you know the exact timings you may want to try for oracle time based recovery. Remember this time has to be just before 3719 dbf.
Example:
SQL> STARTUP MOUNT
SQL> RECOVER DATABASE UNTIL TIME '2009-03-21:11:00:00';
SQL> ALTER DATABASE OPEN RESETLOGS;
Hope this helps.
Manoj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I checked, the brbackup is done between 12:14 till 12:51.
and the brarchive is between 12:51 till 13:12
and the only offline redo log xxx3718.dbf is on 12:44
I am restoring the control file from the brbackup.
does that mean others still in online redo log of the source system?
how to apply those from the online redo log?
is it possible to recover until 13:12?
regards,
zl
User | Count |
---|---|
84 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.