Home Database Mysql Tutorial 设置rman实现归档备份在两个不同的目录

设置rman实现归档备份在两个不同的目录

Jun 07, 2016 pm 03:55 PM
different backup accomplish Archive Table of contents set up

[oracle@edbjr2p1 admin]$ rman target /catalog rc_admin/rc_admin@emrep Recovery Manager: Release 10.2.0.1.0 -Production on Sat Apr 12 09:41:41 2014 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: PROD(DB

[oracle@edbjr2p1 admin]$ rman target /catalog rc_admin/rc_admin@emrep

Recovery Manager: Release 10.2.0.1.0 -Production on Sat Apr 12 09:41:41 2014

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: PROD(DBID=255136845)

connected to recovery catalog database

RMAN>configure archivelog backup copies for device type disk to 2;

old RMAN configuration parameters:

CONFIGURE ARCHIVELOG BACKUP COPIES FORDEVICE TYPE DISK TO 2;

new RMAN configuration parameters:

CONFIGURE ARCHIVELOG BACKUP COPIES FORDEVICE TYPE DISK TO 2;

new RMAN configuration parameters aresuccessfully stored

starting full resync of recovery catalog

full resync complete

RMAN>configure channel 1 device type disk format '/u01/%U','/u01/app/%U';

old RMAN configuration parameters:

CONFIGURE CHANNEL 1 DEVICE TYPE DISKFORMAT '/u01/%U', '/u01/app/%U';

new RMAN configuration parameters:

CONFIGURE CHANNEL 1 DEVICE TYPE DISKFORMAT '/u01/%U', '/u01/app/%U';

new RMAN configuration parameters aresuccessfully stored

starting full resync of recovery catalog

full resync complete

RMAN> backuparchivelog all;

Starting backup at 12-APR-14

current log archived

configuration for DISK channel 2 is ignored

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=196 devtype=DISK

skipping archive log file/home/oracle/flash/PROD/archivelog/2014_03_31/o1_mf_1_6_9ml8yy6m_.arc; alreadybacked up 2 time(s)

略。。

channel ORA_DISK_1: starting archive logbackupset

channel ORA_DISK_1: specifying archivelog(s) in backup set

input archive log thread=1 sequence=38recid=33 stamp=844681323

channel ORA_DISK_1: starting piece 1 at12-APR-14

channel ORA_DISK_1: finished piece 1 at12-APR-14 with 2 copies and tag TAG20140412T094204

piece handle=/u01/0mp5hk3c_1_1 comment=NONE

piece handle=/u01/app/0mp5hk3c_1_2 comment=NONE

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

Finished backup at 12-APR-14

Starting Control File and SPFILE Autobackupat 12-APR-14

piecehandle=/home/oracle/backup/control/cf_c-255136845-20140412-03 comment=NONE

Finished Control File and SPFILE Autobackupat 12-APR-14

此时配置完备份archivelog可以看到archivelog备份到了两个位置。

但是对于备份数据文件会看到数据文件只是备份到了一个目录:

RMAN> backupdatafile 2;

Starting backup at 12-APR-14

using channel ORA_DISK_1

channel ORA_DISK_1: starting full datafilebackupset

channel ORA_DISK_1: specifying datafile(s)in backupset

input datafile fno=00002name=/u01/app/oracle/oradata/PROD/disk1/undotbs01.dbf

channel ORA_DISK_1: starting piece 1 at12-APR-14

channel ORA_DISK_1: finished piece 1 at12-APR-14

piece handle=/u01/0op5hk42_1_1 tag=TAG20140412T094226comment=NONE

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

Finished backup at 12-APR-14

Starting Control File and SPFILE Autobackupat 12-APR-14

piecehandle=/home/oracle/backup/control/cf_c-255136845-20140412-04 comment=NONE

Finished Control File and SPFILE Autobackupat 12-APR-14

Statement of this Website
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

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to set the scheduled time for publishing works on Douyin? How does it set the video duration? How to set the scheduled time for publishing works on Douyin? How does it set the video duration? Mar 27, 2024 pm 06:11 PM

Publishing works on Douyin can attract more attention and likes, but sometimes it may be difficult for us to publish works in real time. In this case, we can use Douyin's scheduled release function. Douyin’s scheduled release function allows users to automatically publish works at a scheduled time, which can better plan the release plan and increase the exposure and influence of the work. 1. How to set the scheduled time for publishing works on Douyin? To set a scheduled release time, first go to Douyin's personal homepage, find the "+" button in the upper right corner, and click to enter the release page. There is a clock icon in the lower right corner of the publishing page. Click to enter the scheduled publishing interface. In the interface, you can choose the type of work you want to publish, including short videos, long videos, and live broadcasts. Next, you need to set a time for your work to be published. TikTok provides

How to use MySQL backup and restore in PHP? How to use MySQL backup and restore in PHP? Jun 03, 2024 pm 12:19 PM

Backing up and restoring a MySQL database in PHP can be achieved by following these steps: Back up the database: Use the mysqldump command to dump the database into a SQL file. Restore database: Use the mysql command to restore the database from SQL files.

Where is the Douyin tag set? How can it be tagged so that it can be pushed accurately? Where is the Douyin tag set? How can it be tagged so that it can be pushed accurately? Mar 27, 2024 am 11:01 AM

As one of the most popular short video platforms in the world, Douyin allows everyone to become a creator and share every moment of life. For Douyin users, tags are a very important function. It can help users better classify and retrieve content, and also allows the platform to push appropriate content to users more accurately. So, where are the Douyin tags set? This article will explain in detail how to set up and use tags on Douyin. 1. Where is the Douyin tag set? Using tags on Douyin can help users better classify and label their works, making it easier for other users to find and follow them. The method to set the label is as follows: 1. Open the Douyin APP and log in to your account. 2. Click the "+" sign at the bottom of the screen and select the "Publish" button. 3.

How to set up scheduled publishing on Weibo_Tutorial on how to set up scheduled publishing on Weibo How to set up scheduled publishing on Weibo_Tutorial on how to set up scheduled publishing on Weibo Mar 29, 2024 pm 03:51 PM

1. Open the Weibo client, click the three little dots on the editing page, and then click Scheduled Post. 2. After clicking on scheduled posting, there will be a time option on the right side of the publishing time. Set the time, edit the article, and click on the yellow words in the lower right corner to schedule posting. 3. The mobile version of Weibo does not currently support scheduled publishing. This function can only be used on the PC client!

Do Not Disturb Mode Not Working in iPhone: Fix Do Not Disturb Mode Not Working in iPhone: Fix Apr 24, 2024 pm 04:50 PM

Even answering calls in Do Not Disturb mode can be a very annoying experience. As the name suggests, Do Not Disturb mode turns off all incoming call notifications and alerts from emails, messages, etc. You can follow these solution sets to fix it. Fix 1 – Enable Focus Mode Enable focus mode on your phone. Step 1 – Swipe down from the top to access Control Center. Step 2 – Next, enable “Focus Mode” on your phone. Focus Mode enables Do Not Disturb mode on your phone. It won't cause any incoming call alerts to appear on your phone. Fix 2 – Change Focus Mode Settings If there are some issues in the focus mode settings, you should fix them. Step 1 – Open your iPhone settings window. Step 2 – Next, turn on the Focus mode settings

How to set the Enter key to send messages in QQ How to set the Enter key to send messages in QQ Mar 25, 2024 pm 07:10 PM

1. First, click on the mobile phone desktop to enter QQ, and click on the avatar in the upper left corner. 2. Click [Settings] in the lower left corner. 3. Click to open [Accessibility]. 4. Then we only need to click to turn on the [Enter key to send message] switch.

How to set the countdown to grab tickets in Damai How to set the countdown to grab tickets in Damai Apr 01, 2024 pm 07:01 PM

When buying tickets on Damai.com, in order to ensure that the ticket purchase time can be accurately grasped, users can set a floating clock to grab tickets. The detailed setting method is below, let us learn together. How to bind the floating clock to Damai 1. Click to open the floating clock app on your phone to enter the interface, and click on the location where the flash sale check is set, as shown in the figure below: 2. After coming to the page of adding new records, click on Damai.com Copy the ticket purchase link page copied in. 3. Next, set the flash sale time and notification time below, turn on the switch button behind [Save to Calendar], and click [Save] below. 4. Click to turn on [Countdown], as shown in the figure below: 5. When the reminder time comes, click the [Start Picture-in-Picture] button below. 6. When the ticket purchase time comes

Where to set Douyin recommendations and selections Where to set Douyin recommendations and selections Mar 27, 2024 pm 05:06 PM

Where are the recommendations and selections on Douyin? In Douyin short videos, there are two categories: selection and recommendation. Most users don’t know how to set up recommendations and selections. Next is the Douyin tutorial that the editor brings to users. Audio recommendations and selected setting method tutorials, interested users come and take a look! Douyin usage tutorial Where to set up Douyin recommendations and selections 1. First open the Douyin short video APP and enter the main page, click on the [Me] area in the lower right corner and select [three horizontal lines] in the upper right corner; 2. Then on the right The function bar will expand, slide the page to select [Settings] at the bottom; 3. Then on the settings function page, find the [Personal Information Management] service; 4. Finally jump to the personal information management page, slide [Personalized Content Recommendations] 】The buttons on the back can be set.

See all articles