| 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
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
