BACKUP

来源:互联网 发布:python url发送 编辑:程序博客网 时间:2024/05/28 05:16

 

 

backup(oracle)

The following table illustrates the main types of physical backups and the non-RMAN methods for performing these backups.

Backup ObjectBackup MethodExample

Datafiles

Operating system utility

% cp df3.f df3.bak

Archived logs

Operating system utility

% cp log_1_23.arc log_1_23.bak

Control files

SQL statement

SQL> ALTER DATABASE BACKUP CONTROLFILE TO cf1.bak

Initialization parameter file

SQL statement

SQL> CREATE PFILE = init.ora.bak FROM SPFILE;

Network and password files

Operating system utility

% cp tnsnames.ora tnsnames.bak

C:/> copy tnsnames.ora tnsnames.bak

Logical objects (tables, indexes, PL/SQL units)

Export utility

% export SYSTEM/manager TABLE=hr.emp FILE=emp.dmp


 

 

 

Consistent and Inconsistent User-Managed Backups

You can use RMAN or operating system commands to make an inconsistent backup or a consistent backup. An inconsistent backup is a backup of one or more database files made while the database is open or after the database has not been shut down normally. A consistent backup is a backup of one or more database files that you make after the database has been shut down normally. Unlike an inconsistent backup, a consistent backup does not require recovery after it is restored.

A consistent whole database backup is the only valid backup option for databases running in NOARCHIVELOG mode, because otherwise redo needed for recovery is not available. In NOARCHIVELOG mode, Oracle overwrites redo records without archiving them first.

If you run the database in ARCHIVELOG mode, then you can back up database files while the database is open. These backups are inconsistent, but as long as you have the necessary archived redo logs you can recover these backups. You can either take a tablespace offline and back up its datafiles, or perform an online backup. An online backup occurs when the tablespace is still online. To perform an online backup, you must begin and end the backup with SQL statements that place the tablespace in and take the tablespace out of backup mode.

 

 

原创粉丝点击
热门问题 老师的惩罚 人脸识别 我在镇武司摸鱼那些年 重生之率土为王 我在大康的咸鱼生活 盘龙之生命进化 天生仙种 凡人之先天五行 春回大明朝 姑娘不必设防,我是瞎子 快成熟葡萄软果怎么办 木本叶长白斑点了怎么办 天猫卖家超过72小时未发货怎么办 淘宝超过72小时不发货怎么办 鸿运当头干叶了怎么办 百合枝干长歪了怎么办 植物主干长歪了怎么办 钱兜子花叶子黄怎么办 丝瓜有苦味吃了怎么办 吃了苦的西葫芦怎么办 吃了苦的西葫芦中毒怎么办 吃了一点苦丝瓜怎么办 丝瓜苦味我吃了怎么办? 小孩牙地包天怎么办 小孩的牙地包天怎么办 小孩牙是地包天怎么办 布偶猫生宝宝时怎么办 仔猪拉稀打针喂药都不好怎么办 qq群宠物沉眠怎么办 单位不给开离职证明怎么办 电梯年检报告丢了怎么办 小学生养成夜训交怎么办? 遇到自私多疑的老公该怎么办 老年人吵架非说打她了装病怎么办 高三厌学家长该怎么办 考研团员档案丢了怎么办 学生的档案丢了怎么办 大四团员证丢了怎么办 2岁宝宝吸收不好怎么办 孩子逆反心理特强沟通不了怎么办 一年级孩子有逆反心里怎么办 如果一个学生会部门没人留怎么办 如果学生会部门很少人报名怎么办 职场说错话了我该怎么办? 中考通知书收到两份怎么办 高三学生英语差怎么办 论文查重百分之0怎么办 微信红包发错人了怎么办 文学社在社团活动日可以怎么办 小孩玩游戏瞎花钱怎么办 党员不配合纪检调查工作怎么办