Home » RDBMS Server » Backup & Recovery » How to find current and last log sequence number which was backed
How to find current and last log sequence number which was backed [message #273178] Tue, 09 October 2007 06:26 Go to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
v$archived_log

Regards
Michel
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
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 Go to previous message
aslamkhalife
Messages: 42
Registered: July 2007
Location: India
Member
Hi Michel,

Thanks for again guiding me

Thanks very much

Regards

Aslam Khalife
Previous Topic: urgent help
Next Topic: Autmatic recovery on DR Server using hotbackups
Goto Forum:
  


Current Time: Sun Dec 11 02:01:45 CST 2016

Total time taken to generate the page: 0.13549 seconds