Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

Configuring AUTOBACKUP of CONTROLFILE and SPFILE in Oracle database 11gR2

Posted by Mir Sayeed Hassan on February 17th, 2018

Configuring AUTOBACKUP of CONTROLFILE and SPFILE in Oracle database 11gR2

 Whenever you perform any RMAN backup, Configure the Control file & SPFILE

 To setup the control file & spfile auto backup

RMAN>; configure controlfile autobackup... 
Read more..

Posted in RMAN | Comments Off on Configuring AUTOBACKUP of CONTROLFILE and SPFILE in Oracle database 11gR2

Script to automatically startup and shutdown the Oracle database 11gR2

Posted by Mir Sayeed Hassan on February 17th, 2018

Script to automatically startup and shutdown the Oracle database 11gR2

Fallow the below step by step procedure as shown below:

Create the directory as shown below:

[oracle@ogg-test1 ~]$ pwd
/home/oracle
[root@oracleTestServer ~]# mkdir -p /home/oracle/scripts
[root@oracleTestServer... 
Read more..

Posted in DBA Scripts | Comments Off on Script to automatically startup and shutdown the Oracle database 11gR2

Configuring Retention Policy in RMAN in Oracle database 11gR2

Posted by Mir Sayeed Hassan on February 14th, 2018

Configuring Retention Policy in RMAN in Oracle database 11gR2

RMAN Configuration retention policy is a feature to avoid the manually deleting the old backup files from the disk in an Oracle database 11g2

Configuring this retention policy is much easily to delete the old backup by setting up as per your requirement

Now...
Read more..

Posted in RMAN | Comments Off on Configuring Retention Policy in RMAN in Oracle database 11gR2

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

Posted by Mir Sayeed Hassan on February 14th, 2018

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

Find the below error while starting of the database

SQL>; startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 4.8103E+10 bytes
Fixed Size                 ... 
Read more..

Posted in ORA-Error | Comments Off on ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

Backup database when NOARCHIVELOG Mode by using RMAN in Oracle database 11gR2

Posted by Mir Sayeed Hassan on February 13th, 2018

Backup database when NOARCHIVELOG Mode by using RMAN in Oracle database 11gR2

Consider the database is running in noarchivelog mode, in this case you can take only the offline full db backup & cannot take the online backup

If you want to take the full db backup in noarchivelog mode, the db should...
Read more..

Posted in RMAN | Comments Off on Backup database when NOARCHIVELOG Mode by using RMAN in Oracle database 11gR2

ORA-01157/ORA-01110: cannot identify/lock data file 12 – see DBWR trace file

Posted by Mir Sayeed Hassan on February 13th, 2018

ORA-01157/ORA-01110: cannot identify/lock data file 12 – see DBWR trace file

As you can see while starting of the database, the datafile 12 is missing/corrupted and through the ora error as shown:

sys@TESTDB> startup
ORACLE instance started.
Total System Global Area 2455228416 bytes
Fixed Size                 ... 
Read more..

Posted in ORA-Error | Comments Off on ORA-01157/ORA-01110: cannot identify/lock data file 12 – see DBWR trace file

« Previous Entries
Next Entries »