| Online backup 9i & 10g |
| Tuesday, May 6, 2008 |
Online backup in 9i using begin and end backup mode:
----------------------------------------------------
(Database should be in archive log mode)
connect sqlplus as sysdba and do the following
steps:
spool begin.sql
select 'alter tablespace ' || tablespace_name ||
' begin backup;' from dba_tablespaces where
tablespace_name != 'TEMP';
spool off
spool end.sql
select 'alter tablespace ' || tablespace_name ||
' end backup;' from dba_tablespaces where
tablespace_name != 'TEMP';
spool off
then execute,
@begin.sql
check,
select status from v$backup;
it'll show status as active
Copy the data_top and archive log files
to the backup location. After copying
remove the archive log files in archive location.
after copying the datafiles execute,
@end.sql
Check the status,
select status from v$backup;
it'll show status as not active
Online backup in 10g:
---------------------
(Database should be in archive log mode)
connect sqlplus as sysdba and do the following
steps:
Execute,
alter database begin backup;
check,
select status from v$backup;
it'll show status as active
Copy the data_top and archive log files
to the backup location. After copying
remove the archive log files in archive location.
Execute,
alter database end backup;
Check the status,
select status from v$backup;
it'll show status as not active.
Enabling archive log 9i and 10g and restoring
online backups will be in next posting. |
posted by Senthil Kumaran @ 9:19 PM   |
|
|
|
