This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Apr 19, 2012 1:24 AM by UweHesse RSS

Oracle Database Backup

931394 Newbie
Currently Being Moderated
Hi

I want to take the backup of oracle database(10g) for installing oracle patches and upgradation.
I am using windows7. I dont have any userID and Password. I have tried some default userId and Passwords like Scott/Tiger, System/Manager.
But no use. Can anyone guide me how to take the backup and how to proceed further.

Thanks,
Nirmal
  • 1. Re: Oracle Database Backup
    582561 Newbie
    Currently Being Moderated
    if u want to take RMAN backup then u must have sysdba privileges.
  • 2. Re: Oracle Database Backup
    931394 Newbie
    Currently Being Moderated
    Any other options?
  • 3. Re: Oracle Database Backup
    Aman.... Oracle ACE
    Currently Being Moderated
    What's the 4 digit db version ? Are you not able to use operating system authentication ?

    Aman....
  • 4. Re: Oracle Database Backup
    931394 Newbie
    Currently Being Moderated
    We are now in oracle 10.1.0.3.0
    And we are planning to move to new version.
  • 5. Re: Oracle Database Backup
    Aman.... Oracle ACE
    Currently Being Moderated
    Same question, are you not able to use operating system authentication?

    Aman....
  • 6. Re: Oracle Database Backup
    839439 Pro
    Currently Being Moderated
    928391 wrote:
    We are now in oracle 10.1.0.3.0
    And we are planning to move to new version.
    If you can use operating system authentication then try as ...

    rman target /
    RMAN> backup database plus archivelog ;



    --neeraj                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
  • 7. Re: Oracle Database Backup
    Fran Guru
    Currently Being Moderated
    like technohub told you, the user sys is necessary. if you can try to change the password from sys user:
    sqlplus / as sysdba
    
    SQL*Plus: Release 10.2.0.1.0 - Production on MiÚ Abr 18 12:38:47 2012
    
    Copyright (c) 1982, 2005, Oracle.  All rights reserved.
    
    
    Conected to:
    Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
    
    SQL> alter user sys identified by oracle;
    
    User altered.
    
    SQL> conn sys/oracle as sysdba
    Connected.
    SQL>
    next, duplicate database. Please check:
    http://www.akadia.com/services/ora_duplicate_database_rman.html

    HTH
  • 8. Re: Oracle Database Backup
    UweHesse Expert
    Currently Being Moderated
    You refer to a secondary problem with your headline. Your major problem is
    >
    I dont have any userID and Password.
    >

    Why not?
    You must resolve this first. You cannot upgrade without it anyway.

    Look if your Win OS user is in the group ORA_DBA. Then you may open a DOS-Box and call
    sqlplus / as sysdba
    Try this first. If it doesn't succeed, come back to us so we can guide you about how to make that connection possible.

    Kind regards
    Uwe Hesse

    "Don't believe it, test it!"
    http://uhesse.com
  • 9. Re: Oracle Database Backup
    mBk77 Journeyer
    Currently Being Moderated
    Try to login with the account in which the database is installed.

    You dont need to enter any password .

    Or if you have the admin privlage just open the cmp prompt "run as administrator" and enter
    sqlplus / as sysdba
    if you get any error then copy past it here.

    On how to take backups-->

    The easies way to take a backup is to shutdown the database and copy the spfile, controlfile and the datafiles.

    To shutdown the database you need to login as sysdba.

    Once you've shutdown the database copy the spfile, controlfile and the datafiles, to the backup destination.

    One more thing If you want to upgare from 10g to 11g then physical backups are useless you need to take logical backup.

    GO through the below links on how to take logical backups.

    http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_export.htm
    http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_import.htm
  • 10. Re: Oracle Database Backup
    931394 Newbie
    Currently Being Moderated
    i couldn't able to use operating system authentication
  • 11. Re: Oracle Database Backup
    Aman.... Oracle ACE
    Currently Being Moderated
    928391 wrote:
    i couldn't able to use operating system authentication
    And the error was?

    Aman....
  • 12. Re: Oracle Database Backup
    931394 Newbie
    Currently Being Moderated
    I am not sure that the given credentials were OS credentials or not.
    But the error is wrong password for the user.
  • 13. Re: Oracle Database Backup
    Aman.... Oracle ACE
    Currently Being Moderated
    928391 wrote:
    I am not sure that the given credentials were OS credentials or not.
    But the error is wrong password for the user.
    What's the output of the command.
    c:\sqlplus / as sysdba
    Aman....
  • 14. Re: Oracle Database Backup
    931394 Newbie
    Currently Being Moderated
    It has been connected to the oracle database successfully.
    Please guide me how to take the backup now.
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points