Can I copy the files after shutting down the service
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 29

Thread: Can I copy the files after shutting down the service

  1. #1
    Join Date
    Dec 2002
    Location
    Chennai, India
    Posts
    104

    Can I copy the files after shutting down the service

    Hi Gurus,
    Can I copy the database files after shutting down the Oracle service(using net stop OracleServiceSID) with out shutting down the database instance.
    FYI.
    I have to use this copied files for similar database that are running on different system.

    Regards,
    Sudheer

  2. #2
    Join Date
    Aug 2003
    Posts
    54
    when you shutdown the services, pretty much the same thing as SHUTDOWN IMMEDIATE and you surely can copy the datafiles; HOWEVER, you mentioned to copy them to different system, are they on the same o/s platform otherwise you can't do that.

    SOLUTION: exp/imp

  3. #3
    Join Date
    Jun 2000
    Posts
    295
    depends on your Oracle version.
    In Oracle 7, for example, you have to stop the service AND
    stop the database.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    If you're in archivelog mode, you can copy the files while the database is up and just start recovery on your cloned database.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Dec 2002
    Location
    Chennai, India
    Posts
    104
    How can I figure out whether my database is in archivelog mode or not?

  6. #6
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    As sys user do.

    sql> archive log list
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  7. #7
    Join Date
    Oct 2002
    Location
    Ljubljana,Slovenia
    Posts
    28
    DBA user can do

    SELECT log_mode FROM v$database;
    Aleš Orehek

  8. #8
    Join Date
    Dec 2002
    Location
    Chennai, India
    Posts
    104
    I'd executed 'select log_mode form v$database' and in each case I'd seen that databases are in NOARCHIEVELOG MODE.
    Should I do the backup like

    1. Stop OracleServiceXXX using net stop ....
    2. copies all the db files to tape
    3. restart the service using net start ...

    Here everything worked fine for me for two databases but for third database restore from backup causes some problem and it says
    'ORA-01113: file 2 needs media ercovery
    ORA-01110: data file 2: 'H:\db\acc\acc.dbf'

    Any ideas on what went wrong here?

    FYI: Iam using Oracle9i

  9. #9
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by sudheer_nm
    I'd executed 'select log_mode form v$database' and in each case I'd seen that databases are in NOARCHIEVELOG MODE.
    Should I do the backup like

    1. Stop OracleServiceXXX using net stop ....
    2. copies all the db files to tape
    3. restart the service using net start ...

    Here everything worked fine for me for two databases but for third database restore from backup causes some problem and it says
    'ORA-01113: file 2 needs media ercovery
    ORA-01110: data file 2: 'H:\db\acc\acc.dbf'

    Any ideas on what went wrong here?

    FYI: Iam using Oracle9i
    This simply means that the copy of datafile was not proper. The copy of the db files should be done when the database is down.
    Just delay the copy comand by some time say 5 mins. Shutdown time can be longer in case there is a long active transaction pending to rollback or commit.

    Just delay the copy command.

    Here you cannot do any thing about it unless you have a valid cold backup.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  10. #10
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Originally posted by marist89
    If you're in archivelog mode, you can copy the files while the database is up and just start recovery on your cloned database.
    *cough cough* You left out an important piece of information. Alter tablespace begin backup
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width