Başlıktaki hatayı alırsanız tanımlı olan rman device channel’larınızı temizleyebilirsiniz veya connection tanımınızdaki user/pass bilgilerini kontrol edebilirsiniz;

 
 RMAN> BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG FROM TIME 'SYSDATE-1'
 2> LIKE '+ASM/testdb/archivelog/%' TAG='TESTDB_archs_20170218'
 3> FILESPERSET 100 FORMAT '/oracle/rman/%d_ARCHLOGS_%T_%s.rman'
 4> SKIP INACCESSIBLE;
 Starting backup at 18-FEB-17
 current log archived
 allocated channel: ORA_DISK_1
 channel ORA_DISK_1: SID=355 instance=FBCBPRD2 device type=DISK
 released channel: ORA_DISK_1
 RMAN-00571: ===========================================================
 RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===========
 RMAN-00571: ===========================================================
 RMAN-03002: failure of backup command at 02/18/2017 22:55:59
 RMAN-12001: could not open channel ORA_DISK_2
 RMAN-10008: could not create channel context
 RMAN-10003: unable to connect to target database
 ORA-28000: the account is locked

tstdbserver@oracle </backup/oracle/rman_bck> rman target / catalog TESTDB_RMAN@RMAN_DB

Recovery Manager: Release 11.2.0.4.0 - Production on Sat Feb 18 23:52:09 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: TESTDB (DBID=120972342)
 connected to recovery catalog database

RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK CLEAR;

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 CONNECT '*';
 old RMAN configuration parameters are successfully deleted
 starting full resync of recovery catalog
 full resync complete

RMAN> CONFIGURE CHANNEL 3 DEVICE TYPE DISK CLEAR;

old RMAN configuration parameters:
 CONFIGURE CHANNEL 3 DEVICE TYPE DISK CONNECT '*';
 old RMAN configuration parameters are successfully deleted
 starting full resync of recovery catalog
 full resync complete

RMAN> CONFIGURE CHANNEL 4 DEVICE TYPE DISK CLEAR;

old RMAN configuration parameters:
 CONFIGURE CHANNEL 4 DEVICE TYPE DISK CONNECT '*';
 old RMAN configuration parameters are successfully deleted
 starting full resync of recovery catalog
 full resync complete

RMAN> show all;

RMAN configuration parameters for database with db_unique_name TESTDB are:
 CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
 CONFIGURE BACKUP OPTIMIZATION OFF; # default
 CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
 CONFIGURE CONTROLFILE AUTOBACKUP ON;
 CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '+ASM/TESTDB/BACKUP/TESTDB_CTL_%F';
 CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
 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 COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
 CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
 CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+ASM/TESTDB/CONTROLFILE/snapcf_testdb.f';
 CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+ASM/testdb/controlfile/snapcf_testdb.f';

RMAN> exit

Recovery Manager complete.
 tstdbserver@oracle <> . /oracle/rman_archbackup.sh
 ______________________________________________________________\n
 TEST ARCHIVE BACKUP
 ______________________________________________________________\n
 Recovery Manager: Release 11.2.0.4.0 - Production on Sat Feb 18 23:53:20 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: TESTDB (DBID=120972342)
 connected to recovery catalog database

RMAN> 2>
 echo set on
 RMAN>

RMAN>
 2> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET PARALLELISM 8;
 new RMAN configuration parameters:
 CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET PARALLELISM 8;
 new RMAN configuration parameters are successfully stored
 starting full resync of recovery catalog
 full resync complete
 RMAN>

RMAN>
 5> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
 sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT
 RMAN> BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG FROM TIME 'SYSDATE-1'
 2> LIKE '+ASM/testdb/archivelog/%' TAG='TESTDB_archs_20170218'
 3> FILESPERSET 100 FORMAT '/oracle/rman/%d_ARCHLOGS_%T_%s.rman'
 4> SKIP INACCESSIBLE;
 Starting backup at 18-FEB-17
 current log archived
 allocated channel: ORA_DISK_1
 channel ORA_DISK_1: SID=126 instance=TESTDB2 device type=DISK
 allocated channel: ORA_DISK_2
 channel ORA_DISK_2: SID=361 instance=TESTDB2 device type=DISK
 allocated channel: ORA_DISK_3
 channel ORA_DISK_3: SID=440 instance=TESTDB2 device type=DISK
 allocated channel: ORA_DISK_4
 channel ORA_DISK_4: SID=476 instance=TESTDB2 device type=DISK
 allocated channel: ORA_DISK_5
 channel ORA_DISK_5: SID=519 instance=TESTDB2 device type=DISK
 allocated channel: ORA_DISK_6
 channel ORA_DISK_6: SID=558 instance=TESTDB2 device type=DISK
 allocated channel: ORA_DISK_7
 channel ORA_DISK_7: SID=588 instance=TESTDB2 device type=DISK
 allocated channel: ORA_DISK_8
 channel ORA_DISK_8: SID=630 instance=TESTDB2 device type=DISK
 channel ORA_DISK_1: starting compressed archived log backup set
 channel ORA_DISK_1: specifying archived log(s) in backup set
 input archived log thread=2 sequence=270232 RECID=1660102 STAMP=936230335
 input archived log thread=1 sequence=270886 RECID=1660104 STAMP=936230391
 input archived log thread=2 sequence=270233 RECID=1660110 STAMP=936230709
 ...
 ...
 ...
Reklam