【正文】 uld not open parameter file 39。/oracle/product/39。starting Oracle instance without parameter file for retrival of spfileOracle instance startedTotal System Global Area 159383552 bytesFixed Size 2082504 bytesVariable Size 67111224 bytesDatabase Buffers 83886080 bytesRedo Buffers 6303744 bytes恢復(fù) spfile 到/tmp/RMAN run {2 allocate channel c1 type 39。sbt_tape39。 parms 39。ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/)39。RMAN restore spfile to pfile 39。/tmp/39。RMAN release channel c1。RMAN }關(guān)閉數(shù)據(jù)庫(kù)RMAN shutdown immediateOracle instance shut down修改數(shù)據(jù)庫(kù)參數(shù)文件第 22 頁(yè) 共 48 頁(yè)現(xiàn)在已經(jīng)把 spfile 恢復(fù)為 pfile，并可以通過(guò)編輯 pfile 文件以使數(shù)據(jù)庫(kù)適應(yīng)當(dāng)前的系統(tǒng)環(huán)境（如內(nèi)存大小、控制文件位置、RAC 參數(shù)等） 。默認(rèn)情況下 pfile 的位置是：$ORACLE_HOME/dbs/initsid.ora當(dāng)前 pfile 位置為：/tmp/以下是根據(jù)恢復(fù)機(jī)情況編輯好 pfile 文件=15619588096=16777216=268435456=1258291200=0*.audit_file_dest=39。/oracle/admin/MZYX/adump39。*.background_dump_dest=39。/oracle/admin/MZYX/bdump39。*.patible=39。39。*.control_files=39。/oradata/data/ryd_control0139。,39。/oradata/data/ryd_control0239。*.core_dump_dest=39。/oracle/admin/MZYX/cdump39。*.db_block_size=8192*.db_cache_size=5G*.db_domain=39。39。*.db_file_multiblock_read_count=16*.db_name=39。MZYX39。*.db_recovery_file_dest=39。/oracle/flash_recovery_area39。*.db_recovery_file_dest_size=2147483648*.db_writer_processes=2*.job_queue_processes=10*.large_pool_size=268435456*.log_archive_dest_1=39。location=/arch139。*.log_buffer=6291456*.open_cursors=1000*.pga_aggregate_target=1G*.processes=1000*.remote_login_passwordfile=39。exclusive39。*.sessions=1000*.sga_max_size=2G*.sga_target=0*.shared_pool_size=1G*.thread=1*.undo_management=39。AUTO39。第 23 頁(yè) 共 48 頁(yè)*.undo_retention=10800*.undo_tablespace=39。undo39。*.undo_tablespace=39。UNDOTBS139。*.user_dump_dest=39。/oracle/admin/MZYX/udump39。根據(jù)參數(shù)文件的內(nèi)容用 oracle 用戶創(chuàng)建以下目錄/oracle/admin/MZYX/adump/oracle/admin/MZYX/bdump/oracle/admin/MZYX/cdump/oracle/admin/MZYX/udump、恢復(fù)控制文件重新連接到恢復(fù)目錄，并以 nomount 方式打開(kāi)數(shù)據(jù)庫(kù)$ rman target / catalog rman/rman@cataRecovery Manager: Release Production on Sat Aug 9 02:42:49 2022Copyright (c) 1982, 2022, Oracle. All rights reserved.connected to target database (not started)connected to recovery catalog databaseRMAN set DBID=2169033083executing mand: SET DBIDdatabase name is MZYX and DBID is 2169033083RMAN startup nomount pfile=’/tmp/’connected to target database (not started)Oracle instance startedTotal System Global Area 6761218048 bytesFixed Size 2094264 bytesVariable Size 1375734600 bytesDatabase Buffers 5368709120 bytesRedo Buffers 14680064 bytes第 24 頁(yè) 共 48 頁(yè)恢復(fù)控制文件RMAN run {2 allocate channel c1 type 39。sbt_tape39。 parms 39。ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/)39。RMAN restore controlfile。RMAN release channel c1。RMAN }數(shù)據(jù)庫(kù)將會(huì)根據(jù) pfile 所指定的控制文件的位置去恢復(fù)控制文件。把數(shù)據(jù)庫(kù)打開(kāi)到 mount 狀態(tài)RMAN alter database mount。database mountedreleased channel: ORA_DISK_查找數(shù)據(jù)庫(kù)的 SCN 號(hào)碼通過(guò)恢復(fù)目錄 catalog 查找出備份集中備份的最大 SCN 號(hào)碼RMAN list backup。List of Backup Sets===================BS Key Type LV Size Device Type Elapsed Time Completion Time 375 Full DISK 00:02:38 07AUG08 BP Key: 377 Status: EXPIRED Compressed: NO Tag: TAG20220807T190039 Piece Name: /backup/ List of Datafiles in backup set 375 File LV Type Ckp SCN Ckp Time Name 1 Full 52149370 07AUG08 /oradata/data/ryd_system01 2 Full 52149370 07AUG08 /dev/ryd_undotbs1_01 3 Full 52149370 07AUG08 /oradata/data/ryd_sysaux01第 25 頁(yè) 共 48 頁(yè) 4 Full 52149370 07AUG08 /oradata/data/ryd_user01 5 Full 52149370 07AUG08 /oradata/data/ryd_undotbs2_01 6 Full 52149370 07AUG08 /oradata/data/ryd_system02 7 Full 52149370 07AUG08 /oradata/data/ryd_sysaux02 8 Full 52149370 07AUG08 /dev/ryd_perfstat01 9 Full 52149370 07AUG08 /dev/ryd_indx01 10 Full 52149370 07AUG08 /dev/ryd_undotbs1_02 11 Full 52149370 07AUG08 /dev/ryd_undotbs1_03 12 Full 52149370 07AUG08 /dev/ryd_undotbs1_04 13 Full 52149370 07AUG08 /dev/ryd_undotbs2_02 14 Full 52149370 07AUG08 /dev/ryd_undotbs2_03 15 Full 52149370 07AUG08 /dev/ryd_undotbs2_04 16 Full 52149370 07AUG08 /oradata/data/ryd_data01 17 Full 52149370 07AUG08 /oradata/data/ryd_data02 18 Full 52149370 07AUG08 /oradata/data/ryd_data03 19 Full 52149370 07AUG08 /oradata/data/ryd_data04 20 Full 52149370 07AUG08 /oradata/data/ryd_data05 21 Full 52149370 07AUG08 /oradata/data/ryd_data06 22 Full 52149370 07AUG08 /oradata/data/ryd_data07 23 Full 52149370 07AUG08 /oradata/data/ryd_data08 24 Full 52149370 07AUG08 /oradata/data/ryd_data09 25 Full 52149370 07AUG08 /oradata/data/ryd_data10 26 Full 52149370 07AUG08 /dev/ryd_part_data01 27 Full 52149370 07AUG08 /dev/ryd_part_data02 28 Full 52149370 07AUG08 /dev/ryd_part_data03 29 Full 52149370 07AUG08 /dev/ryd_part_data04 30 Full 52149370 07AUG08 /dev/ryd_part_data05 31 Full 52149370 07AUG08 /dev/ryd_part_data06 32 Full 52149370 07AUG08 /dev/ryd_part_data07 33 Full 52149370 07AUG08 /dev/ryd_part_data08 34 Full 52149370 07AUG08 /dev/ryd_part_data09 35 Full 52149370 07AUG08 /dev/ryd_part_data10BS Key Type LV Size Device Type Elapsed Time Completion Time 376 Full DISK 00:00:02 07AUG08 BP Key: 378 Status: EXPIRED Compressed: NO Tag: TAG20220807T190039 Piece Name: /backup/ Control File Included: Ckp SCN: 52150898 Ckp ti