Re: Backup Question

You're on the right track.

However, I think that you misunderstand the "structural change" concept. It does not relate to DDL statements such as creation/dropping of tables. It relates to adding/removing/renaming database files and/or tablespaces

Hope this helps

--
Karl
Oracle Certified DBA

Jim Anderson wrote in message <34AAA872.7128F87_at_ci.lincoln.ne.us>...


>We are using Oracle 7.3.2.3.1 on Netware. I am testing Oracle

>backup/recovery procedures. On page 23-3 of the Administrator's  Guide,

>it states that if you are running in ARCHIVELOG mode, you only need to

>backup the control file before and after a structural change to the

>database. I am assuming this means that you can recover from the

>structural change with only the control file before the change. To test

>this, I make a backup of the control file and drop a tablespace. To try

>and get the tablespace back, I shutdown the database, start the

>instance, mount and issue:

>

>alter database recover until time 'time_before table was dropped' using

>backup control file;

>

>The logs are applied and everything appears to have worked. I then try

>to open the database with:

>

>alter database open resetlogs;

>

>I receive errors indicating that the system tablespace needs recovery

>due to incomplete recovery. Am I wrong in assuming that the Admin guide

>means that you can recover from a structural change with only the

>control file before the structural change? The section on time based

>recovery states that you need to restore datafiles from before the time

>of the intended time based recovery. In real life I would backup the

>entire database before a structural change. I am just curious what the

>correct answer to this question is.

>

>Thanks for any help,

>Jim Anderson

>



begin 666 Karl E. Jørgensen.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..DKX<F=E;G-E;CM+87)L.T4N
M#0I&3CI+87)L($4N($KX<F=E;G-E;@T*3U)'.E-E<75E;"!);6%G90T*3D]4
M13I396YI;W(@4WES=&5M<R!%;F=I;F5E<@T*55),.@T*55),.FAT=' Z+R]S
M97%U96PM:6UA9V4N8V]M#0I%34%)3#M04D5&.TE.5$523D54.FMJ;W)G0&US
H;BYC;VT-"E)%5CHQ.3DX,#$P,50R,C W,CA:#0I%3D0Z5D-!4D0-"@``
`
end
end