Oracle Help

• set view column size in SQL sqlplus SQL> col member format a40
• view redo01.log under UNIX
  $strings redo01.log | head -3
• change oracle password
  orapwd file=/export/home/oracle/8.1.6/dbs/orapwdev2 password=xxx entries=5
• export entire oracle
  exp SYSTEM/password@SID FULL=y FILE=dba.dmp LOG=dba.log
  exp SYSTEM/password PARFILE=params.dat
  To import just the dept and emp tables from the scott schema
  imp SYSTEM/password FIlE=dba.dmp FROMUSER=scott TABLES=(dept,emp)
• import entire oracle
  imp SYSTEM/password FULL=y FIlE=dba.dmp
  
• ORA-01207: file is more recent than controlfile - old controlfile
  Solution

  1.Mount the database
  SQL>Startup mount
  
  2. trace the control file
  
  SQL> Alter database backup controlfile to trace;
  
  3. Create a control file creation script from the tracefile generated in user_dump_des
  The file will reside in user_dump_destination
  
  Use the Noresetlogs option
  
  4.shutdown the database and start it NOMOUNT mode
  
  SQL>shutdown abort
  SQL>startup NoMount
  
  5.Create the control file
  
  Use the script generated by the 'backup controlfile to trace' command above.
  
  You have to put only a part of the script.
  ===>SQL>@make_control.sql;
  
  6.Recover database
  
  SQL>recover database ;
  
  7.Open the database
  
  SQL>Alter database open ;
  

• ORA-01113: file 1 needs media recovery
  Solution

  SQL> SHUTDOWN
  SQL> STARTUP MOUNT
  SQL> RECOVER DATABASE
  SQL> ALTER DATABASE OPEN;
  

• ORA-00353: log corruption near block 2 change 19475093 time
  Solution incomplete recovery

• ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
  Solution

  2.shut immediate;
  3.startup nomount;
  4.create controlfile from trace file...just copy paste (which is automatically comes into udump)
  5.recover database;
  6.alter database open
  

• ORA-00308: cannot open archived log
  Solution

  NOTE:  The DBA can query the view v$archive_dest to view the status of all five Archive Log Destinations.
  SELECT group#, status, member FROM v$logfile;
  

• ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
  Solution

  alter database open noresetlogs;
  

• ORA-00354 ORA-00353 ORA-00312 Corrupt redo block header
  Solution