oracle报ora07217,ORA-07217

ゝ一世哀愁。 2023-01-18 09:10 39阅读 0赞

ORA-07217

备份时遇到如下报错：

\[oracle@localhost ~\]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Fri May 10 22:05:49 2013

connected to target database: TESTDB (DBID=2581100181)

RMAN> run\{configure channel 2 device type disk format '/ogg/rman\_bk/%U';

backup database;

\}2> 3>

using target database control file instead of recovery catalog

old RMAN configuration parameters:

CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '/ogg/rman\_bk/%U';

new RMAN configuration parameters:

CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '/ogg/rman\_bk/%U';

new RMAN configuration parameters are successfully stored

Starting backup at 10-MAY-13

configuration for DISK channel 2 is ignored

allocated channel: ORA\_DISK\_1

channel ORA\_DISK\_1: SID=14 device type=DISK

channel ORA\_DISK\_1: starting full datafile backup set

channel ORA\_DISK\_1: specifying datafile(s) in backup set

input datafile file number=00002 name=/u01/oradata/testdb/sysaux01.dbf

input datafile file number=00001 name=/u01/oradata/testdb/system01.dbf

input datafile file number=00004 name=/u01/oradata/testdb/users01.dbf

input datafile file number=00003 name=/u01/oradata/testdb/undotbs01.dbf

input datafile file number=00005 name=/u01/oradata/testdb/test01.dbf

channel ORA\_DISK\_1: starting piece 1 at 10-MAY-13

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA\_DISK\_1 channel at 05/10/2013 22:05:57

ORA-07217: sltln: environment variable cannot be evaluated.

是由于环境变量配置有问题导致的

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 OFF; \# default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; \# default

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 CHANNEL DEVICE TYPE DISK FORMAT   '/ogg/rman\_bk/$d%T%t';

CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '/ogg/rman\_bk/%U';

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 '/u01/oracle/dbs/snapcf\_testdb.f'; \# default

重新设置：

RMAN> configure channel device type disk format '/0gg/rman\_bk/%U';

old RMAN configuration parameters:

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/ogg/rman\_bk/$d%T%t';

new RMAN configuration parameters:

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/0gg/rman\_bk/%U';

new RMAN configuration parameters are successfully stored

released channel: ORA\_DISK\_1

这次暴露的问题是路径找不到，因为笔误将ogg的首字母写成大写形式了。

RMAN> backup database;

Starting backup at 10-MAY-13

configuration for DISK channel 2 is ignored

allocated channel: ORA\_DISK\_1

channel ORA\_DISK\_1: SID=14 device type=DISK

channel ORA\_DISK\_1: starting full datafile backup set

channel ORA\_DISK\_1: specifying datafile(s) in backup set

input datafile file number=00002 name=/u01/oradata/testdb/sysaux01.dbf

input datafile file number=00001 name=/u01/oradata/testdb/system01.dbf

input datafile file number=00004 name=/u01/oradata/testdb/users01.dbf

input datafile file number=00003 name=/u01/oradata/testdb/undotbs01.dbf

input datafile file number=00005 name=/u01/oradata/testdb/test01.dbf

channel ORA\_DISK\_1: starting piece 1 at 10-MAY-13

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA\_DISK\_1 channel at 05/10/2013 22:06:43

ORA-19504: failed to create file "/0gg/rman\_bk/0no9aj3i\_1\_1"

ORA-27041: unable to open file

Linux Error: 2: No such file or directory

Additional information: 9

正确设置为：

RMAN> configure channel device type disk format '/ogg/rman\_bk/%U';

old RMAN configuration parameters:

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/0gg/rman\_bk/%U';

new RMAN configuration parameters:

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/ogg/rman\_bk/%U';

new RMAN configuration parameters are successfully stored

released channel: ORA\_DISK\_1

再次备份：

RMAN> backup database;

Starting backup at 10-MAY-13

configuration for DISK channel 2 is ignored

allocated channel: ORA\_DISK\_1

channel ORA\_DISK\_1: SID=14 device type=DISK

channel ORA\_DISK\_1: starting full datafile backup set

channel ORA\_DISK\_1: specifying datafile(s) in backup set

input datafile file number=00002 name=/u01/oradata/testdb/sysaux01.dbf

input datafile file number=00001 name=/u01/oradata/testdb/system01.dbf

input datafile file number=00004 name=/u01/oradata/testdb/users01.dbf

input datafile file number=00003 name=/u01/oradata/testdb/undotbs01.dbf

input datafile file number=00005 name=/u01/oradata/testdb/test01.dbf

channel ORA\_DISK\_1: starting piece 1 at 10-MAY-13

……

oracle报ora07217,ORA-07217

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 Oracle 11g Data Guard 增加数据文件报错：ORA-01111、ORA-01110、ORA-01157

相关 Oracle启动时报 ORA-00119 ORA-00130

相关 oracle ora12838(ORA-12838报错解决)

相关 oracle ORA-01172、ORA-01151 错误解决

相关 oracle 报错ora 00942,Oracle 物理视图刷新报错ORA-00942

相关 oracle报ora07217,ORA-07217

相关 Oracle异常ORA-29538、ORA-29540

相关 Oracle tnsnames.ora和listener.ora

相关 Oracle:ORA-28002

相关 ORACLE 操作空间字段报ORA-29877/ORA-29875错误的处理