Hot backup of a datafile

[pcotten]

We need to do hot backup of a datafile in our production database and copy it to the standby, since this datafile on the standby seems corrupted.

I am looking for the safest way to do this.

Do I issue a Alter datfile "path" begin backup command? How do I copy the file over to standby? Thanks.

[sreddy]

Assuming your OS is unix. If its NT Click and drag

ALTER TABLESPACE XYZ BEGIN BACKUP;
cp p:/primary/xyz.dbf s:/standby/xyz.dbf
ALTER TABLESPACE XYZ END BACKUP;

p---> Primary Database Machine
s---> Standby Databsse machine

If machines are ssh enabled use scp instead of copy.

[pcotten]

I am assuming that we do the backup in svrmgrl.

When the backup is done, copy the file over and then issue the end backup command. Am I right? Thanks.

[sreddy]

You have option to use SQL*Plus or SVRMGRL if its 8i for SQL commands, you do not have any option if its 9i.

[jmodic]

Originally posted by sreddy
You have option to use SQL*Plus or SVRMGRL if its 8i for SQL commands, you do not have any option if its 9i.

It can be *any* tool that can execute SQL commands - you are not limited to SQL*Plus/svrmgrl. So you allways have many options.

[sreddy]

Jmodic,

You are right from general Usage of SQL, I meant at OS level we do these tasks like backing up tablespaces copying/moving datafiles etc.,

[jmodic]

Originally posted by sreddy
I meant at OS level we do these tasks like backing up tablespaces

No you don't. You can't put your tablespace in backup mode from OS level - you must allways use some application for that. And if you ment "from command line interface we do this task..." then again you certanly are not limited to SQL*Plus/svrmgrl - you can use any command line utility/application that is capable of executing SQL. You can even write your own, if you want.

You are only limited to SQL*Plus/svrmgrl when it comes to database startup/shutdown. That is because STARUP/SHUTDOWN are not SQL commands, they are SQL*Plus's (or svrmgrl's) commands. So only those two tools will know what you want with those commands.

[Mnemonical]

Originally posted by jmodic
You are only limited to SQL*Plus/svrmgrl when it comes to database startup/shutdown. That is because STARUP/SHUTDOWN are not SQL commands, they are SQL*Plus's (or svrmgrl's) commands. So only those two tools will know what you want with those commands.

RMAN also accepts startup and shutdown commands.


F.