OraFAQ Forum: Backup & Recovery » Consistent Online Backup

Home » RDBMS Server » Backup & Recovery » Consistent Online Backup

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

Consistent Online Backup [message #141412]

Mon, 10 October 2005 02:05

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

Hi

I have to ask 03 questions but the goal is one “Consistent Online Backup”. Just can’t afford to disturb my query users time to time for backup.

1. Is there any possibility of taking consistent backup of online no-archive database with RMAN?
2. I thing Online backup is inconsistent because it wont cover ongoing insertions & updating take place at the time of backup creation. So if I stop all insertions & updating and just let queries to executes and take a Whole System backup from operating system commands. Will it be consider as consistent or I must have to shutdown database to achieve consistent backup.
3. If online backup is consistent if no insertion, updating take place, is there any option to open/alter database in read only mode.

Wishes
Jawad

Report message to a moderator

Re: Consistent Online Backup [message #141432 is a reply to message #141412]

Mon, 10 October 2005 04:47

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>2. I thing Online backup is inconsistent because it wont cover ongoing insertions & updating take place at the time of backup creation
Statement is partially correct.
All 'ongoeing operations' are always recorded in ORL and prompty passed into the archived logs in a timely / structured fashion.For this same reason, You need to backup your ARchived logs.
If your database has some data that is worthy and you intend to do the backup, have it in archived log mode.
Else
be prepared for the doomsday.
And no backup is ever been perfectly correct (and is Never ever without archived logs).
One of the near solutions is RMAN.
You always backup archived logs and your database.

Report message to a moderator

Re: Consistent Online Backup [message #141447 is a reply to message #141432]

Mon, 10 October 2005 06:06

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

>>1. Is there any possibility of taking consistent backup of online no-archive database with RMAN?

Hot backup or online backup for non-archive database is not possible.

--Girish

Report message to a moderator

Previous Topic:	oracle 10g RMAN
Next Topic:	Restoring Oracel10g database backup to a new windows server ....

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 02:53:11 CDT 2025