In this article, we will see how tablespaces are managed in a Multi-tenant architecture. Mainly we have 4 types of tablespaces System Tablespace. User permanent tablespace. Temporary tablespace. Undo tablespace. System tablespace must be created while creating a database using either DBCA or manually. SQL> select name,con_id from v$datafile where name like ‘%system%’; NAME CON_ID […]
Articles Tagged: Tablespace
Tablespaces Info for upgrading to 18c
To help you keep track of your tablespace allocations, the following AUTOEXTEND tablespaces are expected to successfully EXTEND during the upgrade process. Tablespace Size Min Size For Upgrade ———- ———- ———– SYSAUX 490 MB 718 MB SYSTEM 750 MB 1194 MB TEMP 54 MB 150 MB UNDOTBS1 85 MB 446 MB Minimum tablespace sizes for […]
ORA-00959 Error while trying to drop a tablespace
Scenario: A tablespace has been created in the database through a script using Mixed case.Now we want to drop the tablespace. SQL> select tablespace_name,status from dba_tablespaces; TABLESPACE_NAME STATUS ————————– ——— SYSTEM ONLINE SYSAUX […]
Recover from a loss of the SYSTEM tablespace on the original location
Recovery is an important process for any kind of organization. if the database can not recover properly That is the worst condition of any DBA‘s professional because it causes unlivable loss of an organization. We have many kinds of solutions to restore the database according to the loss of database. We are going to have […]
Recover loss of a non-system tablespace with the RMAN Data Recovery Advisor
These steps are for recovery in which we will know about how to recover from a loss of a non-system tablespace on the same location while the database is closed. Normally our database is always in open mode. In some cases we can face error ORA-01157: cannot identify/lock data file %s – see DBWR trace file” […]
Recover from a loss of a non-system tablespace on the same location while the database is open
We are going to have a look on the steps which are followed by DBA to recover a loss of a non-system tablespace on the same location while the database is open. When we lose a non-system tablespace you cannot access and query only objects that were created on their datafiles Meanwhile users can continue to […]
Recover from a loss of a temporary tablespace
This article is about a recovery of temporary tablespace. As we know that Temporary tablespaces are used to manage space for database sort operations and for storing global temporary tables. For example, if you join two large tables, and Oracle cannot do the sort in memory (see SORT_AREA_SIZE initialization parameter), space will be allocated in […]