oracle 10g rman备份与恢复之四(二)
RMAN> DELETE NOPROMPT EXPIRED BACKUP;
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
398 395 1 1 EXPIRED DISK /oracle/ora10g/rmanback/full_T%
433 430 1 1 EXPIRED DISK /oracle/ora10g/rmanback/full_20130420
494 491 1 1 EXPIRED DISK /oracle/ora10g/rmanback/inc0_1co7jn4l_20130421
555 552 1 1 EXPIRED DISK /oracle/ora10g/rmanback/inc0_1eo7jo4g_20130421
deleted backup piece
backup piece handle=/oracle/ora10g/rmanback/full_T% recid=35 stamp=813237736
deleted backup piece
backup piece handle=/oracle/ora10g/rmanback/full_20130420 recid=37 stamp=813238342
deleted backup piece
backup piece handle=/oracle/ora10g/rmanback/inc0_1co7jn4l_20130421 recid=39 stamp=813292693
deleted backup piece
backup piece handle=/oracle/ora10g/rmanback/inc0_1eo7jo4g_20130421 recid=41 stamp=813293712
Deleted 4 EXPIRED objects
RMAN> list backupset;
RMAN>
------------------------------------------------------------------------------------------------
backup format ‘/oracle/ora10g/rmanback/full_%u_%T.bak' database plus archivelog;
-----------------------------------------------------------------------
恢复
1、口令文件恢复
[root@redhat dbs]# pwd
/oracle/ora10g/product/10.2.0/db_1/dbs
[root@redhat dbs]# ls
hc_wolf.dat initdw.ora init.ora lkDUMMY lkWOLF orapwwolf snapcf_wolf.f spfilewolf.ora
[root@redhat dbs]#
假设口令文件丢失
重建口令文件
[oracle@redhat ~]$ cd /oracle/ora10g/product/10.2.0/db_1/dbs
[oracle@redhat dbs]$ orapwd file=orapwwolf password=123456 entries=5
[oracle@redhat dbs]$ ls
hc_wolf.dat initdw.ora init.ora lkDUMMY lkWOLF orapwwolf orapwwolf.bak snapcf_wolf.f spfilewolf.ora
[oracle@redhat dbs]$
[oracle@redhat dbs]$ orapwd
Usage: orapwd file= password= entries= force=
where
file - name of password file (mand),
password - password for SYS (mand),
entries - maximum number of distinct DBA and force - whether to overwrite existing file (opt),
OPERs (opt),
There are no spaces around the equal-to (=) character.
2、spfile丢失（dbid=3778783462）
startup nomount
set dbid dbid_number
restore spfile from autobackup
shutdown immediate
set dbid dbid_number
startup
模拟丢失spfile
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /oracle/ora10g/product/10.2.0/
db_1/dbs/spfilewolf.ora
SQL>
（[root@redhat db_1]# cd dbs
[root@redhat dbs]# ls
hc_wolf.dat init.ora lkWOLF snapcf_wolf.f
initdw.ora lkDUMMY orapwwolf spfilewolf.ora
[root@redhat dbs]# mv spfilewolf.ora spfilewolf.ora.bak
[root@redhat dbs]# ls
hc_wolf.dat init.ora lkWOLF snapcf_wolf.f
initdw.ora lkDUMMY orapwwolf spfilewolf.ora.bak
[root@redhat dbs]# pwd
/oracle/ora10g/product/10.2.0/db_1/dbs
）
RMAN>startup nomount;
RMAN>set dbid 3778783462
RMAN>restore spfile from autobackup(真实的路径也行)
RMAN>shutdown immediat