oracle11g-port link, multiple log files, backup archive

Source: Internet
Author: User

Oracle NET Protocol
Remote Connection to Oracle Net
Configure the network port method
NETCA Graphical Way of
The Listening file is
650) this.width=650; "height=" 258 "src=" http://b288.photo.store.qq.com/psb?/81c1194a-ff39-4e50-b1b1-40057b06260f/ vkrj83wkndmj4prflbzob129ee7cyes6*8vrxqcpimu!/b/dcabaaaaaaaa&bo=ggicaqaaaaafaka! "width=" 642 "style=" vertical-align:top; "alt=" dcabaaaaaaaa&bo=ggicaqaaaaafaka! "/>

Use the DBCA graphical interface to modify the port. Or select a port when new
In the use of graphical, root to give Xhost + permissions otherwise cannot be used
---------------------------------------------------------------------------------------------------
Start the database, first locate the parameter file, and then locate the control file,

View Control file names
650) this.width=650; "height=" 185 "src=" http://b178.photo.store.qq.com/psb?/81c1194a-ff39-4e50-b1b1-40057b06260f/ tbrrdiynxd9xxnh4zgj.4hse2k0b8okpvzxnmk*982e!/b/dliaaaaaaaaa&bo=xgk5aaaaaaafamy! "width=" 606 "style=" vertical-align:top; "alt=" dliaaaaaaaaa&bo=xgk5aaaaaaafamy! "/>


Multiple Control file backup
650) this.width=650, "height=", "src=" http://b246.photo.store.qq.com/psb?/81c1194a-ff39-4e50-b1b1-40057b06260f/ g5islkh3uv3pdrmna7mfqlwre50e7psvmjr1ekj0y2o!/b/dpyaaaaaaaaa&bo=iajwaaaaaaafank! "width=" 648 "style=" vertical-align:top; "alt=" dpyaaaaaaaaa&bo=iajwaaaaaaafank! "/>
You need to close the database after modifying the SPFile parameter
650) this.width=650; "height=" 98 "src=" http://b287.photo.store.qq.com/psb?/81c1194a-ff39-4e50-b1b1-40057b06260f/ zm5e5pyj6zw1ybvz6lzwfep9kx*yf3gqf1jy0roms00!/b/db8baaaaaaaa&bo=6qbiaaaaaaafakg! "width=" 233 "style=" vertical-align:top; "alt=" db8baaaaaaaa&bo=6qbiaaaaaaafakg! "/>
Then use the Oracle User manual CP for a control01 file, the path above can be written on its own, typically saved on a different disk backup multiple
When a damage is done, the direct CP can be filled in.


Log buffers Save All commands that have been executed in the database
When the capacity is used to One-third, records are permanently saved to the redo log.
Redo logs also have a number of, I hope that more can self-add redo log
View Redo log Files
650) this.width=650; "height=" 261 "src=" http://b288.photo.store.qq.com/psb?/81c1194a-ff39-4e50-b1b1-40057b06260f/ gd.e99dj6fhk226sb41c6h.uudocaou2dzw4fmw6pnk!/b/dcabaaaaaaaa&bo=ugifaqaaaaafahc! "width=" 594 "style=" vertical-align:top; "alt=" dcabaaaaaaaa&bo=ugifaqaaaaafahc! "/>

Current currently in use
Inactive non-active
Redo log files also require multiple backups to ensure security,
650) this.width=650; "height=" 137 "src=" http://b248.photo.store.qq.com/psb?/81c1194a-ff39-4e50-b1b1-40057b06260f/ Nm5erxnxfoyjjp5krn225i6bjxyj423dxlrrwbzlcpu!/b/dpgaaaaaaaaa&bo=gwkjaaaaaaafacs! "width=" 643 "style=" vertical-align:top; "alt=" dpgaaaaaaaaa&bo=gwkjaaaaaaafacs! "/>
Note that the directory to save the file must have permissions, directly select the main group can ~ permissions appropriate, give more may have unexpected trouble
Delete Log Group command
650) this.width=650; "height=" 113 "src=" http://b288.photo.store.qq.com/psb?/81c1194a-ff39-4e50-b1b1-40057b06260f/ ul6t7jnm9kshtdnvsebquvlzstd9ibq3atqllmazs7i!/b/dcabaaaaaaaa&bo=ygfxaaaaaaafade! "width=" 354 "style=" vertical-align:top; "alt=" dcabaaaaaaaa&bo=ygfxaaaaaaafade! "/>


Checkpoint Event
Checkpoints are equivalent to backup points, and if this is more likely to recover faster when a problem occurs because there is no need to recover longer and more records, it is usually recorded every three seconds
If log changes are recorded
or manually request a checkpoint.
650) this.width=650; "height=" 186 "src=" http://b287.photo.store.qq.com/psb?/81c1194a-ff39-4e50-b1b1-40057b06260f/ dfeqhqhktxpwc1tfemyrl*z3wtpfffigx43yq*ywv8m!/b/db8baaaaaaaa&bo=mag6aaaaaaafakg! "width=" 304 "style=" vertical-align:top; "alt=" db8baaaaaaaa&bo=mag6aaaaaaafakg! "/>
The first is to toggle the logging checkpoint, and the second is to manually record the checkpoint.

Database archiving, with no 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 the archive to close the database and then start the database to mount mode
ALTER DATABASE Archivelog; This command sets the database to archive mode

This article is from the "11627223" blog, please be sure to keep this source http://11637223.blog.51cto.com/11627223/1911966

oracle11g-port link, multiple log files, backup archive

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.