Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    21

    Unhappy Unanswered: Error while performing database recovery... HELP

    Hi,

    I have been trying to work on cold database backups, i.e offline full database backups and recovery.

    While taking the backup, I copy the control files and the datafiles in a backup folder.

    Then I perform a little test.

    What I do is add few more records in the database.

    To see if restoration works or not, what I do is the following steps:

    1) Shutdown the database.
    2) Copy the data files and control files from the backup folder back to the proper location where the database files are kept.
    3) Start the instance and mount the database.
    4) Do incomplete recovery by typing

    SQL> alter database recover until cancel.

    This is to mimic incomplete recovery.

    5) alter database open RESETLOGS.

    But my test fails at step 4) while I am trying to mimic incomplete recovery.


    FYI, I AM RUNNING THE DATABASE IN NO ARCHIVE LOG MODE.


    I do the following and hence get the following errors:

    Please see to it and let me know what exactly could be the cause of errors.


    [oracle@atech3 blackboard_backup]$ sqlplus /nolog

    SQL*Plus: Release 8.1.7.0.0 - Production on Wed Jul 23 14:40:47 2003

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

    SQL> connect / as sysdba
    Connected.
    SQL> shutdown normal
    Database closed.
    Database dismounted.
    ORACLE instance shut down.

    Here I copy the datafiles and the control files from the backup folder to the database location. (copy only control and data files)


    The next step is as follows:

    SQL> startup mount
    ORACLE instance started.

    Total System Global Area 72704160 bytes
    Fixed Size 73888 bytes
    Variable Size 55681024 bytes
    Database Buffers 16777216 bytes
    Redo Buffers 172032 bytes
    Database mounted.
    SQL> alter database recover until cancel;
    alter database recover until cancel
    *
    ERROR at line 1:
    ORA-00279: change 486384461 generated at 07/21/2003 11:36:55 needed for thread
    1
    ORA-00289: suggestion : /usr/local/oracle/admin/wku/arch/arch1056230.arc
    ORA-00280: change 486384461 for thread 1 is in sequence #1056230

    Thanks a lot.

    - Bikram.

  2. #2
    Join Date
    Jul 2003
    Posts
    21

    Re: Error while performing database recovery... HELP

    Can anybody help ??? ....

    - Bikram.



    Originally posted by bikramjeet77
    Hi,

    I have been trying to work on cold database backups, i.e offline full database backups and recovery.

    While taking the backup, I copy the control files and the datafiles in a backup folder.

    Then I perform a little test.

    What I do is add few more records in the database.

    To see if restoration works or not, what I do is the following steps:

    1) Shutdown the database.
    2) Copy the data files and control files from the backup folder back to the proper location where the database files are kept.
    3) Start the instance and mount the database.
    4) Do incomplete recovery by typing

    SQL> alter database recover until cancel.

    This is to mimic incomplete recovery.

    5) alter database open RESETLOGS.

    But my test fails at step 4) while I am trying to mimic incomplete recovery.


    FYI, I AM RUNNING THE DATABASE IN NO ARCHIVE LOG MODE.


    I do the following and hence get the following errors:

    Please see to it and let me know what exactly could be the cause of errors.


    [oracle@atech3 blackboard_backup]$ sqlplus /nolog

    SQL*Plus: Release 8.1.7.0.0 - Production on Wed Jul 23 14:40:47 2003

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

    SQL> connect / as sysdba
    Connected.
    SQL> shutdown normal
    Database closed.
    Database dismounted.
    ORACLE instance shut down.

    Here I copy the datafiles and the control files from the backup folder to the database location. (copy only control and data files)


    The next step is as follows:

    SQL> startup mount
    ORACLE instance started.

    Total System Global Area 72704160 bytes
    Fixed Size 73888 bytes
    Variable Size 55681024 bytes
    Database Buffers 16777216 bytes
    Redo Buffers 172032 bytes
    Database mounted.
    SQL> alter database recover until cancel;
    alter database recover until cancel
    *
    ERROR at line 1:
    ORA-00279: change 486384461 generated at 07/21/2003 11:36:55 needed for thread
    1
    ORA-00289: suggestion : /usr/local/oracle/admin/wku/arch/arch1056230.arc
    ORA-00280: change 486384461 for thread 1 is in sequence #1056230

    Thanks a lot.

    - Bikram.

  3. #3
    Join Date
    Jul 2003
    Posts
    21

    Talking Re: Error while performing database recovery... HELP

    I think I got the solution to this problem.

    I think what might have happened was that prior to running the database in no archive log mode, we might have been running the DB in archive log mode and hence it might have recorded changes in the log files.

    Now that we are running in no archive log mode, but since the log files were never reset using RESETLOGS option while opening the database,
    It might have been trying to detect changes recorded in the archive logs.

    What I did was I recopied the backup files along with the older log files having same SCN as that in the data files header.

    After mounting and opening the database with RESETLOGS option, I shutdown the database and recopied the data files and control files in the backup directory.

    Now after I made changes in the active database, I shutdown the DB and copied the backup files from the backup directory, did incomplete recovery and started the database with RESETLOGS option.

    It worked for me.

    So, I guess the ultimate solution was to open the database with RESETLOGS option just to reset the SCN so that there are no records in the redo log files to do recovery.

    Thanks,

    - Bikram.











    Originally posted by bikramjeet77
    Hi,

    I have been trying to work on cold database backups, i.e offline full database backups and recovery.

    While taking the backup, I copy the control files and the datafiles in a backup folder.

    Then I perform a little test.

    What I do is add few more records in the database.

    To see if restoration works or not, what I do is the following steps:

    1) Shutdown the database.
    2) Copy the data files and control files from the backup folder back to the proper location where the database files are kept.
    3) Start the instance and mount the database.
    4) Do incomplete recovery by typing

    SQL> alter database recover until cancel.

    This is to mimic incomplete recovery.

    5) alter database open RESETLOGS.

    But my test fails at step 4) while I am trying to mimic incomplete recovery.


    FYI, I AM RUNNING THE DATABASE IN NO ARCHIVE LOG MODE.


    I do the following and hence get the following errors:

    Please see to it and let me know what exactly could be the cause of errors.


    [oracle@atech3 blackboard_backup]$ sqlplus /nolog

    SQL*Plus: Release 8.1.7.0.0 - Production on Wed Jul 23 14:40:47 2003

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

    SQL> connect / as sysdba
    Connected.
    SQL> shutdown normal
    Database closed.
    Database dismounted.
    ORACLE instance shut down.

    Here I copy the datafiles and the control files from the backup folder to the database location. (copy only control and data files)


    The next step is as follows:

    SQL> startup mount
    ORACLE instance started.

    Total System Global Area 72704160 bytes
    Fixed Size 73888 bytes
    Variable Size 55681024 bytes
    Database Buffers 16777216 bytes
    Redo Buffers 172032 bytes
    Database mounted.
    SQL> alter database recover until cancel;
    alter database recover until cancel
    *
    ERROR at line 1:
    ORA-00279: change 486384461 generated at 07/21/2003 11:36:55 needed for thread
    1
    ORA-00289: suggestion : /usr/local/oracle/admin/wku/arch/arch1056230.arc
    ORA-00280: change 486384461 for thread 1 is in sequence #1056230

    Thanks a lot.

    - Bikram.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •