I have tried to run rman from the catalog database server(adm_p) and tried to backup the database (fndry_p) to a directory on adm_p server. Both are unix servers. Below is my code and errors. The directory exists on adm_p and not on fndry_p (because I obviously don't want to backup my database to the same server). The error proves that it is looking at the target database. What should I do to make it look at adm_p???
Please help
Thanks,
Nirasha
********************************
RMAN> run {
2> allocate channel arch1 type disk;
3> sql 'alter system archive log current';
4> backup
5> format '/orahome/tapebackup/al_t%t_s%s_p%p'
6> (archivelog all);
7> release channel arch1;
8> }
I am not sure, but you my try with following modification.
Replace '/orahome/tapebackup/al_t%t_s%s_p%p' with
'host_name:/orahome/tapebackup/al_t%t_s%s_p%p'
I tried it and it did not work. I did my regular pings etc to the server first to check connectivity. I suspected that it would not work because I tried using an NT box (check earlier message I posted on this forum) saying f: and it created a file on unix (target db server) called that.
anyway, any help would be highly appreciated.
run {
2> allocate channel arch1 type disk;
3> sql 'alter system archive log current';
4> backup
5> format 'ora001:/orahome/tapebackup/al_t%t_s%s_p%p'
6> (archivelog all);
7> release channel arch1;
8> }
I think in rman, there are two ways you could do backup, one is with disk which is on the database server, the other way is use tape. When you do backup, you have to specify the type, disk or tape. Why don't you backup to tape?
What I am doing is to backup on my database server, then my sysadmin backup the whole server to tape. Hope it helps.
Actually doing it to disk is the simpler bit. I don't mind doing it to tape but that gets more complex, especially with the MML.
I know about the two types of backup (i.e. tape and disk), what I can't figure out (and it is frustrating the living daylights out of me), is how come the directory in the 'format' command looks on the target database server? Who in their right mind would WANT to backup a database on the same server the databse resides. Is it just me or is this a staright forward problem? Oracle seem so baffled about this. I can't believe that no one before has not had the need to back up a database to a disk other than the server it resides on.
Thanks for your help, but I think I am resigning myself to the fact that the product is incapable of this simple action.
Any help you (or anyone out there) might offer is highly appreciated.
Actually I just found out (through another person's similar old query to Oracle) that RMAN can only 'see' the target server.
So I have to NFS mount the catalog (or wherever I want it to backup to) server directories onto the target server. I personally thing that it is pathetic, that the software can only see it's own directories by default. I mean who in their right mind would want to back up to the same server???
And now if I want several databases backed up, I have to do this each time.. Where is the sense? If they had to default to some directory it makes sense that it should have been the catalog server directories.
Anyway, I guess I have to work within those brilliant limitations.
Thanks for your help and hope that your backup is much better.
Reply With Quote
Bookmarks