Monday, February 6, 2023

Oracle::TO shutdown fastly use alter system switch log file#Fast shutdown of Oracle Database

 Oracle::TO shutdown in faster way use alter system switch log file:

SQL> alter system switch logfile;

System altered.

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL>

Then release the server for any maintenance task.

No comments:

Post a Comment

MYSQL:::Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables

  Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables Introduction: In the dynamic landscape of database management...