##1 編輯引數檔案

orcl.__db_cache_size=629145600

orcl.__java_pool_size=4194304

orcl.__large_pool_size=71303168

orcl.__oracle_base='/u01/oracle'#ORACLE_BASE set from environment

orcl.__pga_aggregate_target=314572800

rman.__db_cache_size=629145600

rman.__java_pool_size=4194304

rman.__large_pool_size=71303168

rman.__oracle_base='/u01/oracle'#ORACLE_BASE set from environment

rman.__pga_aggregate_target=314572800

rman.__db_cache_size=629145600

rman.__java_pool_size=4194304

rman.__large_pool_size=71303168

rman.__oracle_base='/u01/oracle'#ORACLE_BASE set from environment

rman.__pga_aggregate_target=314572800

rman.__sga_target=947912704

rman.__shared_io_pool_size=0

rman.__shared_pool_size=230686720

rman.__streams_pool_size=0

*._use_adaptive_log_file_sync='FALSE'

*.audit_file_dest='/u01/oracle/admin/rman/adump'

*.audit_trail='db'

*.compatible='11.2.0.4.0'

*.control_files='/u01/oracle/oradata/rman/control01.ctl','/u01/oracle/oradata/rman/control02.ctl'

*.db_block_size=8192

*.db_domain=''

*.db_name='rman'

*.db_recovery_file_dest='/u01/oracle/fast_recovery_area'

*.db_recovery_file_dest_size=4385144832

*.diagnostic_dest='/u01/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=rmanXDB)'

*.open_cursors=3000

*.pga_aggregate_target=314572800

*.processes=1500

*.remote_login_passwordfile='EXCLUSIVE'

*.sec_case_sensitive_logon=FALSE

##2 建立目錄。這裡如果時間夠用的話，個人建議建立一個相同名稱的例項更好。

[oracle@rman1 ~]$ mkdir -p /u01/oracle/admin/$ORACLE_SID/{dpdump,adump,pfile}

[oracle@rman1 ~]$ mkdir -p /u01/oracle/diag/rdbms/orcl/orcl/{alert,cdump,incident,incpkg,ir,lck,metadata,metadata_dgif,metadata_pv,stage,sweep,trace}

[oracle@rman1 ~]$ mkdir -p /u01/oracle/oradata/$ORACLE_SID

[oracle@rman1 ~]$ mkdir -p /u01/oracle/fast_recovery_area/$ORACLE_SID/{onlinelog,archivelog}

##3 恢復

