rman.docx
- 文档编号:3835028
- 上传时间:2022-11-25
- 格式:DOCX
- 页数:9
- 大小:15.30KB
rman.docx
《rman.docx》由会员分享,可在线阅读,更多相关《rman.docx(9页珍藏版)》请在冰豆网上搜索。
rman
启动监听
lsnrctlstart
启动数据库
SQL>sqlplus/nolog
SQL>conn/assysdba
SQL>startup//启动数据库
SQL>shutdown//停止数据库
EM管理器启动
emctlstartdbconsole启动
emctlstopdbconsole停止
.bash_profile配置
#oracle
exportORACLE_BASE=/u01/app
exportORACLE_HOME=$ORACLE_BASE/oracle
exportORACLE_SID=orcl
exportPATH=$ORACLE_HOME/bin:
$PATH:
$HOME/bin
改变数据库的databaselogmode模式
startupmount//mount启动数据库
alterdatabasearchivelog//改变databaselogmode模式
SQL>archiveloglist
DatabaselogmodeArchiveMode
AutomaticarchivalEnabled
ArchivedestinationUSE_DB_RECOVERY_FILE_DEST
Oldestonlinelogsequence3
Nextlogsequencetoarchive5
Currentlogsequence5
Rman
connecttarget/
liskbackupset;
backupdatabase//全备份
usingtargetdatabasecontrolfileinsteadofrecoverycatalog
ListofBackupSets
===================
BSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime
-------------------------------------------------------------
1Full985.20MDISK00:
00:
5314-OCT-12
BPKey:
1Status:
AVAILABLECompressed:
NOTag:
TAG20121014T232632
PieceName:
/u01/app/flash_recovery_area/ORCL/backupset/2012_10_14/o1_mf_nnndf_TAG20121014T232632_87opf8cn_.bkp
ListofDatafilesinbackupset1
FileLVTypeCkpSCNCkpTimeName
---------------------------------
1Full101347814-OCT-12/u01/app/oradata/orcl/system01.dbf
2Full101347814-OCT-12/u01/app/oradata/orcl/sysaux01.dbf
3Full101347814-OCT-12/u01/app/oradata/orcl/undotbs01.dbf
4Full101347814-OCT-12/u01/app/oradata/orcl/users01.dbf
BSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime
-------------------------------------------------------------
2Full9.36MDISK00:
00:
0314-OCT-12
BPKey:
2Status:
AVAILABLECompressed:
NOTag:
TAG20121014T232632
PieceName:
/u01/app/flash_recovery_area/ORCL/backupset/2012_10_14/o1_mf_ncsnf_TAG20121014T232632_87oph2jj_.bkp
SPFILEIncluded:
Modificationtime:
14-OCT-12
SPFILEdb_unique_name:
ORCL
ControlFileIncluded:
CkpSCN:
1013478Ckptime:
14-OCT-12
backupincrementallevel=0database;//0级全备份,可进行增量备份
BSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime
-------------------------------------------------------------
3Incr0985.20MDISK00:
00:
0514-OCT-12
BPKey:
3Status:
AVAILABLECompressed:
NOTag:
TAG20121014T234247
PieceName:
/u01/app/flash_recovery_area/ORCL/backupset/2012_10_14/o1_mf_nnnd0_TAG20121014T234247_87oqcqkr_.bkp
ListofDatafilesinbackupset3
FileLVTypeCkpSCNCkpTimeName
---------------------------------
10Incr101347814-OCT-12/u01/app/oradata/orcl/system01.dbf
20Incr101347814-OCT-12/u01/app/oradata/orcl/sysaux01.dbf
30Incr101347814-OCT-12/u01/app/oradata/orcl/undotbs01.dbf
40Incr101347814-OCT-12/u01/app/oradata/orcl/users01.dbf
BSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime
-------------------------------------------------------------
4Incr09.36MDISK00:
00:
0914-OCT-12
BPKey:
4Status:
AVAILABLECompressed:
NOTag:
TAG20121014T234247
PieceName:
/u01/app/flash_recovery_area/ORCL/backupset/2012_10_14/o1_mf_ncsn0_TAG20121014T234247_87oqdcfn_.bkp
SPFILEIncluded:
Modificationtime:
14-OCT-12
SPFILEdb_unique_name:
ORCL
ControlFileIncluded:
CkpSCN:
1013478Ckptime:
14-OCT-12
控制文件位置
[oracle@oracleorcl]$pwd
/u01/app/oradata/orcl
[oracle@oracleorcl]$ls
control01.ctlredo02.logsysaux01.dbftemp01.dbfusers01.dbf
redo01.logredo03.logsystem01.dbfundotbs01.dbf
[oracle@oracleorcl]$stringscontrol01.ctl
}|{z
NORCL
{/l
{/ORCL
{/ORCL
orcl
orcl
z|/~~
z|/~~
/u01/app/oradata/orcl/redo03.log
/u01/app/oradata/orcl/redo02.log
/u01/app/oradata/orcl/redo01.log
/u01/app/oradata/orcl/users01.dbf
/u01/app/oradata/orcl/undotbs01.dbf
/u01/app/oradata/orcl/sysaux01.dbf
/u01/app/oradata/orcl/system01.dbf
/u01/app/oradata/orcl/temp01.dbf
/u01/app/oradata/orcl/redo03.log
/u01/app/oradata/orcl/redo02.log
/u01/app/oradata/orcl/redo01.log
/u01/app/oradata/orcl/users01.dbf
/u01/app/oradata/orcl/undotbs01.dbf
/u01/app/oradata/orcl/sysaux01.dbf
/u01/app/oradata/orcl/system01.dbf
/u01/app/oradata/orcl/temp01.dbf
SYSTEM
SYSAUX
UNDOTBS1
USERS
TEMP
SYSTEM
SYSAUX
UNDOTBS1
USERS
TEMP
{/~~
{/~~
DISK
/u01/app/flash_recovery_area/ORCL/backupset/2012_10_14/o1_mf_nnndf_TAG20121014T232632_87opf8cn_.bkp
TAG20121014T232632
DISK
/u01/app/flash_recovery_area/ORCL/backupset/2012_10_14/o1_mf_ncsnf_TAG20121014T232632_87oph2jj_.bkp
TAG20121014T232632
DISK
/u01/app/flash_recovery_area/ORCL/backupset/2012_10_14/o1_mf_nnnd0_TAG20121014T234247_87oqcqkr_.bkp
TAG20121014T234247
DISK
/u01/app/flash_recovery_area/ORCL/backupset/2012_10_14/o1_mf_ncsn0_TAG20121014T234247_87oqdcfn_.bkp
TAG20121014T234247
DISK
/u01/app/flash_recovery_area/ORCL/backupset/2012_10_14/o1_mf_nnndf_TAG20121014T232632_87opf8cn_.bkp
TAG20121014T232632
DISK
/u01/app/flash_recovery_area/ORCL/backupset/2012_10_14/o1_mf_ncsnf_TAG20121014T232632_87oph2jj_.bkp
TAG20121014T232632
DISK
/u01/app/flash_recovery_area/ORCL/backupset/2012_10_14/o1_mf_nnnd0_TAG20121014T234247_87oqcqkr_.bkp
TAG20121014T234247
|/l
|/l
|/l
|/l
|/l
|/l
|/l
|/l
|/l
|/l
|/l
|/l
|/l
|/l
|/l
|/l
|/l
|/l
|/l
ORCL
ORCL
ORCL
orcl
HbE#v
orcl
HbE#v
2012-10-14T23:
24:
18
RMAN
2012-10-14T23:
24:
18
list
2012-10-14T23:
24:
18
list
2012-10-14T23:
24:
18
backup
2012-10-14T23:
24:
18
list
2012-10-14T23:
24:
18
list
2012-10-14T23:
32:
52
RMAN
2012-10-14T23:
32:
52
list
2012-10-14T23:
40:
35
RMAN
2012-10-14T23:
40:
35
list
2012-10-14T23:
40:
35
backup
2012-10-14T23:
40:
35
list
2012-10-14T23:
44:
59
RMAN
2012-10-14T23:
44:
59
list
2012-10-14T23:
50:
36
RMAN
2012-10-14T23:
50:
36
list
2012-10-14T23:
24:
18
RMAN
2012-10-14T23:
24:
18
list
2012-10-14T23:
24:
18
list
2012-10-14T23:
24:
18
backup
2012-10-14T23:
24:
18
list
2012-10-14T23:
24:
18
list
2012-10-14T23:
32:
52
RMAN
2012-10-14T23:
32:
52
list
2012-10-14T23:
40:
35
RMAN
2012-10-14T23:
40:
35
list
2012-10-14T23:
40:
35
backup
2012-10-14T23:
40:
35
list
2012-10-14T23:
44:
59
RMAN
2012-10-14T23:
44:
59
list
2012-10-14T23:
50:
36
RMAN
2012-10-14T23:
50:
36
list
orcl
UNNAMED_INSTANCE_2
UNNAMED_INSTANCE_3
UNNAMED_INSTANCE_4
UNNAMED_INSTANCE_5
UNNAMED_INSTANCE_6
UNNAMED_INSTANCE_7
UNNAMED_INSTANCE_8
orcl
UNNAMED_INSTANCE_2
UNNAMED_INSTANCE_3
UNNAMED_INSTANCE_4
UNNAMED_INSTANCE_5
UNNAMED_INSTANCE_6
UNNAMED_INSTANCE_7
UNNAMED_INSTANCE_8
ACMunittestingoperation
LSBDatabaseGuard
SupplementalLogDataDDL
LSBRoleChangeSupport
RFSblockandkillacrossRAC
RAC-wideSGA
ACMunittestingoperation
LSBDatabaseGuard
SupplementalLogDataDDL
LSBRoleChangeSupport
RFSblockandkillacrossRAC
RAC-wideSGA
[oracle@oracleorcl]$
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- rman
![提示](https://static.bdocx.com/images/bang_tan.gif)