Amit Oracle DBA Blog

This blog is to share oracle concept and real time experience for Oracle beginner.....

Wednesday, 1 April 2015

ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation ORA-06512: at “SYS.UTL_FILE”, ORA-29283: invalid file operation

When doing export occur above error, let’s check directories: SQL> select directory_name, directory_path from dba_directories DIREC...

Tuesday, 31 March 2015

How to clone the Oracle database software

This note describes the process of cloning an Oracle Home - in this case we are cloning 11g Release 2 Oracle Home from source machine ...

Wednesday, 25 February 2015

Recovery from complete loss of all online redo log files using RMAN

STEP 1: Check database details. SQL> select instance_name,version from v$instance; INSTANCE_NAME VERSION ---------------...

Friday, 20 February 2015

Database Point-In-Time Recovery

STEP 1: Note the current database clock time SQL> select to_char(sysdate,'DD-MON-YY:HH24:MI:SS') from dual; TO_CHAR...

Thursday, 19 February 2015

RMAN-06059: expected archived log not found, loss of archived log compromises recoverability

While RMAN full backup, you may encountered “RMAN-06059: expected archived log not found, loss of archived log compromises recoverability”...

View web version

Powered by Blogger.