设为首页 收藏本站
查看: 1007|回复: 0

[经验分享] OCM_Session1_9_Database Backup and Availability

[复制链接]

尚未签到

发表于 2015-11-9 11:39:08 | 显示全部楼层 |阅读模式
9. Database Backup and Availability 9.1 Backup the database to prepare for complete recovery under all circumstances. 9.2 Open the database.

  • 9.1 Backup the database to prepare for complete recovery under all circumstances.


没有说明如何备份数据库。建议冷备份和热备份一起。
1.创建备份的目录[oracle@ocm1 ~]$ cd $ORACLE_BASE/oradata/PROD/Disk5[oracle@ocm1 Disk5]$ lltotal 0[oracle@ocm1 Disk5]$ mkdir bak[oracle@ocm1 Disk5]$ lltotal 4drwxr-xr-x 2 oracle oinstall 4096 Mar 19 15:02 bak[oracle@ocm1 Disk5]$ cd bak[oracle@ocm1 bak]$ pwd/u01/app/oracle/oradata/PROD/Disk5/bak
2.将数据库改变为归档模式SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startup mountORACLE instance started.
Total System Global Area  524288000 bytesFixed Size                  1220360 bytesVariable Size             163578104 bytesDatabase Buffers          356515840 bytesRedo Buffers                2973696 bytesDatabase mounted.SQL> alter database archivelog;  
Database altered.
3.rman备份
[oracle@ocm1 ~]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Wed Mar 19 15:08:31 2014
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
connected to target database: PROD (DBID=254361867, not open)
RMAN> backup as compressed backupset database format '/u01/app/oracle/oradata/PROD/Disk5/bak/PROD_%U.bak';
Starting backup at 19-MAR-14using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=285 devtype=DISKchannel ORA_DISK_1: starting compressed full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=00004 name=/u01/app/oracle/oradata/PROD/Disk1/example01.dbfinput datafile fno=00001 name=/u01/app/oracle/oradata/PROD/Disk1/system01.dbfinput datafile fno=00003 name=/u01/app/oracle/oradata/PROD/Disk1/sysaux01.dbfinput datafile fno=00002 name=/u01/app/oracle/oradata/PROD/Disk1/undotbs01.dbfinput datafile fno=00007 name=/u01/app/oracle/oradata/PROD/Disk1/users01.dbfinput datafile fno=00008 name=/u01/app/oracle/oradata/PROD/Disk1/oltp01.dbfinput datafile fno=00005 name=/u01/app/oracle/oradata/PROD/Disk1/indx01.dbfinput datafile fno=00006 name=/u01/app/oracle/oradata/PROD/Disk1/tools01.dbfchannel ORA_DISK_1: starting piece 1 at 19-MAR-14channel ORA_DISK_1: finished piece 1 at 19-MAR-14piece handle=/u01/app/oracle/oradata/PROD/Disk5/bak/PROD_01p3iuaf_1_1.bak tag=TAG20140319T151005 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:02:07channel ORA_DISK_1: starting compressed full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetincluding current control file in backupsetincluding current SPFILE in backupsetchannel ORA_DISK_1: starting piece 1 at 19-MAR-14channel ORA_DISK_1: finished piece 1 at 19-MAR-14piece handle=/u01/app/oracle/oradata/PROD/Disk5/bak/PROD_02p3iuee_1_1.bak tag=TAG20140319T151005 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:03Finished backup at 19-MAR-14
RMAN>

  • 9.2 Open the database.
RMAN> alter database open;
database opened
SQL> select open_mode from v$database;
OPEN_MODE----------READ WRITE         版权声明:本文为博主原创文章,未经博主允许不得转载。

运维网声明 1、欢迎大家加入本站运维交流群:群②:261659950 群⑤:202807635 群⑦870801961 群⑧679858003
2、本站所有主题由该帖子作者发表,该帖子作者与运维网享有帖子相关版权
3、所有作品的著作权均归原作者享有,请您和我们一样尊重他人的著作权等合法权益。如果您对作品感到满意,请购买正版
4、禁止制作、复制、发布和传播具有反动、淫秽、色情、暴力、凶杀等内容的信息,一经发现立即删除。若您因此触犯法律,一切后果自负,我们对此不承担任何责任
5、所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其内容的准确性、可靠性、正当性、安全性、合法性等负责,亦不承担任何法律责任
6、所有作品仅供您个人学习、研究或欣赏,不得用于商业或者其他用途,否则,一切后果均由您自己承担,我们对此不承担任何法律责任
7、如涉及侵犯版权等问题,请您及时通知我们,我们将立即采取措施予以解决
8、联系人Email:admin@iyunv.com 网址:www.yunweiku.com

所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其承担任何法律责任,如涉及侵犯版权等问题,请您及时通知我们,我们将立即处理,联系人Email:kefu@iyunv.com,QQ:1061981298 本贴地址:https://www.yunweiku.com/thread-136982-1-1.html 上篇帖子: ORA- 12012 : err or on aut o execu te of job ORACLE_OCM. MGMT_CONFIG_JOB_2_ 下篇帖子: OCM_Session3_3_Flashback Database
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

扫码加入运维网微信交流群X

扫码加入运维网微信交流群

扫描二维码加入运维网微信交流群,最新一手资源尽在官方微信交流群!快快加入我们吧...

扫描微信二维码查看详情

客服E-mail:kefu@iyunv.com 客服QQ:1061981298


QQ群⑦:运维网交流群⑦ QQ群⑧:运维网交流群⑧ k8s群:运维网kubernetes交流群


提醒:禁止发布任何违反国家法律、法规的言论与图片等内容;本站内容均来自个人观点与网络等信息,非本站认同之观点.


本站大部分资源是网友从网上搜集分享而来,其版权均归原作者及其网站所有,我们尊重他人的合法权益,如有内容侵犯您的合法权益,请及时与我们联系进行核实删除!



合作伙伴: 青云cloud

快速回复 返回顶部 返回列表