Oracle笔记

Oracle笔记

bachue posted @ 2010年9月10日 04:25 in Database with tags backup database oracle rman , 2552 阅读

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; //开启控制文件自动备份

new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
 
RMAN> backup database spfile include current controlfile plus archivelog;
 
/*备份归档日志,由于命令中带有plus archivelog,因此手动备份归档日志*/
Starting backup at 09-SEP-10
current log archived //当前日志归档
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=143 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=4 recid=1 stamp=729289389
channel ORA_DISK_1: starting piece 1 at 09-SEP-10
channel ORA_DISK_1: finished piece 1 at 09-SEP-10
piece handle=/home/oracle/oracle/flash_recovery_area/ORCL/backupset/2010_09_09/o1_mf_annnn_TAG20100909T202309_68knfh2s_.bkp tag=TAG20100909T202309 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 09-SEP-10
 
/*备份数据文件,控制文件和服务器参数文件*/
Starting backup at 09-SEP-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/home/oracle/oracle/oradata/orcl/system01.dbf
input datafile fno=00003 name=/home/oracle/oracle/oradata/orcl/sysaux01.dbf
input datafile fno=00005 name=/home/oracle/oracle/oradata/orcl/example01.dbf
input datafile fno=00002 name=/home/oracle/oracle/oradata/orcl/undotbs01.dbf
input datafile fno=00004 name=/home/oracle/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: starting piece 1 at 09-SEP-10
channel ORA_DISK_1: finished piece 1 at 09-SEP-10
piece handle=/home/oracle/oracle/flash_recovery_area/ORCL/backupset/2010_09_09/o1_mf_nnndf_TAG20100909T202312_68knfjll_.bkp tag=TAG20100909T202312 comment=NONE //数据文件备份位置
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:55
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 09-SEP-10
channel ORA_DISK_1: finished piece 1 at 09-SEP-10
piece handle=/home/oracle/oracle/flash_recovery_area/ORCL/backupset/2010_09_09/o1_mf_ncsnf_TAG20100909T202312_68knk68q_.bkp tag=TAG20100909T202312 comment=NONE //控制文件和服务器参数文件位置
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
Finished backup at 09-SEP-10
 
/*归档日志再次被备份,事后查看备份文件,发现第一次归档备份文件大小是第二次的数百倍,可能因为是Open Backup,数据库在备份期间生成了重做日志,因此需要再次备份,证据就是Close Backup的时候不会有第二次备份归档日志,他会显示:specification does not match any archive log in the recovery catalog backup cancelled because all files were skipped*/
Starting backup at 09-SEP-10
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=5 recid=2 stamp=729289512
channel ORA_DISK_1: starting piece 1 at 09-SEP-10
channel ORA_DISK_1: finished piece 1 at 09-SEP-10
piece handle=/home/oracle/oracle/flash_recovery_area/ORCL/backupset/2010_09_09/o1_mf_annnn_TAG20100909T202512_68knk991_.bkp tag=TAG20100909T202512 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 09-SEP-10
 
/*由于之前开启了自动备份控制文件和服务器参数文件,因此他们再次被备份*/
Starting Control File and SPFILE Autobackup at 09-SEP-10
piece handle=/home/oracle/oracle/flash_recovery_area/ORCL/autobackup/2010_09_09/o1_mf_s_729289514_68knkby5_.bkp comment=NONE //注意不是放在backupset文件夹下面,而是放在autobackup文件夹下面
Finished Control File and SPFILE Autobackup at 09-SEP-10
 
 
/*
备份完毕,共五个文件,四个在backupset文件夹下,一个在autobackup文件夹下
从上述文字可知,如果开启控制文件自动备份,那么只要发生备份,控制文件和服务器参数文件必然会自动备份,无论备份命令中是否已经显式的要求备份他们了,且自动备份的位置是在autobackup文件夹下。
 
控制文件和服务器参数文件总备份在一起。
 
只要要求备份归档日志(即plus archivelog),归档日志就会有两次备份,分别存储在两个文件下。
*/
 
maid services dubai 说:
2019年9月18日 15:56

