OraFAQ Forum: Backup & Recovery » target db not open after create AUXiliary instance (merged 3)

Home » RDBMS Server » Backup & Recovery » target db not open after create AUXiliary instance (merged 3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

target db not open after create AUXiliary instance (merged 3) [message #319338]

Fri, 09 May 2008 22:43

malvika
Messages: 55
Registered: May 2008
Location: india

Member

malvika.mistry@gmail.com

dear all
i have one REMOTE database EASTLEG and it's already in running mode means startup and used.

i am create one instance AUX for that DATABASE for create AUXILIARY DATABASE.

and create password file for AUX also.......

for this in initAUX.ora i write DB_NAME=EASTLEG same as initEASTLEG DB_NAME para value.

and i start EASTLEG using AUX instance.and it start but when i goes to run RMAN command

i.e

[oracle9i@datastorage oracle9i]$ rman target sys/mataji@EASTLEG catalog rman/rman@CATDB auxiliary aux/aux@EASTLEG

Recovery Manager: Release 9.2.0.4.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges

i got this type error

and i not open my EASTLEG database....
and for some time i shutdown EASTLEG database

but after that i can't startup it again

startup pfile=$ORACLE_HOME/dbs/initEASTLEG.ora.....

but it gives this result.........

SQL> startup force pfile=$ORACLE_HOME/dbs/initEASTLEG.ora
ORACLE instance started.

Total System Global Area 1140397296 bytes
Fixed Size 451824 bytes
Variable Size 352321536 bytes
Database Buffers 786432000 bytes
Redo Buffers 1191936 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode

can any body help me for that....

Report message to a moderator

Re: target db not open after create AUXiliary instance [message #319341 is a reply to message #319338]

Fri, 09 May 2008 22:56

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>RMAN-00554: initialization of internal recovery manager package failed
>RMAN-04005: error from target database:
>ORA-01031: insufficient privileges

MetaLink has a Note which contains a checklist for the ORA-01031 error for SYSDBA user.

Report message to a moderator

Re: target db not open after create AUXiliary instance [message #319342 is a reply to message #319341]

Fri, 09 May 2008 22:59

malvika
Messages: 55
Registered: May 2008
Location: india

Member

malvika.mistry@gmail.com

what i will do next

for solve this problem

Report message to a moderator

Re: target db not open after create AUXiliary instance [message #319343 is a reply to message #319338]

Fri, 09 May 2008 23:04

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>what i will do next for solve this problem
I give up. What will you do?

Will you read & follow the RMAN manual which enumerates how to properly configure & use RMAN?

The RMAN documentation can be found at http://tahiti.oracle.com

Report message to a moderator

Re: target db not open after create AUXiliary instance [message #319347 is a reply to message #319343]

Sat, 10 May 2008 00:06

malvika
Messages: 55
Registered: May 2008
Location: india

Member

malvika.mistry@gmail.com

thanks

i read all the thing for used and configure RMAN.

actully i write same instance_name in both AUXILIARY and TARGET init.ora files.

startup with pfile but it gives error

ORA-01102: cannot mount database in EXCLUSIVE mode

[Updated on: Sat, 10 May 2008 00:15]

Report message to a moderator

ORA-01102: cannot mount database in EXCLUSIVE mode [message #319350 is a reply to message #319338]

Sat, 10 May 2008 00:41

malvika
Messages: 55
Registered: May 2008
Location: india

Member

malvika.mistry@gmail.com

hi my database no open in mount mode please tell me how i open my database

Report message to a moderator

Re: ORA-01102: cannot mount database in EXCLUSIVE mode [message #319352 is a reply to message #319350]

Sat, 10 May 2008 00:44

Michel Cadot
Messages: 68649
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Go to your alert.log file and see why it is not opening.

Regards
Michel

Report message to a moderator

Re: target db not open after create AUXiliary instance [message #319353 is a reply to message #319347]

Sat, 10 May 2008 00:46

Michel Cadot
Messages: 68649
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

See my answer in the topic you created with this subject.
http://www.orafaq.com/forum/t/104009/102589/

Regards
Michel

Report message to a moderator

Re: ORA-01102: cannot mount database in EXCLUSIVE mode [message #319354 is a reply to message #319352]

Sat, 10 May 2008 00:56

malvika
Messages: 55
Registered: May 2008
Location: india

Member

malvika.mistry@gmail.com

thanks but i cant understand how to understood this file
here,
in this file all the step they give to open database and memory allocation ...
i don't translate this file to solve this error .
can you help me for that

Report message to a moderator

Re: target db not open after create AUXiliary instance [message #319355 is a reply to message #319353]

Sat, 10 May 2008 01:07

malvika
Messages: 55
Registered: May 2008
Location: india

Member

malvika.mistry@gmail.com

thanks bro..........

i think you are not interested to give me the answer that's way you do it.

thanks....for you help........

but i want to tell you one thing that if we have a good knowledge and any other people not then go to help them or not go front of them for help

i cleared in my last message that i can understand how to translate the alert.log file if you not want to help me then no give any reaponse ...

you are experience person and also educated if you behave like this then you can use this forum for solve their problem...

thanks for reading this msg

Report message to a moderator

Re: target db not open after create AUXiliary instance [message #319357 is a reply to message #319355]

Sat, 10 May 2008 01:15

Michel Cadot
Messages: 68649
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I really don't understand your answer, I understand you don't know how to read the file but maybe WE can but if you don't post it we can't help.

Post the last part since the startup command until the error ORA-01102: cannot mount database in EXCLUSIVE mode.

Of course, if you don't want to be helped you can stay in this behaviour, offending the one that try to help you.

Regards
Michel

[Updated on: Sat, 10 May 2008 01:17]

Report message to a moderator

Re: target db not open after create AUXiliary instance [message #319359 is a reply to message #319357]

Sat, 10 May 2008 01:23

malvika
Messages: 55
Registered: May 2008
Location: india

Member

malvika.mistry@gmail.com

thaks bro........,

and sorry for my this odd behaviour ...bro.........

here i send you my alert.log file if you find the problem of my database started then please help me and aslo, tell me how to implement it.

SQL> startup pfile=$ORACLE_HOME/dbs/initEASTLEG.ora
ORACLE instance started.

Total System Global Area 1140397296 bytes
Fixed Size 451824 bytes
Variable Size 352321536 bytes
Database Buffers 786432000 bytes
Redo Buffers 1191936 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode

[Updated on: Sat, 10 May 2008 01:42]

Report message to a moderator

Re: target db not open after create AUXiliary instance (merged) [message #319390 is a reply to message #319338]

Sat, 10 May 2008 08:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

01102, 00000, "cannot mount database in EXCLUSIVE mode"
// *Cause:  Some other instance has the database mounted exclusive or shared.
// *Action: Shutdown other instance or mount in a compatible mode.

Report message to a moderator

Re: target db not open after create AUXiliary instance [message #319392 is a reply to message #319359]

Sat, 10 May 2008 09:22

Michel Cadot
Messages: 68649
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

here i send you my alert.log file

Where is it?

Regards
Michel

Report message to a moderator

loss all controlefile want to restart database [message #319502 is a reply to message #319338]

Mon, 12 May 2008 00:23

malvika
Messages: 55
Registered: May 2008
Location: india

Member

malvika.mistry@gmail.com

hi ,friends.

i loss my EASTLEG database all controle FILE can i restart my database again.
if yes then how?

please send me all step for that.
thanks

Report message to a moderator

Re: target db not open after create AUXiliary instance [message #319503 is a reply to message #319392]

Mon, 12 May 2008 00:27

malvika
Messages: 55
Registered: May 2008
Location: india

Member

malvika.mistry@gmail.com

hi bro,

actully i lost all my controlefile for EASTLEG database and i think this is the problem to restart the database.

plese tell me how i can restart it i have spfile and i create from it new pfile by

create pfile from spfile='spfileEASTLEG.ora'

and new pfile created.

can i restart my database ?

or i loss it?

Report message to a moderator

Re: loss all controlefile want to restart database [message #319505 is a reply to message #319502]

Mon, 12 May 2008 00:39

Michel Cadot
Messages: 68649
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Do not multipost your questions.

Regards
Michel

Report message to a moderator

Re: target db not open after create AUXiliary instance [message #319506 is a reply to message #319503]

Mon, 12 May 2008 00:40

Michel Cadot
Messages: 68649
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

CREATE CONTROFILE

Regards
Michel

Report message to a moderator

Re: loss all controlefile want to restart database [message #319507 is a reply to message #319505]

Mon, 12 May 2008 00:41

malvika
Messages: 55
Registered: May 2008
Location: india

Member

malvika.mistry@gmail.com

OK
.
can i recreate the controlfile?

Report message to a moderator

Re: loss all controlefile want to restart database [message #319508 is a reply to message #319507]

Mon, 12 May 2008 00:44

Michel Cadot
Messages: 68649
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

malvika wrote on Mon, 12 May 2008 07:41

OK
.
can i recreate the controlfile?

See above link.

Regards
Michel

Report message to a moderator

Re: loss all controlefile want to restart database [message #319513 is a reply to message #319508]

Mon, 12 May 2008 01:16

malvika
Messages: 55
Registered: May 2008
Location: india

Member

malvika.mistry@gmail.com

CREATE CONTROLFILE REUSE DATABASE "EASTLEG" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 453
LOGFILE GROUP 1 ('/newdata/app/oracle/oradata/EASTLEG/redo01.log') SIZE 100M,
GROUP 2 ('/newdata/app/oracle/oradata/EASTLEG/redo02.log') SIZE 100M,
GROUP 3 ('/newdata/app/oracle/oradata/EASTLEG/redo03.log') SIZE 100M
DATAFILE '/newdata/app/oracle/oradata/EASTLEG/system01.dbf' SIZE 300M,
'/newdata/app/oracle/oradata/EASTLEG/drsys01.dbf' SIZE 200M,
'/newdata/app/oracle/oradata/EASTLEG/indx01.dbf' SIZE 300M;

SQL> @$ORACLE_HOME/dbs/createEASTLEGctl.sql
CREATE CONTROLFILE REUSE DATABASE "EASTLEG" NORESETLOGS NOARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01163: SIZE clause indicates 38400 (blocks), but should match header 128000
ORA-01110: data file 1: '/newdata/app/oracle/oradata/EASTLEG/system01.dbf'

i change the system01.dbf size using this equations..

Expected size = Expected # of blocks * db_block_size / 1024

= 38400 * 8192/1024
= 307200

--------------
change code
----------
CREATE CONTROLFILE REUSE DATABASE "EASTLEG" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 453
LOGFILE GROUP 1 ('/newdata/app/oracle/oradata/EASTLEG/redo01.log') SIZE 100M,
GROUP 2 ('/newdata/app/oracle/oradata/EASTLEG/redo02.log') SIZE 100M,
GROUP 3 ('/newdata/app/oracle/oradata/EASTLEG/redo03.log') SIZE 100M
DATAFILE '/newdata/app/oracle/oradata/EASTLEG/system01.dbf' SIZE 307200K,
'/newdata/app/oracle/oradata/EASTLEG/drsys01.dbf' SIZE 200M,
'/newdata/app/oracle/oradata/EASTLEG/indx01.dbf' SIZE 300M;

but this error display...

CREATE CONTROLFILE REUSE DATABASE "EASTLEG" NORESETLOGS NOARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01163: SIZE clause indicates 38400 (blocks), but should match header 128000
ORA-01110: data file 1: '/newdata/app/oracle/oradata/EASTLEG/system01.dbf'

Report message to a moderator

Re: loss all controlefile want to restart database [message #319516 is a reply to message #319513]

Mon, 12 May 2008 01:20

Michel Cadot
Messages: 68649
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

The message says you gave 38400 blocks and you should give 128000 blocks.

Regards
Michel

Report message to a moderator

Re: loss all controlefile want to restart database [message #319528 is a reply to message #319516]

Mon, 12 May 2008 02:03

malvika
Messages: 55
Registered: May 2008
Location: india

Member

malvika.mistry@gmail.com

thanks

controlfile is created.

but database not open b'cus it need media recovery .
and i haven't any backup .
so what i do next.

and if i connect to EASTLEG database then it gives this error.

SQL> connect sys/mataji@eastleg;
ERROR:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor

Warning: You are no longer connected to ORACLE.

[Updated on: Mon, 12 May 2008 02:04]

Report message to a moderator

Re: loss all controlefile want to restart database [message #319544 is a reply to message #319528]

Mon, 12 May 2008 02:30

Michel Cadot
Messages: 68649
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Sorry, there are too much things you don't know and I don't want to spend hours to continue to guide you step by step.
You have to first read administrator and backup and recovery guides (and I should add database concepts).

Regards
Michel

Report message to a moderator

Re: loss all controlefile want to restart database [message #319545 is a reply to message #319544]

Mon, 12 May 2008 02:32

malvika
Messages: 55
Registered: May 2008
Location: india

Member

malvika.mistry@gmail.com

thanks.
------------------------------
this is the alertCATDB.log file can you tell me what is the error for CATDB DATABASE not start.
---------------------------
Fri May 9 10:27:14 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
processes = 300
timed_statistics = TRUE
shared_pool_size = 536870912
sga_max_size = 1615403728
shared_pool_reserved_size= 52428800
large_pool_size = 16777216
java_pool_size = 83886080
control_files = /u02/app/oracle/admin/CATDB/catdb1.ctl
db_block_size = 8192
db_writer_processes = 4
db_cache_size = 805306368
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest_1 = location=/u02/app/oracle/admin/CATDB/arch
log_archive_max_processes= 6
log_archive_format = arch_catdb_%s.log
log_buffer = 104857600
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
log_checkpoints_to_alert = TRUE
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
O7_DICTIONARY_ACCESSIBILITY= TRUE
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = CATDB
dispatchers = (PROTOCOL=TCP) (SERVICE=atuldbXDB)
session_cached_cursors = 200
utl_file_dir = /home/oracle9i
job_queue_processes = 20
_job_queue_interval = 60
cursor_sharing = EXACT
hash_join_enabled = TRUE
background_dump_dest = /u02/app/oracle/admin/CATDB/bdump
user_dump_dest = /u02/app/oracle/admin/CATDB/udump
core_dump_dest = /u02/app/oracle/admin/CATDB/cdump
sort_area_size = 524288
db_name = CATDB
open_cursors = 999
star_transformation_enabled= FALSE
query_rewrite_enabled = TRUE
query_rewrite_integrity = TRUSTED
pga_aggregate_target = 786432000
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
DBW1 started with pid=4
DBW2 started with pid=5
DBW3 started with pid=6
LGWR started with pid=7
CKPT started with pid=8
SMON started with pid=9
RECO started with pid=10
CJQ0 started with pid=11
QMN0 started with pid=12
Fri May 9 10:27:25 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL
=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=15
ARC0: Archival started
ARC1 started with pid=16
ARC1: Archival started
ARC2 started with pid=17
ARC2: Archival started
ARC3 started with pid=18
ARC3: Archival started
ARC4 started with pid=19
ARC4: Archival started
ARC5 started with pid=20
Fri May 9 10:27:28 2008
ARCH: STARTING ARCH PROCESSES COMPLETE
Fri May 9 10:27:28 2008
ARC1: Thread not mounted
Fri May 9 10:27:28 2008
ARC5: Archival started
Fri May 9 10:27:28 2008
ARC5: Thread not mounted
Fri May 9 10:27:28 2008
ARC2: Thread not mounted
Fri May 9 10:27:28 2008
Fri May 9 10:27:28 2008
ARC3: Thread not mounted
ARC0: Thread not mounted
Fri May 9 10:27:28 2008
ARC4: Thread not mounted
Fri May 9 10:28:21 2008
CREATE DATABASE CATDB
USER SYS IDENTIFIED BY
USER SYSTEM IDENTIFIED BY **** MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 453
LOGFILE GROUP 1 ('/newdata/app/oracle/oradata/CATDB/redo01.log') SIZE 100M,
GROUP 2 ('/newdata/app/oracle/oradata/CATDB/redo02.log') SIZE 100M,
GROUP 3 ('/newdata/app/oracle/oradata/CATDB/redo03.log') SIZE 100M
DATAFILE '/newdata/app/oracle/oradata/CATDB/system01.dbf' SIZE 300M,
'/newdata/app/oracle/oradata/CATDB/drsys01.dbf' SIZE 200M,
'/newdata/app/oracle/oradata/CATDB/indx01.dbf' SIZE 300M
UNDO TABLESPACE UNDOTBS1
DATAFILE '/newdata/app/oracle/oradata/CATDB/undotbs01.dbf' SIZE 200M
REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
CHARACTER SET WE8ISO8859P1
Fri May 9 10:28:21 2008
Restarting dead background process QMN0
QMN0 started with pid=12
Fri May 9 10:28:21 2008
Database mounted in Exclusive Mode.
Fri May 9 10:28:32 2008
Successful mount of redo thread 1, with mount id 2199994309.
Assigning activation ID 2199994309 (0x83213fc5)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /newdata/app/oracle/oradata/CATDB/redo01.log
Successful open of redo thread 1.
Fri May 9 10:28:34 2008
SMON: enabling cache recovery
Fri May 9 10:28:34 2008
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in
future release
Fri May 9 10:28:34 2008
ARC1: Media recovery disabled
Fri May 9 10:28:34 2008
create tablespace SYSTEM datafile '/newdata/app/oracle/oradata/CATDB/system01
.dbf' SIZE 300M,
'/newdata/app/oracle/oradata/CATDB/drsys01.dbf' SIZE 200M,
'/newdata/app/oracle/oradata/CATDB/indx01.dbf' SIZE 300M
default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online
Fri May 9 10:28:55 2008
Completed: create tablespace SYSTEM datafile '/newdata/app
Fri May 9 10:28:56 2008
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Completed: create rollback segment SYSTEM tablespace SYSTEM

Fri May 9 10:29:07 2008
CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE '/newdata/app/oracle/oradata/CATDB/und
otbs01.dbf' SIZE 200M
REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
Fri May 9 10:29:11 2008
Created Undo Segment _SYSSMU1$
Created Undo Segment _SYSSMU2$
Created Undo Segment _SYSSMU3$
Created Undo Segment _SYSSMU4$
Created Undo Segment _SYSSMU5$
Created Undo Segment _SYSSMU6$
Created Undo Segment _SYSSMU7$
Created Undo Segment _SYSSMU8$
Created Undo Segment _SYSSMU9$
Created Undo Segment _SYSSMU10$
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Completed: CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE '/newdat
Fri May 9 10:29:14 2008
Beginning local checkpoint up to RBA [0x1.5a0d.10], SCN: 0x0000.00001e6b
Fri May 9 10:29:14 2008
SMON: enabling tx recovery
Completed checkpoint up to RBA [0x1.5a0d.10], SCN: 0x0000.00001e6b
replication_dependency_tracking turned off (no async multimaster replication fou
nd)
Completed: CREATE DATABASE CATDB
USER SYS IDENTIFIED BY
USER
Fri May 9 10:33:36 2008
Restarting dead background process QMN0
QMN0 started with pid=12
Fri May 9 10:33:49 2008
Starting ORACLE instance (normal)
Fri May 9 10:38:52 2008
Restarting dead background process QMN0
QMN0 started with pid=21
Fri May 9 10:44:05 2008
Restarting dead background process QMN0
QMN0 started with pid=21
Fri May 9 10:49:18 2008
Restarting dead background process QMN0
QMN0 started with pid=21
Fri May 9 10:52:38 2008
Beginning log switch checkpoint up to RBA [0x2.2.10], SCN: 0x0000.00007aec
Thread 1 advanced to log sequence 2
Current log# 2 seq# 2 mem# 0: /newdata/app/oracle/oradata/CATDB/redo02.log
Fri May 9 10:52:41 2008
ARC2: Media recovery disabled
Fri May 9 10:54:35 2008
Restarting dead background process QMN0
QMN0 started with pid=21
Fri May 9 10:55:47 2008
Completed checkpoint up to RBA [0x2.2.10], SCN: 0x0000.00007aec
Fri May 9 10:57:07 2008
Beginning log switch checkpoint up to RBA [0x3.2.10], SCN: 0x0000.0000c00f
Thread 1 advanced to log sequence 3
Current log# 3 seq# 3 mem# 0: /newdata/app/oracle/oradata/CATDB/redo03.log
Fri May 9 10:57:10 2008
ARC4: Media recovery disabled
Fri May 9 11:27:59 2008
Completed checkpoint up to RBA [0x3.2.10], SCN: 0x0000.0000c00f
Fri May 9 11:38:37 2008
Beginning log switch checkpoint up to RBA [0x4.2.10], SCN: 0x0000.00014376
Thread 1 advanced to log sequence 4
Current log# 1 seq# 4 mem# 0: /newdata/app/oracle/oradata/CATDB/redo01.log
Fri May 9 11:38:39 2008
ARC0: Media recovery disabled
Fri May 9 11:55:22 2008
create tablespace rman datafile '/newdata/app/oracle/oradata/CATDB/rman01.dbf' s
ize 300M autoextend on
Fri May 9 11:55:30 2008
Completed: create tablespace rman datafile '/newdata/app/orac
Fri May 9 12:09:30 2008
Completed checkpoint up to RBA [0x4.2.10], SCN: 0x0000.00014376

-----------------------------------------------------

[Updated on: Mon, 12 May 2008 02:58]

Report message to a moderator

Previous Topic:	Backup and Recovery without using Archivelog ON
Next Topic:	backup table using rman

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 11 02:08:09 CDT 2024