Using  SQL Interface: There are 2 main dynamic performance views to see your database’s current redo log structure. 1. v$logfile => Shows redo log groups, group members and member status. 1 sql> select group#,status,member from v$logfile; GROUP# STATUS MEMBER 1 /oradata/mydb/redo_log_files/redo01.log 2 /oradata/mydb/redo_log_files/redo02.log 3 /oradata/mydb/redo_log_files/redo03.log Here, this database has 3 redo log groups with 3 members. You can see the path of redo log files and see which group they belong to. If status is null then it means that the file is in use. 2. v$log => This view provides information about your redo log groups. This information is […]

In order to start Oracle service in a UNIX or Linux based system you need to login as a Oracle user. How To Startup Oracle Database on a Unix/Linux Use the su – username command to login as oracle user. Open the Terminal or login using ssh and type the following command to login $ su – oracle Start Oracle server in UNIX/Linux   Now, use the lsnrctl command to start service (usually located at /home/oracle/oracle/product/10.2.0/db_1/bin directory): $ lsnrctl start Next start database: $ dbstart If above is not working try to login as sysdba: $ sqlplus ‘/ as sysdba’ […]

Check if any there are any active DB backup tasks running: [root@ProdDB01 ~]# su – oracle -bash-3.1$ sqlplus ‘/ as sysdba’ SQL*Plus: Release 8.1.6.0.0 – Production on Thu Mar 20 12:44:12 2014 (c) Copyright 1999 Oracle Corporation.  All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.6.1.0 – Production With the Partitioning option JServer Release 8.1.6.0.0 – Production SQL> SELECT  COUNT(*) FROM v$backup WHERE status =’ACTIVE’;   COUNT(*) ———-          0 SQL>   Attempt to Recover the reported file: SQL> recover datafile ‘/opt/dbfiles/oradata/inst3/system01inst3.dbf’ ORA-00279: change 339928152 generated at 03/20/2014 09:57:48 needed for thread 1 ORA-00289: suggestion : /opt/dbfiles/inst3/archive/1_2253810.dbf ORA-00280: change […]