Recently one of our database was migrated. After migration DB is up and running, But we found below errors in the alert log.
Errors in file /oracle/app/oracle/admin/test/diag/rdbms/b2btrn/TEST/trace/test_ora_20464.trc:
ORA-01157: cannot identify/lock data file 205 – see DBWR trace file
ORA-01110: data file 205: ‘/test/oradata/b2btrn/tempfile/temp1.304.921456819′
Now I queried dba_temp_files, and got the same error.
SQL> select (more...)
While dropping a tablespace, getting error ORA-38301: can not perform DDL/DML over objects in Recycle Bin .
SQL> drop tablespace DATA including contents and datafiles;
drop tablespace DATA including contents and datafiles
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-38301: can not perform DDL/DML over objects in Recycle Bin
Before dropping the tablespace, disable recyclbin .
1. Disable recyclebin:
SQL> ALTER SYSTEM SET recyclebin (more...)
While running rman commands from the catalog database, you might get the error RMAN-20005: target database name is ambiguous. , if the database was restored from another database.
rman target sys/oracle#51234@RMANBKP catalog rman_b2ccrmpd/rman@catdb
Recovery Manager: Release 220.127.116.11.0 – Production on Fri Oct 14 10:34:05 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to (more...)