- 论坛徽章:
- 0
|
脚本应该没问题,以前一直都能做备份的。
tmsm[/nsr/applogs]#tail -n 500 msglog_trade_every_day_full_disk.log
11> (tablespace 'SYSTEM'
12> ,'TRADE'
13> ,'TRADEINDEX'
14> include current controlfile);
15>
16> release channel ch1;
17> release channel ch2;
18> release channel ch3;
19> release channel ch4;
20> }
21>
connected to target database: TRADE (DBID=2338289953)
using target database controlfile instead of recovery catalog
allocated channel: ch1
channel ch1: sid=90 devtype=SBT_TAPE
channel ch1: NMO v4.5.0.0
sent command to channel: ch1
allocated channel: ch2
channel ch2: sid=88 devtype=SBT_TAPE
channel ch2: NMO v4.5.0.0
sent command to channel: ch2
allocated channel: ch3
channel ch3: sid=97 devtype=SBT_TAPE
channel ch3: NMO v4.5.0.0
sent command to channel: ch3
allocated channel: ch4
channel ch4: sid=96 devtype=SBT_TAPE
channel ch4: NMO v4.5.0.0
sent command to channel: ch4
sent command to channel: ch1
sent command to channel: ch2
sent command to channel: ch3
sent command to channel: ch4
Starting backup at 02-JUN-10
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
including current controlfile in backupset
input datafile fno=00001 name=/oradata/system01.dbf
channel ch1: starting piece 1 at 02-JUN-10
channel ch2: starting full datafile backupset
channel ch2: specifying datafile(s) in backupset
input datafile fno=00011 name=/oradata/TRADE.dbf
channel ch2: starting piece 1 at 02-JUN-10
channel ch3: starting full datafile backupset
channel ch3: specifying datafile(s) in backupset
input datafile fno=00013 name=/oradata/TRADEINDEX.dbf
channel ch3: starting piece 1 at 02-JUN-10
user interrupt received
Finished backup at 02-JUN-10
Recovery Manager: Release 9.2.0.7.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN> connect target rman/rman@trade;
2> run {
3> allocate channel ch1 type 'SBT_TAPE';
4> allocate channel ch2 type 'SBT_TAPE';
5> allocate channel ch3 type 'SBT_TAPE';
6> allocate channel ch4 type 'SBT_TAPE';
7> send 'NSR_ENV=(NSR_DATA_VOLUME_POOL=trade disk backup pool,NSR_SERVER=backupserver.cssfintra.com)';
8>
9> backup
10> format 'Trade_full%d_%U'
11> (tablespace 'SYSTEM'
12> ,'TRADE'
13> ,'TRADEINDEX'
14> include current controlfile);
15>
16> release channel ch1;
17> release channel ch2;
18> release channel ch3;
19> release channel ch4;
20> }
21>
connected to target database: TRADE (DBID=2338289953)
using target database controlfile instead of recovery catalog
allocated channel: ch1
channel ch1: sid=101 devtype=SBT_TAPE
channel ch1: NMO v4.5.0.0
sent command to channel: ch1
allocated channel: ch2
channel ch2: sid=102 devtype=SBT_TAPE
channel ch2: NMO v4.5.0.0
sent command to channel: ch2
allocated channel: ch3
channel ch3: sid=107 devtype=SBT_TAPE
channel ch3: NMO v4.5.0.0
sent command to channel: ch3
allocated channel: ch4
channel ch4: sid=100 devtype=SBT_TAPE
channel ch4: NMO v4.5.0.0
sent command to channel: ch4
sent command to channel: ch1
sent command to channel: ch2
sent command to channel: ch3
sent command to channel: ch4
Starting backup at 02-JUN-10
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
cannot make a snapshot controlfile
released channel: ch1
released channel: ch2
released channel: ch3
released channel: ch4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch1 channel at 06/02/2010 14:06:12
ORA-00230: operation disallowed: snapshot controlfile enqueue unavailable
Recovery Manager complete.
Recovery Manager: Release 9.2.0.7.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN> connect target rman/rman@trade;
2> run {
3> allocate channel ch1 type 'SBT_TAPE';
4> allocate channel ch2 type 'SBT_TAPE';
5> allocate channel ch3 type 'SBT_TAPE';
6> allocate channel ch4 type 'SBT_TAPE';
7> send 'NSR_ENV=(NSR_DATA_VOLUME_POOL=trade disk backup pool,NSR_SERVER=backupserver.cssfintra.com)';
8>
9> backup
10> format 'Trade_full%d_%U'
11> (tablespace 'SYSTEM'
12> ,'TRADE'
13> ,'TRADEINDEX'
14> include current controlfile);
15>
16> release channel ch1;
17> release channel ch2;
18> release channel ch3;
19> release channel ch4;
20> }
21>
connected to target database: TRADE (DBID=2338289953)
using target database controlfile instead of recovery catalog
allocated channel: ch1
channel ch1: sid=107 devtype=SBT_TAPE
channel ch1: NMO v4.5.0.0
sent command to channel: ch1
allocated channel: ch2
channel ch2: sid=102 devtype=SBT_TAPE
channel ch2: NMO v4.5.0.0
sent command to channel: ch2
allocated channel: ch3
channel ch3: sid=101 devtype=SBT_TAPE
channel ch3: NMO v4.5.0.0
sent command to channel: ch3
allocated channel: ch4
channel ch4: sid=95 devtype=SBT_TAPE
channel ch4: NMO v4.5.0.0
sent command to channel: ch4
sent command to channel: ch1
sent command to channel: ch2
sent command to channel: ch3
sent command to channel: ch4
Starting backup at 02-JUN-10
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
cannot make a snapshot controlfile
released channel: ch1
released channel: ch2
released channel: ch3
released channel: ch4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch1 channel at 06/02/2010 14:08:46
ORA-00230: operation disallowed: snapshot controlfile enqueue unavailable
Recovery Manager complete.
Recovery Manager: Release 9.2.0.7.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN> connect target rman/rman@trade;
2> run {
3> allocate channel ch1 type 'SBT_TAPE';
4> allocate channel ch2 type 'SBT_TAPE';
5> allocate channel ch3 type 'SBT_TAPE';
6> allocate channel ch4 type 'SBT_TAPE';
7> send 'NSR_ENV=(NSR_DATA_VOLUME_POOL=trade disk backup pool,NSR_SERVER=backupserver.cssfintra.com)';
8>
9> backup
10> format 'Trade_full%d_%U'
11> (tablespace 'SYSTEM'
12> ,'TRADE'
13> ,'TRADEINDEX'
14> include current controlfile);
15>
16> release channel ch1;
17> release channel ch2;
18> release channel ch3;
19> release channel ch4;
20> }
21>
connected to target database: TRADE (DBID=2338289953)
using target database controlfile instead of recovery catalog
allocated channel: ch1
channel ch1: sid=105 devtype=SBT_TAPE
channel ch1: NMO v4.5.0.0
sent command to channel: ch1
allocated channel: ch2
channel ch2: sid=110 devtype=SBT_TAPE
channel ch2: NMO v4.5.0.0
sent command to channel: ch2
allocated channel: ch3
channel ch3: sid=106 devtype=SBT_TAPE
channel ch3: NMO v4.5.0.0
sent command to channel: ch3
allocated channel: ch4
channel ch4: sid=95 devtype=SBT_TAPE
channel ch4: NMO v4.5.0.0
sent command to channel: ch4
sent command to channel: ch1
sent command to channel: ch2
sent command to channel: ch3
sent command to channel: ch4
Starting backup at 02-JUN-10
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
cannot make a snapshot controlfile
released channel: ch1
released channel: ch2
released channel: ch3
released channel: ch4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch1 channel at 06/02/2010 14:20:35
ORA-00230: operation disallowed: snapshot controlfile enqueue unavailable
Recovery Manager complete.
Recovery Manager: Release 9.2.0.7.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN> connect target rman/rman@trade;
2> run {
3> allocate channel ch1 type 'SBT_TAPE';
4> allocate channel ch2 type 'SBT_TAPE';
5> allocate channel ch3 type 'SBT_TAPE';
6> allocate channel ch4 type 'SBT_TAPE';
7> send 'NSR_ENV=(NSR_DATA_VOLUME_POOL=trade disk backup pool,NSR_SERVER=backupserver.cssfintra.com)';
8>
9> backup
10> format 'Trade_full%d_%U'
11> (tablespace 'SYSTEM'
12> ,'TRADE'
13> ,'TRADEINDEX'
14> include current controlfile);
15>
16> release channel ch1;
17> release channel ch2;
18> release channel ch3;
19> release channel ch4;
20> }
21>
connected to target database: TRADE (DBID=2338289953)
using target database controlfile instead of recovery catalog
allocated channel: ch1
channel ch1: sid=110 devtype=SBT_TAPE
channel ch1: NMO v4.5.0.0
sent command to channel: ch1
allocated channel: ch2
channel ch2: sid=105 devtype=SBT_TAPE
channel ch2: NMO v4.5.0.0
sent command to channel: ch2
allocated channel: ch3
channel ch3: sid=104 devtype=SBT_TAPE
channel ch3: NMO v4.5.0.0
sent command to channel: ch3
allocated channel: ch4
channel ch4: sid=106 devtype=SBT_TAPE
channel ch4: NMO v4.5.0.0
sent command to channel: ch4
sent command to channel: ch1
sent command to channel: ch2
sent command to channel: ch3
sent command to channel: ch4
Starting backup at 02-JUN-10
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
cannot make a snapshot controlfile
released channel: ch1
released channel: ch2
released channel: ch3
released channel: ch4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch1 channel at 06/02/2010 14:23:10
ORA-00230: operation disallowed: snapshot controlfile enqueue unavailable
Recovery Manager complete.
Recovery Manager: Release 9.2.0.7.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN> connect target rman/rman@trade;
2> run {
3> allocate channel ch1 type 'SBT_TAPE';
4> allocate channel ch2 type 'SBT_TAPE';
5> allocate channel ch3 type 'SBT_TAPE';
6> allocate channel ch4 type 'SBT_TAPE';
7> send 'NSR_ENV=(NSR_DATA_VOLUME_POOL=trade disk backup pool,NSR_SERVER=backupserver.cssfintra.com)';
8>
9> backup
10> format 'Trade_full%d_%U'
11> (tablespace 'SYSTEM'
12> ,'TRADE'
13> ,'TRADEINDEX'
14> include current controlfile);
15>
16> release channel ch1;
17> release channel ch2;
18> release channel ch3;
19> release channel ch4;
20> }
21>
connected to target database: TRADE (DBID=2338289953)
using target database controlfile instead of recovery catalog
allocated channel: ch1
channel ch1: sid=109 devtype=SBT_TAPE
channel ch1: NMO v4.5.0.0
sent command to channel: ch1
allocated channel: ch2
channel ch2: sid=103 devtype=SBT_TAPE
channel ch2: NMO v4.5.0.0
sent command to channel: ch2
allocated channel: ch3
channel ch3: sid=102 devtype=SBT_TAPE
channel ch3: NMO v4.5.0.0
sent command to channel: ch3
allocated channel: ch4
channel ch4: sid=106 devtype=SBT_TAPE
channel ch4: NMO v4.5.0.0
sent command to channel: ch4
sent command to channel: ch1
sent command to channel: ch2
sent command to channel: ch3
sent command to channel: ch4
Starting backup at 02-JUN-10
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
cannot make a snapshot controlfile
released channel: ch1
released channel: ch2
released channel: ch3
released channel: ch4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch1 channel at 06/02/2010 14:32:42
ORA-00230: operation disallowed: snapshot controlfile enqueue unavailable
Recovery Manager complete.
Recovery Manager: Release 9.2.0.7.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN> connect target rman/rman@trade;
2> run {
3> allocate channel ch1 type 'SBT_TAPE';
4> allocate channel ch2 type 'SBT_TAPE';
5> allocate channel ch3 type 'SBT_TAPE';
6> allocate channel ch4 type 'SBT_TAPE';
7> send 'NSR_ENV=(NSR_DATA_VOLUME_POOL=trade disk backup pool,NSR_SERVER=backupserver.cssfintra.com)';
8>
9> backup
10> format 'Trade_full%d_%U'
11> (tablespace 'SYSTEM'
12> ,'TRADE'
13> ,'TRADEINDEX'
14> include current controlfile);
15>
16> release channel ch1;
17> release channel ch2;
18> release channel ch3;
19> release channel ch4;
20> }
21>
connected to target database: TRADE (DBID=2338289953)
using target database controlfile instead of recovery catalog
allocated channel: ch1
channel ch1: sid=103 devtype=SBT_TAPE
channel ch1: NMO v4.5.0.0
sent command to channel: ch1
allocated channel: ch2
channel ch2: sid=102 devtype=SBT_TAPE
channel ch2: NMO v4.5.0.0
sent command to channel: ch2
allocated channel: ch3
channel ch3: sid=101 devtype=SBT_TAPE
channel ch3: NMO v4.5.0.0
sent command to channel: ch3
allocated channel: ch4
channel ch4: sid=113 devtype=SBT_TAPE
channel ch4: NMO v4.5.0.0
sent command to channel: ch4
sent command to channel: ch1
sent command to channel: ch2
sent command to channel: ch3
sent command to channel: ch4
Starting backup at 02-JUN-10
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
cannot make a snapshot controlfile
released channel: ch1
released channel: ch2
released channel: ch3
released channel: ch4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch1 channel at 06/02/2010 14:35:17
ORA-00230: operation disallowed: snapshot controlfile enqueue unavailable
Recovery Manager complete. |
|