In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Oracle net protocol
Remote connection oracle net
Method of configuring network port
Netca graphical mode
The listening file is in
Use dbca graphical interface to modify the port. Or select a port when you create a new one
When using graphics, root must grant xhost + permission or it cannot be used.
-
Start the database, first find the parameter file, and then find the control file
View control file name
Multiple control file backup
After modifying the spfile parameters, you need to close the database.
Then use oracle users to manually cp a control01 file, and the above path can be written by yourself, usually saving multiple backups on different disks
When one is damaged, just fill it in with cp.
The log buffer holds all commands executed in the database
When the capacity reaches 1/3, the record is permanently saved to the redo log.
There are also a number of redo logs. If there are more, you can add redo logs by yourself.
View the redo log file
What current is currently using
Inactive inactive
Redoing log files also requires multiple backups to ensure security.
Note that the directory where the file is saved must have permissions. Directly select the master group as long as the permissions are appropriate. If you give too much trouble, you may have unexpected troubles.
Delete log group command
Checkpoint event
Checkpoints are equivalent to backup points, and if there are more of them, the faster you can recover when something goes wrong, because you don't need to recover more records for longer, which is usually recorded every three seconds.
If the log changes, record it.
Or manually request a checkpoint
The first is to switch logging checkpoints, and the second is to record checkpoints manually
Database archiving and non-archiving
If you need to back up data, the database must be archived or it cannot be backed up.
Archive log list; View Information
You need to set up archiving to close the database first, and then start the database to mount mode
Alter database archivelog; this command sets the database to archive mode
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.