All geek questions in one place

Problem while backing up Oracle 10g

I just got started and identified a problem in which the database is not currently being properly backed up, so to speak. We do one backup every 6 hours using our own Oracle backup utility, but we also sold the process to a company in which they stated that they could essentially perform “warm” backups of our database by simply taking copies of the file system from our files databases, and when we needed to restore, we just shut down Oracle, and then copied the files that were copied, restart Oracle, and the world will become whole again. The challenge is that we have not received this yet. I need to spend more time reviewing the message that Oracle provides, but my main question is: "Is it possible" to take copies of Oracle files,while Oracle is still running, and use these files later to restore the database? I know that it works if the database is closed and then copies are made, but this is the first thing I heard about the fact that the copy (file system) can be executed while the database is running. Any guidance would be greatly appreciated. Here is the error we get.

ORA-00314: log 3 of thread 1, expected sequence# 1939 doesn't match 1944
ORA-00312: online log 3 thread 1: 'E:\ORACLE\ORADATA\ITMS\REDO03.LOG'
+3
source share
4 answers

Yes, it is possible, but first you need to transfer all the table spaces to backup mode and then display them (for example, ALTER TABLESPACE x BEGIN BACKUPand ALTER TABLESPACE x END BACKUP), you will need to check the syntax and make sure that it is suitable for your situation!). A huge simplification, this tells Oracle not to write to any of the data files, so they are all in a consistent state.

The two main problems that you encounter are that individual files are updated while they are being copied, so one file may be damaged; and more noticeably, different files have different internal timestamps and sequences, so Oracle will not allow them to be used.

, , . , , , .

, - . , , . , RECOVER , , ; , RESETLOGS , . , ...

+3

, "" Oracle.

  • , "BEGIN BACKUP".
  • , Veritas, , .
+3

. ARCHIVELOG.

script :

Alter tablespace USERS begin backup;
host cp -p /u02/oradata/PROD/users01.dbf /u03/backup/PROD/
host cp -p /u02/oradata/PROD/users02.dbf /u03/backup/PROD/
Alter tablespace USERS end backup;

RMAN. RMAN - QUITE ROBUST, , , . , , .. RMAN.

, ( Oracle DBA, , ymmv):

$ ORAENV_ASK=NO
$ ORACLE_SID=PROD
$ . oraenv
$ rman target=/

Recovery Manager: Release 10.2.0.4.0 - Production on Thu Oct 28 14:23:29 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: PROD (DBID=x)

RMAN> backup as compressed backupset database plus archivelog;

...

Backup Complete.
+1

- , Amazon EC2. - EBS. , EBS , , , RECOVER DATABASE.

, , , .

+1

Source: https://habr.com/ru/post/1771931/

More articles:


All Articles