Firstly you must enable flashback features in mount mode. You can check url https://www.roamway.com/2792.html for details. Example: Flashback database to specified time SQL> shutdown immediate;…

Execute the following command to check frequency of redo log switch in every hours of every day. SELECT TO_CHAR(first_time, ‘YYYY-MON-DD’) DAY , TO_CHAR(SUM(DECODE(TO_CHAR(first_time, ‘HH24′), ’00’,…

Check status of redo logs SQL> set line 800 pages 1000;SQL> col member for a90;SQL> col name for a110;SQL> col IS_RECOVERY_DEST_FILE for a21;SQL> select *…

There is a dataguard database, the simple information as shown in below. I wanna know what will happen when I execute command “alter database recover…

Confirm size of data tablespace and temp tablespace in original database check data tablespace of original database SQL>set line 500; SELECT total.tablespace_name, Round(total.MB, 2) AS…

It’s absolutely that adopting compression option can reduce occupation of disk space. For example the size of original dmp file which without compression option is…

background When I imported an impdp(a.dmp) file to an idel instance,I encountered an error “ORA-06564: object X does not exist” A portion of importing logs…

background A JAVA program throwed out an error that ” java.sql.SQLException: ORA-28001: the password has expired ” when The program was runing. This error is…