|
-
Thanks..
So, I do this way...
STARTUP NOMOUNT;
CREATE CONTROLFILE set DATABASE "TEST" RESETLOGS noARCHIVELOG
MAXLOGFILES 8
MAXLOGMEMBERS 4
MAXDATAFILES 1021
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 (
'/dvl/oracle/db1/logg1m1.dbf',
'/dvl/oracle/db1/logg1m2.dbf'
) SIZE 128M,
GROUP 2 (
'/dvl/oracle/db1/logg2m1.dbf',
'/dvl/oracle/db1/logg2m2.dbf'
) SIZE 128M,
GROUP 3 (
'/dvl/oracle/db1/logg3m1.dbf',
'/dvl/oracle/db1/logg3m2.dbf'
) SIZE 128M
DATAFILE
'/dvl/oracle/db1/system01.dbf',
'/dvl/oracle/db1/ts_undo01.dbf',
'/dvl/oracle/db1/psindex02.dbf',
'/dvl/oracle/db1/ts_undo02.dbf',
'/dvl/oracle/db1/ts_stpack01.dbf'
CHARACTER SET WE8ISO8859P1;
RECOVER DATABASE using backup controlfile until cancel;
ALTER DATABASE OPEN resetlogs;
ALTER TABLESPACE TEMP ADD TEMPFILE '/dvl/oracle/db1/temp02.dbf'
SIZE 1024M REUSE AUTOEXTEND OFF;
correct?
when i do from colbackup, i wont use RECOVER DATABASE using backup controlfile until cancel;
so, in this case of hotbackup, I have to use RECOVER DATABASE using backup controlfile until cancel;
Waiting for input..
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|