Re: Recovery --- What am I doing wrong ?????????????????????????????????

On 29 Jan 98 19:23:39 GMT, austby_at_centuryinter.net (A Ustby) wrote:

>Hi,
>
>Using Oracle 7.3.2 on a Rs/6000 AIX box.
>
>Trying to do a point in time recovery, it sayes it did it - but data doesn't
>show it.
>
>--------
>
>1) Did a hot backup
>1a) Archive has been turned on.
>
>2) shutdown
>
>3) startup mount;
>
>4) recover database until time '1998-01-29:10:15:00';
>
>5) alter database open noresetlogs;
>
>6) SQLPLUS "select" on a test table shows restore didn't restore data.
>
>NO errors/warnings were produced.
>
>What am I missing ????????????????????
>
>Thanks for any comments or suggestions................ Art

You are doing a time-based incomplete recovery! You must notice :

1. when you alter no archive log mode to archive log mode, do you make a full backup?
2. what's the backup method ? off-line or on-line backup. for off-line, you must shutdown the database before doing a full backup. for on-line, you must execute : alter tablsespace tablespace_name begin backup; backup your datafile belong the tablespace_name. then alter tablsespace tablespace_name end backup; backup these datafiles by tablespace.
3. when you perform restore if you restore all data files? (not just the damaged file).
4. above your process steps 5, It should be the : alter database open resetlogs; the on line redo logs must be reset . and these archived redo logs is no use!
   • Slight Heart, Thousand Miles. Ken-ming Wang ***
   • MCSE & CNE/CNI Certified Sys. Engineer *** FROM
   • LGS 3d*/Administrator On LGS Go Server ***
   • Welcome to LGS. http://www.lgs.hinet.net *** R.O.C