oracle spfile 恢复,【实验】从RMAN备份中恢复spfile文件

1.使用自动备份恢复spfile

ora10g@linux5 /home/oracle$ rman target /Recovery Manager: Release 10.2.0.4.0 - Production on Sat Mar 14 03:00:39 2009Copyright (c) 1982, 2007, Oracle.  All rights reserved.connected to target database: ORA10G (DBID=3998073128)RMAN> list backup summary;using target database control file instead of recovery catalogList of Backups===============Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag------- -- -- - ----------- --------------- ------- ------- ---------- ---1       B  F  A DISK        13-MAR-09       1       1       NO         TAG20090313T0822362       B  F  A DISK        13-MAR-09       1       1       NO         TAG20090313T082344RMAN> restore spfile to '/home/oracle/spfileora10g.ora' from autobackup;Starting restore at 14-MAR-09allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=527 devtype=DISKrecovery area destination: /oracle/u01/app/oracle/flash_recovery_areadatabase name (or database unique name) used for search: ORA10Gchannel ORA_DISK_1: autobackup found in the recovery areachannel ORA_DISK_1: autobackup found: /oracle/u01/app/oracle/flash_recovery_area/ORA10G/autobackup/2009_03_13/o1_mf_s_681380624_4vm9wko2_.bkpchannel ORA_DISK_1: SPFILE restore from autobackup completeFinished restore at 14-MAR-09RMAN> exitRecovery Manager complete.ora10g@linux5 /home/oracle$ ls -l spfile*-rw-r----- 1 oracle oinstall 3584 Mar 14 03:01 spfileora10g.oraora10g@linux5 /home/oracle$ strings spfileora10g.oraora10g.__db_cache_size=58720256ora10g.__java_pool_size=4194304ora10g.__large_pool_size=4194304ora10g.__shared_pool_size=92274688ora10g.__streams_pool_size=4194304*.audit_file_dest='/oracle/u01/app/oracle/admin/ora10g/adump'*.background_dump_dest='/oracle/u01/app/oracle/admin/ora10g/bdump'*.compatible='10.2.0.3.0'*.control_files='/oracle/u02/oradata/ORA10G/controlfile/o1_mf_4srph8fv_.ctl','/oracle/u01/app/oracle/flash_recovery_area/ORA10G/controlfile/o1_mf_4srph96b_.ctl'*.core_dump_dest='/oracle/u01/app/oracle/admin/ora10g/cdump'*.cursor_sharing='EXACT'*.db_block_size=8192*.db_create_file_dest='/oracle/u02/oradata'*.db_create_online_log_dest_1='/oracle/u01'*.db_create_online_log_dest_2='/oracle/u02'*.db_create_online_log_dest_3='/oracle/u02'*.db_domain=''*.db_file_multiblock_read_count=16*.db_name='ora10g'*.db_recovery_file_dest='/oracle/u01/app/oracle/flash_recovery_area'*.db_recovery_file_dest_size=4294967296*.job_queue_processes=10*.log_archive_format='%t_%s_%r.dbf'*.open_cursors=300*.pga_aggregate_target=16777216*.processes=500*.remote_login_passwordfile='EXCLUSIVE'*.sga_target=167772160*.undo_management='AUTO'*.undo_tablespace='UNDOTBS1'*.user_dump_dest='/oracle/u01/app/oracle/admin/ora10g/udump'

2.通过指定备份文件的方法进行恢复