Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by dbtoo2001

  1. dbtoo2001

    3 databases - but only 1 can connect to rman

    Have you resolved this? Can you login to sqlplus as sysdba? Since it's only the network connected servers, it may be that a GPO was applied which changed what the oracle dba group administrators have been granted.
  2. dbtoo2001

    Motivate Yourself as DBA

    I would suggest the following: automate the list that you gave of normal routine, email yourself the results (if you don't do that already.) if your company doesn't have a 'play machine', insist on one, and start practicing - standby databases, scenarios for failures, rman, etc. join OTN...
  3. dbtoo2001

    sqlplus: not found.

    Typically (even when spelled correctly) you don't include the bin in the home... ORALCE_HOME=/appl/oracle/10.1.0/bin; export ORACLE_HOME should be ORACLE_HOME=/appl/oracle/10.1.0; export ORACLE_HOME
  4. dbtoo2001

    RMAN Restore of Hot Backup

    http://forums.oracle.com/forums/thread.jspa?messageID=2262928&#2262928
  5. dbtoo2001

    Measure changes for disaster recovery.

    Read through http://www.oracle.com/pls/db92/db92.show_toc?partno=a96653&remark=drilldown&word=dataguard . It will explain what is necessary.
  6. dbtoo2001

    Deinstall Spatial (MDSYS)

    Metalink Note:179472.1
  7. dbtoo2001

    [b]Best Way To Delete By Date?[/b]

    Of course I'm familiar with Tom's montra. He also offers great advice on many things, including bulk collect: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:3561337894959 (sorry, don't have access to tiny url from work.) It wasn't 'my' proscribed solution, as it was a...
  8. dbtoo2001

    [b]Best Way To Delete By Date?[/b]

    ? http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96624/05_colls.htm#35883
  9. dbtoo2001

    [b]Best Way To Delete By Date?[/b]

    Consider bulk collect: http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96624/05_colls.htm#28415
  10. dbtoo2001

    How to export an old oracle database?

    http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76993/osbackup.htm#1366
  11. dbtoo2001

    Accessing Oracle DB Over Internet

    http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_environments.htm#sthref47
  12. dbtoo2001

    completely re-moving oracle from windows

    http://www.mydigitallife.info/2005/12/13/manual-and-clean-uninstall-oracle-for-windows/ Found this from google
  13. dbtoo2001

    Help with Oracle 10g

    You haven't been paying attention in class, have you? http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch3.htm#sthref712 http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements008.htm#sthref722 http://ORA-00955.ora-code.com/ Crystal ball says you need to...
  14. dbtoo2001

    FAQ on "how to post" required?

    Since I've got Santa rolling on the floor laughing, here's a couple more: Parasiting I'm in a position I said I could do But haven't experience to back what I knew So I post in the forum - my defacto mentor Brain dump your knowledge to this genus stentor I need it right now, it's an URGENT...
  15. dbtoo2001

    Using only archivelogs for recovery?

    http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/recoscen003.htm#BRADV224 I've never tried it. Let us know how you make out, and what the steps were that you did. Thanks. Good luck.

Part and Inventory Search

Back
Top