I did that in oracle 8.0.5, worked fine.
Just keep issuing the startup, recover database and shutdown
command until you want to open it.
-----Original Message-----
From: karthik ganesan
[mailto:oracledba-ezmlmshield-x53913141.[Email address protected]
Sent: Thursday, October 05, 2006 11:31 AM
To: LazyDBA Discussion
Subject: RE: Regarding RMAN restoration - urgent - please!
Hi Hans,
Then I hope my way of doing it is okay - data guard will be implemented
shortly. So till that time, let me go ahead with my way of doing it.
Hope there won't be any issues?
Please confirm - shall I go ahead with my view. Test runs were fine as
of.
Regards,
karthik
-----Original Message-----
From: Hans
[mailto:oracledba-ezmlmshield-x99753158.[Email address protected]
Sent: Thursday, October 05, 2006 11:37 AM
To: LazyDBA Discussion
Subject: RE: Regarding RMAN restoration - urgent - please!
You are trying to re-invent the concept of a standby (or dataguard)
database; Oracle Corp. has already done that.
Lookup on standby (up till 8i) or dataguard (9i and up) databases
Hans
-----Original Message-----
From: karthik ganesan [mailto:oracledba-ezmlmshield-x85276318.[Email
address protected]
Sent: donderdag 5 oktober 2006 10:27
To: LazyDBA Discussion
Subject: Regarding RMAN restoration - urgent - please!
Hi all,
I'm using oracle RMAN for hot backup and recovery, its working fine.
My current practice-
I take the RMAN hot backup every night and then restore the contents on
another server. During this phase the ATM machine won't be accessible
due to resource crunching that takes place because of hot backup.
My proposed view -
Once the data is restored, take the archive logs every 2 hours and just
keep running, Recover database; The advantage, I need not take hot
backup every night in the Live, instead transfer only the archive logs
and apply it on the backup server database. When situation demands use
ALTER DATABASE OPEN RESETLOGS;
Will there be any flaw or data inconsistency will it occur?
Regards,
KARTHIK GANESAN
IT Consultant
Uganda
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you receive
this message by mistake, you are hereby notified that any disclosure,
reproduction, distribution or use of this message is strictly
prohibited. Please inform the sender by reply transmission and delete
the message without copying or opening it.
Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the files have
NOT been scanned for viruses by the ING mail domain. Always scan
attachments before opening them.
-----------------------------------------------------------------
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Disclaimer
This e-mail and any attachments transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. If you have received this e-mail in error please notify the sender and delete the original message. Any views or opinion expressed in this e-mail are those of the author and do not necessarily represent those of the Department of Labour. The recipient should check this e-mail and any attachments for the presence of viruses and other destructive codes. While all possible precautions have been taken, the Department accepts no liability whatsoever for loss or damage resulting from the opening of this message or attachments, or the use of the information contained in this message or attachment.
Oracle LazyDBA home page