Common commands for oracle Management

 

Java code

Sqlplus/nolog

Conn/as sysdba

 

 

Java code

Shutdown immediate

 

Startup mount;

 

Alter database open;

 

Java code

ORA-00313 and ORA-00312: oracle initialization or shutdown in progress

 

Alter database clear logfile group 1;

Alter database clear logfile group 2;

Alter database clear logfile group 3;

 

Alter database clear unarchived logfile group 1;

Alter database clear unarchived logfile group 2;

Alter database clear unarchived logfile group 3;

 

Alter system switch logfile;

 

Alter database open resetlogs;

 

Select group #, sequence #, archived, status from v $ log;

 

 

Java code

# ORA-00257 Solution

Alter system set DB_RECOVERY_FILE_DEST_SIZE = 10g;

 

# Disable the log flashback Function

Alter database flashback off

 

Run rman Management in shell

 

Rman target/

 

Configure retention policy to recovery window of 7 days;

 

Crosscheck backup;

 

Delete archivelog all completed before 'sysdate-7 ';

Author "szgaea"