Can I copy the files after shutting down the service

[sudheer_nm]

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

[candyman]

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

[sysdba]

depends on your Oracle version.
In Oracle 7, for example, you have to stop the service AND
stop the database.

[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.

[sudheer_nm]

How can I figure out whether my database is in archivelog mode or not?

[adewri]

As sys user do.

sql> archive log list

[AOrehek]

DBA user can do

SELECT log_mode FROM v$database;

[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

[adewri]

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.

[OracleDoc]

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