Cold backup Oracle Database using fbackup

[Johnson Punniyalingam]

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

[SKR_1]

Can you post the error which you facing during backup

Thanks

SKR

[Patrick Wallek]

>>which not sucessfull backing up the Database

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

[James R. Ferguson]

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...

[Kenan Erdey]

Hi,

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

[Johnson Punniyalingam]

Hi All,

here by have attached output of the errorlog

Thanks
Johnson

[Patrick Wallek · Accepted solution]

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?

[Johnson Punniyalingam]

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

[Gokul Chandola]

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

[Steven E. Protter]

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

[Rory Hammond]

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

[Johnson Punniyalingam]

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

[Johnson Punniyalingam]

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.:)