- 论坛徽章:
- 0
|
很急啊,RAC的日志问题
The first, if your database is in products env, don't make testing in that, following method can used in test env only!!!
Do you delete a non-current redo log?
if yes. you deleted log file is the redo log that not finish archive operation.now you can do following.
shutdown database immediate(must not be abort)
cold whole backup database(backup current env)
change cluster_database=false
connect the instance you deleted log
alter system archive log stop
change database to non-archive mode
you may startup database
or
startup mount
alter database open resetlog(make sure env, carefully)
if ok
shutdown database immediate
re-startup
cold whole backup database
startup mount
change it to archive mode at each node
alter database open
alter cluster_database=true(restore to RAC mode)
alter system archive log start (start archive operation)
FYI..
if you delete current redo log, so difficultly to restore, need modify "__"prefix oracle internal parameter, and not reference here . |
|