OraFAQ Forum: Backup & Recovery » Cold backup script

Home » RDBMS Server » Backup & Recovery » Cold backup script

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Cold backup script [message #201906]

Tue, 07 November 2006 05:42

prashanth_gs
Messages: 67
Registered: November 2005
Location: chennai

Member

Hi

We are creating new database in 10gr2. Regarding the backup strategy We are planning to have Daily export and Weekly cold backup.

Can any one provide us the model script for cold backup to schedule in crontab.

DB: 10gR2
OS : Sunsolaris 5.8
DB size : 25 GB

Thanks and Regards,
prashanth

Report message to a moderator

Re: Cold backup script [message #201912 is a reply to message #201906]

Tue, 07 November 2006 06:05

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

You are decide to "daily export" export is not a valid bkp.
or cold bkp once a week is ok but ur database is how much downtime. it is OLTP OR DSS type database.

there are two bkp method
1.RMAN
2.User Managed Bkp.

hope this helps.
MOhammad Taj.

Report message to a moderator

Re: Cold backup script [message #201914 is a reply to message #201912]

Tue, 07 November 2006 06:09

prashanth_gs
Messages: 67
Registered: November 2005
Location: chennai

Member

Its user managed backup.

I just need a formal script for scheduling cold backup in crontab.

Report message to a moderator

Re: Cold backup script [message #201987 is a reply to message #201906]

Tue, 07 November 2006 13:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Its user managed backup.
Is it also user managed restores?
Without thoroughly tested restore procedures, any "backup" is a waste of electrons & magnetic flux.

Report message to a moderator

Previous Topic:	rman backup is taking more time
Next Topic:	Fully automated TSPITR with RMAN

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 02 11:58:48 CDT 2024