oracle rman备份时间,Oracle 11g RMAN备份-一致备份

--调整为非归档模式

sys@TESTDB11>shutdownimmediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

--启动到mount状态

sys@TESTDB11>startup

mount;

ORACLE instance started.

Total SystemGlobalArea855982080bytes

FixedSize2230792bytes

VariableSize641730040bytes

Database Buffers209715200bytes

Redo Buffers2306048bytes

Database mounted.

--如果开启了闪回日志，则要关闭闪回日志

sys@TESTDB11>alterdatabase

flashbackoff;

--改变为非归档模式

Database altered.

sys@TESTDB11>alterdatabase

noarchivelog;

Database altered.

--开库

sys@TESTDB11>alterdatabaseopen;

Database altered.

--查看已经运行于非归档模式

sys@TESTDB11>archiveloglist;

DatabaselogmodeNoArchiveMode

Automatic archivalDisabled

Archive destination/archive2

Oldestonlinelogsequence22

Currentlogsequence24

--登录rman后关库

RMAN>shutdownimmediate;

usingtarget database controlfileinsteadofrecoverycatalog

database closed

database dismounted

Oracle instance shut down

--不能进行备份

RMAN>backup database;

Starting backupat2013-08-1405:42:26

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

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

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

RMAN-03002:failureofbackup commandat08/14/201305:42:26

RMAN-06171:notconnectedtotarget database

--进入nomount状态,仍然不能进行备份

RMAN>startup nomount;

connectedtotarget database(notstarted)

Oracle instance started

Total SystemGlobalArea855982080bytes

FixedSize2230792bytes

VariableSize641730040bytes

Database Buffers209715200bytes

Redo Buffers2306048bytes

RMAN>backup database;

Starting backupat2013-08-1405:43:17

allocated channel:ORA_DISK_1

channel ORA_DISK_1:SID=18devicetype=DISK

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

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

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

RMAN-03002:failureofbackup commandat08/14/201305:43:18

ORA-01507:databasenotmounted

--只有在mount状态下才可进行备份，原因是rman需要控制文件中的信息，同时需要向控制文件中存储信息

RMAN>mount database;

database mounted

released channel:ORA_DISK_1

--进行全库一致性备份

RMAN>backup database;

Starting backupat2013-08-1405:48:27

configurationforDISK channel2isignored

allocated channel:ORA_DISK_1

channel ORA_DISK_1:SID=18devicetype=DISK

channel ORA_DISK_1:starting full datafile backupset

channel ORA_DISK_1:specifying datafile(s)inbackupset

inputdatafilefilenumber=00001name=/oradata/system01.dbf

inputdatafilefilenumber=00002name=/oradata/sysaux01.dbf

inputdatafilefilenumber=00005name=/oradata/example01.dbf

inputdatafilefilenumber=00003name=/oradata/undotbs01.dbf

inputdatafilefilenumber=00007name=/oradata/fbtbs01.dbf

inputdatafilefilenumber=00008name=/oradata/users02.dbf

inputdatafilefilenumber=00006name=/oradata/newts01.dbf

inputdatafilefilenumber=00004name=/oradata/users01.dbf

channel ORA_DISK_1:starting piece1at2013-08-1405:48:28

channel ORA_DISK_1:finished piece1at2013-08-1405:51:01

piece handle=/pooldisk02/backup03/20oh8i5c_1_1 tag=TAG20130814T054828comment=NONE

channel ORA_DISK_1:backupsetcomplete,elapsedtime:00:02:33

Finished backupat2013-08-1405:51:01

Starting ControlFileandSPFILE Autobackupat2013-08-1405:51:01

piece handle=/u01/app/oracle/fast_recovery_area/TESTDB11/autobackup/2013_08_14/o1_mf_s_823412526_90pr8psq_.bkpcomment=NONE

Finished ControlFileandSPFILE Autobackupat2013-08-1405:51:04

--打开归档模式

sys@TESTDB11>shutdownimmediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

--启动到mount状态

sys@TESTDB11>startup mount;

ORACLE instance started.

Total SystemGlobalArea855982080bytes

FixedSize2230792bytes

VariableSize641730040bytes

Database Buffers209715200bytes

Redo Buffers2306048bytes

Database mounted.

--修改为归档模式

sys@TESTDB11>alterdatabase

archivelog;

Database altered.

--查看归档模式

sys@TESTDB11>archiveloglist;

DatabaselogmodeArchiveMode

Automatic archivalEnabled

Archive destination/archive2

Oldestonlinelogsequence22

Nextlogsequencetoarchive24

Currentlogsequence24

--开库

sys@TESTDB11>alterdatabaseopen;

Database altered.

--将原来所有备份删除，包括刚做的一致性备份

RMAN>deletebackup;

--开归档之后要做一个整库备份(非一致性的)

RMAN>backup database;