Noarchivelog 11.2.0.1 Restart
- From: Ed Long <rdhm99a@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 21 Jan 2011 10:08:22 -0800 (PST)
Hi everyone and happy Friday.
I have a benchmark system that I can't get to restart and need your advice.
Please understand that I've spent half a day on the RMAN user guide and
reference without success.
Here is the sequence that has worked up to now.
1: Create LEVEL 0 backup using RMAN.
2: Run Real Application Test test.
3: recycle system to mount mode.
3: Restore backup.
4: Recover to SCN. (No real logs to apply).
5: start open.
None of the recover until options appear to work.
I have an export of the application database so I can if necessary drop the
database and start over again. However, I want to understand this recovery
scenario so if it happens in the future on a system I don't have an export of I
understand my options.
All of my options end up with the system table space off line. I don't see a
way to get it back online.
RMAN 11003 appears to be the root of the problem although the version I'm
seeing is garbled.
Edward Long
Other related posts:
