Re: Datawarehouse backup
- From: Krishna Kakatur <kkakatur@xxxxxxxx>
- To: dba.orcl@xxxxxxxxx
- Date: Thu, 10 Mar 2005 13:12:31 -0800
If you can pin-point your REAL readonly datafiles, which most of the times
exist in Data warehouses - you can back them just once. Then, your weekly
backup process becomes simple.
Also, You don't need to change all the tablespaces to READONLY during
weekly backup.
Regards,
Krishna Kakatur
Database Administrator, Music
RealNetworks, Inc.
kkakatur@xxxxxxxx
At 07:41 PM 3/9/2005, Sami Seerangan wrote:
>All:
>
>We are planning to cold backup for 1 TeraBytes of datawarehouse
>database on weekly basis (every Saturday).
>Version :9i R2,
>OS: Sun Solaris
>No Archivelog Mode
>
>These are the steps we decide to perform.
>
>A)Backup
>
>1) Stop ETL jobs
>2) Change all the tablespaces to READ-ONLY mode except SYSTEM
>3) Alter system switch logfile( 3 times)
>4) Shutdown database
>5) Copy system tablespace datafiles, the control files and the online redo
>logs.
>6) Startup database
>7) Compress & Copy all the READ-ONLY tablespaces datafiles to tape
>8) Change all the READ-ONLY tablespaces to READ-WRITE
>9) Start ETL job
>
>B) Recovery:
>1) Backup previous cold backup
>2) Run ETL jobs up to date
>
>The only db outage would be between step # 3 and 5. These steps will
>be controlled from control-M product.
>
>I would like to know, is there any problem in this approach or is
>there any better way to perform the same?
>
>Thanks in advance
>--Sami
>--
>//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
