on 01-16-2009 7:28 PM
on a system crash,
we restored yesterday night online backup , but it does not have online redo log files?
All data files, Control & we have all archive logs.
How to go forwards
Rgds
Hi Srini...
You will be able to recover data till the last archive log file which was created . The data which was in online redo log file just before the crash either will be recovered automatically on database startup ( The Transaction if incomeplete will be rolled back ) .
Thanks
Aashish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Srinivas,
The online backup doesn't backs up the online redo logs as Stefan already mentioned. Also, it doesn't backs up the tempfiles.
As you already mentioned, you have the archive logs backed up. So it shouldn't be a problem. You can restore your database, recover it starting from the start time of the backup being used for restoration till the last archive log backed up. Afterwards, perform a ALTER DATABASE OPEN RESETLOGS;
This should help you get back the crashed DB in a consistent state. Also, don't forget to create your tempfiles later.
Regards,
Deoraj Alok.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
> we restored yesterday night online backup , but it does not have online redo log files?
That is a normal behaviour.
The online redolog files are never backuped, because they would be inconsistent by an online backup.
The online redolog files are automatically created by an "ALTER DATABASE OPEN RESETLOGS".
If you want to perform a complete recovery you will need the online redolog files from your crashed system.
If the online redolog files are lost, recover your database as far as possible (available archived logs) and perform an open resetlogs.
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi there,
you may want to use BRRECOVER instead. It will determine which archive logs need to be restored and trigger BRRESTORE appropriately.
regards,
Lars
BTW: there's this funny thing called documentation [http://help.sap.com] ...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
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.