An alternative method to quickly fix Oracle parameter files

Source: Internet
Author: User

DBAs do not have to back up files. Eygle is called the DBA's nightmare. So far!

Although many people think that backup of parameter files is not important, you often suffer!

Parameter file. For windows, spfile and pfile of Oracle are in the E: \ oracle \ product \ 10.2.0 \ db_1 \ database directory by default, SPFILEsid. ORA and INITsid. ORA and oracle use spfile by default. If spfile is damaged, pfile is automatically used. If both are broken, an error is prompted. What if there is no backup?

Of course, you can find the init template that comes with oracle and set the parameters of your system one by one. That would be a bad thing, and it would waste your precious time. Is there any way? The key is fast!

As shown in the question, I have a good solution.

Starting from the alert_alaska.log warning log, because it records the running status of the database all the time, including the parameter information for each startup. What we need is

Processes = 150
_ Shared_pool_size = 75497472
_ Large_pool_size = 4194304
_ Java_pool_size = 4194304
_ Streams_pool_size = 0
Nls_language = AMERICAN
Nls_territory = AMERICA
Sga_target = 167772160
Control_files = E: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ALASKA \ CONTROL01.CTL, E: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ALASKA \ CONTROL02.CTL, E: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ALASKA \ CONTROL03.CTL
DB _ block_size = 8192
_ Db_cache_size = 79691776
Compatible = 10.2.0.1.0
Db_file_multiblock_read_count = 16
Db_recovery_file_dest = e: \ oracle \ product \ 10.2.0/alash_recovery_area
Db_recovery_file_dest_size = 1073741824
Log_checkpoints_to_alert = TRUE
Undo_management = AUTO
Undo_tablespace = UNDOTBS1
Undo_retention = 900
Remote_login_passwordfile = EXCLUSIVE
Db_domain = com.cn
Dispatchers = '(PROTOCOL = TCP) (SERVICE = alaskaXDB )'
# Use ''to cause them
Job_queue_processes = 10
Audit_file_dest = E: \ ORACLE \ PRODUCT \ 10.2.0 \ ADMIN \ ALASKA \ ADUMP
Background_dump_dest = E: \ ORACLE \ PRODUCT \ 10.2.0 \ ADMIN \ ALASKA \ BDUMP
User_dump_dest = E: \ ORACLEPRODUCT \ 10.2.0ADMIN \ ALASKA \ UDUMP
Core_dump_dest = E: \ ORACLE \ PRODUCT \ 10.2.0 \ ADMIN \ ALASKA \ CDUMP
Db_name = alaska
Open_cursors = 300
Pga_aggregate_target = 16777216


Copy the previously successfully started parameter Statement (such as the code snippet) to a text. You only need to add ''(single quotation mark) to the value of dispatchers = (PROTOCOL = TCP) (SERVICE = alaskaXDB ), change to dispatchers = '(PROTOCOL = TCP) (SERVICE = alaskaXDB)' and save it as c: \ pfile.txt

Run startup pfile = 'C: \ pfile.txt ';

Is it fast? It's an alternative! As you wish.

Related Article

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.