09-08-2011 09:34 PM
Hi,
I am in a very big dilemma. Please help!!
We migrated our Oracle 10.2.0.3 database from Server A to Server B. Server A has NetBackup Client (version 6.5) installed and the Rman backups were working and being sent to tape. Server B has some issues with installation of NetBackup client. Our System Admin is currently working to resolve these issues. Meanwhile I was asked to copy the RMAN backup sets from Server B to Server A and send them to tape from Server A (since we have the NetBackup client installed on Server A). This being a temporary solution until the installation issues gets resolved on Server B.
First of all I would like to know is this possible? Can I send the RMAN backup sets (and backup pieces) to tape from Server A where as the database is no longer residing on Server A (copying using scp or sftp is not a problem, I can copy the files to Server A, but can I direct them to sbt_tape)?
If so can you brief me the steps for doing it? Do I need to create a new policy? Or do I need to create a new schedule? If so can you give me the commands to create the policy and schedule? And finally the commands to send the RMAN backups set to tape.
Thanks,
AM
09-08-2011 10:49 PM
What OS on ServerB ?? what NBU version u are tring to install on serverB ?
IF ServerA & ServerB with different hostname then your backup will not work
for this u need to create other nbu policy & oracle backup script according to New host (ServerB).
09-09-2011 02:18 AM
To backup Oracle by NetBackup for Oracle(sbt_tape), NetBackup client must be intalled on the instance host, and libobk must be linked to Oracle.
Consider following steps insted.
STEP1: backup Oracle with disk channel on server B
STEP2: copy backup files created in STEP1 to server A
STEP3: configure file backup policy, and backup files transered in STEP2
09-09-2011 04:23 AM
The backup type in Yasuhisa suggestion would be a standard backup (not Oracle).
You dump to disk via RMAN or export on B, scp those files to A, then backup (standard) on A.
09-09-2011 10:40 AM
Yogesh,
The OS on Server B is Solaris 10. There is no NBU on server B yet, but the SA is trying to install NBU client 6.5. And yes Server A and Server B are two different servers with different hostnames.
Yasuhisa & Riaan,
I will try to follow the steps that you mentioned. I've no questions as far as STEP 1 and 2 are concerned.
I will backup oracle database to Server B with disk channel (STEP 1), and then scp / sftp these files over to Server A (STEP 2)... But I've a question on STEP 3, how do I configure file backup policy (I never did this earlier, can you provide a command and if possible an example of this). And how to backup the files to tape, can you provide the command and an example if possible. Also do I need to connect to the master server before I run any command? Or the connection part is internal to the backup command in STEP 3.
Thanks for your support.
Thanks,
Akram
09-12-2011 12:02 PM
I took the backup on server B (backup to disk), and then transferred the files (backup sets) to server A. I tried to send these files to the tape using bp command (interactive menu) but I got this below error in the process log:
11:31:49 INF - Backup by oracle on client ebdm01-ebr:no schedules of the correct
type exist in this policy
Can somebody let me know how to resolve this issue? Can I create a new policy (with a new schedule) if this policy is the issue? If so can somebody provide the command or steps on how to create the policy.
And how do I direct bp command to use this new policy? Am I going in the wrong direction? Please guide...
Thanks,
AM
09-12-2011 12:35 PM
Solution
09-12-2011 12:35 PM
Add a schedule in new or existing policy on the master for Server A of type 'User Backup' and add a window during which you will alow User type backups. You can even open User backup window 24 x 7.
09-12-2011 01:10 PM
you are not doing an oracle backup - Oracle did the backup to disk on server B and made 'files' just files.
you moved those files to server A - they are still files. So you are not trying to do an Oracle backup from serverA you are just backing up files. plan old disk files (they just happend to be an oracle backup files)