topic Re: Cold backup Oracle Database using fbackup in Operating System - HP-UX

Cold backup Oracle Database using fbackup

Johnson Punniyalingam — Mon, 22 Sep 2008 14:57:43 GMT

Hi All,

Could any one let me know how to perform cold backup on Oracle Database using fbackup command, need to acomplish stop Oracle Database then perform fbackup of the 2 mount point /opt/oracle /PRD_Data then start back the oracle Database in script, here by have copied my script which not sucessfull backing up the Database, please help ..

Thanks,
Johnson

Re: Cold backup Oracle Database using fbackup

SKR_1 — Mon, 22 Sep 2008 15:04:32 GMT

Can you post the error which you facing during backup

Thanks

SKR

Re: Cold backup Oracle Database using fbackup

Patrick Wallek — Mon, 22 Sep 2008 15:05:54 GMT

>>which not sucessfull backing up the Database

So what was the error? Did it give you any output in the log file?

Re: Cold backup Oracle Database using fbackup

James R. Ferguson — Mon, 22 Sep 2008 15:49:49 GMT

Hi Johnson:

You are assuming that a non-zero return code from 'fbackup' denotes failure. That isn't strictly true. A value of <4> signifies warnings which may be seen in the 'fbackup' logs (if you capture them). see the 'fbackup' manpages.

Regards!

...JRF...

Re: Cold backup Oracle Database using fbackup

Kenan Erdey — Mon, 22 Sep 2008 16:08:14 GMT

Hi,

turn your script to debugging mode by changing first line. perhaps it may help you.
#!/sbin/sh -x

Re: Cold backup Oracle Database using fbackup

Johnson Punniyalingam — Tue, 23 Sep 2008 00:52:18 GMT

Hi All,

here by have attached output of the errorlog

Thanks
Johnson

Re: Cold backup Oracle Database using fbackup

Patrick Wallek — Tue, 23 Sep 2008 01:08:26 GMT

So what's the problem?

The only issue I see is:

*****
TNS-01106: Listener using listener name LISTENER has already been started
*****

This just means that your listener was already running. Big deal.

I don't see any evidence of your database being stopped or restarted. Is that the problem?

Re: Cold backup Oracle Database using fbackup

Johnson Punniyalingam — Tue, 23 Sep 2008 02:23:51 GMT

Hi Patrick Wallek,

I am Questioning my self either fbackup could not start sucesfull. due Oracle
TNS-01106: Listener using listener name LISTENER has already been started. or the fabckup command which in my script causing the problem need check or work with DBA ask them to stop Database than perform fabckup becoz yesterday was trying by my own. Can please help me to confirm my below fbackup command its ok?

/usr/sbin/fbackup -f /dev/rmt/0mn -i /opt/app/oracle -i /PDN2/oradata >> /var/tm
p/db-fbackup.log 2&>1

Thanks,
Johnson

Re: Cold backup Oracle Database using fbackup

Gokul Chandola — Tue, 23 Sep 2008 06:04:41 GMT

Hi,
For Cold backup you have to SHUTDOWN DB first.
You have to copy all datafile as well as Control file then only you can recover DB in case of any crises.

Regards,
Gokul Chandola

Re: Cold backup Oracle Database using fbackup

Steven E. Protter — Tue, 23 Sep 2008 07:59:23 GMT

Shalom,

If the oracle databases are hosted on a regular cooked file system.

stop oracle.

Kick the fbackup process off.

start oracle after.

The entire thing can be scripted.

You can for a hot backup, put the database in backup mode, but you said you wanted cold.

If you have OnlineJFS, you can create a snapshot and have fbackup back the snapshot up while the database is back up and running.

I'll check back to see if you want more information no that.

SEP

Re: Cold backup Oracle Database using fbackup

Rory Hammond — Wed, 24 Sep 2008 00:41:14 GMT

On our systems DBShut does not turn off the listner.
You might want to stop the listener in your script.

Re: Cold backup Oracle Database using fbackup

Johnson Punniyalingam — Wed, 24 Sep 2008 11:56:01 GMT

Hi All,

I seriously take this opportunity to thank everyone who have shared there knowledge on subject to my Cold Oracle Backup issue has been resolved by working with Oracle DBA,

Resolution:-
by removing the Oracle Listeners stop script from the backup script we are able to perform the Cold backup successfully because the dbshut & perform the Oracle Listener too.:)

Thanks,
Johnson

Re: Cold backup Oracle Database using fbackup

Johnson Punniyalingam — Thu, 25 Sep 2008 10:25:42 GMT

Resolution:-
by removing the Oracle Listeners stop script from the backup script we are able to perform the Cold backup successfully because the dbshut & perform the Oracle Listener too.:)