rmanWord文档格式.docx

rmanWord文档格式.docx

《rmanWord文档格式.docx》由会员分享，可在线阅读，更多相关《rmanWord文档格式.docx（9页珍藏版）》请在冰豆网上搜索。

exportORACLE_BASE=/u01/app

exportORACLE_HOME=$ORACLE_BASE/oracle

exportORACLE_SID=orcl

exportPATH=$ORACLE_HOME/bin:

$PATH:

$HOME/bin

改变数据库的databaselogmode模式

startupmount//mount启动数据库

alterdatabasearchivelog//改变databaselogmode模式

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

2Full9.36MDISK00:

0314-OCT-12

2Status:

/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:

backupincrementallevel=0database;

//0级全备份，可进行增量备份

3Incr0985.20MDISK00:

0514-OCT-12

3Status:

TAG20121014T234247

/u01/app/flash_recovery_area/ORCL/backupset/2012_10_14/o1_mf_nnnd0_TAG20121014T234247_87oqcqkr_.bkp

ListofDatafilesinbackupset3

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

4Incr09.36MDISK00:

0914-OCT-12

4Status:

/u01/app/flash_recovery_area/ORCL/backupset/2012_10_14/o1_mf_ncsn0_TAG20121014T234247_87oqdcfn_.bkp

控制文件位置

[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

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

SYSTEM

SYSAUX

UNDOTBS1

USERS

TEMP

{/~~

DISK

/u01/app/flash_recovery_area/ORCL/backupset/2012_10_14/o1_mf_nnndf_TAG20121014T232632_87opf8cn_.bkp

TAG20121014T232632

/u01/app/flash_recovery_area/ORCL/backupset/2012_10_14/o1_mf_ncsnf_TAG20121014T232632_87oph2jj_.bkp

/u01/app/flash_recovery_area/ORCL/backupset/2012_10_14/o1_mf_nnnd0_TAG20121014T234247_87oqcqkr_.bkp

TAG20121014T234247

/u01/app/flash_recovery_area/ORCL/backupset/2012_10_14/o1_mf_ncsn0_TAG20121014T234247_87oqdcfn_.bkp

|/l

ORCL

HbE#v

2012-10-14T23:

24:

18

RMAN

list

backup

32:

52

40:

35

44:

59

50:

36

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

[oracle@oracleorcl]$