OraFAQ Forum: Backup & Recovery » how archive redo logs are applied

Home » RDBMS Server » Backup & Recovery » how archive redo logs are applied

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

how archive redo logs are applied [message #127362]

Mon, 11 July 2005 07:02

mademba
Messages: 23
Registered: July 2005

Junior Member

hi!
when i issue the following rman commands:
restore database;
recover database;
did archived redo logs are restored and applied to restored backup.?
thanks for ur help

Report message to a moderator

Re: how archive redo logs are applied [message #127364 is a reply to message #127362]

Mon, 11 July 2005 07:03

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

Senior Member

Yes. Recovery is done by applying archive logs only. Firstly RMAN will check at the default archive log destination for availability of required archive logs, if they are not present there, it will ask for the alternate destination fo archive logs.

Regds
Girish

[Updated on: Mon, 11 July 2005 07:05]

Report message to a moderator

Re: how archive redo logs are applied [message #127365 is a reply to message #127364]

Mon, 11 July 2005 07:11

mademba
Messages: 23
Registered: July 2005

Junior Member

well,
when do a RMAN>list backup summary;
i've all the backup i made.
what backup is chosen when i say RMAN>restore database; ??

Report message to a moderator

Re: how archive redo logs are applied [message #127366 is a reply to message #127365]

Mon, 11 July 2005 07:13

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

Senior Member

That RMAN chooses for you. Its going to choose the latest one.

[EDIT TEXT] RMAN RESTORE command will restore a file only & only if restoration is necessary for it.

[Updated on: Mon, 11 July 2005 07:23]

Report message to a moderator

Re: how archive redo logs are applied [message #127370 is a reply to message #127366]

Mon, 11 July 2005 07:23

mademba
Messages: 23
Registered: July 2005

Junior Member

ok
one day:

1) i created a table, inserted some rows in and committed
2) i made a full online backup while my database was turning in automatic archiving
3) i dropped the table i've create and
4) issued a Point In Time recovering until the time when a did the full backup

my table was recovered but the rows i've inserted were not present
how can u explain that??

Report message to a moderator

Re: how archive redo logs are applied [message #127371 is a reply to message #127370]

Mon, 11 July 2005 07:30

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

Senior Member

Hi

Can u provide the following information:

1. Time of issuing & completion of online backup command.

2. Time of dropping of table.

3. Time specified in set until time clause during recovery using RMAN.

Regds
Girish

Report message to a moderator

Re: how archive redo logs are applied [message #127372 is a reply to message #127371]

Mon, 11 July 2005 07:36

mademba
Messages: 23
Registered: July 2005

Junior Member

i don't remember exactely but suppose

The online backup command is issued at time T

Time of dropping the table is T+5 minutes

Time specified in set until time clause during recovery using RMAN is T
best regards!

Report message to a moderator

Re: how archive redo logs are applied [message #127393 is a reply to message #127362]

Mon, 11 July 2005 09:11

rsone
Messages: 7
Registered: June 2005
Location: Jacksonville

Junior Member

Hello,

Can you check alert log and tell exactly what time is the table dropped.

As per your recovery, its supposed to recover your table if you have commited data and did the online backup.

Can you also tell what time you inserted the data and commited comparing with online backup you took.

Ramana

Report message to a moderator

Re: how archive redo logs are applied [message #127420 is a reply to message #127393]

Mon, 11 July 2005 10:49

mademba
Messages: 23
Registered: July 2005

Junior Member

i don't found what i did in the alert log but fortunately i've noted them.

i created the table at 11/07/2005_11:41:53
i inserted rows and commited at the same day at 11:43:36
i did a backup at 11:45:12
i dropped the table at 11:47:08

i issued the command
RMAN> recover database until time '11/07/2005_11:46:00'

Report message to a moderator

Previous Topic:	how to recover tablespace
Next Topic:	Importing Oracle 8.1.7 into Oracle 9.0.2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 22:41:12 CST 2024