Stand By Database File Prep 3

[Michael42]

Hello,

In the Oracle 9 docs for Stand By Database it mentions the database must be shutdown to copy the data files (system.dbf,users01.dbf etc.). I am in a 24\7 environment where this is not possible.

Can I simply do the following for each data file?

1. ALTER TABLESPACE <tablepsace_name> BEGIN BACKUP;
2. cp <tablespace>.dbf /oracle/standby_db_files
3. ALTER TABLESPACE <tablepsace_name> END BACKUP;

I have never used this "hot" backup technique. Will this disrupt the user\application access to tables in the tablespace being "hot" backed up? Seems silly to ask but I need to make sure.

Thanks,

Michael42

 

[LKBrwnDBA]

Yes, it's possible and it works.

Remember to also do:
ALTER SYSTEM CHECKPOINT;
and
ALTER SYSTEM ARCHIVE LOG CURRENT;


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[eagertotry]

Yes, you can do it this way. As a "hot" backup thing, this works without a problem. You can create your standby database this way without a problem. Just make sure that you copy all the archive logs also to the standby location.

 

[Michael42]

Thanks all very much for your confirmations.

Thanks,

Michael42

 

[dbtoo2001]

Michael42 - after you've created your standby and you have been running it for awhile, make sure you periodically check for unrecoverable transactions. Run this in both the primary and the standby, the output should match in both. If not, the standby needs to be refreshed.

set linesize 132
set pages 100
col name format a55
SELECT name, unrecoverable_change# FROM v$datafile;

 

[Michael42]

dbtoo2001,

Thanks very much for this info.

-Michael42