Oracle 11g 备份与恢复使用RMAN创建备份集举例-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

Oracle 11g 备份与恢复使用RMAN创建备份集举例

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 04:43 PM

Oracle 11g 备份与恢复使用RMAN创建备份集举例

Linux公社

首页 → 数据库技术

背景：

阅读新闻

Oracle 11g 备份与恢复使用RMAN创建备份集举例

[日期：2014-08-28] 来源：Linux社区作者：LuiseDalian [字体：]

Oracle 11g 备份与恢复使用RMAN创建备份集举例

--%d: Specifies the name of the database

--%s: Specifies the backup set number. This number is a counter in the control file that is incremented for each backup set.

-- The counter value starts at 1 and is unique for the lifetime of the control file.

-- If you restore a backup control file, then duplicate values can result.

-- Also, CREATE CONTROLFILE initializes the counter back to 1

--%p: Specifies the piece number within the backup set.

-- This value starts at 1 for each backup set and is incremented by 1 as each backup piece is created.

RMAN> backup as backupset format '/backup01/df_%d_%s_%p.bus' tablespace users;

Starting backup at 09-AUG-14

using channel ORA_DISK_1

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00004 name=+DISKGROUP01/testdb11/users01.dbf

channel ORA_DISK_1: starting piece 1 at 09-AUG-14

channel ORA_DISK_1: finished piece 1 at 09-AUG-14

piece handle=/backup01/df_TESTDB11_31_1.bus tag=TAG20140809T104346 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 09-AUG-14

--查看产生的备份文件

[oracle@OL54.cuug.net:/backup01]$ ls -l

total 18248

-rw-r----- 1 oracle dba 9830400 Aug 9 07:31 02pfgdr4_1_1

-rw-r----- 1 oracle dba 5251072 Aug 9 09:13 data_D-TESTDB11_I-2620210741_TS-USERS_FNO-4_0mpfgjqi

-rw-r----- 1 oracle dba 3571712 Aug 9 10:43 df_TESTDB11_31_1.bus

--删除所有备份

RMAN> delete backup;

using channel ORA_DISK_1

List of Backup Pieces

BP Key BS Key Pc# Cp# Status Device Type Piece Name

------- ------- --- --- ----------- ----------- ----------

575 574 1 1 AVAILABLE DISK /backup01/df_TESTDB11_31_1.bus

Do you really want to delete the above objects (enter YES or NO)? yes

deleted backup piece

backup piece handle=/backup01/df_TESTDB11_31_1.bus RECID=26 STAMP=855139427

Deleted 1 objects

--------------------------------------推荐阅读 --------------------------------------

RMAN 配置归档日志删除策略

Oracle基础教程之通过RMAN复制数据库

RMAN备份策略制定参考内容

RMAN备份学习笔记

Oracle数据库备份加密 RMAN加密

--------------------------------------分割线 --------------------------------------

本文永久更新链接地址：

linux

MySQL搭建带过滤的复制环境

Oracle数据泵远程导入文件到本地数据库

最新资讯

本周热门

Linux公社简介 - 广告服务 - 网站地图 - 帮助信息 - 联系我们
本站（LinuxIDC）所刊载文章不代表同意其说法或描述，仅为提供更多信息，，也不构成任何建议。

Copyright © 2006-2014　Linux公社　All rights reserved 浙ICP备06018118号

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

How do you alter a table in MySQL using the ALTER TABLE statement?Mar 19, 2025 pm 03:51 PM

The article discusses using MySQL's ALTER TABLE statement to modify tables, including adding/dropping columns, renaming tables/columns, and changing column data types.

How do I configure SSL/TLS encryption for MySQL connections?Mar 18, 2025 pm 12:01 PM

Article discusses configuring SSL/TLS encryption for MySQL, including certificate generation and verification. Main issue is using self-signed certificates' security implications.[Character count: 159]

How do you handle large datasets in MySQL?Mar 21, 2025 pm 12:15 PM

Article discusses strategies for handling large datasets in MySQL, including partitioning, sharding, indexing, and query optimization.

What are some popular MySQL GUI tools (e.g., MySQL Workbench, phpMyAdmin)?Mar 21, 2025 pm 06:28 PM

Article discusses popular MySQL GUI tools like MySQL Workbench and phpMyAdmin, comparing their features and suitability for beginners and advanced users.[159 characters]

How do you drop a table in MySQL using the DROP TABLE statement?Mar 19, 2025 pm 03:52 PM

The article discusses dropping tables in MySQL using the DROP TABLE statement, emphasizing precautions and risks. It highlights that the action is irreversible without backups, detailing recovery methods and potential production environment hazards.

How do you represent relationships using foreign keys?Mar 19, 2025 pm 03:48 PM

Article discusses using foreign keys to represent relationships in databases, focusing on best practices, data integrity, and common pitfalls to avoid.

How do you create indexes on JSON columns?Mar 21, 2025 pm 12:13 PM

The article discusses creating indexes on JSON columns in various databases like PostgreSQL, MySQL, and MongoDB to enhance query performance. It explains the syntax and benefits of indexing specific JSON paths, and lists supported database systems.

How do I secure MySQL against common vulnerabilities (SQL injection, brute-force attacks)?Mar 18, 2025 pm 12:00 PM

Article discusses securing MySQL against SQL injection and brute-force attacks using prepared statements, input validation, and strong password policies.(159 characters)

See all articles