Oracle mobile redo log file

The Oracle mobile redo log method is very simple. The following describes the methods of Oracle mobile redo log files in detail. If you are interested in Oracle mobile redo logs, take a look.

 
 

  
  
$ sqlplus '/as sysdba' 
 
 

# Shut down the database.

 
 

  
  
SQL> shutdown immediate 
 
 

# Cp log file to the target location.

 
 

  
  
SQL> !cp /opt/oracle/oradata/redo* /opt/oracle/oratest/ 
 
 

# Start the database in mount mode.

 
 

  
  
SQL>startup mount; 
 
 

# Modify the location of log files in the database.

 
 

  
  
SQL> alter database rename file '/opt/oracle/oradata/redo01.log' to '/opt/oracle/oratest/redo01.log'  
  
  
SQL> alter database rename file '/opt/oracle/oradata/redo02.log' to '/opt/oracle/oratest/redo02.log'  
  
  
SQL> alter database rename file '/opt/oracle/oradata/redo03.log' to '/opt/oracle/oratest/redo03.log' 
 
 

# Modify the database status.

 
 

  
  
SQL> alter database open; 
 
 

# View the Modification result.

 
 

  
  
SQL> select * from v$logfile; 
 
 

Oracle Log File Reconstruction Method

Concepts of oracle users

Add Oracle user information in Linux

Measure the test taker's knowledge about the ORACLE user authentication mechanism.

Oracle tablespace statements