hot backup

[james07]

Hello all,

Does anyone here have a step-by-step process for doing a hot backup for Oracle8i on Unix?

I saw it somewhere on line once, but because of my crapping internet connection, I lost the link before I was able to print out the doc.

appreciated,

keep on truckin

[Kishore]

So many threads available on this forum. Search for Hot Backup

[sreddy]

I can outline the procedure, If you want including the syntax etc., I have to do that tomorrow from my desk:

1) bkup_begin.sql ( main script calls 2 script)

Setup the environment, meaning ORACLE_SID and ORACLE_HOME and call cr_tslistbegin.sql

2)cr_tslistbegin.sql (calls 3 script)

Use SQL to build SQL commnd 'ALTER tablespace xyz BEGIN BACKUP' from DBA_TABLESPACES view and spool it to tslistbegin.sql

3)tslistbegin.sql (Which contains striped out ALTER TABLESPACE Bacup BEGIN commands)

3a)tslistend.sql (Which contains striped out ALTER TABLESPACE Backup END commands)

2a)cr_tslistend.sql (calls 3a script)

Use SQL to build SQL commnad 'ALTER tablespace xyz END BACKUP ONLINE' using DBA_TABLESPACES view and spool it to tslistend.sql

1a)bkup_end.sql ( main end script calls 2a script)

Setup the environment, meaning ORACLE_SID and ORACLE_HOME and call cr_tslistend.sql

In simple terms:
1:Set environment
2,3: tablespace for backup and back it up
2a,3a:END backup.

Finally dump controlfile to trace using:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

I know the syntax what I typed in z wrong. Check for syntax.

Thanks for correcting me.




[Edited by sreddy on 02-07-2001 at 03:35 PM]

[james07]

sreddy,

that woud be great. Its exactly what I need, a procedure.

I'll check back later on tonight.


thanks

[sln81]

The above procedure for hot backup is fine except onething. The tablespaces need not be taken offline to take a hot backup.

[sambavan]

Why not try looking into that of using RMAN, that would avoid the necessity of taking the table space offline. It would also be easier at the time of recovery.

Sam