Your local house housecleaning services vendors charge in a different; it mostly hinges on your standards. So, if you happen to doing “deep housecleaning, ” they offer a swelling sum amount for the job, and if you happen to living within the studio, put on charge you will from 210 to 310 AED that would go as much 1, 500 AED in a 5-bedroom studio.

dui lawyer montreal 说:
2019年11月15日 00:59

Outfitting fashionably is a terrific way to express your self and increase your self-confidence. It can result in success in the areas, even your own professional as well as personal existence. However, style trends alter quickly. It occasionally feels impossible maintain with the actual fast-paced.

shopping batalha 说:
2020年3月24日 19:52

The method before a purchase online is most likely the most critical with a shopping cart's accomplishment. If the particular buying method causes disappointment, confusion or perhaps insecurity, the user probably will abandon the shopping cart application, never to go back again.

elimperio travel 说:
2020年3月24日 19:53

In order to make the nearly all of your company travel price range, it is important to policy for leveraging the program for many it will probably be worth. Telling travelers to choose the least expensive logical airfare is simply not enough. Here will be the elements that ought to be considered any time planning or perhaps evaluating the travel system.

travelling 2 peru 说:
2020年3月24日 19:57

A fantastic option is undertake a 'personalised' on the web booking tool that is custom made in accordance with you company particular vacation policies and also needs. Although getting your own vacation tech provides its positive aspects - for instance to be able to increase performance with integrated approval techniques and taking care of your travel whenever you want - there are many disadvantages that ought to be noted.

rapidity news 说:
2020年3月24日 19:58

Tv set is one more medium regarding news and also current affairs in different country or perhaps locality; more frequently news will be brought stay and realtime. However, internet also can bring such advantages for news visitors and viewers. Aside coming from full posts on well-known news, you can find websites which usually enable viewers to look at news just like what they could find about TV.

eastern iowa news 说:
2020年3月24日 19:59

Virtually any news around the globe can become published online in just a matter of few seconds. People may be more updated with the aid of online magazines. Current extramarital relationships news can be looked at immediately from the internet as opposed to waiting to get a day so that you can read it around the printed magazines.

maids in dubai 说:
2020年4月29日 18:17

If you hire a new servant maid to scrub you office or house, you are generally permitting her gain access to to your own belongings. Consequently before getting a house maid, you need to ask selected questions to discover more on her qualifications information along with personal qualifications. First issue is that will, you need to inquire your mates, relatives as well as acquaintances because of their personal experience while using servant service personnel.

painters in Dubai 说:
2020年4月29日 18:17

If you need to give your own home a certain sort of atmosphere, then indoor paints are incredibly important. The paints that you just choose will give you either friendliness or coolness on the rooms in your home and if you wish to paint on your own or use house artists; keep planned that you have many ideas that you can consider. These concepts include finding things for example the right coloring, colors, hues, schemes, coloring methods, and various other related features.

cleaning company dub 说:
2021年6月07日 14:45

Stay away from using mobile phones, tablets, televisions regarding televisions although cleaning your house. Because this could slow straight down the pace with the work. Additionally, you can become having a smaller amount energy to carry on the washing process. Thus, put apart these disruptions to increase the complete process.

AP 10th Physics Mode 说:
2022年9月15日 22:47

Physical Science is the part of Science known as Physics (PS), every student in class 10th grade studying at Government & Private Schools of the state board can download the AP SSC PS Model Paper 2023 with answers for all topics of the course designed by the board experts based on the new revised syllabus and curriculum of the BSEAP. Either Telugu medium, English medium and Urdu medium students of class 10th can download the AP SSC Physics model papers 2023 to practice with regular revisions and mock tests. AP 10th Physics Model Paper Class teachers and leading institutional experts are prepared those AP 10th Class PS Model Paper 2023 Pdf with answers that support all exam formats of the board such as Summative Assessments (SA-1 & SA-2) and Formative assessments (FA-1, FA-2, FA-3, FA-4) along with Assignments.


登录 *


loading captcha image...
(输入验证码)
or Ctrl+Enter