Posted by Mir Sayeed Hassan on February 13th, 2018
Offline (Cold) backup of database in Oracle 11gRr2
Fallow the step by step procedure as shown below:
Shutdown the database
sys@TESTDB>shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
Now manually copy all the datafiles, logfiles, controlfiles, parameter...
Read more..
Posted in RMAN | Comments Off on Offline (Cold) backup of database in Oracle 11gRr2
Posted by Mir Sayeed Hassan on February 13th, 2018
Online (Hot) backup of datafile
To perform the online backup of the database, the database should be running in archivelog mode, below query:
Check the database Instance Name & Version
sys@TESTDB>select INSTANCE_NAME, VERSION from v$instance;
INSTANCE_NAME VERSION
——————————------------------
testdb ...
Read more..
Posted in RMAN | Comments Off on Online (Hot) backup of datafile in Oracle database 11gR2
Posted by Mir Sayeed Hassan on February 13th, 2018
Disable database in NOARCHIVELOG mode in Oracle database 11gR2
Check the database Instance Name & Version
sys@TESTDB>select INSTANCE_NAME, VERSION from v$instance;
INSTANCE_NAME VERSION
---------------- ----------
testdb 11.2.0.4.0
Check the status of the...
Read more..
Posted in RMAN | Comments Off on Disable database in NOARCHIVELOG mode in Oracle database 11gR2
Posted by Mir Sayeed Hassan on February 13th, 2018
Enable database in Archivelog mode in Oracle database 11gR2
Check the database Instance Name & Version
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
Managing the UNDO TABLESPACE in Oracle database 11gR2
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.
The Undo records are more used as shown below:
- Rollback the transactions when a ROLLBACK statement is issued
- Recover...
Read more..
Posted in DBA Administration | Comments Off on Managing the UNDO TABLESPACE in Oracle database 11gR2
Posted by Mir Sayeed Hassan on February 12th, 2018
Managing Multiplexing of Control Files in Oracle database 11gR2
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
The control file contains:
- The database name
- Name & location of datafiles...
Read more..
Posted in DBA Administration | Comments Off on Managing Multiplexing of Control Files in Oracle database 11gR2
