Posted by Mir Sayeed Hassan on February 13th, 2018
sys@TESTDB>select INSTANCE_NAME, VERSION from v$instance; INSTANCE_NAME VERSION ---------------- ---------- testdb 11.2.0.4.0
Posted in RMAN | Comments Off on Disable database in NOARCHIVELOG mode in Oracle database 11gR2
Posted by Mir Sayeed Hassan on February 13th, 2018
sys@TESTDB>select INSTANCE_NAME, VERSION from v$instance; INSTANCE_NAME VERSION ---------------- ----------------- testdb 11.2.0.4.0
Posted in RMAN | Comments Off on Enable database in Archivelog mode in Oracle database 11gR2
Posted by Mir Sayeed Hassan on February 12th, 2018
In an Oracle DB the undo tbs is used for maintaining the information that is used to rollback or any undo changes to the database.
Posted in DBA Administration | Comments Off on Managing the UNDO TABLESPACE in Oracle database 11gR2
Posted by Mir Sayeed Hassan on February 12th, 2018
As per the Oracle DB, every db has its own controlfile; the control file is a binary file that records the physical structure of the db
Posted in DBA Administration | Comments Off on Managing Multiplexing of Control Files in Oracle database 11gR2
Posted by Mir Sayeed Hassan on February 10th, 2018
The temporary tablespace is basically used for sorting the large tables in database & database should contain 1 temp tbs in it, this temp tbs are created while creation of the database itself, Therefore if it requires you can create multiple temp tbs in the database.
sys@TESTDB>...Read more..
Posted in DBA Administration | Comments Off on Managing Temporary Tablespaces in Oracle database 11gR2
Posted by Mir Sayeed Hassan on February 10th, 2018
To Increase/extend the Size of a tablespace
Method 1 – Increase/Extend the size of the tbs using the resize keyword as shown below:
sys@TESTDB> select INSTANCE_NAME, VERSION from v$instance; INSTANCE_NAME ...Read more..
Posted in DBA Administration | Comments Off on Increase or decrease the size of Tablespace and Datafiles in Oracle database 11gR2