Recently I discovered in a legacy Oracle 220.127.116.11.0 database that the tablespace holding de AUD$ table has been in backup mode for six months. Dunno who issued the begin backup command on it six moths ago.
- The scheduled backups are cold backups that will not issue a end backup command on any tablespace. The database can be shutdown and started up with no problemo.
- The datafiles belonging to the AUD$ tables have a modification date of just right now.
- When you query the AUD$ table you can see that it's being updated almost every minute. This table is inserted data continously.
- I understand that REDO information is generated when a datafile is in active backup mode but that tablespace has been un backup mode for six months for Pete's sake.
- Can this tablespace cotinue in active backup mode forever with no consequences?
- Is there a risk of losing data?
- Is this a disaster waiting to happen?
- What exactly is happening here?