Re: how to handle migrating to new database over time

I wouldn't be suggesting this if I hadn't already taken 10g for a spin and fell off a couple times :-)

There's a lot of little gotchas and each one takes time. For example, you have to
have the "login as a batch job" privilege for a lot of oracle activities. By default even administrator doesn't have that in 2003 server.
There's just a lot of issues like that.

Plus I'm trying to use features I didn't use before like em and rman and each one of these is a world unto itself.

Anyone know what magic it takes for rman to recognize a dlt tape drive? MS' backup uses it just fine. It is using a MS driver dlttape.sys But apparently that's not enough for rman. I'm wondering if it is even possible to use this tape drive with oracle. Windows labels it as
"Bnchmark dlt scsi sequential device".
I think the relevant error message from
the test tape backup in em is (note
that sbtio.log exists but has no contents):

• ACTION NAME:(0000001 STARTED1) 2005-07-08 17:51:24.945
• SERVICE NAME:(SYS$USERS) 2005-07-08 17:51:24.945
• SESSION ID:(136.6) 2005-07-08 17:51:24.945 SKGFQ OSD: Error in function sbtinit on line 2325 SKGFQ OSD: Look for SBT Trace messages in file D:\ORACLE\PRODUCT\10.1.0 \ADMIN\MYDB\UDUMP\sbtio.log SBT Initialize failed for oracle.static