加载中…RMAN ORA-19504、ORA-27038错误解决方法
(2013-03-13 15:53:32)| 分类： oracle |
用于执行脱机-全部-完整备份的RMAN脚本：
执行脱机-全部-完整备份
RMAN> @offline_full_whole.rman
RMAN> run {
2> shutdown immediate;
3> startup mount;
4> allocate channel d1 type disk;
5> backup as backupset database format '/home/oracle/backup/offline_full_whole';
6> alter database open;
7> }
database closed
database dismounted
Oracle instance shut down
connected to target database (not started)
Oracle instance started
database mounted
Total System Global
Area
Fixed Size
Variable Size
Database Buffers
Redo Buffers
allocated channel: d1
channel d1: SID=133 device type=DISK
Starting backup at 13-MAR-13
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
channel d1: starting piece 1 at 13-MAR-13
channel d1: finished piece 1 at 13-MAR-13
piece handle=/home/oracle/backup/offline_full_whole tag=TAG20130313T160352 comment=NONE
channel d1: backup set complete, elapsed time: 00:00:25
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel d1: starting piece 1 at 13-MAR-13
released channel: d1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on d1 channel at 03/13/2013 16:04:20
ORA-19504: failed to create file "/home/oracle/backup/offline_full_whole"
ORA-27038: created file already exists
Additional information: 1
RMAN> **end-of-file**
增加_%U参数后再次尝试备份：
RMAN> @offline_full_whole.rman
RMAN> run {
2> shutdown immediate;
3> startup mount;
4> allocate channel d1 type disk;
5> backup as backupset database format '/home/oracle/backup/offline_full_whole_%U';
6> alter database open;
7> }
database dismounted
Oracle instance shut down
connected to target database (not started)
Oracle instance started
database mounted
Total System Global Area
Fixed Size
Variable Size
Database Buffers
Redo Buffers
allocated channel: d1
channel d1: SID=133 device type=DISK
Starting backup at 13-MAR-13
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
channel d1: starting piece 1 at 13-MAR-13
channel d1: finished piece 1 at 13-MAR-13
piece handle=/home/oracle/backup/offline_full_whole_0fo4ec11_1_1 tag=TAG20130313T160904 comment=NONE
channel d1: backup set complete, elapsed time: 00:00:15
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel d1: starting piece 1 at 13-MAR-13
channel d1: finished piece 1 at 13-MAR-13
piece handle=/home/oracle/backup/offline_full_whole_0go4ec1f_1_1 tag=TAG20130313T160904 comment=NONE
channel d1: backup set complete, elapsed time: 00:00:01
Finished backup at 13-MAR-13
database opened
released channel: d1
RMAN> **end-of-file**
喜欢
0
赠金笔