Oracle 9I恢復實戰
[oracle9i@RHEL5 arch]$ rman target /
Recovery Manager: Release 9.2.0.8.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database (not started)
RMAN> run { startup nomount; }
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'initorcl.ora'
trying to start the Oracle instance without parameter files ...
Oracle instance started
Total System Global Area 101782120 bytes
Fixed Size 451176 bytes
Variable Size 50331648 bytes
Database Buffers 50331648 bytes
Redo Buffers 667648 bytes
RMAN> set dbid=1281244005;
executing command: SET DBID
RMAN> restore spfile from autobackup;
Starting restore at 14-JUN-11
using channel ORA_DISK_1
channel ORA_DISK_1: looking for autobackup on day: 20110614
channel ORA_DISK_1: autobackup found: c-1281244005-20110614-01
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 14-JUN-11
RMAN> run
2> {
3> shutdown abort;
4> startup nomount;
5> }
Oracle instance shut down
connected to target database (not started)
Oracle instance started
Total System Global Area 235999648 bytes
Fixed Size 450976 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
RMAN> restore controlfile from autobackup;
Starting restore at 14-JUN-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=12 devtype=DISK
channel ORA_DISK_1: looking for autobackup on day: 20110614
channel ORA_DISK_1: autobackup found: c-1281244005-20110614-01
channel ORA_DISK_1: controlfile restore from autobackup complete
replicating controlfile
input filename=orcl/control01.ctl
output filename=orcl/control02.ctl
output filename=orcl/control03.ctl
Finished restore at 14-JUN-11
RMAN> alter database mount;
database mounted
RMAN> restore database;
Starting restore at 14-JUN-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to orcl/system01.dbf
restoring datafile 00002 to orcl/undotbs01.dbf
restoring datafile 00003 to orcl/drsys01.dbf
restoring datafile 00004 to orcl/indx01.dbf
restoring datafile 00005 to orcl/tools01.dbf
restoring datafile 00006 to orcl/users01.dbf
restoring datafile 00007 to orcl/xdb01.dbf
channel ORA_DISK_1: restored backup piece 1
piece handle=db.1_1.dbf tag=TAG20110614T131846 params=NULL
channel ORA_DISK_1: restore complete
Finished restore at 14-JUN-11
RMAN> recover database;
Starting recover at 14-JUN-11
using channel ORA_DISK_1
starting media recovery
archive log thread 1 sequence 14 is already on disk as file orcl/redo02.log
archive log thread 1 sequence 15 is already on disk as file orcl/redo03.log
archive log filename=orcl/redo02.log thread=1 sequence=14
archive log filename=orcl/redo03.log thread=1 sequence=15
media recovery complete
Finished recover at 14-JUN-11
RMAN> alter database open resetlogs;
database opened
RMAN> quit
Recovery Manager complete.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/81227/viewspace-697953/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 10G恢復實戰Oracle 10g
- Oracle 9i備份和恢復Oracle
- Oracle 10G恢復實戰1Oracle 10g
- Oracle 9i統計資訊備份與恢復Oracle
- Oracle 9i 用RMAN 恢復刪除掉的表Oracle
- oracle實驗記錄 (恢復-完全恢復)Oracle
- oracle實驗記錄 (恢復-rman恢復)Oracle
- Oracle 9i的備份和恢復機制(轉)Oracle
- innobackupex備份恢復實戰
- 實戰LVCB的恢復
- RMAN異地恢復實戰
- Oracle恢復實驗(一)Oracle
- Oracle恢復實驗(二)Oracle
- Oracle恢復實驗(三)Oracle
- Oracle恢復實驗(四)Oracle
- oracle 9I 資料庫異機恢復( Catalog 庫 )Oracle資料庫
- oracle實驗記錄 (恢復-不完全恢復)Oracle
- PG 資料庫恢復實戰資料庫
- Windows系統崩潰後恢復Oracle 9i資料庫WindowsOracle資料庫
- Oracle 9i Logical Standby與Physical standby歸檔恢復區別Oracle
- 【Oracle 恢復表空間】 實驗Oracle
- oracle實驗記錄 (恢復-redo)Oracle
- 【備份恢復】Oracle 資料備份與恢復微實踐Oracle
- 28_bbed實戰(1)_delete操作恢復delete
- Oracle10g 10.2.0.5 RAC一次恢復ORC、votedisk實戰Oracle
- NBU恢復oracleOracle
- oracle實驗記錄 (恢復-使用resetlogs open前備份恢復)Oracle
- oracle實驗記錄 (恢復-rman基於控制檔案的恢復)Oracle
- Oracle 表級的快速恢復(實習)Oracle
- oracle media recovery介質恢復實驗-Oracle
- oracle實驗記錄(恢復-checkpoint cnt)Oracle
- oracle實驗記錄 (可恢復session)OracleSession
- oracle 9i 裸裝置資料檔案損壞的恢復過程Oracle
- Oracle例項恢復和介質恢復Oracle
- rman恢復方案和oracle異機恢復Oracle
- Kubernetes備份恢復之velero實戰
- oracle實驗記錄 (恢復-恢復未備份的資料檔案)Oracle
- Oracle備份恢復之熱備份恢復及異機恢復Oracle