This discussion is archived
0 Replies Latest reply: May 8, 2007 11:41 AM by 576502 RSS

Automate Archivelog Restore via OEM - No DataGuard

576502 Newbie
Currently Being Moderated
Using Oracle9i 9.2.0.6.0 I have created a process to create a standby version of my PROD database (no DataGuard). I am able to manually recover archive logs by modifying the sequence number used in the following command:

restore archivelog from sequence 12345 thread 1;

As long as I run this often and manually change the sequence number to reflect new logs (select max(sequence#)from v$archivelog;), this keeps my standby database relatively current.
Is there a way to use a parameter or sql statement to get the next sequence number from my PROD logs so that I can script or automate this process? I would like to be able to run a job via OEM (I use OEM 10g)? Any examples or help would be greatly appreciated. I am a junior, junior DBA.