Re: Rookie restore problem

From: <todd_at_nospam.org>
Date: 31 Mar 2001 18:52:59 GMT
Message-ID: <9a592b$tu$1@news.netmar.com>

This what I have been doing to attempt to restore on a different machine:

Short version
1) I installed Oracle on new machine (same directory structure) 2) I created a new control file(s) by issuing: alter database backup controlfile to trace;
3) I modify that script to add additional .dbf file that was in the old database (CONTROLROOM.dbf)
4) I run the script in svrmgrl to create new control files using RESETLOGS instead of NORESETLOGS, because I didn't back the redo logs up

5) I copy over all the backup .dbf files to new machine
6) using svrmgrl, connect internal, startup mount
7) alter database open resetlogs
8) message about how the system01.dbf file needs recovery
9) recover database using backup controlfile until cancel;

10) when prompted for the arc file, I hit enter, but the .arc file doesn't exist.

Did I screw this up by not backing up the arc files?

Todd

In article <3ABDB15E.F7334B42_at_netvigator.com>, Reid Lai <reidlai_at_netvigator.com> writes:
>What are your steps?
>
>Reid
>
>todd_at_nospam.org wrote:
>
>> I backed up a database using the following script:
>> /*************************************************************/
>> /* Description: Oracle Backup script */
>> /* Usage: Execute in SYSDBA-privileged SQL*Plus session */
>> /*************************************************************/
>>
>> PROMPT Backup up database to jar file
>> PROMPT $ORACLE_BASE/backups/db-backup.tar
>>
>> PROMPT Backing up SYSTEM tablespace ...
>> PROMPT
>> ALTER TABLESPACE system BEGIN BACKUP;
>> HOST cp $ORACLE_BASE/oradata/www/system01.dbf $ORACLE_BASE/backups/.
>> ALTER TABLESPACE system END BACKUP;
>>
>> PROMPT SYSTEM tablespace backed up.
>> PROMPT
>>
>> PROMPT Backing up TOOLS tablespace ...
>> PROMPT
>> ALTER TABLESPACE tools BEGIN BACKUP;
>> HOST cp $ORACLE_BASE/oradata/www/tools01.dbf $ORACLE_BASE/backups/.
>> ALTER TABLESPACE tools END BACKUP;
>>
>> PROMPT TOOLS tablespace backed up.
>> PROMPT
>>
>> PROMPT Backing up TEMP tablespace ...
>> PROMPT
>> ALTER TABLESPACE temp BEGIN BACKUP;
>> HOST cp $ORACLE_BASE/oradata/www/temp01.dbf $ORACLE_BASE/backups/.
>> ALTER TABLESPACE temp END BACKUP;
>>
>> PROMPT TEMP tablespace backed up.
>> PROMPT
>>
>> PROMPT Backing up USERS tablespace ...
>> PROMPT
>> ALTER TABLESPACE users BEGIN BACKUP;
>> HOST cp $ORACLE_BASE/oradata/www/users01.dbf $ORACLE_BASE/backups/.
>> ALTER TABLESPACE users END BACKUP;
>>
>> PROMPT USERS tablespace backed up.
>> PROMPT
>>
>> PROMPT Backing up SYSTEM tablespace ...
>> PROMPT
>> ALTER TABLESPACE system BEGIN BACKUP;
>> HOST cp $ORACLE_BASE/oradata/www/system01.dbf $ORACLE_BASE/backups/.
>> ALTER TABLESPACE system END BACKUP;
>>
>> PROMPT SYSTEM tablespace backed up.
>> PROMPT
>>
>> PROMPT Backing up RBS tablespace ...
>> PROMPT
>> ALTER TABLESPACE rbs BEGIN BACKUP;
>> HOST cp $ORACLE_BASE/oradata/www/rbs01.dbf $ORACLE_BASE/backups/.
>> ALTER TABLESPACE rbs END BACKUP;
>>
>> PROMPT SYSTEM RBS backed up.
>> PROMPT
>>
>> PROMPT Backing up DRSYS tablespace ...
>> PROMPT
>> ALTER TABLESPACE drsys BEGIN BACKUP;
>> HOST cp $ORACLE_BASE/oradata/www/drsys01.dbf $ORACLE_BASE/backups/.
>> ALTER TABLESPACE DRSYS END BACKUP;
>>
>> PROMPT DRSYS tablespace backed up.
>> PROMPT
>>
>> PROMPT Backing up INDX tablespace ...
>> PROMPT
>> ALTER TABLESPACE indx BEGIN BACKUP;
>> HOST cp $ORACLE_BASE/oradata/www/indx01.dbf $ORACLE_BASE/backups/.
>> ALTER TABLESPACE indx END BACKUP;
>>
>> PROMPT INDX tablespace backed up.
>> PROMPT
>>
>> PROMPT Backing up CONTROLROOM tablespace ...
>> PROMPT
>> ALTER TABLESPACE controlroom BEGIN BACKUP;
>> HOST cp $ORACLE_BASE/oradata/db/CONTROLROOM.dbf $ORACLE_BASE/backups/.
>> ALTER TABLESPACE controlroom END BACKUP;
>>
>> PROMPT CONTROLROOM tablespace backed up.
>> PROMPT
>>
>> PROMPT Backing up database control file ....
>> PROMPT
>>
>> ALTER DATABASE BACKUP CONTROLFILE TO

'$ORACLE_BASE/backups/controlbkup.ctl'
>> REUSE;
>>
>> PROMPT Database Control file backed up.
>> PROMPT
>>
>> PROMPT Backing up misc files.....
>> PROMPT
>>
>> HOST cp $ORACLE_HOME/dbs/initwww.ora $ORACLE_BASE/backups/.
>> HOST cp $ORACLE_HOME/dbs/orapwwww $ORACLE_BASE/backups/.
>> HOST cp $ORACLE_HOME/network/admin/*.ora $ORACLE_BASE/backups/.
>> HOST cp /etc/oratab $ORACLE_BASE/backups/.
>> HOST cp /etc/rc.d/init.d/dbora $ORACLE_BASE/backups/.
>>
>> PROMPT misc files backed up
>> PROMPT
>>
>> -------------------------
>>
>> I have a different box with Oracle installed that I would like to restore
the
>> backup from above. I've tried a few different ways, but I'm not having
any
>> luck. Any suggestions?
>>
>> Thanks,
>> Todd
>>
>> ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web

>> http://newsone.net/ -- Free reading and anonymous posting to 60,000+
groups
>> NewsOne.Net prohibits users from posting spam. If this or other posts
>> made through NewsOne.Net violate posting guidelines, email
abuse_at_newsone.net
>

Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net

Received on Sat Mar 31 2001 - 12:52:59 CST