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
Posted in RMAN | Comments Off on Configuring Retention Policy in RMAN in Oracle database 11gR2
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
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
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
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
