If you have on DB machine path C:\backup\
You may use that.
run {
allocate channel ch1 type disk;
backup
format='C:\backup\%t.%d.%s%p'
database;
release channel ch1;
}
If you created network drive H (-> C on Rec. Cat. machine)
you may use that:
run {
allocate channel ch1 type disk;
set maxcorrupt for datafile 1,2,3,4,5,6,7,8,9,10,11 to 0;
backup
incremental level=0
check logical
format='H:\backup\%t.%d.%s%p'
database;
}
Where 1,2,3, ... 11 - numbers of datafiles.
you may get them from v$datafile view
Originally posted by Diggers12 Can you give me the RMAN commands I should run so I know I have the correct ones.
sorry i am getting the same error still, for mapping the network drive i there somethin sprcial I should do. I have mapped it through Windows Explorer, is that enough?
I should be enough,
Do you have enough space on network drive?
Do you have enough priviledges on disk space and w/r operations?
Originally posted by Diggers12 Hello,
sorry i am getting the same error still, for mapping the network drive i there somethin sprcial I should do. I have mapped it through Windows Explorer, is that enough?
Thanks
The poin in saving backup in another machine is HD crash. You will not be able to recover database if your DB and backup in the same machine, you will lose database.
this is why i am trying to save the backup to the recovery catalog machine. I have 1.9Gb free on the C: drive of this machine but still I get the error
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel ch1
RMAN-10035: exception raised in RPC: ORA-19504: failed to create file "H:\backup\433073047.PICIS_DB.181"
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.BACKUPPIECECREATE
I have set up the mapping with Windws Explorer with full permissions for everyone so i assume it it ok? I am totally stumped? Any ideas anyone?
Did you try to save backup on DB machine?
So H:\ drive is C:\ on Rec.Cat machine?
Do you have C:\backup folder on Rec.Cat machine ?
Is drive H:\ reference on C:\backup\?
is folder H:\backup\?
is 1,9Gb enought for your DB backup?
ORA-27040 skgfrcre: create error, unable to create file
Cause: Create system call returned an error, unable to create file.
Action: Verify the file name and permissions.
... O/S-Error: (OS 3) The system cannot find the path specified.
try to save only control file it will be more faster then backup all DB, just for checking.
run {
allocate channel ch2 type disk;
copy current controlfile to 'h:\backup\cf.cf';
}
Reply With Quote
Bookmarks