-
TO ALL RMAN GURU,
Below is rman backup script that was run but backup failed.
Could some one have a look at the error stack and point me to the right direction as my backup fail with the error
RMAN-10035: exception raised in RPC: ORA-19504: failed to create file "C:\ORACLE
\RMAN_BACK\RICK11"
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECRE
ATE
below is every thing that you might need.
Thanks
C:\>SET ORACLE_SID=RICK
C:\>RMAN
Recovery Manager: Release 8.1.7.0.0 - Production
RMAN> CONNECT TARGET INTERNAL/ORACLE@RICK
RMAN-06005: connected to target database: RICK (DBID=398027678)
RMAN> CONNECT CATALOG RMAN_USER/RMAN_USER@RMCAT
RMAN-06008: connected to recovery catalog database
RMAN-06428: recovery catalog is not installed
RMAN> CREATE CATALOG TABLESPACE RMAN_TS;
RMAN-06431: recovery catalog created
RMAN> REGISTER DATABASE;
RMAN-03022: compiling command: register
RMAN-03023: executing command: register
RMAN-08006: database registered in recovery catalog
RMAN-03023: executing command: full resync
RMAN-08002: starting full resync of recovery catalog
RMAN-08004: full resync complete
RMAN> REPORT SCHEMA;
RMAN-03022: compiling command: report
Report of database schema
File K-bytes Tablespace RB segs Name
---- ---------- -------------------- ------- -------------------
1 280576 SYSTEM YES C:\ORACLE\ORADATA\RICK\SYSTEM01.DBF
2 51200 RBS YES C:\ORACLE\ORADATA\RICK\RBS01.DBF
3 20480 USERS NO C:\ORACLE\ORADATA\RICK\USERS01.DBF
4 20480 TEMP NO C:\ORACLE\ORADATA\RICK\TEMP01.DBF
5 10240 TOOLS NO C:\ORACLE\ORADATA\RICK\TOOLS01.DBF
6 20480 INDX NO C:\ORACLE\ORADATA\RICK\INDX01.DBF
7 20480 DRSYS NO C:\ORACLE\ORADATA\RICK\DR01.DBF
8 204800 USERS NO C:\ORACLE\ORADATA\RICK\USERS02.DBF
9 204800 DRSYS NO C:\ORACLE\ORADATA\RICK\DRSYS02.DBF
10 204800 TOOLS NO C:\ORACLE\ORADATA\RICK\TOOLS02.DBF
11 204800 INDX NO C:\ORACLE\ORADATA\RICK\INDX02.DBF
12 204800 RBS YES C:\ORACLE\ORADATA\RICK\RBS02.DBF
13 204800 TEMP NO C:\ORACLE\ORADATA\RICK\TEMP02.DBF
14 204800 SYSTEM YES C:\ORACLE\ORADATA\RICK\SYSTEM02.DBF
15 409600 TOOLS NO C:\ORACLE\ORADATA\RICK\TOOLS03.DBF
RMAN> CREATE SCRIPT DAYFULLBACK{
2> ALLOCATE CHANNEL DB1 TYPE DISK;
3> BACKUP
4> FORMAT'C:\ORACLE\RMAN_BACK\%d%s%p'
5> (DATABASE);
6> RELEASE CHANNEL DB1;
7> }
RMAN-03022: compiling command: create script
RMAN-03023: executing command: create script
RMAN-08085: created script DAYFULLBACK
RMAN> RUN {EXECUTE SCRIPT DAYFULLBACK;}
RMAN-03021: executing script: DAYFULLBACK
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: DB1
RMAN-08500: channel DB1: sid=12 devtype=DISK
RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel DB1: starting full datafile backupset
RMAN-08502: set_count=1 set_stamp=458313079 creation_time=04-APR-02
RMAN-08010: channel DB1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00015 name=C:\ORACLE\ORADATA\RICK\TOOLS03.DBF
RMAN-08522: input datafile fno=00001 name=C:\ORACLE\ORADATA\RICK\SYSTEM01.DBF
RMAN-08011: including current controlfile in backupset
RMAN-08522: input datafile fno=00008 name=C:\ORACLE\ORADATA\RICK\USERS02.DBF
RMAN-08522: input datafile fno=00009 name=C:\ORACLE\ORADATA\RICK\DRSYS02.DBF
RMAN-08522: input datafile fno=00010 name=C:\ORACLE\ORADATA\RICK\TOOLS02.DBF
RMAN-08522: input datafile fno=00011 name=C:\ORACLE\ORADATA\RICK\INDX02.DBF
RMAN-08522: input datafile fno=00012 name=C:\ORACLE\ORADATA\RICK\RBS02.DBF
RMAN-08522: input datafile fno=00013 name=C:\ORACLE\ORADATA\RICK\TEMP02.DBF
RMAN-08522: input datafile fno=00014 name=C:\ORACLE\ORADATA\RICK\SYSTEM02.DBF
RMAN-08522: input datafile fno=00002 name=C:\ORACLE\ORADATA\RICK\RBS01.DBF
RMAN-08522: input datafile fno=00003 name=C:\ORACLE\ORADATA\RICK\USERS01.DBF
RMAN-08522: input datafile fno=00004 name=C:\ORACLE\ORADATA\RICK\TEMP01.DBF
RMAN-08522: input datafile fno=00006 name=C:\ORACLE\ORADATA\RICK\INDX01.DBF
RMAN-08522: input datafile fno=00007 name=C:\ORACLE\ORADATA\RICK\DR01.DBF
RMAN-08522: input datafile fno=00005 name=C:\ORACLE\ORADATA\RICK\TOOLS01.DBF
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: DB1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03015: error occurred in stored script DAYFULLBACK
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel DB1
RMAN-10035: exception raised in RPC: ORA-19504: failed to create file "C:\ORACLE
\RMAN_BACK\RICK11"
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECRE
ATE
RMAN>
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
-
As you can see that was an OS error. Check to see whether you have enough space in the disk where you are backing thing
Sam
Thanx
Sam
Life is a journey, not a destination!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|