Oracle Study Notes: a detailed study of the basic settings that affect the Oracle database status alter Database

Alter Database

2. Flashbackup {on |Off} -- Mount -- whether to enable the database flash Function
4. {Begin |End} Backup ---- whether to enable the backup mode of the database
6. {Mount | open} -- started and nomount -- Database loading modes: mounted and open
8. Open {read only |Read Write} -- Started, nomount, and mount -- open mode of the database: Read-only and read/write.If standby is read only and primary is read write
10. Open {read only |Read Write} {Resetlogs |Noresetlogs} -- Started, nomount, and mount -- whether to reset the online redo file when the database is opened
12. Set Default {Samllfile| Bigfile} tablespace ---- default database file types: bigfile and smallfile
14. Default tablespace TBS ---- default permanent tablespace of the database
16. Default temporary tablespace {temptbs | temptbs group} ---- default temporary tablespace of the database
18. Rename global_name to db_global_name ---- global_name of the database
20. {Enable |Disable} Block change tracking ---- whether the database enables block change tracking
22. Set time_zone = {+ |-} hh: Mi | time_zone_region} ---- set the default time zone of the database.The database must be restarted to take effect.
24. Guard {None| Standby | all} ---- sets the database security level.Can be changed by alte session
26. {Archivelog |Noarchivelog} -- Mount -- set whether the database is archived
28. {No Force| Force} logging -- Mount -- set whether the data is in force logging Mode
30. Tablespace and file operations
32. Recover operation
34. Stanby operation