[oracle@rman1 ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Fri May 5 13:24:52 2017

connected to target database (not started)

#RMAN> set dbid 1829607053 #注意，我自己在這裡並沒有指定dbid，恢復成功了。但是，如果可能知道dbid的情況下，還是需要指定的。

RMAN> startup nomount

Oracle instance started

Total System Global Area 993775616 bytes

Fixed Size 2259360 bytes

Variable Size 859833952 bytes

Database Buffers 125829120 bytes

Redo Buffers 5853184 bytes

RMAN> restore controlfile from '/u01/backup/ctl_20170505_RMAN_db_6_1.bak';

Starting restore at 05-MAY-17

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=19 device type=DISK

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

output file name=/u01/oracle/oradata/rman/control01.ctl

output file name=/u01/oracle/oradata/rman/control02.ctl

Finished restore at 05-MAY-17

RMAN> alter database mount;

database mounted

released channel: ORA_DISK_1

RMAN> catalog start with '/u01/backup';

RMAN> restore database;

Starting restore at 05-MAY-17

Starting implicit crosscheck backup at 05-MAY-17

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=19 device type=DISK

Crosschecked 4 objects

Finished implicit crosscheck backup at 05-MAY-17

Starting implicit crosscheck copy at 05-MAY-17

using channel ORA_DISK_1

Finished implicit crosscheck copy at 05-MAY-17

searching for all files in the recovery area

cataloging files...

no files cataloged

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00001 to /u01/oracle/oradata/rman/system01.dbf

channel ORA_DISK_1: restoring datafile 00002 to /u01/oracle/oradata/rman/sysaux01.dbf

channel ORA_DISK_1: restoring datafile 00003 to /u01/oracle/oradata/rman/undotbs01.dbf

channel ORA_DISK_1: restoring datafile 00004 to /u01/oracle/oradata/rman/users01.dbf

channel ORA_DISK_1: reading from backup piece /u01/backup/backup_1829607053_20170505_RMAN_3_1.bak

channel ORA_DISK_1: piece handle=/u01/backup/backup_1829607053_20170505_RMAN_3_1.bak tag=TAG20170505T104501

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:55

Finished restore at 05-MAY-17

RMAN> recover database;

Starting recover at 05-MAY-17

using channel ORA_DISK_1

starting media recovery

channel ORA_DISK_1: starting archived log restore to default destination

channel ORA_DISK_1: restoring archived log

archived log thread=1 sequence=5

channel ORA_DISK_1: restoring archived log

archived log thread=1 sequence=6

channel ORA_DISK_1: reading from backup piece /u01/backup/arc_20170505_RMAN_5_1.bak

channel ORA_DISK_1: piece handle=/u01/backup/arc_20170505_RMAN_5_1.bak tag=TAG20170505T105032

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

archived log file name=/u01/oracle/fast_recovery_area/RMAN/archivelog/2017_05_05/o1_mf_1_5_djr4l1qk_.arc thread=1 sequence=5

channel default: deleting archived log(s)

archived log file name=/u01/oracle/fast_recovery_area/RMAN/archivelog/2017_05_05/o1_mf_1_5_djr4l1qk_.arc RECID=4 STAMP=943192130

archived log file name=/u01/oracle/fast_recovery_area/RMAN/archivelog/2017_05_05/o1_mf_1_6_djr4l1t9_.arc thread=1 sequence=6

channel default: deleting archived log(s)

archived log file name=/u01/oracle/fast_recovery_area/RMAN/archivelog/2017_05_05/o1_mf_1_6_djr4l1t9_.arc RECID=3 STAMP=943192129

unable to find archived log

archived log thread=1 sequence=7

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 05/05/2017 13:48:51

RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 7 and starting SCN of 966849

##在sqlplus裡面繼續恢復

[oracle@rman1 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Fri May 5 13:49:52 2017

SQL> conn / as sysdba

Connected.

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 966849 generated at 05/05/2017 10:50:32 needed for thread 1

ORA-00289: suggestion :

/u01/oracle/fast_recovery_area/RMAN/archivelog/2017_05_05/o1_mf_1_7_%u_.arc

ORA-00280: change 966849 for thread 1 is in sequence #7

Specify log: {=suggested | filename | AUTO | CANCEL}

CANCEL

Media recovery cancelled.

SQL> alter database open resetlogs;

database opened

#redo log會在resetlogs後自動根據controlfile建立，temp表空間也會在resetlogs後自動建立。

[root@rman1 ~]# ls /u01/oracle/oradata/rman/*

/u01/oracle/oradata/rman/control01.ctl /u01/oracle/oradata/rman/sysaux01.dbf /u01/oracle/oradata/rman/undotbs01.dbf

/u01/oracle/oradata/rman/control02.ctl /u01/oracle/oradata/rman/system01.dbf /u01/oracle/oradata/rman/users01.dbf

[root@rman1 ~]# ls /u01/oracle/oradata/rman/*

/u01/oracle/oradata/rman/control01.ctl /u01/oracle/oradata/rman/redo02.log /u01/oracle/oradata/rman/system01.dbf /u01/oracle/oradata/rman/users01.dbf

/u01/oracle/oradata/rman/control02.ctl /u01/oracle/oradata/rman/redo03.log /u01/oracle/oradata/rman/temp01.dbf

/u01/oracle/oradata/rman/redo01.log /u01/oracle/oradata/rman/sysaux01.dbf /u01/oracle/oradata/rman/undotbs01.dbf

[root@rman1 ~]# ls /u01/oracle/oradata/rman/* -lh

-rw-r----- 1 oracle oinstall 9.3M May 5 13:52 /u01/oracle/oradata/rman/control01.ctl

-rw-r----- 1 oracle oinstall 9.3M May 5 13:52 /u01/oracle/oradata/rman/control02.ctl

-rw-r----- 1 oracle oinstall 51M May 5 13:52 /u01/oracle/oradata/rman/redo01.log

-rw-r----- 1 oracle oinstall 51M May 5 13:51 /u01/oracle/oradata/rman/redo02.log

-rw-r----- 1 oracle oinstall 51M May 5 13:51 /u01/oracle/oradata/rman/redo03.log

-rw-r----- 1 oracle oinstall 491M May 5 13:51 /u01/oracle/oradata/rman/sysaux01.dbf

-rw-r----- 1 oracle oinstall 741M May 5 13:51 /u01/oracle/oradata/rman/system01.dbf

-rw-r----- 1 oracle oinstall 21M May 5 13:52 /u01/oracle/oradata/rman/temp01.dbf

-rw-r----- 1 oracle oinstall 76M May 5 13:51 /u01/oracle/oradata/rman/undotbs01.dbf

-rw-r----- 1 oracle oinstall 5.1M May 5 13:51 /u01/oracle/oradata/rman/users01.dbf

#檢查DBID

SQL> select DBID from v$database;

DBID

----------

1829607053

SQL> !ls /u01/backup

arc_20170505_RMAN_5_1.bak backup_1829607053_20170505_RMAN_3_1.bak ctl_20170505_RMAN_db_6_1.bak

backup_1829607053_20170505_RMAN_2_1.bak backup_1829607053_20170505_RMAN_4_1.bak

oracle 11G r2 異機恢復

相關文章