| Questions [message #237760] |
Tue, 15 May 2007 11:26  |
california_6_1
Messages: 29
Registered: February 2007
|
Junior Member |
|
|
I have few questions and would greatly appreciate, if someone please take a moment to answer these:
Undo tablespace: Just curious what will happen, if the undo tablespaces files are deleted, when the database is running? The database is runnig on Sun solaris and it's a oracle 10g version.
Redo logs: I have placed a user tablespace in backup mode. EG: Alter tablespace users begin backup. what happens if i leave the tablespace in backup mode(for 5 or 10 days) and the database is getting heavily populated?
Appreciated the answer.
Many thanks,
Cali
|
|
|
|
| Re: Questions [message #237944 is a reply to message #237760] |
Wed, 16 May 2007 03:22  |
Frank Naude
Messages: 4581
Registered: April 1998
|
Senior Member |
|
|
| Quote: | what will happen, if the undo tablespaces files are deleted, when the database is running
|
You will get nasty errors and the database will most likely crash. Don't try it!
| Quote: | what happens if i leave the tablespace in backup mode(for 5 or 10 days) and the database is getting heavily populated?
|
Database will write an enormous amount to redo, slowing down all transactions. The database will most likely get stuck. Again, not recommended for production systems. Rather switch to RMAN backups (no need for BEGIN BACKUP statements).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
