backup 的路径

最新推荐文章于 2022-06-22 10:02:02 发布
最新推荐文章于 2022-06-22 10:02:02 发布
阅读量1.1k 收藏
点赞数
分类专栏： rman 文章标签： backup
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/hzdxw/article/details/43372021
版权 
<pre name="code" class="sql">RMAN> show
2> all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/disk1/user_bs_%d%p%s.bkp';
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '/home/oracle/disk2/user_bs_%d%p%s.bkp';
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/home/oracle/disk2/same_bs_%d%p%s.bkp';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/11G/dbs/snapcf_db01.f'; # default

RMAN> 
 

RMAN> backup tablespace DTFILETS;

Starting backup at 01-FEB-15
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00011 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf
channel ORA_DISK_1: starting piece 1 at 01-FEB-15
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00012 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf
channel ORA_DISK_2: starting piece 1 at 01-FEB-15
channel ORA_DISK_2: finished piece 1 at 01-FEB-15
piece handle=/home/oracle/disk2/user_bs_DB011150.bkp tag=TAG20150201T153459 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: finished piece 1 at 01-FEB-15
piece handle=/home/oracle/disk1/user_bs_DB011149.bkp tag=TAG20150201T153459 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:05
Finished backup at 01-FEB-15

RMAN>
 

清除之前设置的通道信息
 

 

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE<span style="color:#cc0000;"> CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/disk1/user</span>_bs_%d%p%s.bkp';
CONFIGURE <span style="color:#ff0000;">CHANNEL 2 DEVICE TYPE DISK FORMAT   '/home/oracle/disk2/user</span>_bs_%d%p%s.bkp';
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/home/oracle/disk2/same_bs_%d%p%s.bkp';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/11G/dbs/snapcf_db01.f'; # default

RMAN> configure channel 1 device type disk clear;

old RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/disk1/user_bs_%d%p%s.bkp';
old RMAN configuration parameters are successfully deleted
released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '/home/oracle/disk2/user_bs_%d%p%s.bkp';
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/home/oracle/disk2/same_bs_%d%p%s.bkp';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/11G/dbs/snapcf_db01.f'; # default

RMAN> configure channel 2 device type disk clear;

old RMAN configuration parameters:
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '/home/oracle/disk2/user_bs_%d%p%s.bkp';
old RMAN configuration parameters are successfully deleted

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/home/oracle/disk2/same_bs_%d%p%s.bkp';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/11G/dbs/snapcf_db01.f'; # default

RMAN> configure channel  device type disk clear;

old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/home/oracle/disk2/same_bs_%d%p%s.bkp';
old RMAN configuration parameters are successfully deleted

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/11G/dbs/snapcf_db01.f'; # default

RMAN>
的确清空了通道设置。 

 

再次备份表空间，查看系统默认备份地址：
 

RMAN> backup tablespace DTFILETS;

Starting backup at 01-FEB-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=126 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=133 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=132 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00011 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf
channel ORA_DISK_1: starting piece 1 at 01-FEB-15
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00012 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf
channel ORA_DISK_2: starting piece 1 at 01-FEB-15
channel ORA_DISK_1: finished piece 1 at 01-FEB-15
piece handle=/u01/oracle/11G/dbs/4npu6lmq_1_1 tag=TAG20150201T154842 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_2: finished piece 1 at 01-FEB-15
piece handle=/u01/oracle/11G/dbs/4opu6lmq_1_1 tag=TAG20150201T154842 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01
Finished backup at 01-FEB-15

RMAN> <pre name="code" class="sql"><span style="color:#cc0000;">/u01/oracle/11G/dbs 即 SQL> host echo $ORACLE_HOME/dbs     /u01/oracle/11G/dbs</span>
 

 

 

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/11G/dbs/snapcf_db01.f'; # default

RMAN> run{allocate channel c5 DEVICE TYPE DISK;
2> backup tablespace DTFILETS;}

allocated channel: c5
channel c5: sid=116 devtype=DISK

Starting backup at 01-FEB-15
channel c5: starting full datafile backupset
channel c5: specifying datafile(s) in backupset
input datafile fno=00011 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf
input datafile fno=00012 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf
channel c5: starting piece 1 at 01-FEB-15
channel c5: finished piece 1 at 01-FEB-15
piece handle=<span style="color:#cc0000;">/u01/oracle/11G/dbs/</span>5gpu6nop_1_1 tag=TAG20150201T162352 comment=NONE
channel c5: backup set complete, elapsed time: 00:00:01
Finished backup at 01-FEB-15
released channel: c5

RMAN>  run{allocate channel <span style="color:#ff0000;">c5 DEVICE TYPE DISK format '/home/oracle/disk/same_bs_%d%p%s.bkp';</span>
2> backup tablespace DTFILETS;}

