Posted by Mir Sayeed Hassan on 17th September 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/
Posted in ORA-Error | Comments Off on ORA-Error – 01111/ORA-01110/ORA-01157 name the datafile is unKnown
Posted by Mir Sayeed Hassan on 17th September 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
Posted by Mir Sayeed Hassan on 10th September 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