Oracle11g- port links, multiple log files, backup archives

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