allocated channel: c5
channel c5: sid=116 devtype=DISK

Starting backup at 01-FEB-15
channel c5: starting full datafile backupset
channel c5: specifying datafile(s) in backupset
input datafile fno=00011 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf
input datafile fno=00012 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf
channel c5: starting piece 1 at 01-FEB-15
channel c5: finished piece 1 at 01-FEB-15
piece handle=/home/oracle/disk/same_bs_DB011177.bkp tag=TAG20150201T162406 comment=NONE
channel c5: backup set complete, elapsed time: 00:00:01
Finished backup at 01-FEB-15
released channel: c5

RMAN> 
 

 

 

RMAN> run{allocate <span style="color:#ff0000;">channel 5 DEVICE TYPE</span> DISK;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "integer": expecting one of: "channel_id, double-quoted-string, equal, identifier, single-quoted-string"
RMAN-01007: at line 1 column 22 file: standard input

RMAN> run{allocate channel c5 DEVICE TYPE DISK;
2> backup tablespace DTFILETS;}

allocated channel: c5
channel c5: sid=116 devtype=DISK

Starting backup at 01-FEB-15
channel c5: starting full datafile backupset
channel c5: specifying datafile(s) in backupset
input datafile fno=00011 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf
input datafile fno=00012 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf
channel c5: starting piece 1 at 01-FEB-15
channel c5: finished piece 1 at 01-FEB-15
piece handle=/u01/oracle/11G/dbs/5cpu6ni6_1_1 tag=TAG20150201T162022 comment=NONE
channel c5: backup set complete, elapsed time: 00:00:01
Finished backup at 01-FEB-15
released channel: c5

RMAN> 注意手动分配通道的时候 纯数字不可以的 
 

RMAN> run{allocate<span style="color:#ff0000;"> channel 5 DEVICE</span> TYPE DISK format '/home/oracle/disk/same_bs_%d%p%s.bkp';

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "integer": expecting one of: "channel_id, double-quoted-string, equal, identifier, single-quoted-string"
RMAN-01007: at line 1 column 22 file: standard input

RMAN>
 

 

 

 

 ----------------------------------------下面是各种细节，自己看吧，没什么大用------------------------------------- 

 

 

[oracle@MasterHadoop50 backupset]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Sun Feb 1 16:01:41 2015

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

connected to target database: DB01 (DBID=1467107934)

RMAN> crosscheck DatafileCopy   '/tmp/controlfile.ctl';

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=116 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=111 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=110 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 02/01/2015 16:01:49
RMAN-20230: datafile copy not found in the recovery catalog
RMAN-06015: error while looking up datafile copy name: /tmp/controlfile.ctl

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/11G/dbs/snapcf_db01.f'; # default

RMAN> /home/oracle/disk2/same_bs_%d%p%s.bkp

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signalled during parse
RMAN-02001: unrecognized punctuation symbol "/"

RMAN> 

RMAN> 

rman{allocate channel c4 DEVICE TYPE DISK;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "{": expecting one of: "append, at, auxiliary, catalog, cmdfile, clone, checksyntax, debug, log, msglog, mask, msgno, nocatalog, pipe, rcvcat, script, slaxdebug, send, target, timeout, trace"
RMAN-01007: at line 1 column 5 file: standard input

RMAN> backup tablespace DTFILETS;}

Starting backup at 01-FEB-15
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00011 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf
channel ORA_DISK_1: starting piece 1 at 01-FEB-15
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00012 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf
channel ORA_DISK_2: starting piece 1 at 01-FEB-15
channel ORA_DISK_1: finished piece 1 at 01-FEB-15
piece handle=/u01/oracle/11G/dbs/4rpu6mo1_1_1 tag=TAG20150201T160625 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_2: finished piece 1 at 01-FEB-15
piece handle=/u01/oracle/11G/dbs/4spu6mo1_1_1 tag=TAG20150201T160625 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01
Finished backup at 01-FEB-15

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "}": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01007: at line 0 column 28 file: standard input

RMAN> 

RMAN> 

RMAN> 

RMAN> 

RMAN> 

RMAN> 

rman{allocate channel c4 DEVICE TYPE DISK format '/home/oracle/disk2/same_bs_%d%p%s.bkp';

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "{": expecting one of: "append, at, auxiliary, catalog, cmdfile, clone, checksyntax, debug, log, msglog, mask, msgno, nocatalog, pipe, rcvcat, script, slaxdebug, send, target, timeout, trace"
RMAN-01007: at line 1 column 5 file: standard input

RMAN> backup tablespace DTFILETS;}

Starting backup at 01-FEB-15
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00011 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf
channel ORA_DISK_1: starting piece 1 at 01-FEB-15
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00012 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf
channel ORA_DISK_2: starting piece 1 at 01-FEB-15
channel ORA_DISK_1: finished piece 1 at 01-FEB-15
piece handle=/u01/oracle/11G/dbs/4tpu6mpb_1_1 tag=TAG20150201T160707 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_2: finished piece 1 at 01-FEB-15
piece handle=/u01/oracle/11G/dbs/4upu6mpb_1_1 tag=TAG20150201T160707 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:03
Finished backup at 01-FEB-15

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "}": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01007: at line 0 column 28 file: standard input

RMAN> 

RMAN> 

RMAN> 

RMAN> 

RMAN> 

RMAN> 

rman{allocate channel c1 DEVICE TYPE DISK format '/home/oracle/disk2/same_bs_%d%p%s.bkp';

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "{": expecting one of: "append, at, auxiliary, catalog, cmdfile, clone, checksyntax, debug, log, msglog, mask, msgno, nocatalog, pipe, rcvcat, script, slaxdebug, send, target, timeout, trace"
RMAN-01007: at line 1 column 5 file: standard input

RMAN> backup tablespace DTFILETS;}

Starting backup at 01-FEB-15
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00011 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf
channel ORA_DISK_1: starting piece 1 at 01-FEB-15
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00012 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf
channel ORA_DISK_2: starting piece 1 at 01-FEB-15
channel ORA_DISK_1: finished piece 1 at 01-FEB-15
piece handle=/u01/oracle/11G/dbs/4vpu6mq6_1_1 tag=TAG20150201T160734 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_2: finished piece 1 at 01-FEB-15
piece handle=/u01/oracle/11G/dbs/50pu6mq6_1_1 tag=TAG20150201T160734 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01
Finished backup at 01-FEB-15

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "}": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01007: at line 0 column 28 file: standard input

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/11G/dbs/snapcf_db01.f'; # default

RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/disk1/user_bs_%d%p%s.bkp';

new RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/disk1/user_bs_%d%p%s.bkp';
new RMAN configuration parameters are successfully stored
released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3

RMAN> 

RMAN> 

rman{allocate channel c4 DEVICE TYPE DISK format '/home/oracle/disk2/same_bs_%d%p%s.bkp';

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "{": expecting one of: "append, at, auxiliary, catalog, cmdfile, clone, checksyntax, debug, log, msglog, mask, msgno, nocatalog, pipe, rcvcat, script, slaxdebug, send, target, timeout, trace"
RMAN-01007: at line 1 column 5 file: standard input

RMAN> backup tablespace DTFILETS;}

Starting backup at 01-FEB-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=116 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=111 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=110 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00011 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf
channel ORA_DISK_1: starting piece 1 at 01-FEB-15
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00012 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf
channel ORA_DISK_2: starting piece 1 at 01-FEB-15
channel ORA_DISK_1: finished piece 1 at 01-FEB-15
piece handle=/home/oracle/disk1/user_bs_DB011161.bkp tag=TAG20150201T160857 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_2: finished piece 1 at 01-FEB-15
piece handle=/u01/oracle/11G/dbs/52pu6msp_1_1 tag=TAG20150201T160857 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:03
Finished backup at 01-FEB-15

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "}": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01007: at line 0 column 28 file: standard input

RMAN> 

RMAN> 

RMAN> 

rman{allocate channel c1 DEVICE TYPE DISK format '/home/oracle/disk/same_bs_%d%p%s.bkp';

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "{": expecting one of: "append, at, auxiliary, catalog, cmdfile, clone, checksyntax, debug, log, msglog, mask, msgno, nocatalog, pipe, rcvcat, script, slaxdebug, send, target, timeout, trace"
RMAN-01007: at line 1 column 5 file: standard input

RMAN> backup tablespace DTFILETS;}

Starting backup at 01-FEB-15
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00011 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf
channel ORA_DISK_1: starting piece 1 at 01-FEB-15
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00012 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf
channel ORA_DISK_2: starting piece 1 at 01-FEB-15
channel ORA_DISK_1: finished piece 1 at 01-FEB-15
piece handle=/home/oracle/disk1/user_bs_DB011163.bkp tag=TAG20150201T160924 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_2: finished piece 1 at 01-FEB-15
piece handle=/u01/oracle/11G/dbs/54pu6mtl_1_1 tag=TAG20150201T160924 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01
Finished backup at 01-FEB-15

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "}": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01007: at line 0 column 28 file: standard input

RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '/home/oracle/disk2/user_bs_%d%p%s.bkp';

new RMAN configuration parameters:
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '/home/oracle/disk2/user_bs_%d%p%s.bkp';
new RMAN configuration parameters are successfully stored
released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3

RMAN> backup tablespace DTFILETS;

Starting backup at 01-FEB-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=116 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=111 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=110 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00011 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf
channel ORA_DISK_1: starting piece 1 at 01-FEB-15
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00012 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf
channel ORA_DISK_2: starting piece 1 at 01-FEB-15
channel ORA_DISK_1: finished piece 1 at 01-FEB-15
piece handle=/home/oracle/disk1/user_bs_DB011165.bkp tag=TAG20150201T161127 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_2: finished piece 1 at 01-FEB-15
piece handle=/home/oracle/disk2/user_bs_DB011166.bkp tag=TAG20150201T161127 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01
Finished backup at 01-FEB-15

RMAN> 

RMAN> 

RMAN> 

rman{allocate channel c3 DEVICE TYPE DISK format '/home/oracle/disk/same_bs_%d%p%s.bkp';

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "{": expecting one of: "append, at, auxiliary, catalog, cmdfile, clone, checksyntax, debug, log, msglog, mask, msgno, nocatalog, pipe, rcvcat, script, slaxdebug, send, target, timeout, trace"
RMAN-01007: at line 1 column 5 file: standard input

RMAN> backup tablespace DTFILETS;}

Starting backup at 01-FEB-15
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00011 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf
channel ORA_DISK_1: starting piece 1 at 01-FEB-15
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00012 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf
channel ORA_DISK_2: starting piece 1 at 01-FEB-15
channel ORA_DISK_1: finished piece 1 at 01-FEB-15
piece handle=/home/oracle/disk1/user_bs_DB011167.bkp tag=TAG20150201T161253 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_2: finished piece 1 at 01-FEB-15
piece handle=/home/oracle/disk2/user_bs_DB011168.bkp tag=TAG20150201T161253 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:03
Finished backup at 01-FEB-15

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "}": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01007: at line 0 column 28 file: standard input

RMAN> run{allocate channel c4 DEVICE TYPE DISK format '/home/oracle/disk/same_bs_%d%p%s.bkp';
2> }

released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3
allocated channel: c4
channel c4: sid=116 devtype=DISK
released channel: c4

RMAN> 

RMAN> 

RMAN> 

run{allocate channel c3 DEVICE TYPE DISK format '/home/oracle/disk/same_bs_%d%p%s.bkp';
2> backup tablespace DTFILETS;}

allocated channel: c3
channel c3: sid=116 devtype=DISK

Starting backup at 01-FEB-15
channel c3: starting full datafile backupset
channel c3: specifying datafile(s) in backupset
input datafile fno=00011 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf
input datafile fno=00012 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf
channel c3: starting piece 1 at 01-FEB-15
channel c3: finished piece 1 at 01-FEB-15
piece handle=/home/oracle/disk/same_bs_DB011169.bkp tag=TAG20150201T161608 comment=NONE
channel c3: backup set complete, elapsed time: 00:00:01
Finished backup at 01-FEB-15
released channel: c3

RMAN> run{allocate channel c3 DEVICE TYPE DISK;
2> backup tablespace DTFILETS;}

allocated channel: c3
channel c3: sid=116 devtype=DISK

Starting backup at 01-FEB-15
channel c3: starting full datafile backupset
channel c3: specifying datafile(s) in backupset
input datafile fno=00011 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf
input datafile fno=00012 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf
channel c3: starting piece 1 at 01-FEB-15
channel c3: finished piece 1 at 01-FEB-15
piece handle=/u01/oracle/11G/dbs/5apu6ncm_1_1 tag=TAG20150201T161726 comment=NONE
channel c3: backup set complete, elapsed time: 00:00:01
Finished backup at 01-FEB-15
released channel: c3

RMAN> run{allocate channel 1 DEVICE TYPE DISK;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "integer": expecting one of: "channel_id, double-quoted-string, equal, identifier, single-quoted-string"
RMAN-01007: at line 1 column 22 file: standard input

RMAN> run{allocate channel c1 DEVICE TYPE DISK;
2> backup tablespace DTFILETS;}

allocated channel: c1
channel c1: sid=116 devtype=DISK

Starting backup at 01-FEB-15
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00011 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf
input datafile fno=00012 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf
channel c1: starting piece 1 at 01-FEB-15
channel c1: finished piece 1 at 01-FEB-15
piece handle=/u01/oracle/11G/dbs/5bpu6ndo_1_1 tag=TAG20150201T161800 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 01-FEB-15
released channel: c1

RMAN> run{allocate channel  DEVICE TYPE DISK;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "device": expecting one of: "channel_id, double-quoted-string, equal, identifier, single-quoted-string"
RMAN-01007: at line 1 column 23 file: standard input

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/disk1/user_bs_%d%p%s.bkp';
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '/home/oracle/disk2/user_bs_%d%p%s.bkp';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/11G/dbs/snapcf_db01.f'; # default

RMAN> run{allocate channel 1;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "integer": expecting one of: "channel_id, double-quoted-string, equal, identifier, single-quoted-string"
RMAN-01007: at line 1 column 22 file: standard input

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01007: at line 1 column 23 file: standard input

RMAN> run{allocate channel 4;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "integer": expecting one of: "channel_id, double-quoted-string, equal, identifier, single-quoted-string"
RMAN-01007: at line 1 column 22 file: standard input

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01007: at line 1 column 23 file: standard input

RMAN> run{allocate channel 5;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "integer": expecting one of: "channel_id, double-quoted-string, equal, identifier, single-quoted-string"
RMAN-01007: at line 1 column 22 file: standard input

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01007: at line 1 column 23 file: standard input

RMAN> run{allocate channel c5;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "device, name, type"
RMAN-01007: at line 1 column 24 file: standard input

RMAN> run{allocate channel c1 DEVICE TYPE DISK;
2> 
3> 

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "end-of-file": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, copy, convert, crosscheck, configure, duplicate, debug, delete, execute, endinline, flashback, host, mount, open, plsql, recover, release, replicate, report, restore, resync, }, set, setlimit, sql, switch, startup, shutdown, send, show, transport, validate"
RMAN-01007: at line 3 column 1 file: standard input

RMAN> run{allocate channel 5 DEVICE TYPE DISK;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "integer": expecting one of: "channel_id, double-quoted-string, equal, identifier, single-quoted-string"
RMAN-01007: at line 1 column 22 file: standard input

RMAN> run{allocate channel c5 DEVICE TYPE DISK;
2> backup tablespace DTFILETS;}

allocated channel: c5
channel c5: sid=116 devtype=DISK

Starting backup at 01-FEB-15
channel c5: starting full datafile backupset
channel c5: specifying datafile(s) in backupset
input datafile fno=00011 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf
input datafile fno=00012 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf
channel c5: starting piece 1 at 01-FEB-15
channel c5: finished piece 1 at 01-FEB-15
piece handle=/u01/oracle/11G/dbs/5cpu6ni6_1_1 tag=TAG20150201T162022 comment=NONE
channel c5: backup set complete, elapsed time: 00:00:01
Finished backup at 01-FEB-15
released channel: c5

RMAN> backup tablespace DTFILETS;

Starting backup at 01-FEB-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=116 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=111 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=110 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00011 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf
channel ORA_DISK_1: starting piece 1 at 01-FEB-15
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00012 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf
channel ORA_DISK_2: starting piece 1 at 01-FEB-15
channel ORA_DISK_1: finished piece 1 at 01-FEB-15
piece handle=/home/oracle/disk1/user_bs_DB011173.bkp tag=TAG20150201T162040 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_2: finished piece 1 at 01-FEB-15
piece handle=/home/oracle/disk2/user_bs_DB011174.bkp tag=TAG20150201T162040 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01
Finished backup at 01-FEB-15

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/disk1/user_bs_%d%p%s.bkp';
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '/home/oracle/disk2/user_bs_%d%p%s.bkp';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/11G/dbs/snapcf_db01.f'; # default

 run{allocate channel c5 DEVICE TYPE DISK format '/home/oracle/disk/same_bs_%d%p%s.bkp';
2> backup tablespace DTFILETS;}

released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3
allocated channel: c5
channel c5: sid=116 devtype=DISK

Starting backup at 01-FEB-15
channel c5: starting full datafile backupset
channel c5: specifying datafile(s) in backupset
input datafile fno=00011 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf
input datafile fno=00012 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf
channel c5: starting piece 1 at 01-FEB-15
channel c5: finished piece 1 at 01-FEB-15
piece handle=/home/oracle/disk/same_bs_DB011175.bkp tag=TAG20150201T162200 comment=NONE
channel c5: backup set complete, elapsed time: 00:00:01
Finished backup at 01-FEB-15
released channel: c5

RMAN> configure channel 1 type disk clear;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "type": expecting one of: "device"
RMAN-01007: at line 1 column 21 file: standard input

RMAN> configure channel 1 device type disk clear;

old RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/disk1/user_bs_%d%p%s.bkp';
old RMAN configuration parameters are successfully deleted

RMAN> configure channel 2 device type disk clear;

old RMAN configuration parameters:
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '/home/oracle/disk2/user_bs_%d%p%s.bkp';
old RMAN configuration parameters are successfully deleted

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/11G/dbs/snapcf_db01.f'; # default

RMAN> run{allocate channel c5 DEVICE TYPE DISK;
2> backup tablespace DTFILETS;}

allocated channel: c5
channel c5: sid=116 devtype=DISK

Starting backup at 01-FEB-15
channel c5: starting full datafile backupset
channel c5: specifying datafile(s) in backupset
input datafile fno=00011 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf
input datafile fno=00012 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf
channel c5: starting piece 1 at 01-FEB-15
channel c5: finished piece 1 at 01-FEB-15
piece handle=/u01/oracle/11G/dbs/5gpu6nop_1_1 tag=TAG20150201T162352 comment=NONE
channel c5: backup set complete, elapsed time: 00:00:01
Finished backup at 01-FEB-15
released channel: c5

RMAN>  run{allocate channel c5 DEVICE TYPE DISK format '/home/oracle/disk/same_bs_%d%p%s.bkp';
2> backup tablespace DTFILETS;}

allocated channel: c5
channel c5: sid=116 devtype=DISK

Starting backup at 01-FEB-15
channel c5: starting full datafile backupset
channel c5: specifying datafile(s) in backupset
input datafile fno=00011 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf
input datafile fno=00012 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf
channel c5: starting piece 1 at 01-FEB-15
channel c5: finished piece 1 at 01-FEB-15
piece handle=/home/oracle/disk/same_bs_DB011177.bkp tag=TAG20150201T162406 comment=NONE
channel c5: backup set complete, elapsed time: 00:00:01
Finished backup at 01-FEB-15
released channel: c5

RMAN> 
 

 

 

 


 

                

        

        

    




    

      

        

            

              
                
                  5icode.top
                
              
            

            

                关注
              
            

        

        

          
    
            
  • 
              
                
                
                
                
                      0
                
              
              
    点赞
    
            
    • 
            
  • 
              
                
                
                
              
              
    踩
    
            
    • 
            
  • 
              
                
                
                
                
                    0
                
              
              
    
                
    
                  
                    收藏
                  
                
    
              
    
              
    
                
    
                  觉得还不错?
                  
                    一键收藏
                  
                 
                
    
              
    
            
    • 
          
  • 
            
    
              
              
            
    
              
              
              
                    0
              
            
            
    评论
    
          
    • 
          
  • 
          
    • 
          
  • 
            
              
            
              
    
            
              
                
            
    
          
    • 
        

      

      

            

                专栏目录
          










                



	

		

			

				
					
backuplog

				
			

			

				

					beer2008cn的专栏
				

				

					03-03
					
					888
					
				

			

		

		

			
				
<br /><br />#!/bin/bash<br />###接受3个参数 1为log日志所在目录,2为备份目录,3为应用名称<br />###备份默认备份7天以前的所有包含 ".log"的文件,建议每月执行一次<br />###默认每月10号执行<br />logDir="/usr/local/tomcat/logs/"<br />backlogDir="/backup/log/cs/tomcatlogs/"<br />appName="cstomcatlog"<br /> <br />DAY_STR=

			
		

	



                

              
                



	

		

			

				
					
Java实现zookeeper数据的备份以及恢复

				
			

			

				

					qq_44898256的博客
				

				

					09-23
					
					1028
					
				

			

		

		

			
				
zookeper学习日记
欢迎使用Markdown编辑器
你好！ 这是你第一次使用 Markdown编辑器 所展示的欢迎页。如果你想学习如何使用Markdown编辑器, 可以仔细阅读这篇文章，了解一下Markdown的基本语法知识。
新的改变
我们对Markdown编辑器进行了一些功能拓展与语法支持，除了标准的Markdown编辑器功能，我们增加了如下几点新功能，帮助你用它写博客：

全新的界面设计 ，将会带来全新的写作体验；
在创作中心设置你喜爱的代码高亮样式，Markdown 将代码片显示选择的高亮样式

			
		

	



                


  
              

                


	

		

			

				
					
用户管理的备份恢复

				
			

			

				

					m0_38036502的博客
				

				

					07-01
					
					258
					
				

			

		

		

			
				
用户管理的备份恢复
冷备份（脱机备份）

一致性备份，直接拷贝要备份的文件，在关闭实例的情况下。
在非归档模式下： 只能完全恢复。
例如周一做了一次备份，到周四的时候，需要恢复数据，从周一到周四这之间的数据就会丢失，只会还原到周一备份前的数据状态。
完全和非完全：
1.要把所有的关键性数据拷贝出来：数据文件、控制文件、日志文件
2.恢复

热备份（联机备份）

也叫不一致备份，可以在数据库实例开启的状态下进行备份，可以还原到某一个时间节点，可以单文件恢复，不需要像冷备份的全部文件统一恢复。

这里讲一下热备

			
		

	





	

		

			

				
					
RMAN备份数据库_双重备份备份集（Duplexing Backup Sets）

				
			

			

				

					jetliu05的博客
				

				

					06-22
					
					949
					
				

			

		

		

			
				
RMAN 双重备份备份集（duplexing backup sets）

			
		

	



		

			
		



	

		

			

				
					
【RMAN】【RMAN命令】CONFIGURE命令(1)--RMAN 配置参数说明

				
			

			

				

					infiltrators的博客
				

				

					02-06
					
					2594
					
				

			

		

		

			
				
使用RMAN>show all;
可以显示出RMAN 配置参数为:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CON

			
		

	





	

		

			

				
					
backup

				
			

			

				

					03-22
				

			

		

		

			
				
在IT行业中，备份（"backup"）是至关重要的任务，特别是在数据量日益庞大的今天。它涉及到保护关键信息免受意外损失，比如系统故障、硬件损坏、病毒感染或人为错误。Python作为一种强大且易学的编程语言，提供了多种...

			
		

	





	

		

			

				
					
DB_BackUp.rar_backup.db

				
			

			

				

					09-23
				

			

		

		

			
				
这些组件可能分别对应备份操作、设置备份时间的界面、选择备份路径的功能、对话框处理、以及文件路径选择等模块。  综上所述，这个压缩包包含了一个数据库备份程序，该程序提供了定时备份和其他高级选项，如用户...

			
		

	





	

		

			

				
					
virt-backup:备份由libvirt管理的kvm guest虚拟机

				
			

			

				

					05-04
				

			

		

		

			
				
虚拟备份 使用BlockCommit功能对由libvirt管理的KVM guest虚拟机进行外部备份。 主要目标是为Proxmox VE备份系统（无vma系统）做一个适度的替代方案，以自动备份...配置配置文件中查找到以下路径，在这个特定的顺序： 

			
		

	





	

		

			

				
					
SCRIPTS_backup_Driver_powershell_

				
			

			

				

					10-03
				

			

		

		

			
				
标题“SCRIPTS_backup_Driver_powershell_”和描述中的“Simples Script to backup drivers”都指向一个关键主题：使用PowerShell脚本备份驱动程序。这个过程在IT管理中非常常见，因为驱动程序是操作系统与硬件设备...

			
		

	





	

		

			

				
					
markdown-backup:将远程图像下载到markdown文件中并将其存储在本地

				
			

			

				

					05-08
				

			

		

		

			
				
 的例子$ tree testtest└── test.md0 directories, 1 file$ cat test/test.md# markdown-backup![alt](https://github.githubassets.com/images/icons/emoji/unicode/1f44b.png)$ markdown-backup.js "test/*.md...

			
		

	





	

		

			

				
					
BackupReocveryZkInfo

				
			

			

				

					08-06
				

			

		

		

			
				
方便备份恢复zookeeper

			
		

	





	

		

			

				
					
oracle RMAN指定路径产生备份集

				
			

			

				

					yigongye
				

				

					09-03
					
					2985
					
				

			

		

		

			
				
指定路径产生备份集

backup as backupset format '/u02/backup/rman/df_%d_%s_%p.bak' datafile 7;

 

 

同理还有很多执行形式

backup as backupset format '/u02/backup/rman/df_%d_%s_%p.bak' tablespace users;

备份用户表空间

 

bac...

			
		

	





	

		

			

				
					
数据库全库的备份和恢复

				
			

			

				

					weixin_44524950的博客
				

				

					01-16
					
					628
					
				

			

		

		

			
				
源库：
10.190.104.111
PROD1
目的库：
10.190.104.28
PROD1
run {
allocate channel c1 device type disk;
backup incremental level 0
format ‘/u01/backup/db_full_%U.bkp’
tag ‘2016-09-23-FULL’
database plus archive...

			
		

	





	

		

			

				
					
oracle 第3方备份工具,Oracle rman 备份工具参数设置

				
			

			

				

					weixin_33479657的博客
				

				

					04-03
					
					352
					
				

			

		

		

			
				
使用RMAN>show all;可以显示出RMAN 配置参数为:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultCONFIGURE BACKUP OPTIMIZATION OFF; # defaultCONFIGURE DEFAULT DEVICE TYPE TO DISK; # defaultCONFIGURE CONTROLFIL...

			
		

	





	

		

			

				
					
Oracle中Rman自动备份数据库

				
			

			

				

					oyzl68的专栏
				

				

					04-06
					
					3373
					
				

			

		

		

			
				
目录
1 数据库修改为自动归档模式
2 修改rman参数
3 rman自动备份脚本
4 设置系统自动备份参数
5  rman还原
恢复整个数据库
恢复单个表空间
 1 数据库修改为自动归档模式。
为什么要设置为自动归档模式呢？主要是因为，如果不设置为自动归档模式，使用rman的时候需要把数据库修改到mount状态而不是open状态。而自动归档模式是可以在open使用中进行热备的。

			
		

	





	

		

			

				
					
zookeeper数据恢复

				
			

			

				

					苏苏爱自由
				

				

					09-05
					
					2881
					
				

			

		

		

			
				
刚刚在向hbase表写数据时发现一个神奇的现象：判断该表显示不存在，建表时发现显示 表已存在。

org.apache.hadoop.hbase.TableExistsException: cash_log:op_info

查看hdfs文件发现该表数据不存在。 
查看 zk显示该表 meta信息存在。 
 
要做的 就是在zk上使用rmr /hbase1/table/cash_log:op_in...

			
		

	





	

		

			

				
					
ORA-19504: failed to create file "/u01/backup/db_0_20190603_1" ORA-27038: created file already exist...

				
			

			

				

					weixin_34199335的博客
				

				

					06-03
					
					688
					
				

			

		

		

			
				
1.问题：在用rman进行0级备份时，报错：
ORA-19504: failed to create file "/u01/backup/db_0_20190603_1"ORA-27038: created file already exists

2.通过报错，可以看到是文件重复：created file altready exists

3.查看备份脚本：
RMAN> b...

			
		

	





	

		

			

				
					
OCP-1Z0-053-V13.02-623题

					
热门推荐

				
			

			

				

					一抹曦阳-Oracle
				

				

					12-11
					
					1万+
					
				

			

		

		

			
				
623.You issued the following commands to configure setting in RMAN;
RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;
RMAN> CONFIGURE DATAFILE BACKUP COPIES

			
		

	





	

		

			

				
					
【rman】命名格式串

				
			

			

				

					Sharon--start focusing on Oracle
				

				

					07-09
					
					1021
					
				

			

		

		

			
				
--format='/u01/backup/arch_%U_%T' 
这个是我们指定备份集命名的格式串，RMAN
提供了与格式串关联的一些语法元素，这些元素叫：占位符。
        rman 将使用相应的定义值来替换他们。 例如示例中的 %U 语法元素告诉RMAN要使用系统生成的唯一表示符替换文件名。 
使用FORMAT参数时可使用的各种替换变量，如下（注意大小写）所示：
%a：Or

			
		

	





	

		

			

				
					
将vo1数据卷的数据备份到宿主机的/newback中，将容器的/backup路径挂载上去，并将容器内/dir1文件夹打包到/backup/backup.tar

					
最新发布

				
			

			

				

					05-25
				

			

		

		

			
				
2. 接下来，我们可以使用以下命令启动一个新的容器，并将其/backup路径挂载到vo1数据卷上去：   ```  docker run -it -v vo1:/backup alpine sh  ```   这个命令中，我们启动了一个新的Alpine Linux容器，并将vo1...

			
		

	



              



  
“相关推荐”对你有帮助么？

  

      
    
          
  • 
              
    
                  
                  
              
    
              
    非常没帮助
    
          
    • 
          
  • 
              
    
                  
                  
              
    
              
    没帮助
    
          
    • 
          
  • 
              
    
                  
                  
              
    
              
    一般
    
          
    • 
          
  • 
              
    
                  
                  
              
    
              
    有帮助
    
          
    • 
          
  • 
              
    
                  
                  
              
    
              
    非常有帮助
    
          
    • 
      

      

      

          
          提交
      

      

  




          




        



    





    



      

      

        
      

      





	

		评论	
	

	
	




  

    

      添加红包
      
    

    

      

        
        

          
          
        

        
请填写红包祝福语或标题

      

      

        
        

          
          个
        

        
红包个数最小为10个

      

      

        
        

          
          元
        

        
红包金额最低5元

      

      

        
        

          当前余额3.43元
          前往充值 >
        

      

      

        

          需支付：10.00元
        

        
        
      

    

  





  

    
    
  

  

    
    
  








  

    

      

        

          

            
            
成就一亿技术人!

          

          

        

        

          

          

            领取后你会自动成为博主和红包主的粉丝
            规则
          

        

      

      

        

          

            
              
            
            

              
hope_wisdom
 发出的红包
            

          

        

        

          

          

          

        

      

    

    

  



      
      

      
实付元

      
使用余额支付

      

        

          

            
            点击重新获取
          

        

        
扫码支付

      

      

        
          
            
          
          
        
      

      

        
        钱包余额
          0
          

            
            

              

                
抵扣说明：

                
 1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
 2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

              

            

          

      

      余额充值