backup recover
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: backup recover

  1. #1
    Join Date
    Jan 2000
    Location
    san jose
    Posts
    149

    Arrow

    time t:
    whole backup + controlfile backup ct1

    time t+1
    add a datafile

    time t+2
    drop a tablespace

    time t+3
    add a tablespace

    time 4
    crash

    can i use controlfile backup ct1 to recover to time t+3?

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Yes.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Jan 2000
    Location
    san jose
    Posts
    149
    if that's the case, what's different if i use ct1 or the one i backup at time t+3?

    oracle always suggest to use control file that can reflect the
    database structure, but i think any control file older than
    the time we want to recover to will do , am i right?

  4. #4
    Join Date
    Mar 2001
    Posts
    24
    In your case, your control file is changed (details see the following). I don't think you can use the control file backup ct1 to recover to time t+3.

    Control Files will be changed and advisable to backup after any following commands is issued:

    ALTER DATABASE [ADD|DROP] LOGFILE
    ALTER DATABASE [ADD|DROP] LOGFILE MEMBER
    ALTER DATABASE [ADD|DROP] LOGFILE GROUP
    ALTER DATABASE [NOARCHIVELOG|ARCHIVELOG]
    ALTER DATABASE RENAME FILE
    CREATE TABLESPACE
    ALTER TABLESPACE [ADD|RENAME] DATAFILE
    ALTER TABLESPACE [READ WRITE|READ ONLY]
    DROP TABLESPACE

    Hope this can help.

  5. #5
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Controlfile - SCN - Logfile

    Hi, 20th April 2001 16:06 hrs chennai

    I want to make you onething clear.

    If you are using the contolfile from the backup then
    You cannot recover DB to time t+3 with old controlfile of ct1.

    If you have the existing controlfile mirrored or back up in trace or the existing contolfile is not damaged there is no need of using old backup controlfile to recover.The copy of the control file with the restored datafiles from backup will help you to move ahead and recover till the last SCN by applying the logfiles.

    Cheers

    Padmam
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

Posting Permissions

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



Click Here to Expand Forum to Full Width