Export: Release 11.2.0.3.0 - Production on Mon Aug 3 10:11:40 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
######################################
Create a new directory with UNC naming e.g. \\192.168.26.11\rmanbackup
C:\Users\OR-01>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Mon Aug 3 10:17:11 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create directory remote2 as '\\192.168.26.11\rmanbackup';
Directory created.
SQL> grant read,write on directory remote2 to public;
Grant succeeded.
It works now
#############################################
C:\Users\OR-01>expdp ' / as sysdba' directory=remote2 full=y dumpfi
le=full.dmp logfile=full.log
Export: Release 11.2.0.3.0 - Production on Mon Aug 3 10:18:01 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYS"."SYS_EXPORT_FULL_04": "/******** AS SYSDBA" directory=remote2 fu
ll=y dumpfile=full.dmp logfile=full.log
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 75.25 GB
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PROFILE
No comments:
Post a Comment