国产一级a片免费看高清,亚洲熟女中文字幕在线视频,黄三级高清在线播放,免费黄色视频在线看

打開APP
userphoto
未登錄

開通VIP，暢享免費(fèi)電子書等14項(xiàng)超值服

開通VIP

首頁

好書

留言交流

下載APP

聯(lián)系客服
rman恢復(fù) nocatalog 方式恢復(fù)
控制文件在,數(shù)據(jù)文件丟失.完全恢復(fù)過程
RMAN> startup mount;
connected to target database (not started)
Oracle instance started
database mounted
Total System Global Area     135337540 bytes
Fixed Size                      452164 bytes
Variable Size                109051904 bytes
Database Buffers              25165824 bytes
Redo Buffers                    667648 bytes
RMAN> restore database;
Starting restore at 16-AUG-06
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=11 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /opt/oracle/oradata/tldb/system01.dbf
restoring datafile 00002 to /opt/oracle/oradata/tldb/undotbs01.dbf
restoring datafile 00003 to /opt/oracle/oradata/tldb/users01.dbf
channel ORA_DISK_1: restored backup piece 1
piece handle=/opt/oracle/product/9.2.0/dbs/1fhqs95f_1_1 tag=TAG20060816T100015 params=NULL
channel ORA_DISK_1: restore complete
Finished restore at 16-AUG-06
RMAN> recover database;
Starting recover at 16-AUG-06
using channel ORA_DISK_1
starting media recovery
media recovery complete
Finished recover at 16-AUG-06
RMAN> alter database open;
database opened
RMAN>
------------------------------------------------------------------------
控制文件丟失,不完全恢復(fù)
 
 
控制文件損壞時(shí),使用 using backup controlfile
sql> recover database until time ‘YYYY-MM-DD:HH:MI:SS‘
until cancel
until scn <integer>
或者需要恢復(fù)到不同的控制文件狀態(tài)時(shí).比如:表空間的誤刪除
做完不完全恢復(fù),需要重新做備份.

 
tl1:~ # rman target /
Recovery Manager: Release 9.2.0.6.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.
connected to target database: TLDB (DBID=937533021)

tl1:~ # rman target /

Recovery Manager: Release 9.2.0.6.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database (not started)

RMAN> startup nomount; --數(shù)據(jù)庫先啟動到nomount狀態(tài).

Oracle instance started

Total System Global Area     135337540 bytes

Fixed Size                      452164 bytes
Variable Size                109051904 bytes
Database Buffers              25165824 bytes
Redo Buffers                    667648 bytes

RMAN> restore controlfile from autobackup;

Starting restore at 16-AUG-06

using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=11 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/16/2006 09:34:14
RMAN-06495: must explicitly specify DBID with SET DBID command --提示需要設(shè)置dbid.我們在做rman備份的時(shí)候可以看到dbid.

RMAN> set dbid 937533021

executing command: SET DBID

RMAN> restore controlfile from autobackup;

Starting restore at 16-AUG-06

using channel ORA_DISK_1
channel ORA_DISK_1: looking for autobackup on day: 20060816
channel ORA_DISK_1: autobackup found: c-937533021-20060816-01
channel ORA_DISK_1: controlfile restore from autobackup complete
replicating controlfile
input filename=/opt/oracle/oradata/tldb/control01.ctl
output filename=/opt/oracle/oradata/tldb/control02.ctl
output filename=/opt/oracle/oradata/tldb/control03.ctl
Finished restore at 16-AUG-06

RMAN> alter database mount; --此時(shí)數(shù)據(jù)庫可以mount上了.

database mounted

RMAN> alter database open; --但是還不能打開

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 08/16/2006 09:35:10
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

RMAN> alter database open resetlogs; --打開報(bào)錯,因?yàn)閞estore之后沒有recover.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 08/16/2006 09:35:20
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: ‘/opt/oracle/oradata/tldb/system01.dbf‘

RMAN> recover database;

Starting recover at 16-AUG-06
using channel ORA_DISK_1

starting media recovery

archive log thread 1 sequence 1 is already on disk as file /opt/oracle/oradata/tldb/redo03.log
archive log filename=/opt/oracle/oradata/tldb/redo03.log thread=1 sequence=0
media recovery complete
Finished recover at 16-AUG-06

RMAN> alter database open resetlogs;

database opened

RMAN>
恢復(fù)完畢.
使用resetlogs之后需在catalog database 上進(jìn)行reset database，原有備份信息將不可用，所以要及時(shí)進(jìn)行新的完全備份。
-------------------------------------------------------------
redolog丟失,不完全恢復(fù)
online redo log損壞,數(shù)據(jù)庫僅恢復(fù)到最后一個(gè)歸檔的日志文件。
SQL> recover database using backup controlfile until cancel;
SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;
SQL> CANCEL
SQL> alter database open resetlogs;
Database altered.
 
SQL> startup mount;
ORACLE instance started.
Total System Global Area  135337540 bytes
Fixed Size                   452164 bytes
Variable Size             109051904 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes
Database mounted.

SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;
ORA-00279: change 1712919 generated at 08/16/2006 17:26:27 needed for thread 1
ORA-00289: suggestion : /opt/oracle/arch/1_1.arc
ORA-00280: change 1712919 for thread 1 is in sequence #1

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/opt/oracle/oradata/tldb/redo01.log.bak --此處是mv了的redo log file.
Log applied.
Media recovery complete.
SQL>
SQL> alter database open ;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;
Database altered.
SQL>
至此恢復(fù)完成.
 
--------------------------------------------------------------
spfile丟失,完全恢復(fù)
 
tl1:~ # rman target /
Recovery Manager: Release 9.2.0.6.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.
connected to target database (not started)
RMAN> startup nomount;
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file ‘/opt/oracle/product/9.2.0/dbs/inittldb.ora‘
trying to start the Oracle instance without parameter files ...
Oracle instance started
Total System Global Area     101782948 bytes
Fixed Size                      452004 bytes
Variable Size                 50331648 bytes
Database Buffers              50331648 bytes
Redo Buffers                    667648 bytes
RMAN>
RMAN> set dbid 937533021
executing command: SET DBID
RMAN> restore spfile from autobackup;
Starting restore at 16-AUG-06
using channel ORA_DISK_1
channel ORA_DISK_1: looking for autobackup on day: 20060816
channel ORA_DISK_1: autobackup found: c-937533021-20060816-0c
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 16-AUG-06
RMAN>
RMAN> host;
[oracle@tl1 ~]$ ls -l $ORACLE_HOME/dbs/spfiletldb.ora
-rw-r-----  1 oracle dba 3584 Aug 16 11:59 /opt/oracle/product/9.2.0/dbs/spfiletldb.ora
[oracle@tl1 ~]$ exit
exit
host command complete
RMAN> shutdown immediate;
Oracle instance shut down
RMAN> set dbid 937533021
executing command: SET DBID
RMAN> startup;
connected to target database (not started)
Oracle instance started
database mounted
database opened
Total System Global Area     135337540 bytes
Fixed Size                      452164 bytes
Variable Size                109051904 bytes
Database Buffers              25165824 bytes
Redo Buffers                    667648 bytes
RMAN> exit

Recovery Manager complete.
------------------------------------------------------------------
到時(shí)間點(diǎn)的不完全恢復(fù).
 
tl1:~ # rman target /
Recovery Manager: Release 9.2.0.6.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.
connected to target database: TLDB (DBID=937533021)
RMAN> run {
2> sql "alter session set nls_date_format=‘‘yyyy-mm-dd hh24:mi:ss‘‘";
3> set until time= ‘2006-08-16 12:46:00‘;
4> restore database;
5> recover database;
6> sql ‘alter database open resetlogs‘;
7> }
using target database controlfile instead of recovery catalog
sql statement: alter session set nls_date_format=‘‘yyyy-mm-dd hh24:mi:ss‘‘
executing command: SET until clause
Starting restore at 16-AUG-06
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=12 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /opt/oracle/oradata/tldb/system01.dbf
restoring datafile 00002 to /opt/oracle/oradata/tldb/undotbs01.dbf
restoring datafile 00003 to /opt/oracle/oradata/tldb/users01.dbf
channel ORA_DISK_1: restored backup piece 1
piece handle=/opt/oracle/product/9.2.0/dbs/24hqsino_1_1 tag=TAG20060816T124336 params=NULL
channel ORA_DISK_1: restore complete
Finished restore at 16-AUG-06
Starting recover at 16-AUG-06
using channel ORA_DISK_1
starting media recovery
archive log thread 1 sequence 3 is already on disk as file /opt/oracle/arch/1_3.arc
channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=2
channel ORA_DISK_1: restored backup piece 1
piece handle=/opt/oracle/product/9.2.0/dbs/25hqsio0_1_1 tag=TAG20060816T124344 params=NULL
channel ORA_DISK_1: restore complete
archive log filename=/opt/oracle/arch/1_2.arc thread=1 sequence=2
archive log filename=/opt/oracle/arch/1_3.arc thread=1 sequence=3
media recovery complete
Finished recover at 16-AUG-06
sql statement: alter database open resetlogs
RMAN>
--------------------------------------------------
undo表空間壞,不完全恢復(fù)
類似于普通文件的恢復(fù).
 
  
本站僅提供存儲服務(wù)，所有內(nèi)容均由用戶發(fā)布，如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容，請點(diǎn)擊舉報(bào)。
打開APP，閱讀全文并永久保存 查看更多類似文章
猜你喜歡
類似文章
使用RMAN復(fù)制數(shù)據(jù)庫
12c 表恢復(fù)
RMAN異機(jī)復(fù)制數(shù)據(jù)庫
RMAN異機(jī)恢復(fù)測試 - victor1010的個(gè)人空間 - ITPUB個(gè)人空間 - po...
使用RMAN進(jìn)行排除表空間備份
使用rman tspitr恢復(fù)被刪除的數(shù)據(jù)或表
更多類似文章 >>
生活服務(wù)
分享 收藏 導(dǎo)長圖 關(guān)注 下載文章
綁定賬號成功
后續(xù)可登錄賬號暢享VIP特權(quán)！
如果VIP功能使用有故障，
可點(diǎn)擊這里聯(lián)系客服！

聯(lián)系客服