-
Hi,
I need information about hot backups.
after I giver alter tablespace tablespacename begin backup
How it is functioning, If anybody knows
How i can take hot backups plz tell me the steps and details.
I am confused with this.
Thanking You,
my id is shankar_gk@hotmail.com
G.Shankar.
-
Following are the minimum steps to a hot backup:
1) Make sure the database is in ARCHIVELOG mode.
2) Prepare the database for a hot backup:
SQL> ALTER TABLESPACE tablespace_name BEGIN BACKUP;
3) Obtain the oldest online log sequence #:
SQL> ARCHIVE LOG LIST;
4) Back up the database using a system command:
UNIX: obackup, tar, dd, etc...
NT: backup manager, etc..
5) Set the tablespace to no hot backup mode:
SQL> ALTER TABLESPACE tablespace_name END BACKUP;
6) Obtain the current online log sequence #:
SQL> ARCHIVE LOG LIST;
7) Force a log switch:
SQL> ALTER SYSTEM SWITCH LOGFILE;
Good luck
R
On the other hand, you have different fingers.
-
Originally posted by rlowe
Following are the minimum steps to a hot backup:
.....
A final step is missing from your backup scenario for this backup to be usable:
8.) Back up all the archived logs that have been created during the backup procedure - all archlogs with sequences between (and including) numbers obtained in steps 3.) and 6.)
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
details...
On the other hand, you have different fingers.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|