An alternative method to quickly fix Oracle parameter files

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

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

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.