Home » RDBMS Server » Backup & Recovery » Cold backup script
Cold backup script [message #201906] Tue, 07 November 2006 05:42 Go to next message
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
Re: Cold backup script [message #201912 is a reply to message #201906] Tue, 07 November 2006 06:05 Go to previous messageGo to next message
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.
Re: Cold backup script [message #201914 is a reply to message #201912] Tue, 07 November 2006 06:09 Go to previous messageGo to next message
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.
Re: Cold backup script [message #201987 is a reply to message #201906] Tue, 07 November 2006 13:55 Go to previous message
BlackSwan
Messages: 25050
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.
Previous Topic: rman backup is taking more time
Next Topic: Fully automated TSPITR with RMAN
Goto Forum:
  


Current Time: Sat Dec 10 01:34:27 CST 2016

Total time taken to generate the page: 0.07899 seconds