-
Hot backups
Hello,
I am a new DBA for an existing database which is running in archive mode and I cannot shut it down to take a cold backup.
And we lost the cold backup that old DBA has taken when he turn database into archive mode.
Old DBA set up hot backups of all data files and control file every alternative day. This backup script stops archive log, deletes all archive log files and starts archive log just before hot backups. We have archive log files from just before hot backups are performed.
Now I want to take these hot backup data files, control file and archive log files into another system and bring up the database...basically wants to test these backups.
I would appreciate if anyone can give me a feasible method to test my backups.
Thank you
-
Just forget about your old DBA. Come with your own scripts for hot backups. Same site has some hot backup scripts for reference.
http://www.dbasupport.com/oracle/scr...ry/Hot_Backup/
Raghu
-
Hot backups that old DBA took were genuine. Would I be able to bring up database on another system with these hot backups? I am sure that I need cold backups too in addition to these hot backups. But we lost them.
-
No, you do not need cold backup to restore to another box. Even with hot backups ( I am assuming he got all datafiles,control file to trace, ness. archived log files) you can restore DB to another server provided you have same binaries(version) running on another server.
Raghu
-
Re: Hot backups
Originally posted by Vimala
Hello,
And we lost the cold backup that old DBA has taken when he turn database into archive mode.
You can do your own hot backup too,
aside from the link that raghud stated, here is one quick script
of DOING A HOT BACKUP in SOLARIS(you can edit it,according to your needs) from one machine to another:
DECLARE
WS_TBS NUMBER;
VAR_TBS VARCHAR2(25);
tbs_nam varchar2(25);
file_nam varchar2(50);
Cursor c1 is select tablespace_name, file_name
from dba_data_files order by tablespace_name;
BEGIN
VAR_TBS := 'XXXXXXXXXXXX';
WS_TBS := 1;
OPEN c1;
LOOP
FETCH c1 INTO tbs_nam, file_nam;
IF VAR_TBS = tbs_nam THEN
DBMS_OUTPUT.PUT_LINE('host rcp -pr '||file_nam||' SERVER02:'||file_nam);
ELSE
begin
IF WS_TBS = 0 THEN
DBMS_OUTPUT.PUT_LINE('ALTER TABLESPACE '||VAR_TBS||' END backup;');
END IF;
DBMS_OUTPUT.PUT_LINE('ALTER TABLESPACE '||tbs_nam||' begin backup;');
DBMS_OUTPUT.PUT_LINE('host rcp -pr '||file_nam||' SERVER02:'||file_nam);
VAR_TBS := tbs_nam;
WS_TBS := 0;
end;
END IF;
EXIT WHEN c1%NOTFOUND;
END LOOP;
CLOSE c1;
DBMS_OUTPUT.PUT_LINE('ALTER TABLESPACE '||VAR_TBS||' END backup;');
END;
-
You can restore hot/cold backup to any server, just with hot backups most probably is you need to recreate controlfiles if the PATHs where you are gonna store the datafiles are different then that would imply resetlogs when you recover and open the database
-
Can someone write me a procedure to bring up database on another system (with same oracle binaries) with this type of hot backup.
I have all data files hot backups, control file to trace backup and archive log files.
Should I restore redo log files or create them?
-
-
Re: Hot backups
Originally posted by Vimala
This backup script stops archive log, deletes all archive log files and starts archive log just before hot backups.
I don't like this.
What if your last backup tape turns out to be unreadable? You can't use the last-but-one because you don't have the archivelogs.
I'd keep the archivelogs for at least a week in this case.
-
Can someone write me a procedure to bring up database on another system (with same oracle binaries) with this type of hot backup.
__________________
You have to give your pay check then we can ??
I am just joking .. Please search in metalink there are so many scripts...
Raghu
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
|