PeopleSoft Community Network
1.How to check Log Mode:
SELECT LOG_MODE FROM V$DATABASE;
2.Change Log Mode:
Alter database archivelog; (Database must be in mounted mode, database Alter command will not permanently add entries in spfile, we need to do it manually)
to open database in mount only mode startup mount
3.Open database read only
ALTER DATABASE OPEN READ ONLY;
4. Open Database in read and write mode:
ALTER DATABASE OPEN READ WRITE;
However, read-write is the default mode.
5.Start commands
1.Normal start = startup
2.Startup mount
Other various commands
Tags:
© 2024 Created by Maisam Agha. Powered by