OraFAQ Forum: Backup & Recovery » How to find current and last log sequence number which was backed

Home » RDBMS Server » Backup & Recovery » How to find current and last log sequence number which was backed

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

How to find current and last log sequence number which was backed [message #273178]

Tue, 09 October 2007 06:26

aslamkhalife
Messages: 42
Registered: July 2007
Location: India

Member

Hi
This is the following script below which I have prepared for Backup and deletion of Archive log

run
{
allocate channel dev1 type disk;
backup archive log from sequence xxx until sequence xxx format = 'e:\backup\db_t%t_s%s_p%p' DELETE ALL INPUT;
RELEASE CHANNEL DEV1;
}

My query is that how can I find the from which sequence no should I take backup.

(Imagine that one of the DBA had done backup of archive log from sequence no 123 10 days back and after that i was said to do the same task but I have no idea bout the sequence no from which he started)

Is this the good one or there is another good one for easy backup

Oracle 10.2.0.3.0
O/S Windows 2003 server.

Please guide for this query

Regards

Report message to a moderator

Re: How to find current and last log sequence number which was backed [message #273181 is a reply to message #273178]

Tue, 09 October 2007 06:54

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

v$archived_log

Regards
Michel

Report message to a moderator

Re: How to find current and last log sequence number which was backed [message #273191 is a reply to message #273181]

Tue, 09 October 2007 07:23

aslamkhalife
Messages: 42
Registered: July 2007
Location: India

Member

Hi Michel,

But V$ARCHIVED_LOG does not show which log file was archived by RMAN in order of Sequence Number, because i want to know which logfile was archive by RMAN in past.

Make me correct if am wrong.

Regards

Report message to a moderator

Re: How to find current and last log sequence number which was backed [message #273195 is a reply to message #273191]

Tue, 09 October 2007 07:41

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Yes but you know when you execute your backup, don't you?
So you have the associated archive log.

You also have rman "list backup of archivelog all;" and RC_% views.

Regards
Michel

[Updated on: Tue, 09 October 2007 11:05]

Report message to a moderator

Re: How to find current and last log sequence number which was backed [message #273207 is a reply to message #273195]

Tue, 09 October 2007 08:44

aslamkhalife
Messages: 42
Registered: July 2007
Location: India

Member

Hi Michel,

Thanks for again guiding me

Thanks very much

Regards

Aslam Khalife

Report message to a moderator

Previous Topic:	urgent help
Next Topic:	Autmatic recovery on DR Server using hotbackups

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 12:28:12 CDT 2024