Mir Sayeed Hassan – Oracle Blog

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

ORA-01110: data file 1: ‘/oradata/datafiles/system01.dbf’

Posted by Mir Sayeed Hassan on September 17th, 2017

ORA-01110: data file 1: ‘/oradata/datafiles/system01.dbf’

Error occur while restoring the database from the backup of RMAN

RMAN> alter database open resetlogs;

using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
 RMAN-00569: ===============... 
Read more..

Posted in ORA-Error | Comments Off on ORA-01110: data file 1: ‘/oradata/datafiles/system01.dbf’

ORA-Error – 01111/ORA-01110/ORA-01157 name the datafile is unKnown

Posted by Mir Sayeed Hassan on September 17th, 2017

ORA-Error – 01111/ORA-01110/ORA-01157 name the datafile is unknown

Cause:

This error will occur on standby database after adding the new datafile into primary database

Solution: If you’re standby database is file system storage

View the error in alert log

[oracle@db-std ~]$ cd /u01/app/oracle/diag/rdbms/teststdby/teststdby/trace/
Read more..

Posted in ORA-Error | Comments Off on ORA-Error – 01111/ORA-01110/ORA-01157 name the datafile is unKnown

ORA-19606: Cannot copy or restore to snapshot control file

Posted by Mir Sayeed Hassan on September 17th, 2017

Solution: error cannot copy or restore to snapshot control file in RMAN

Step by step procedure:

[code] $ rman target / [/code]

[code] RMAN> show all; [/code]

using target database control file...

Read more..

Posted in ORA-Error | Comments Off on ORA-19606: Cannot copy or restore to snapshot control file

How to drop or recreate TEMP Tablespace in Oracle 11g (11.2) Database

Posted by Mir Sayeed Hassan on September 10th, 2017

First Verify the Temp TBS Exist in database

[code]SQL> select * from v$tempfile;

FILE# CREATION_CHANGE# CREATION_ TS# RFILE# STATUS ENABLED BYTES BLOCKS CREATE_BYTES...

Read more..

Posted in ORA-Error | Comments Off on How to drop or recreate TEMP Tablespace in Oracle 11g (11.2) Database