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..

Error while starting of Oracle Single instance ASM Database 1st Error – Starting ASM [code] [root@asmdb ~]#su – grid [/code] [code] [grid@asmdb ~]$ asmcmd [/code] Connected to an idle instance [code] ASMCMD> ls [/code] ASMCMD-08102: no connection to ASM; command requires ASM… Read more..

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..

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/

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..

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..