SQL script in online backup

[richard]

to all,

I am a new user of SQL and Oracle, can anyone provide me a script in SQL w/out using RMAN that will enable me to backup and restore in online status or database is up. Can I use the DOS command "copy" for backup online?

richard.

[Raminder]

You can use 'DOS 'copy' command after placing the tablespace (of the datafile(s) you are copying) in backup mode.
I do not have a script but I can give you steps for online backup without RMAN.

1) Execute 'archive log list' form sqlplus to note down the value of oldest online log sequence.

2) Execute 'Alter Tablespace name begin backup;'

3) Copy the datafiles using OS Commands.

4) Execute 'Alter Tablespace end backup;'

5) Repeat for all tablespaces to be backed up.

6) Executer step 1 again, this time to note down last redolog required for using the online backup.

7) Issue 'Alter system switch logfile' to archive current redo log.

8) Do not forget to create a copy of control file by 'Alter database backup controlfile' statement.

Hope this helps.

[richard]

to all,

Can I use that steps in restoring datafiles?


richard